Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup Variables
I download a new spreadsheet everyday, this spreadsheet will have several new
rows everytime. What I need is for this lookup to automatically find the last row in the table array Range("H2").Select ActiveCell.FormulaR1C1 = _ "=VLOOKUP(RC[8],'[Cell Refs Update Macro V3.xls]Lookup'!R2C1:R1770C5,3,FALSE)" Selection.AutoFill Destination:=Range("H2:H" & lastrow) Can anybody help me? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup Variables
Hi,
One way: LastRow=Range("A65536").End(xlUp).Row (Assuming that column A has data in the last row.) -- Ken Hudson "Megadrone" wrote: I download a new spreadsheet everyday, this spreadsheet will have several new rows everytime. What I need is for this lookup to automatically find the last row in the table array Range("H2").Select ActiveCell.FormulaR1C1 = _ "=VLOOKUP(RC[8],'[Cell Refs Update Macro V3.xls]Lookup'!R2C1:R1770C5,3,FALSE)" Selection.AutoFill Destination:=Range("H2:H" & lastrow) Can anybody help me? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup Variables
Remember to check your other post(s).
Megadrone wrote: I download a new spreadsheet everyday, this spreadsheet will have several new rows everytime. What I need is for this lookup to automatically find the last row in the table array Range("H2").Select ActiveCell.FormulaR1C1 = _ "=VLOOKUP(RC[8],'[Cell Refs Update Macro V3.xls]Lookup'!R2C1:R1770C5,3,FALSE)" Selection.AutoFill Destination:=Range("H2:H" & lastrow) Can anybody help me? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup a Vlookup | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
Please Help! vlookup & match with multiple variables | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions |