Hi All,
I'm new to macros and I've been working on this for days but can't seem to get it. I have a workbook with 15 tabs/sheets including the summary sheet I've already created. They all have different names (i.e. Apparel, Automotive, Beauty, etc). Each sheet contains the exact same table, with 465 rows (that will continue to grow) and 7 columns. I need for all of that data in each table to be copied over the same table on the existing summary sheet. The summary sheet also contains some other separate tables with formulas, etc that I don't want to be affected.
I need for the last two sheets on the page to be excluded from the summary. Those are named PASS|R|GY and Sheet2.
Hope I provided enough info. Thank you for the help!
Bookmarks