Drop Down List Query
Hi I am just learning Excel trying to setup a spreadsheet - my query is how do you set up a drop down list which contains variable information - linked to another spreadsheet where the information is input.
I want to be able to change list using week numbers which return a set of varible data for that week.
Can anyone advise best way to tackle this?
Thanks
|