Hi Forum,
I've found a good Formula for appending 2 Tables that are on different worksheets from the site on the below link.
I was wondering if it can be altered to append any number of tables (about 20) & not just 2.
http://superuser.com/questions/53733...ntical-columns
I've attached a file that follows the link instructions where 2 tables of data - Sheet1 & Sheet2 are appended on Sheet3.
Sheet1 & Sheet2 have Named Ranges (SQLDB, EXCELRNG Respectively) that are used in the Formula on Sheet3.
Here's the Formula on Sheet3 that brings the Sheet1 & 2 data over to Sheet3.
I've created another table on Sheet4 to see if anyone can add this into the Formula so it also appends on Sheet3.=IFERROR(INDEX(SQLDB,ROWS(A$2:A2),COLUMN(A2)),IFERROR(INDEX(EXCELRNG,ROWS(A$2:A2)-ROWS(SQLDB),COLUMN(A2)),"-")
Hope I've explained this clearly.
Thanks
Bookmarks