Program that finds a header then displays that column on another WS

[westerla]

The vendor I get one of my reports from is constantly rearranging the columns of their report.

My plan is to paste that Vendor report onto a designated worksheet within my Template Workbook. I need to create a program that will search for a Specific Column Header on the Vendor report, copy that column, and display it on the primary worksheet. There are a total of 5 columns I need to this for. Currently, after I download the Vendor report, I manually copy each column individually and paste it into my template.

I can write formulas and record basic macros, but know absolutely nothing about writing in Visual Basic. Because the column locations constantly change a simply macro wont work. But the Headers are constant.

The Columns Highlighted in Yellow are what I need to find and display.

Thank You!

[rylo]

Hi

Which sheet in your example file is which? Which is the vendor report, which is the sheet the columns have to be copied to, and which is the final output sheet?

rylo

[westerla]

Thank you for taking the time to look.

The Vendor Data is on the IBPAgentReport WS. The final Output sheet is the first WS of the Workbook. The first 5 columns highlighted in yellow (Agent Name, Busy(Work), Open, Calling, and On Call) are what I need to find on IBPAgentReport and display the data in those Highlighted Columns.

[rylo]

Hi

Try this.

Please Login or Register  to view this content.

rylo

[westerla]

That worked liked I dreamed it would! Thank you very much.

[westerla]

Just found a bummer. When I tested it with a different set of data (remember the vendor report constantly moves the columns around), it doesn't work. The Highlighted error in the code is

Please Login or Register  to view this content.

[westerla]

I apologize, I broke it. I fixed it, you are still wonderful and answered a dream.