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.
Last edited by stubert87; 07-25-2011 at 08:10 AM.
Maybe what you need can be found http://www.contextures.com/xlDataVal02.html
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks