Want to create a dashboard in excel for easier search of items

[Mayank_joshi]

I have list of car features which are standard for different car models.

Here is screenshot of the same :

Each worksheet will have entries corresponding to different car models for all the features.

For. example Worksheet #1 will for "hyundai", worksheet #2 for "honda", etc.

Now the dashboard should be something of this sort :

Now in the Model button, it should show the drop down of the list of models (basis worksheet names) and in feature button it should autofill as user is typing.

After pressing go, if that particular feature searched is x , then it should display "Not Available" ; otherwise it should display that particular grid.


NEED HELP REGARDING THE SAME as IM NO GOOD ON EXCEL and need saving with my current.

 

[ouvay]

I imagine you are looking for something like this... I threw that together in a hurry so its not visually appealing or anything.. feel free to play around with it and I'll be happy to help you more on Monday

Download Data package from October 28th.

Size of the data package: 33.19 kB. Free transfer of up to 6 GB of photos, videos and documents. Send large files via email or a link to share. No registration, no ads, just simple file sharing!

filetransfer.io