Hey guys, I am trying to create a macro for a huge data file of 200
columns. I basically want it to do a few things:

1) Search though the file for certain column headers and move about 3
columns to a specific order.

2) Add columns before/after specific columns, again based on the heade
cell value.

3) Populate these new extra columns with formulas to generate values.


I know basics of VBA and can usually figure out things on my own b
experimenting, but could you guys put me in the right direction? Thi
could possibly be really easy but I am just not sure how to go abou
starting it, specifically the searching and moving/adding columns.

Thanks in advance

--
drdavidg
-----------------------------------------------------------------------
drdavidge's Profile: http://www.excelforum.com/member.php...fo&userid=3616
View this thread: http://www.excelforum.com/showthread.php?threadid=55947