I need to do this one but I'm kind of at a loss. Not sure how should I go about doing this.
So the general idea is I want to make some sort of a template for purchase orders(or invoices/or even quotes) where a list(report?) will be generated that will ONLY show the relevant products. What I want to work out is to have all my items listed in the first worksheet. I want the list/report in worksheet 2 to work so that I only need to write how much of an item I need in worksheet 1 and that will show on worksheet 2.
I've attached an .xlsx. In that particular example, let's say I want 1 of AAA, 2 of CCC, and 1 of EEE, or any other combination, I want worksheet 2 to show those three lines.
Is this possible at all?
Thanks in advanced!