On 'Sheet 1' I have a table with 4 columns;
item
item code
item picture
quantity
The only formula driven cells are 'quantity', the rest are static.
....
I basically want this table duplicated on 'sheet 2' but ONLY want data displayed if the quantity cell (in the 'sheet 1' table) is ABOVE 0.
If an item is 0. i don't want it to appear.
any ideas?!
Bookmarks