Hi all,

I'd like to make a big list with items, one item per row, multiple
properties and one column that states howmany I ordered.
On the next tab I'd like an automated report, displaying each line if
and only if I ordered something.

I somewhat managed to do that with an advanced filter but that's not
exactly what I want. It's not updated when I order some other items.

How should I approach this?

Data > Filter > AutoFilter, and select "non-blanks" in the column giving your
order quantity.

Vaya con Dios,
Chuck, CABGx3



"webhead" wrote:

> Hi all,
>
> I'd like to make a big list with items, one item per row, multiple
> properties and one column that states howmany I ordered.
> On the next tab I'd like an automated report, displaying each line if
> and only if I ordered something.
>
> I somewhat managed to do that with an advanced filter but that's not
> exactly what I want. It's not updated when I order some other items.
>
> How should I approach this?
>

On Feb 1, 8:10 pm, CLR <C...@discussions.microsoft.com> wrote:
> Data > Filter > AutoFilter, and select "non-blanks" in the column giving your
> order quantity.
>
> Vaya con Dios,


Yes but that compiles it in the list itself, not on another sheet. I
need a summarized list so I can order that by the other properties.