I don't know if this is really possible...
I have a sheet with an invoice format that I fill out with before printing it.
In another sheet i need to report all the values invoiced in a column and any time i change the invoice I need to paste new values at the end of the list in sheet2.
Is there a way to do it automatically? I mean any time I fill the format invoice excel takes the total amount and paste it as value at the end of the list in the sheet2?
Thank you
I have a sheet with an invoice format that I fill out with before printing it.
In another sheet i need to report all the values invoiced in a column and any time i change the invoice I need to paste new values at the end of the list in sheet2.
Is there a way to do it automatically? I mean any time I fill the format invoice excel takes the total amount and paste it as value at the end of the list in the sheet2?
Thank you