One workbook and many users

  • Thread starter Thread starter Piotr
  • Start date Start date
P

Piotr

Hi,
I have many documents which i send to users in order to fill up
particular fields, some of them fill this same cells which I have to
copy and paste (and calculate sum).
I figured out that I have to make 1 main file and for example 4 other
files so the main one could get particular fields from the others.
Is this good solution ? Or maybe you have some better ideas which came
during your experience ?

regards
Peter
 
Just use one file but with a sheet for each user.

The first sheet could be a summary sheet that adds the data from each of the
others.

Make sure you name the sheets so the users know which is theirs, and protect
all formulae to avoid stiffing up by users.

--
Ken Russell

(e-mail address removed)
Remove yourhat to reply by e-mail
..
 
That whould be great but Im affraid if they ask me to access this from
internet, I was thinking about using SAMBA but this could be little
dengerous.


U¿ytkownik Ken Russell napisa³:
 
Hi

There are 4 users, are they?

Is there in every session new information added to old one, or starts all
from clean sheet everytime?

When the info is added to existing one (or the existing info is simply
changed), then let every user have his workbook (same design for every user
preferably) with all info he has entered. Periodically he sends to you a
copy of his workbook.
You have in your computer a summary workbook, and a workbook for every user.
In summary workbook, you create a sheet for every user, where all info from
appropiate user's workbook is retrieved using links. Something like:
A1=IF('C:\My Documents\UsersData\[user1.xls]Data'!A1="","",'C:\My
Documents\UsersData\[user1.xls]Data'!A1)
Additionaly yo can have in summary workbook sheet(s) with summary data,
various reports, etc.
Every time the user sends to you a new copy of his workbook, you overwrite
this users old file - but workbooks name and path to it must remain same as
old one. Now when you open summary workbook again, all new info is there.

When for every period (p.e. for every month) is created a new workbook (and
workbooks for past periods are preserved), let every user have a predesigned
empty workbook (read-only). When new period starts, this empty workbook is
opened and saved under new name (like User1_200412.xls). After the workbook
is filled, the users sends a copy of it to you.
You have in your computer workbooks for every user, and a summary workbook
again - but their names are fixed - p.e. Current1.xls, Current2.xls,
Current3.xls, Current4.xls and CurrentSummary.xls, where in CurrentSummary
are sheets like User1, User2, ... where info is retieved from Current1.xls,
Current2.xls, ... through links - all like described above.
When new period starts, you clear all data from users workbooks in your
computer (it helps to avoid a confusion, from which period are data for an
user).
When you get a workbook copy from user, you overwrite his workbook in your
computer (As Current1.xls, or Current2.xls, or ... ).
After all users workbooks are overwritten, you can preserve this period
data, when you want. For this open summary workbooks and all users workbooks
at once, and save them under different names (and in different location,
when you want) - like
Summary_200412.xls, User1_200412.xls, User2_200412.xls, User3_200412.xls,
User4_200412.xls
All links are adjusted automatically.
 
Thank you for explanation I was know that there is ringing somewhere but
i dint know where, now I know.

Thank you Arvi and Ken
 
Back
Top