Hello,
I am in charge of an inventory that consists of about 500+ items. These items fall under 6 categories. I have a list of the items within excel already in sheet1, but I want to make it look more presentable and easy to read for co-workers.
At the moment, I have it set up with 5 different columns, (order #, part #, quantity, description, and location). The list takes up 53 rows. What I have in mind is to have a drop down list, where when I click on a certain category, it displays all the information in the 5 different columns, but only for that category. and when I click to the next list, it displays the next and so on and so forth.
I am able to create a drop down list already, but as for mapping the information that I want to each category on the list, I am at a loss. Please help! Any input would be appreciated. If you could point me in the right direction where I can learn how to do this would be great too. Thanks!
Bookmarks