I would like to pull data from Sheet 1 to Sheet 2 of same excel file. Sheet 2 is the master sheet and it has 20 columns (headers are customer information such as firstname, lastname, phone etc.). Sheet 1 has some of the headers of Sheet 2. At the start Sheet 2 is empty (only has headers), and Sheet 1 has both headers and data.
I would like a macro that:
- Go through all column headers of Sheet 2.
- For each column header, copy the whole column (if exists) from Sheet 1 to corresponding column in Sheet 2.
Can someone help pleasetks in advance. I was inspired by the following post, but can't rewrite that
. - http://en.kioskea.net/forum/affich-2...cified-columns
Example:
Sheet 2:
FirstName----LastName----Phone
Sheet 1:
Phone---------LastName
bb-------------cc
bb-------------cc
bb-------------cc
Desired result after executing the macro:
Sheet 2:
FirstName-------------Phone---------LastName
-------------------------cc-------------bb
-------------------------cc-------------bb
-------------------------cc-------------bb
Thanks all in advance!
Bookmarks