Use VBA to find column and replace data?

[alexbrown61]

How do I use VBA to find a field name (Column header?) and then replace its data (row 2 to the end of the table) using a Vlookup table. I already have the lookup table built. Column names and table lenght are not always the same.

Thank you.

Alex

 

[alexbrown61]

I'm using windows 7 and excel 2007.