Results 1 to 10 of 10

Macro to Copy Data from Multiple Sheets Into One

Threaded View

  1. #1
    Registered User
    Join Date
    07-26-2006
    MS-Off Ver
    Office 365
    Posts
    97

    Macro to Copy Data from Multiple Sheets Into One

    I have a model that needs a macro to copy data in other worksheets into one sheet. The good thing is each sheet has the same rules for starting cell and number of columns. The issue is that the number or rows will differ in each worksheet.
    Here is how I am envisioning the setup. (see attachment as well)
    1. The worksheet data needs to be copied into is called “Combined”
    2. The sheets that need copying are between what I call “bookends”
    a. The bookends are Sheet “B” (for beginning) and Sheet “E” (End)
    3. The macro will look in the first sheet after (to the right of) Sheet “B”
    4. It will identify the range of data. The range will always start in cell A10 and pull the columns A through K
    5. It will determine the range (rows down) by finding the first “blank” cell in column A (and not include the blank row).
    a. For example, if the first blank after A10 is A20, the range selected will be A10:K19
    6. The macro will copy all the data (and formatting) and place it starting in A10 of the “Combined” tab.
    7. The macro will repeat this for the next tab between the “B” & “E” bookends, copy and paste the new data range directly under the last data set in the “Combined” tab
    8. The macro will repeat this process until it gets to the “E” tab and then ends.
    I’m hoping the steps above are systematic enough. Sometimes I can be vague and my intent unclear. If unclear please respond and I will clarify.
    Thank you in advance for your time.
    Attached Files Attached Files

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 data from multiple sheets and put it in one sheet.......everyday
    By Ash_Maverick in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-01-2016, 05:20 AM
  2. [SOLVED] Copy data from multiple sheets to one sheet macro
    By sinapourazima in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-13-2014, 12:49 AM
  3. Creating a copy/paste Macro with data from multiple sheets
    By sierradk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-12-2014, 05:21 PM
  4. Help with creating a macro that will copy and paste data to multiple sheets.
    By harkin123 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 08-19-2013, 06:57 AM
  5. Replies: 1
    Last Post: 02-08-2013, 10:36 PM
  6. [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
  7. Macro to Copy Data from One Sheet onto Multiple Sheets
    By ssteines in forum Excel Programming / VBA / Macros
    Replies: 32
    Last Post: 03-03-2011, 05:50 PM

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