G
Guest
I have a team budget with several worksheets. One sheet has salary info and I
need to keep the confidential (for me only). But I would like to let other
team members look at and edit other worksheets (ie costs for projects they're
managing). Can you recommend a method for this?
Last year, team members created their own project spreadsheets and then I
linked to their data. I also put a hyperlink on (my) team worksheet so I
could easily click to see their actual spreadsheet. They never actually
looked at the master team spreadsheet. Is there some way to get all of this
data in one spreadsheet, but still be very, very sure that some of the
workheets will be protected. I don't mind the linking too much - but one
problem I've had is that when IT moves drives or folder locations due to
stoarge issues, then I need to redo the cell links to the individual project
spreadsheets.
Thanks for any help or suggestions.
Regards,
Mary
need to keep the confidential (for me only). But I would like to let other
team members look at and edit other worksheets (ie costs for projects they're
managing). Can you recommend a method for this?
Last year, team members created their own project spreadsheets and then I
linked to their data. I also put a hyperlink on (my) team worksheet so I
could easily click to see their actual spreadsheet. They never actually
looked at the master team spreadsheet. Is there some way to get all of this
data in one spreadsheet, but still be very, very sure that some of the
workheets will be protected. I don't mind the linking too much - but one
problem I've had is that when IT moves drives or folder locations due to
stoarge issues, then I need to redo the cell links to the individual project
spreadsheets.
Thanks for any help or suggestions.
Regards,
Mary