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
Bookmarks