HELP REQUIRED: Dynamic VLookup
I am trying to put together a vlookup that refers to another excel workbook,
however this workbook is created daily and has the name change daily.
I require one workbook to have vlookups that reference the other workbook,
but taking into account the name change. The name change is only in relation
to the date - eg File20090115.xlsx , File20090116.xlsx
I have no problem haing vlookup access a static name but I encounter
problems when trying to make it more intelligent. Any assistance is
appreciated and I extend my thank you in advance.
Cheers,
Clint
|