Why bother pulling the transactions out? You could use a SumIf or a
SumProduct formula or perhaps a pivot table to aggregate based on your
criterial... Post a few more details and we can help you with that if you
wish.
--
HTH...

Jim Thomlinson


"cklevine" wrote:

Hi, I have a huge spread sheet with the deposits and I need to pull them out
and copy them into another sheet to add them up. the text "payment received"
then the amount, is there anyway I select all of these entries (a years
worth) and copy them into another worksheet? I'm using Office 2003-
thanks a lot
cklevine