Morning all - Long time reader, first time poster.
I have a small issue. I have 4 excel files. Each one of these files is updated daily, and the tabs are given new names respective of the date. (eg, yesterday's one will be 04-05-09, todays will be 05-05-09). I'm creating a summary page bringing information from all of these files into one 'front page', but due to the dates on the tabs changing daily, I'm unsure how to make a vlookup find the date, and match it with a tab name before actually doing the lookup within the sheet ... hope that makes sense!
Any help is always appreciate.
Thanks, and have a good day! =D
I have a small issue. I have 4 excel files. Each one of these files is updated daily, and the tabs are given new names respective of the date. (eg, yesterday's one will be 04-05-09, todays will be 05-05-09). I'm creating a summary page bringing information from all of these files into one 'front page', but due to the dates on the tabs changing daily, I'm unsure how to make a vlookup find the date, and match it with a tab name before actually doing the lookup within the sheet ... hope that makes sense!
Any help is always appreciate.
Thanks, and have a good day! =D