Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting File to do VLOOKUP From
Hello,
I have a file that creates a daily build schedule..Is there any way I can create a macro function that will automatically vlookup the comments /details from the most recent file??? Or be able to select the file where to vlookup from??? The files are the same format every day just the comments, status, order # would change example file names: Build plan day 1 Build plan day 2 When build plan day 2 is generated i want to vlookup some columns from build plan day 1 file. thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting File to do VLOOKUP From
Why can't you use a standard v-lookup with a syntax similar to this:
Just put the other workbook name in brackets =vlookup(value to lookup,'[BuildDay1.xls]Sheet1'!$A$1:$B$7,1,false) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting File to do VLOOKUP From
but the workbook name changes every day.. buildday1, then buildday2(need to
get info from buildday1), then buildday3(need to get info from buildday2)...etc Becuase operators only update the current days file and I need to pull specifc data from previous day's update I need it to automatically find the most recent or give me an option to select the file to vlookup from "AndrewArmstrong" wrote: Why can't you use a standard v-lookup with a syntax similar to this: Just put the other workbook name in brackets =vlookup(value to lookup,'[BuildDay1.xls]Sheet1'!$A$1:$B$7,1,false) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP selecting, not highlighting | Excel Worksheet Functions | |||
Vlookup selecting next highest value instead of equal or nearest l | Excel Worksheet Functions | |||
Vlookup - Array not selecting in other workbook | Excel Discussion (Misc queries) | |||
selecting the cell that a vlookup or match function references | Excel Programming | |||
VLOOKUP specific monthly accounting data by selecting drop down li | Excel Worksheet Functions |