Automated List Filtering

[HollyDesBois]

I work with a spreadsheet of materials for which a separate copy is used for each job the company carries out. Typically only 7 items are chosen from the list, so I end up being given a list of 100 possible items to order with only 7 chosen.

Is it possible to set up a process that means if the manager chooses an item then that item only automatically appears on a separate sheet, so that I am working from a list of seven, instead to the huge, mostly unused one?

[zbor]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[zbor]

Why can't you just create Data Validation of 7 items?

can you upload example workbook with you input and desired output?

[HollyDesBois]

Example Attachedsample.xlsx

thank you!

[JeteMc]

In the attached file I put the following formula on sheet 2 as your initial post said that you wanted the chosen items to appear on a separate sheet. You can copy this formula down until you start seeing blank cells and then copy across to get the quantity. The formula used is:

Please Login or Register  to view this content.

Here is a copy of your file with the formula applied:Copy of sample - show only chosen.xlsx
Let me know if you have any questions.

[HollyDesBois]

I am stunned! and it will take me some time to unravel what you have done here. How lovely you are

[zbor]

Here is another approach

Please Login or Register  to view this content.

[FlameRetired]

Edited

Another way with a helper column in column C this formula filled down.

Please Login or Register  to view this content.

Then this formula

Please Login or Register  to view this content.

filled down until you get blanks.

[JeteMc]

Glad that we were able to provide useful solutions. If any or all of them have provided a satisfactory answer to your query then please take a moment to mark the thread 'Solved' using the thread tools link above your first post. Hope that you have a nice day.