I have a multiple table workbook and I need to fill one of the tables with data from all of the other tables when the other tables have more than 11 rows filled.
I have attached a workbook with the tables in it. All the data is sensitive so I had to remove all the data. The actual data doesn't matter in this situation just if there are more than 11 rows of data in each table. The amount of actual data in each table will change each time the workbook is started so that must be taken into account. The tables full sizes are A1:V200.
The 'Extra' table is the table that needs to be filled from tables, 7, 8, 9, 10, 11, 12, 1, 2, 3.
Please post code examples with your replies.
Thanks!
Bookmarks