Hi everyone,

I am trying to create an invoice template in Excel which will automatically populate with the products which have been ordered, along with their price and quantity. I would like to do this without using macros if at all possible, as I sometimes need to create invoices using my smartphone and the android Excel app does not appear to be capable of running macros.

I have a single worksheet which contains over 5,000 rows as follows:

Qty Description Net Price Tax Gross Price
Pump 10.00 2.00 12.00
1 Motor 5.00 1.00 6.00
Seal 20.00 4.00 24.00
Panel 1.00 0.20 1.20
4 Trim 2.00 0.40 2.40
Rotor 5.00 1.00 6.00

When someone orders an item, we enter a number into the QTY column, as above. The desired result in the Invoice Template worksheet would be as follows:

Qty Description Net Price Tax Gross Price
1 Motor 5.00 1.00 6.00
4 Trim 2.00 0.40 2.40

Both worksheets would be contained in the same workbook.

Does anyone know how we can achieve this?

Thanks and regards,

Andy