How to use Hlook up with a macro

[Superfly3372]

Not sure how to get this done. Sheet one A1:EY1 are column headers which start off the same eachtime the workbook is opened. Data (numberic and text) will be copied and pasted into A2:EY? (? because the number of rows will be different every time). I need a macro to rearrange columns either based on a macro or an Hlook macro located in another worksheet.

Example
A1:Batch ID B1:ClmStatus C1:ClaimID D1:FinProd
12345 Paid Hosp CCA
99999 OPEN Hosp CCA
98574 Paid Clinic CCA

I need the headers along with all the data rearranged the same way when the macro is run.

A1:ClaimID B1:FinProd C1:BatchId D1:ClaimStauts

 

[texasalynn]

Use the macro recorder to go through the steps one time. Then after it is finished you can edit the macro to make it more generic. If you have questions about that, then post back with your macro