Hi Team, I just joined the forum today and looking for help.
To give you a background -
Sheet 1 - Has the Basedata having multiple column in Row 1 with different headers - around 60 columns
Sheet 2 - in Column A, I've pasted the 15 headers matching in Sheet 1 - Headers are transposed in Row 2 to 16 (column A)
Sheet 3 - Blank sheet
I need a macro which will help me do the following:
would check the headers in Sheet2, find those headers in Sheet1 copy the entire column and paste in Sheet3, these needs to be repeated for the 15 headers listed in Sheet2.
Any expert advise would be greatly helpful. Thanks for support