There are four people who need to update the same excel sheet, at the same time.
Whats the easiest way of doing this?
I thought one master sheet (that is not edited) and four sheets that feed into it? Or sharing a worksheet (although I am not sure how conflicting changes may work?
Has anybody got any ideas, I've got a bit of a hangover...
Last edited by jodenice; 01-02-2008 at 08:10 AM.
Why not build an access database with forms that the 4 users use to input the data, then link the data back to a master excel sheet either via pivot table or database query. You can likely build a richer interface for them to input data and ensure it is in the proper format.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks