Selecting File to do VLOOKUP From

[CrimsonPlague29]

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

 

[AndrewArmstrong]

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)

 

[CrimsonPlague29]

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