I've been searching all over the place and haven't found an example quite like I want to do.
I've got about 4 dozen name and address files. One is the master name and address file with the following fields in the following order:
Last Name
First Name
Address
City State
Zip
Phone
Etc
It has 50 records in it presently.
Unfortunately, the other 4 dozen excel files don't follow this format or column order. For example, the format in one file is:
First Name
Last Name
Phone
Address
City
State
Zip
Other excel files have other formats as well and varying numbers of columns, some of which I don't need for this exercise. So, I can't just do a copy/paste of the entire spreadsheet and copying/pasting column by column is very tedious considering the number of worksheets involved.
What I want to do is append the contents of the second worksheet into the first, based upon column name. In other words, this second worksheet, containing 25 records would be appended to the first worksheet beginning at column 51 with the columns moved/copied to the correct order in the first spreadsheet. Am I making sense?
I think I could do this with a VBA macro... want to see if something already exists or if others have better ideas.
Thank you.
Bookmarks