+ Reply to Thread
Results 1 to 5 of 5

Combine and update three worksheet into one mastersheet

  1. #1
    Registered User
    Join Date
    03-19-2007
    Posts
    29

    Combine and update three worksheet into one mastersheet

    Hi all,


    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?

  2. #2
    Forum Contributor
    Join Date
    03-14-2006
    Location
    Pakistan
    Posts
    1,791

    Lightbulb

    Quote Originally Posted by sheclaire
    Hi all,


    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.

  3. #3
    Registered User
    Join Date
    03-19-2007
    Posts
    29
    Hi again,

    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?


    Many thanks!

  4. #4
    Registered User
    Join Date
    03-19-2007
    Posts
    29
    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

  5. #5
    Registered User
    Join Date
    03-19-2007
    Posts
    29
    My apologies, this is the attachment
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1