Selecting File to do VLOOKUP From

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CrimsonPlague29 - 24 May 2008 01:29 GMT

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

Reply to this Message

AndrewArmstrong - 24 May 2008 03:08 GMT

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 to this Message

CrimsonPlague29 - 24 May 2008 03:50 GMT

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

> 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 to this Message