Hi. I have 2 workbooks: First is "Audit", with worksheet "Index" and 2nd workbook is "Test" with multiple worksheets. I need a code that will look at the header in cell A1 of worksheet "Index", then look for the matching header in all the worksheets in the "TEST" workbook. Once found, I need the code to copy the column under the header in "Index", and paste it in the column under the Matching header in workbook "TEST".

I am a novice to VBA and have found a simple code, but it is set up so it copies from the "TEST" to the "AUDIT" file instead of the other way around. I don't know how to modify to make it: 1) copy correctly from "AUDIT" to "TEST"; 2) look through ALL worksheets in the destination file (now it is searching through the first one "Raw Data" only. Once I can figure that out, I'd like to further expand the code so that it repeats the same with all headers in range A1:M1 of the "AUDIT" file, copies only rows 3:36 of each column, and pastes VALUES into rows 6:39 of the destination column. Any help on any of this would be appreciated.

Please Login or Register  to view this content.

THANKS!