aglawrence
New Member
- Joined
- Sep 27, 2017
- Messages
- 3
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 have a single worksheet which contains over 5,000 rows as follows:
<tbody>
</tbody>
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:
<tbody>
</tbody>
Both worksheets would be contained in the same workbook.
Does anyone know how we can achieve this?
Thanks and regards,
Andy
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 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 |
<tbody>
</tbody>
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 |
<tbody>
</tbody>
Both worksheets would be contained in the same workbook.
Does anyone know how we can achieve this?
Thanks and regards,
Andy