+ Reply to Thread
Results 1 to 10 of 10

Automatically Copy Data from Multiple Sheets to a Master Sheet

  1. #1
    Registered User
    Join Date
    10-06-2014
    Location
    Kamloops, BC
    MS-Off Ver
    2007
    Posts
    4

    Automatically Copy Data from Multiple Sheets to a Master Sheet

    I'm relatively new to coding, and my boss has asked me to setup a spreadsheet to summarize our sales. Basically, Sheet1 is a Master Sheet, and Sheets 2-9 are for each salesperson's deals. Everytime we enter in a deal on the respective saleman's sheet, he wants it to automatically update on the next available row of the Master Sheet (Sheet1). The first row data for each salesman's sheet is A1:R12. This is also the first available row on the Master Sheet. Any help would be very much appreciated.

    Thanks!

  2. #2
    Forum Contributor
    Join Date
    08-29-2012
    Location
    Hyderbad
    MS-Off Ver
    Excel 2003
    Posts
    121

    Re: Automatically Copy Data from Multiple Sheets to a Master Sheet

    Hi Ryan,

    Can u please attach the excel sheet with output which is done manually, according to your requirement. (Attachment for easy understanding).

  3. #3
    Registered User
    Join Date
    10-06-2014
    Location
    Kamloops, BC
    MS-Off Ver
    2007
    Posts
    4

    Re: Automatically Copy Data from Multiple Sheets to a Master Sheet

    Quote Originally Posted by jagadeesh.rt View Post
    Hi Ryan,

    Can u please attach the excel sheet with output which is done manually, according to your requirement. (Attachment for easy understanding).
    Please find example attached. I filled in the first row on the "Michael" and "Dennis" sheets. Basically I want those to copy over to the summary sheet as soon as they are entered.

    Thanks
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Automatically Copy Data from Multiple Sheets to a Master Sheet

    Maybe:

    Please Login or Register  to view this content.

  5. #5
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Automatically Copy Data from Multiple Sheets to a Master Sheet

    I loaded on your attachment.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    10-06-2014
    Location
    Kamloops, BC
    MS-Off Ver
    2007
    Posts
    4

    Re: Automatically Copy Data from Multiple Sheets to a Master Sheet

    Quote Originally Posted by JOHN H. DAVIS View Post
    I loaded on your attachment.
    Thanks John, but it doesn't look like it worked? None of the data is showing up on the summary page?

  7. #7
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Automatically Copy Data from Multiple Sheets to a Master Sheet

    Quote Originally Posted by Ryan_Brandt View Post
    Thanks John, but it doesn't look like it worked? None of the data is showing up on the summary page?
    The way it is set up now requires that the entire active row is completed before it will copy over. For example type Mike in the Sheet for Michael and you'll see that it copies over.

  8. #8
    Registered User
    Join Date
    10-06-2014
    Location
    Kamloops, BC
    MS-Off Ver
    2007
    Posts
    4

    Re: Automatically Copy Data from Multiple Sheets to a Master Sheet

    This is perfect. Thanks!

  9. #9
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Automatically Copy Data from Multiple Sheets to a Master Sheet

    You're welcome. Glad to help out and thanks for the feed back. Please comply with the Forum Rules and mark this thread as solved. If you need help refer too:

    http://www.excelforum.com/forum-rule...rum-rules.html

  10. #10
    Registered User
    Join Date
    08-08-2013
    Location
    england
    MS-Off Ver
    Excel 2003
    Posts
    33

    Re: Automatically Copy Data from Multiple Sheets to a Master Sheet

    Quote Originally Posted by JOHN H. DAVIS View Post
    You're welcome. Glad to help out and thanks for the feed back. Please comply with the Forum Rules and mark this thread as solved. If you need help refer too:

    http://www.excelforum.com/forum-rule...rum-rules.html


    Hi,

    This is exactly what im looking for, for my problem can you help please? i cant duplicate it for what i need

    http://www.excelforum.com/excel-gene...-complete.html

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 07-17-2014, 09:46 PM
  2. Replies: 6
    Last Post: 11-08-2013, 11:59 AM
  3. [SOLVED] Copy Data From Master Sheet to Multiple Sheets
    By dmmr in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-06-2013, 11:28 AM
  4. Automatically updating multiple sheets to a master sheet
    By welshgirl89 in forum Excel Formulas & Functions
    Replies: 29
    Last Post: 03-07-2013, 02:05 PM
  5. [SOLVED] Macro to copy data from multiple sheets to one (new) master sheet
    By nhtodd in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-24-2012, 02:30 AM

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