Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
The best way forward?
Hi,
Please could someone advise me on the best way forward to do this? I have 25 'areas' and some 20 'categories'. I need to display these so that each area can look at it's own performance or look at the categories across each area. I was wondering if there is a recommended way to say create two worksheets, one for areas and one for categories, then as an example allow a user to select an area from a list and have the display then show the required data. For example, on the categories sheet, the initial display would be the sum of all catrgories across all areas, then a user could select an individual catrgory and see how each area has performed. Would the best way forward be vlookups. index/match or database functions?. Any advise would be greatly appreciated. Also any good links to study the suggested methods?. Thanks, Mickey |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date going forward | Excel Worksheet Functions | |||
HOW DO I GET A BALANCE TO C/FORWARD TO NEXT WORKSHEET | Excel Worksheet Functions | |||
hyphen to forward slashes? | Excel Discussion (Misc queries) | |||
Carrying a balance forward | Excel Worksheet Functions | |||
Page forward goes backwards | Excel Discussion (Misc queries) |