I want to enter data in the sheet named “Master Sheet” everyday for all fifty customers.
In Row 1 of “Master Sheet”, I have header in Column A, B, C and D, named SHEET NAME, DEPOSIT, WITHDRAWAL and BALANCE respectively.
In Row 2 of Master sheet, I have Sum of cells (B2-C2) in Cell D2 under BALANCE header in Column D
In Row 3 of Master Sheet, I have formula SUM of (D2+B3-C2) under BALANCE header in Column D to calculate everyday balance.
I want to copy data to individual sheet of customers based on sheet name to see every day balance of each customer.
And Data should be paste to next empty row in individual sheet.
Can you please help to write the VBA please?
In Row 1 of “Master Sheet”, I have header in Column A, B, C and D, named SHEET NAME, DEPOSIT, WITHDRAWAL and BALANCE respectively.
In Row 2 of Master sheet, I have Sum of cells (B2-C2) in Cell D2 under BALANCE header in Column D
In Row 3 of Master Sheet, I have formula SUM of (D2+B3-C2) under BALANCE header in Column D to calculate everyday balance.
I want to copy data to individual sheet of customers based on sheet name to see every day balance of each customer.
And Data should be paste to next empty row in individual sheet.
Can you please help to write the VBA please?