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