Parts list based on Equipment

Each of the following examples will fit your needs. Here is a macro for only one of the attached workbooks:

Please Login or Register  to view this content.

Thanks for the replay. I was lucky and found a video on you tube for what I was looking for. As I said I'm a complete novice but was able to adapt what he did for my purpose.

Now what I'm trying to do is confine my lists to Columns A-E in the Selector sheet but need the Equipment list below that to shift up or down adapting to the Contents when they Spill in or out.

I attached my work for reference

Again thanks for the help

Done

Sorry about that

Is this what you want

Formula:

Please Login or Register  to view this content.

Sorry but thats not it. If you look at my example you will see two sets of searches. 1 in column A-E te other in G-K. I want all my searches confined to A-E. The problem is that I dont know how many rows each list will generate and was wondering if the rows can be self shifting up or down depending on the length of the list.

If you mean you want the data validation in G2 to go underneath the first filter formula & move up/down, then that is not possible.
If that is not what you mean, can you please post another workbook that shows what you want.

Thats exactly what I was looking for.

Thanks anyways.

Glad to help & thanks for the feedback