run a history report in the background

[Mas]

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 are:
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

 

[Fred Smith]

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.