Consolidate inventory using lists

Hi mdelator

Welcome to the forum.

I am confused by "The list takes up 53 rows" when the inventory "consists of about 500+ items". (Perhaps you have 53 categories?)

That aside, could you not just filter on a 6th column which contains the category?

Regards
Alastair

Hi Alastair,

Let me try to explain a little more.

the columns go as followed

Columns Part number quantity location description
Rows 123 4 backlot module
345 5 router
223 1 appliance


So there are at the moment 53 different part numbers, hence the 53 rows. The categories that I would like to place them in would fall under description. I've only placed 3 different descriptions here but it is a total of 6.

So I want to be able to click on the certain category from the drop down list and see only what falls under that category. Does that make more sense? Please do help! Any advice is appreciated.

Hi mdelator

I think that we are talking of different things, here. I have attached a file that I think will work, but it will consist of 500+ lines - ie 1 for each item. Each item will have a description which is the category. You can then filter on the description.

Does this work for you?

Regards
Alastair

Alastair,

This is very helpful! Thank you. Now let's say I'd want to change/add more descriptions to that filter. How would I do that?

I figured out! thank you again

Hi mdelator

I'm glad you got it to work. You will have to re-set the filter if your list goes past the end of the filter (highlight the area to be filtered, remove then re-instate the filter)

Regards
Alastair