drop down box bringing up further info in adjacent cells?

[stubert87]

i dont quite know how to describe this. Basically i'm managing the food sales figures for my pub and several others in our district based on certain figures: number of meals sold, % of starters, % of desserts, % of side orders etc. this is an ongoing thing monitored every week. I have all the information in seperate tables in sheet 1. Now in sheet 2 i want to be able to pull that data up on a week by week basis. I.e. i select Period 10 Week 1 from a drop down list and this then brings up the figures from that week from sheet 1 so that those figures can easily be read without scrolling through seperate tables accross many weeks. i've never really used excel to this level but know it is possible. any help would be massively appreciated.

[arthurbr]

Maybe what you need can be found http://www.contextures.com/xlDataVal02.html

[stubert87]

thanks, its almost what i'm looking for but i dont want the dependant data to be a list, just the set of data as it appears for that period in the 1st worksheet