Macro required to copy formuals in cells

[robertguy]

Hi,

can any please advise me of the macro code required to insert the following formulas into the associated cells in a tab called 'Weekly Template' and copy down these formulas down the columns i.e. 'AH2' to 'AN2' until the the last row with data in is reached N.B. there is data is in columns 'A' to 'AI'

=VLOOKUP([@[CSC ID]],Table24,27,2) into cell ‘AH2’

=VLOOKUP([@[CSC ID]],Table24,28,2) into cell ‘AI2’

=VLOOKUP([@[CSC ID]],Table24,29,2) into cell ‘AJ2’

=VLOOKUP([@[CSC ID]],Table24,30,2) into cell ‘AK2’

=VLOOKUP([@[CSC ID]],Table24,31,2) into cell ‘AL2’

=VLOOKUP([@[CSC ID]],Table24,32,2) into cell ‘AM2’

=VLOOKUP([@[CSC ID]],Table24,33,2) into cell ‘AN2’

Many thanks in advance for any assistance received

Regards

Rob

[mehmetcik]

You did not specify which column or columns we should look at to find the last used row.

This code uses the Last Used Cell Instead

Please Login or Register  to view this content.

This code assumes that your last used data is in Column A ie column 1, if it is in Column B then change the 1 to a 2.

Please Login or Register  to view this content.