Errors in VBA code

[mpost54]

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

[Crooza]

G'day mate and welcome.

I had a play. Try this. Is this what you wanted?

invoice_control_new_work_copy(1).xlsm

[mpost54]

Hi Crooza,

Some gains and some losses alas!

When clicking on "view invoice" button on the "Invoice worksheet" cell C10 is populated from "Invoice Data" column "J" This should not happen,

On the "Invoice worksheet" when clicking on "View Invoice" button additional data appears in the "amount column" that is incorrect ie not shown against the "Invoice #" data shown on the "Invoice Data" worksheet.

Thanks for trying - I think you can understand my dilemma.

'

[Crooza]

I'll try to review tonight. Was the c10 issue happening before I looked at it? You don't mention it in your original post and I can't imagine the changes I made affected that.

[Crooza]

invoice_control_new_work_copy(1).xlsm

Try this one. It seems to fix the issues you raised in your last post

[mpost54]

Yahoo this seems to have fixed my problem!!!!
Now I will have to look closely to see how you fixed it so I can learn more
Thanks Crooza - your a legend

[Crooza]

Great. Glad it worked. I commented out a few lines of code (rather than deleting it for the c9 and c10 issue) and the rest was just extending the range for the clear contents from column G to column H and picking up an extra column in the paste areas