Hi All,
I'm attempting to copy data from one work book to another. The column names in the header (Row 1) that have the data I want will always be the same, but the column order will be variable. There are many columns in the data sheet but I'm only looking for a few columns out of many.
What I have so far is this:
Which will copy the entire column, but I already have specific headers and formatting in the destination workbook, so I only want the variable data in each column to be copied.
What I would normally use copy data out of a column is this:
Which is works great when I know which order the columns will be in (Column B for example), which is not the casecurrently.
Any help would be greatly appreciated, thanks!
Bookmarks