+ Reply to Thread
Results 1 to 5 of 5

MACRO to copy cells from multiple sheets into a summary sheet

  1. #1
    Registered User
    Join Date
    04-19-2013
    Location
    CA
    MS-Off Ver
    Excel 2010
    Posts
    3

    MACRO to copy cells from multiple sheets into a summary sheet

    macro help.xlsx

    hey everyone im a finance intern and i really need help in creating a macro that can take the same columns A101:A130, B101:B130, C101:C130, and J101:J130 and K101:K130 from multiple worksheets(about 60+) within the same file, and copy the contents into a summary like sheet named "Master List", and listing them out in columns C, D, E, F, and G, with the sheet name to show which sheet it came from, and the value from a fixed cell in each sheet to be listed out column A and B respectively? i attached a sample file above "macro help.xlxs" of the data and what i would like the outcome to be on the "Master List" sheet. thanks!
    Last edited by andrewtmliu; 04-19-2013 at 10:15 PM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,482

    Re: MACRO to copy cells from multiple sheets into a summary sheet

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

  3. #3
    Registered User
    Join Date
    04-19-2013
    Location
    CA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: MACRO to copy cells from multiple sheets into a summary sheet

    hey thanks dave. i just uploaded a sample file!

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

    Re: MACRO to copy cells from multiple sheets into a summary sheet

    Try the attached.
    I have deleted the master list sheet from the attached as the data with it have exceeds this forum's size rule. When you a run the code, it will create the master list sheet. The button is with Amy.
    Attached Files Attached Files
    Last edited by AB33; 04-20-2013 at 09:05 AM.

  5. #5
    Registered User
    Join Date
    04-19-2013
    Location
    CA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: MACRO to copy cells from multiple sheets into a summary sheet

    thanks ab33!

+ 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