Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
run a history report in the background
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
run a history report in the background
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting missing data from one report into another report... | Excel Discussion (Misc queries) | |||
Rollback history | Excel Discussion (Misc queries) | |||
Automate Excel report to place certain data into existing report? | Excel Worksheet Functions | |||
Header in Report Manager Report | Excel Discussion (Misc queries) | |||
font history | Excel Discussion (Misc queries) |