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.
Bookmarks