Transfer data between spreadsheets based on matching headers

Closed
Report
Posts
1
Registration date
Monday December 4, 2017
Status
Member
Last seen
December 4, 2017
-
Hi,

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.

Regards

J