Hello bigMe,
The code I have provided won't work when you want to add the data from table1 to the last row of existing data of table2 based on the header from one workbook to another workbook. The code will overwrite the cells from the second row of the matched header.
To make it more dynamic...
Dear bigMe,
Thanks for your query.
In response to your query to add data from table1 to table2 based on the header, I have created a table of employees' information in Sheet1 of the Employee Info workbook.
Now, I want to import the entire column of the matched header of the Employee Info...