See my attached example
Can you please help me solve my workbook. I’m stuck!!
1) On worksheet2 ("add account") I would like it if the sheet could automatically show the next new account number to be used (after the first one was entered manually).
And when I add a customer, it should automatically copy the formuls as in existing customer’s rows
2) on worksheet1 ("account payment") is where I’m actually stuck!! How do I update my worksheet3 ("customers") after worksheet1 (“account payments”) process button is pressed.
3) And maybe if it is possible, if a customers account balance is zero, to remove that customer from worksheet3 ("customers") and add it to worksheet4 ("paid up accounts")
I don’t know.the above is just what i'm thinking of. Maybe there is a whole other and better way to solve my workbook.