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 - 03 Mar 2008 22:08 GMT
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.
> 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
[quoted text clipped - 9 lines]
>
> Cheers