Transfer data between spreadsheets based on matching headers

leong_js Posts 1 Registration date Monday December 4, 2017 Status Member Last seen December 4, 2017 - Updated on Dec 4, 2017 at 02:11 PM

My use case is to transfer data from "Sheet 1" to "Sheet 2" within same workbook based on matching headers.

If header: Addresses appears in "Sheet 1", i would want to copy the entire column over to header:Addresses under "Sheet 2". It should build on existing data in "Sheet 2" and not overwrite the data.

There may also be blank cells in "Sheet 2" such as the example i have given in column F. So i hope the code should be able to accommodate blank cells, and to paste in the next row.

Look forward to hearing your advice on an appropriate VBA code. if you require more information, do let me know.