+ Reply to Thread
Results 1 to 3 of 3

Combining Worksheet to One Master Sheet (live updating)

  1. #1
    Registered User
    Join Date
    06-25-2013
    Location
    London, England
    MS-Off Ver
    Excel Mac 2011
    Posts
    1

    Post Combining Worksheet to One Master Sheet (live updating)

    Hi All,

    If you can help it would be greatly appreciated!I'd like to take the sheets ('page 1' & 'page 2') in this excel (attached) and merge them into a master spread sheet ('master')

    I know this could be achieved by copy and pasting but ideally the master would update as information was changed in respective pages.

    Desired outcome: 'master' spreadsheet that compiles all the information from the two (or more) other pages of the same format so that data can be observed as a whole.

    Please help! And thank you in advance.

    JoeTest Work Sheet.xlsx

  2. #2
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,230

    Re: Combining Worksheet to One Master Sheet (live updating)

    The code works on window, but nor sure on Mac.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    06-24-2013
    Location
    State College, PA
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Combining Worksheet to One Master Sheet (live updating)

    This can be done through a VBA code. You can actually record a macro and modify it to your needs. If the code is not doing what you wish and you aren't sure how to change it, press F1 while in the VBE to pull up the Help window. I have found this to be outrageously helpful to this day. You can also use this link for the VBA Programming for Dummies book which is another great tool and in fact has a whole chapter that will basically give you the exact answer I believe you are looking for (http://www.docstoc.com/docs/12639404...r-Dummies-2010). Good luck!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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