- Jul 24, 2018
- Office Version
I have workbook with numerous worksheets. I need to copy the table titled PayData(each time a page is created (via macro) a new number is assigned on the end of PayData) to one main table. This will combine all the PayData for all the employees listed and then allow me to filter by month. How do I copy all the PayData tables to one table?