Transfer data between spreadsheets based on matching headers

leong_js 1 Posts Monday December 4, 2017Registration date December 4, 2017 Last seen - Dec 4, 2017 at 08:23 AM

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.



See more