Copy columns of different headers

Hi,

I am looking for a fastest code that will do the flow below. I have 2 sheets in a workbook wtih "old" and "new" sheet. The old sheet has 100+ columns and thousands of data. The new sheet is where all the needed data from the old sheet should be copied. The new sheet has already have the headers (Row 1).

The tool flows like this:
1] get the value in sheet new A1
2] find the value in sheet old columns 1-100
3] when the value is found, copy the entire column from sheet old to sheet new of the same header
4] when the value is not found, go to next value in sheet new B2
5] and repeat step 3 or 4 until all headers in sheet new are populated


I am not yet expert to use arrays and for loops so I will be needing a help to code this.

Thank you.

Hi Richard,

I actually need a whole code for this.

Thanks.

Maybe:

Please Login or Register  to view this content.

Hi John,

It exactly does the code I need. Your genius.

Thanks much for this. Really appreciate it.



Best Regards,
Sarah

You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rules and mark this thread as SOLVED.

Originally Posted by JOHN H. DAVIS

Maybe:

Please Login or Register  to view this content.

How can I use this code with two different files? The old sheet is workbook 1 and new sheet is workbook 2? How can I modify the code? Thanks.