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?
CLR - 01 Feb 2008 19:10 GMT
Data > Filter > AutoFilter, and select "non-blanks" in the column giving your
order quantity.
Vaya con Dios,
Chuck, CABGx3
> Hi all,
>
[quoted text clipped - 7 lines]
>
> How should I approach this?
webhead - 01 Feb 2008 21:04 GMT
> 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.