Shared excel file

  • Thread starter Thread starter Dennis
  • Start date Start date
D

Dennis

I need help to make a shared excel file in a Win NT/2000 network that allows
an user to enter data in his/her column, but cannot see other users' data in
other columns. For example, when user #1 enter data in column C1:C15, he/she
cannot see column D1:D15, E1:E15... that belong to other users. These
columns may be hidden or shaded.
Any help would be appreciated.
Dennis
 
Hi

It's easier to use a design, where every user has his/her own workbook,
where he/she can enter data. And there is a summary/consolidation workbook,
which takes all data together, using links to user workbooks, and where
administrator/poweruser/manager can add new key values and any general
information. User's workbooks are getting those key values and general
information also through links. By such design, all users can work at same
time without blocking data entry for others.

Something like this:

Summary.xls
KeyField, GeneralField1, GenrealField2, User1, User2, User3, ..., Total
The formula for User1 on row2 (D2):
=IF('Path\[User1!xls]Sheet1'!D2="","",'Path\[User1!xls]Sheet1'!D2)
The formula for User2 on row2 (E2):
=IF('Path\[User2!xls]Sheet1'!D2="","",'Path\[User2!xls]Sheet1'!D2)
....

UserX.xls
KeyField, GeneralField1, GenrealField2, Data
The formula for Keyfield on row 2 (A2)
=IF('Path\[Summary!xls]Sheet1'!A2="","",'Path\[Summary!xls]Sheet1'!A2)
The formula for GeneralField1 on row 2 (B2)
=IF('Path\[Summary!xls]Sheet1'!B2="","",'Path\[Summary!xls]Sheet1'!B2)
The formula for GeneralField2 on row 2 (C2)
=IF('Path\[Summary!xls]Sheet1'!C2="","",'Path\[Summary!xls]Sheet1'!C2)
You must have at least same number of rows with formulas, as in Summary.xls,
but you can have some of them ready for case new rows are added in
Summary.xls


Arvi Laanemets
 
Back
Top