Need a Macro to input formulas

Hello I am trying to input formulas using a macro.



I want to input the following formula in column K:

=VLOOKUP(J2,'FA SPLIT MASTER'!$A$1:$A$57670,1,FALSE)

However what I need the Macro to do is input the formulas only up to the length of the entire table in column K.

Column A in this worksheet is the only column which does not have any blank values so that could be used as reference in the macro.

All help is appreciated.

Thanks

Hi

Try

Please Login or Register  to view this content.

rylo

Thanks man. I think this is the 3rd time you have come to the rescue.

Thanks