Results 1 to 3 of 3

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

Threaded View

Reezen Macro/script that combines... 05-22-2019, 10:00 AM
Marc L Re: Macro/script that... 05-22-2019, 10:18 AM
Reezen Re: Macro/script that... 05-22-2019, 10:46 AM
  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

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