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