change data in workbook from various drop down list items

[J-Stack]

Hi all and thanks in advance for any responses.

I'd like to start by iterating I have NO formal Excel training and anything I've done with it has all be self taught on an as-needed-basis. With this particular project, I'm at my wits end and am seeking the advice of the community.

The current project I'm working on is a progress report for a client I have in regards to maintaining 7 different properties with multiple equipment at each location. I though it would be professional and courteous to provide quarterly updates as to the progress of each location, site any abnormalities or necessary repairs and keep a running tab on the efficiency improvements of each piece of equipment. I would also include columns for repair costs, total repair $$$ invested and the number of days between breakdowns. I was thinking of having a chart or graph show the progress as time progressed.

So the idea I have for the workbook is to have a drop down list with all the locations in it and have the data in the workbook change as they choose a different location, as opposed to having separate workbooks or for myself, when entering data, simply choose a location from the dropdown list to update the data. Then the end of year goal would be to have a workbook that combines all that data and averages out the efficiency improvements total $$$ spent so we have baseline to compare against year two.

I hope that makes sense.

Best,
J

[Blake 7]

why dont you mock up a workbook showing your data and your desired output? that would help others to help you.

[J-Stack]

Here's a screen capture of the rough idea I have going. The blue box is where the drop down menu of locations is. I'd like the data below to change reflecting each different location. I realize the chart will update automatically, but I'd like to have a chart that shows the over-all efficiency improvements for all locations combined.

Capture.PNG

Hope that helps.

[J-Stack]

BTW, the current chart is just a 'mock' and doesn't reflect any actual data. The main thing I need understanding with is how to have the data change with each chosen location.

Thanks again for all replies.


Best,
J

[Blake 7]

Why dont you upload your workbook, the one with the data in? from the image it looks like you will need a data validation list and the index function.

[J-Stack]

I didn't know I could upload the whole workbook. for the record, I did use the Data Validation tool to create the list. I have a list of the locations in column "S" and hid the column. I just don't know how to have the other data change when choosing a new location from the list.