To expand on my post, let me paint the full picture. I receive a spreadsheet of information and have to perform a fairly quick analysis. I move six specifc columns to the front of the spreadsheet so they are in a specific order from A thru E (the rest of the columns do not need to be in any specific order). Once ordered in the correct format I copy and paste all those columns into another spreadsheet, which then populates several sheets of data, formulas and calculations. I do several of these per week.
I would like to create a macro to do this faster. I am very new to the macro realm of excel.
I receive data in a spreadsheet from multiple sellers and the column headers are usually labeled differently from each seller, sometimes they say "open date" or "acctopen" or "contract date," etc... In addition to that, the column refering to open/contract date can be column N from one seller and possibly column AA from another.
Ultimately I would to use a formula in conjunction with a macro that will find a column header from a key word of open or contract, then highlight, cut and insert the column in a specific location, such as Column A.
I need some help with another macro, so I will leave that for another post. I hope I am following correct etiquitte as I am new to this type of message board. I really appreciate the suggestions.