I have a worksheet which notes payment's received on each of the accounts we are currently running, noting amount, date etc.

Sometimes the payments are made in full, and sometimes they are made as part payments. I am looking for a way to have a seperate tab set up which automatically records the part payments and the date they were received.

For example:

A= Account Ref
B= Payment
C= Cumulative total
D= Date of Payment
E= Part / Full Payment

What i'd like is so that when the user finishes putting Part payment in the last cell, all the data in the preceeding cells is copied to the seperate tab.

Even if someone could just start me off I'd be more than happy to play until it fit.

Any help would be really really appreciated.