Only Show Data After Selections Are Made

[redjuledhawk]

All,

I am trying to build an extensive spreadsheet, and after a few selections are made, only show the data that pertains to the selections. This is for a Transportation Company and the owner wants to see this. However, he is not computer savy and I may have to show this to him on a paper sheet.

Here is the data that I would want to include:

Type of Truck Size Chassis Companies

Under Type of Truck, I would want the following:

Dump Truck
Water Truck
Service Truck
Stake Bed Truck

Under Size, I would have the following

5 Yard (Only applies to Dump Trucks)
10 Yard (Only applies to Dump Trucks)

2K (only for water truck)
4K (only for water truck)
1.8K (only for water truck)

Under Chassis Companies, I would want the following:

Freightliner
Peterbilt
Mack
Volvo
Kenworth
International
Ford
Chevy
Dodge
GMC
Kia
Isuzu

What I would want to see, is all the data returned that is associated with the selections:

Example:

If you select Dump Truck, then Select 5 Yard, and then select Freightliner, it would show you all the specifications for the Freightliner, but hide the ones for Peterbilt, Kenworth, Mack, Volvo, Etc. I may want to be able to choose three 'Chassis Companies' for comparison purposes and return all the data as well.

Can this be done? I don't even know where to start. In my 25+ years of doing this, we have always had a system that this data was in and we could generate this report easily. However, we are not purchasing a system here (yet ) and need this now.

Thanks,

Rob

 

[mole999]

If you have a table, you can model it in a pivot and select down to a small list

 

[redjuledhawk]

Hello Mole999,

Can you provide an example?

 

[mole999]

see if this can help, easy to demonstrate to someone when you are set up to do so > https://www.youtube.com/watch?v=peNTp5***Fg

 

[redjuledhawk]

Video does not exist.

 

[mole999]

the thres stars are

lower case

f u k

peNTp5***Fg

caught by the swear filter