Help with worksheet to easily access key service data on a specific unit

[Warfrin]

Thanks for taking time out of your busy day to read my post! Full disclosure, I have limited Excel knowledge but have been doing online "Training".

The Ask:

I want to put together an excel worksheet that will allow Service Technicians to easily access key service data on a specific unit. An example of this would be as follows:

A 2012 Yamaha ATV comes into the repair facility for an oil change. I would like the technician to easily walk to their computer, Select Make, then Year, then Model and a sheet of user defined data is populated for the technician to see. Of course, a rest button is always handy I believe my limited skill set would allow me to create drop down menu's in a horizontal fashion on one sheet, but I find these confusing. My hopes would be that, as each option is selected by the user, a new sheet is populated (with another drop down selection) the final sheet being the Service Data. Hope this makes sense.

Anything that can be suggested would be very appreciated.

[AliGW]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are new here, I have done it for you today.)


There are instructions at the top of the page explaining how to attach your sample workbook.