Macro updating of invoice sheet monthly yearly and total

[omarsam]

Hello!

I am completely clueless about Marcros, but I would like to create one to help me deal with a very redundant task!

I have three excel sheets with invoices : per Month, Year and Total

I usually enter the Monthly values, and then I have to copy them all again to year and total

is there a way I can have a macro, that just copies my newly added values in that month, and updates them in the yearly and total tabs, without deleting the previous values? (only newly added values, so I don't repeat the same invoices)



Also, when copying and pasting them, is there a way to arrange the invoices automatically in an invoice number order, via Macro??


I would really appreciate the help, espichiallty if you could guide me step by step!

Best
Omar

[IonutC]

HI there,

Please add the excel template just to see the what we have to do there.

[omarsam]

Hi Ionut

Thank you very much for your reply, i just made a test template with my example, attached in my original question

would appreciate ur help