Macro to Insert column and include a VLOOKUP array for entire column

I would like to insert a column at "g" and Inset this VLOOKUP "=VLOOKUP('Unfinished Correlated Log'!F3,WG205RUN1PASONDATA!$C$2:$N$5281,2) into that cell

This formula works in my current sheet I just want to be able with a click of button to have the column be inserted get the formula to work and have it carry all the way down the entire column - some of the data goes over 5000 rows and sometimes more ---sometimes less.


I want the column to have the header Title "Hole Depth" And I would like this formula to continue down the entire Column. Also the Column has to be formatted as number with 2 dec places.

Please Login or Register  to view this content.