If Then - Fill? 1 List to 2?

[JustOneQuestion]

Hi all,

I am looking to separate a list based off the value in one cell.

I have a 'master' list that has all lots of items on it, and I want to be able to a number, or letter, in a cell off the side of the quantity/description/notes that will mirror the selection in a smaller list.

Here is a made up example of a shortened 'master' list.

[TABLE="width: 406"]
<colgroup><col span="2"><col><col><col></colgroup><tbody>[TR]
[TD]Product[/TD]
[TD]Size[/TD]
[TD]Quantity[/TD]
[TD]Notes[/TD]
[TD]List[/TD]
[/TR]
[TR]
[TD]shirt[/TD]
[TD]lg[/TD]
[TD="align: center"]20[/TD]
[TD]black [/TD]
[TD] 1[/TD]
[/TR]
[TR]
[TD]pants[/TD]
[TD]xl[/TD]
[TD="align: center"]12[/TD]
[TD]white[/TD]
[TD] 2[/TD]
[/TR]
[TR]
[TD]gloves[/TD]
[TD]med[/TD]
[TD="align: center"]6[/TD]
[TD]blue[/TD]
[TD] 2[/TD]
[/TR]
</tbody>[/TABLE]

I want to have another section, for example list 1, that takes all of the items (the product, size, quantity, notes) and puts it in a separate list. without the other items.

So in this example list 1 would only show

[TABLE="width: 406"]
<colgroup><col span="2"><col><col><col></colgroup><tbody>[TR]
[TD]Product[/TD]
[TD]Size[/TD]
[TD]Quantity[/TD]
[TD]Notes[/TD]
[TD]List[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 406"]
<tbody>[TR]
[TD]shirt[/TD]
[TD]lg[/TD]
[TD="align: center"]20[/TD]
[TD]black [/TD]
[TD] 1[/TD]
[/TR]
</tbody>[/TABLE]


and list 2 would only show:
[TABLE="width: 406"]
<colgroup><col span="2"><col><col><col></colgroup><tbody>[TR]
[TD]Product[/TD]
[TD]Size[/TD]
[TD]Quantity[/TD]
[TD]Notes[/TD]
[TD]List

[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 406"]
<tbody>[TR]
[TD]pants[/TD]
[TD]xl[/TD]
[TD="align: center"]12[/TD]
[TD]white[/TD]
[TD] 2[/TD]
[/TR]
[TR]
[TD]gloves[/TD]
[TD]med[/TD]
[TD="align: center"]6[/TD]
[TD]blue[/TD]
[TD] 2[/TD]
[/TR]
</tbody>[/TABLE]

Is this possible?

The items and lists will change a lot, that is what I do not simply have list 1 and 2 with those specific items.

Thank you!

-JOQ

 

[Max1616]

Why not just create a pivot of the master data in your sheet, then add the list field to the pivot filter? From here the table will only populated whatever list you specify in the filter.

 

[JustOneQuestion]

Any chance you could walk me through that?

thank you!

 

[Max1616]

Step 1: Click anywhere inside the raw data set and press Alt,D,P,Enter,Enter,Enter (This will create a pivot table for you).
Step 2: Click Product, Size, and Notes boxes in the pivot fields list (new pane on the right of your screen). This should add these fields to the Row Labels section of the pivot pane.
Step 3: Click the Quantity label and drag it to the values box of the pivot pane
Step 4: Click the List label and drag it to the Report Filter box of the pivot pane
Step 5: Click anywhere in the pivot table then click the PivotTableTools -> Design tab in the MS Ribbon (It should be the color pink).
Step 6: Click the Report Layout Button dropdown and choose "Show in tabular form"
Step 7: On the same tab, click the Subtotals dropdown and choose "Do not Show Subtotals"
(Everything you have done so far has set up the pivot table)
Step 8:Directly above the pivot table you will see a filter box that takes up two cells. It will say "List" in the left cell, and "(All)" in the right cell. Click the drop down in the right cell and choose which list you would like to view.

Hope this helps.