+ Reply to Thread
Results 1 to 4 of 4

Macro to copy data from multiple worksheet cells in to a single Master worksheet

  1. #1
    Registered User
    Join Date
    08-13-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Question Macro to copy data from multiple worksheet cells in to a single Master worksheet

    Hello! I searched the forums and found things similar to what I need, but nothing specifically and these posts were 3-10 years old and no one was responding to them so I thought I would ask on a new post...

    I have a workbook with several worksheets (will be adding and removing worksheets often) all formatted the same. The worksheets are set up like a form and have key data in the same specific cells in each worksheet; C4, C5, G4, G5, K4, K5, and L32 etc. (there are more but just as an example)


    1. I am looking for a macro that will go through the workbook and grab the data from almost every worksheet and compile (copy) it in a worksheet called "Master" starting in row 2 (as headers will be in row 1).
    2. I need it so every time I run the macro (I will put a refresh button in), it deletes all of the current data in "Master" (from row 2 and down) and then updates it with the new data from each worksheet.
    3. I am trying to find a way that when it compiles the data in to "Master" it will also add in the name of the worksheet (in column A) where that data came from, so I have a understanding of which worksheet it is/was from.
    4. Besides the "Master" worksheet, I have a worksheet called "Summary" that I am will be using a drop down list and simple vlookup against all the data compiled in "Master" so I can select the defined name/range and then get the values based off the vlookup (I know how to do this part). In short the macro can't run on the "Summary" or "Master" worksheets, but all the others in the workbook.

    Also, I am using Excel 2010 on windows 7

    for this example, I am basically looking the macro to pull the data from these cell: C4, C5, G4, G5, K4, K5, and L32


    Thanks in advance

    Sand box2.xlsm - sample book with worksheets and "Master" as it would be after a Macro was ran
    Last edited by thunt13; 05-08-2015 at 02:55 PM. Reason: Attached Sample

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

    Re: Macro to copy data from multiple worksheet cells in to a single Master worksheet

    Please attach a sample book with a desired result.

  3. #3
    Registered User
    Join Date
    08-13-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Macro to copy data from multiple worksheet cells in to a single Master worksheet

    Quote Originally Posted by AB33 View Post
    Please attach a sample book with a desired result.
    AB33,
    I attached a sample book (edited and added it to original post above) with a few worksheets and some data in cells I was referencing. The "Master" is displayed as I would hope the results to be after running said macro.

    Thanks

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

    Re: Macro to copy data from multiple worksheet cells in to a single Master worksheet

    Not clear on the output.
    Where are you copying C5,G5 and K5. is it next row or a column? the same for L32.
    Please see the attached and I will adjust the code once I know the output.
    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)

Similar Threads

  1. [SOLVED] Macro to Copy Master Worksheet create and paste in new auto named worksheet
    By TheRealLethality in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-15-2014, 12:46 AM
  2. [SOLVED] copy data from cells in a column on one worksheet to a single cell in another worksheet
    By jpsnickers in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-03-2013, 07:02 PM
  3. Replies: 3
    Last Post: 02-04-2013, 06:00 PM
  4. [SOLVED] Copy Data from Multiple Worksheet to Master Worksheet
    By koolguys4u in forum Excel General
    Replies: 1
    Last Post: 07-02-2012, 08:14 AM
  5. Macro to copy data from worksheet (name changes daily) to master workbook
    By bshelman in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-10-2008, 08:52 AM

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