I want to make a worksheet which can be used as a printed receipt towards customers, this is the basic layout:
- Customer contact details (name, address, etc) these are fixed fields that may be empty
- Header row: "Item|Qty.|price|total"
- Dynamic table containing any number of lines, one for each article the customer purchases
- Footer row containing total number of articles and total amount
What I'm struggling with is how to make the dynamic table work.
Currently I manually insert a row for each new article, but this is cumbersome in situations where it's very busy.
I would like excel to show one blank line by default, and then insert a next line each time the previous line contains any data, automatically moving the footer row down one line and updating the formula used to calculate the total qty. and amount.
Is this possible at all?