How to automatically copy VLOOKUP FORMULA IN A COLUMN
 

I have a spreadsheet that has 34 lines pers employee. I have a column
called
payfield and payfield amount. I want to copy the formula down. Payfield has
Pay field number 1-37 as listed below, but only 34 lines. The formula will
is in the Column L as shown below. After PAY FIELD NUMBER then it starts
over again. Hope this is clear.

COLUMN I COLUMN L
STARTING ROW 2 STARTING ROW 2

Pay Field-Number Payfield Amount
1 Has a VLOOKUP FORMULA
2 BLANK
3 BLANK
4 BLANK
5 BLANK
6 BLANK
7 BLANK
8 BLANK
9 BLANK
10 BLANK
11 BLANK
12 BLANK
13 BLANK
14 BLANK
15 BLANK
16 BLANK
17 BLANK
18 BLANK
19 BLANK
20 BLANK
22 HAS A VLOOKUP FORMULA
23 HAS A VLOOKUP FORMULA
24 HAS A VLOOKUP FORMULA
25 HAS A VLOOKUP FORMULA
26 HAS A VLOOKUP FORMULA
27 HAS A VLOOKUP FORMULA
28 HAS A VLOOKUP FORMULA
29 HAS A VLOOKUP FORMULA
30 HAS A VLOOKUP FORMULA
31 HAS A VLOOKUP FORMULA
32 HAS A VLOOKUP FORMULA
33 HAS A VLOOKUP FORMULA
36 HAS A VLOOKUP FORMULA
37 HAS A VLOOKUP FORMULA


I am looking for an easy way to copy the formula all the way down without
going to the fields one by one and copy the VLOOKUP FORMULA and of course
leave the lines blank that should be. Need to finish this spreadsheet
tonight. I can e-mail the spreadsheet if that will make it clearer.

Bascially I am looking to use fill down to copy the formula or a macro that
will automatically fill down the rows. It is about 6,000 lines - 34 lines
per employee - 192 employes. Also, of course the column index number changes
per payfield. Anybody?

Thanks in Advance any help or solution. Working on this now.