Compiling automated report from stocklist

[webhead]

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]

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

Vaya con Dios,
Chuck, CABGx3

 

[webhead]

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.