I am having a problem sorting out cell references and calculations on the "Invoice Worksheet" on the attached file.

They relate to a macro called "Inv"

1. Cell C9 should be a vacant cell
2. The result in cell E10 should be in cell F13
3. I cannot get the "Amount Column" and "Totals" to calculate on the "Invoice worksheet"

Obviously vba is not my cup of tea as I have spent many hours trying to resolve this!

Any help would be greatly appreciated.

Regards
Michaelinvoice_control_new_work_copy.xlsm