Compiling automated report from stocklist

  • Thread starter Thread starter webhead
  • Start date Start date
W

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?
 
Data > Filter > AutoFilter, and select "non-blanks" in the column giving your
order quantity.

Vaya con Dios,
Chuck, CABGx3
 
Data > Filter > AutoFilter, and select "non-blanks" in the column giving your
order quantity.

Vaya con Dios,
Click to expand...


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.
 
Back
Top