Create dropdown menu that changes vlookup references.
Hi All,
I am creating a sheet that will be a rollup of data sheets to be created weekly. The rollup sheet has a series of vlookups referring to a data sheet. I would like to be able to select a particular week through a drop down menu and have the sheet update with that week's data. Where do I begin?
Thanks in advance.
Post a sample workbook?Where do I begin?
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
I can't provide a sample.
I suspect that you're not going to get much help then.
Sorry
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks