Can anyone help?
I have a list of items all priced, quantities are set to zero, when I insert a quantity the sheet totals the items, simple stuff I know, what I need is the items with ‘quantities’ to appear on sheet 2 below each other in a list. I’ve ‘kind of’ done it but the item appears on the same line as it does on sheet 1 so, for example; if item 17 is at row 104 on sheet 1 and is the first item with a quantity greater than zero, it appears on row 104 on sheet 2, the 103 rows above it are blank, and if the next item selected is on sheet 1 row 110 there are five blank rows between them. I would like to be able to get the items to appear on sheet 2 one below the other. I’ve tried many different combined functions to achieve this, but never get it right.
Thanks in advance