+ Reply to Thread
Results 1 to 3 of 3

Macro/script that combines unique rows to a master sheet from sheets that are only numeric

Hybrid View

  1. #1
    Registered User
    Join Date
    02-19-2019
    Location
    USA
    MS-Off Ver
    Office 2013
    Posts
    15

    Macro/script that combines unique rows to a master sheet from sheets that are only numeric

    I am trying to get a combined macro that will copy only rows that start with "test" in column A on sheets that are numeric (the 4 digit sheet names) and then paste them to a master sheet appending to each other but needs to skip the non-numeric sheet names (like forecast, or ramp, etc)

    so example would be each row that has test in column A on sheet 2100 would be copied and pasted to a new sheet named Master. Then it would copy the same criteria from sheets 2200, 2300, etc.

    Anyone have any experience with this? I've attached a sample sheet to show what I mean.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: Macro/script that combines unique rows to a master sheet from sheets that are only num


    Real worksheet does not have a headers row ?! As at child level with headers just using a filter …

  3. #3
    Registered User
    Join Date
    02-19-2019
    Location
    USA
    MS-Off Ver
    Office 2013
    Posts
    15

    Re: Macro/script that combines unique rows to a master sheet from sheets that are only num

    I want to copy the rows to a master sheet that is just going to be used as raw data.

    the numeric tabs are dynamic, we will add and remove tabs constantly, which is why I wanted a VBA to do the copy so it can copy any and all test rows from numeric sheets to 1 master sheet. The amount and location of rows that start with test will by dynamic as well, always changing.

+ 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] Adjusting a macro that combines data from multiple sheets into existing sheet
    By Stuartzz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-04-2018, 05:49 PM
  2. [SOLVED] Adding the rows of sheets to a master sheet.
    By mohit999 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 09-20-2016, 10:11 AM
  3. Need the master sheet to filter rows to other sheets
    By chrisdantonelli in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-01-2014, 08:03 PM
  4. Macro to Transfer data from multiple sheets into rows on a master sheet
    By serrone in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-30-2013, 06:35 AM
  5. Return Unique Entries from Multiple Sheets into Master Sheet (in Excel 2003)
    By XLHead in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-13-2011, 01:34 PM
  6. inserting rows from different sheets into master sheet
    By Alicita in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-12-2011, 08:25 AM
  7. How do I make a sheet that combines all tabbed sheets & update as.
    By ahmebah in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 01-31-2005, 12:06 PM

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