Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I automatically update column index number in VLookup whe. | Excel Worksheet Functions | |||
Copy formula automatically down when date is entered | Excel Discussion (Misc queries) | |||
Copy VLOOKUP Formula | Excel Discussion (Misc queries) | |||
Automatically insert row and copy formula | Excel Worksheet Functions | |||
How do I create a formula in excel to automatically copy text fro. | Excel Discussion (Misc queries) |