I am new to VBA therefore needs help.
I have three worksheet say CompanyA, Supplier1 & Supplier2.
In CompanyA it has headers:
Date Company Payment Amount Invoice No. Comments
I update these details when I make payments to Supplier1 & 2, then I have to go and update the two Suppliers' worksheet.
Can anyone help me in VBA so that I just use a VBA comment or button to update these data automatically without having to copy and pasting myself.
Please feel free if anyone knows an easier than what I'm thinking.