Hi Tony

Why carry data to another sheet? You might be able to achieve what you
want by filtering the data.

If you highlight your header row and choose DataFilterAutofilter
you could use the dropdown on Name to select the required person and
click the dropdown on Paid Date and select Blank.
This would show all transactions which are outstanding.


--
Regards

Roger Govier


"tonyva" wrote in message
...
I need to create an excel spreadsheet but not sure how to achieve it.
(this
is for commission payout)

On sheet 1 starting lefthand side is "name" next column would be
"client"
next "PB" next "Paid Date" then "Outstanding"

The data would never be deleted and entries would just keep going down
the
page, would be possible when I click on the "name" PD and Outstanding
could
be linked to sheet2.

Any help on this would be great

Thanks
Tony