Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DashBoard Summary to contol output
Hi All,
I have a spreadsheet with the following columns of data Manufacturer, Product, size, Version, Memory capacity on sheet 1 I want to be able to set a header page where i would have 5 cells each labelled as per above. On each cell would be a kind of cell validation list i guess, where the user could select from a list the manufactuerer, then in the next cell, only have what products that manufacter makes, the next cell, the versions of that product and so on. Once on the cells have been selected with the data needed, i would like it to have either re-summarised the main table on sheet 1 to show the selections made or perhaps summarise into a different sheet - whatever would be easier ? I have had a look at some of the posts, but havent found what i am looking for. Is this kind of output possible where cell selection on sheet 1 could determines the output on another ?? Many Thanks in advance for your replies Matt -- Matt Lynn Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200912/1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I show a summary output from data on excess returns | Excel Discussion (Misc queries) | |||
Contol toolbox command button | Excel Discussion (Misc queries) | |||
How to interpret summary output from multiple regression analysis | Excel Discussion (Misc queries) | |||
How do I get the output summary? | Charts and Charting in Excel | |||
Can I contol Tab Order in a worksheet? | Excel Worksheet Functions |