match,copy,paste,accounts

[wegkruip]

Hi there. I’m a learn as you go programmer. I’ve got a problem.

I’ve got a workbook with four worksheets.

Worksheet 1 = “account payment”
Worksheet 2 = “add account”
Worksheet 3 = “customers”
Worksheet 4 = “paid up accounts”

See my example attached.
Please can you help me with the following? I’m stuck

1) On worksheet2 ("add account") I would like it if the sheet could automatically
show the next account number to be used (after the first one was entered manually).
And maybe if you press the down arrow key active cell goes directly to the next input cell.


2) On worksheet1 ("account payment") is where I’m actually stuck!! How do I update my worksheet3 ("customers")


3) And maybe if it is possible, if a customers account balance is zero, to remove that customer from worksheet3 ("customers") and ad it to worksheet4 ("paid up accounts") while always having a certain amount of rows with formulas in worksheet3 ("customers")