redjuledhawk
New Member
- Joined
- Jul 7, 2016
- Messages
- 3
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
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