I have a workbook that includes multiple sheets, unfortunately, the names and number of sheets vary from workbook to workbook. I am trying to set up a macro that:
-selects active sheets
-copies a specific range of cells
-paste that information to a New sheet
-selects next active sheet
-copies text
-paste into the same New sheet
-repeat until all sheets have been copied/pasted into one new sheet for easy filtering
I have the code to copy/paste, but I'm struggling on how to find active sheets and pasting to a new sheet after each copy/paste.
Thanks in Advance for the help
Thanks for looking and helping
Bookmarks