Have you looked in to pivot tables? From your explanation, I expect they're
exactly the solution you are looking for. And so easy to use.

Regards,
Fred.

"Mas" wrote in message
...
Hi, Does anyone have a suggestion how to create an excel file that can
capture history in another sheet. For example to keep tracking payments of
sponsors? Headers a
Name - paymentdate- amount - expiry date.
Everytime I would be getting another donations of the a particular sponsor
I
would like to only change the details in one sheet and did somehow keep a
record of all donation from a particular sponsor in a background sheet. Do
I
make myself clear?
looking forward to your answers!

Cheers