Combine and update three worksheet into one mastersheet
I have three computers that has a copy of identical excel sheets each, that list guest names and their attendance.
I would need to update a master file (identical) combining these three excel files
( guest can register at any counter) so that at the end of the day, the master sheet excel file will show the total guest attendance.
Can anyone give me some pointers on how to do this?
you need to attach a sample file in zip format.
Originally Posted by sheclaire
I suppose I can use data consolidation. I also researched and find that shared worksheet will do similiar actions.
What is the difference between using data consolidation and shared worksheet?
I;ve attached a sample for you. This is just a draft on how it should look like. I;ve inserted all 4 excel worksheets into one tab due to space constraint
The Grand total master file, which is the fourth excel worksheet should update automatically when the excel sheet from different worksheet are updated.
The format for all worksheets are the same
My apologies, this is the attachment
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1