Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
check register with multiple worksheets
I am trying to have the first worksheet be my check register and have it
automatically populate the information in the other worksheets with the same description. For example....if I made a mortgage payment and put morgage under the check register description in worksheet #1, I want excel to populate that line to a worksheet with other mortgage payments and keep a running total. Is this possible? I cannot think of a basic function that would work and the templates online only have the one worksheet with the check register info. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
check register with multiple worksheets
The best way to do this sort of tracking is with pivot tables. See here for
more info: http://www.cpearson.com/excel/pivots.htm Dave -- Brevity is the soul of wit. "jerikthegreat" wrote: I am trying to have the first worksheet be my check register and have it automatically populate the information in the other worksheets with the same description. For example....if I made a mortgage payment and put morgage under the check register description in worksheet #1, I want excel to populate that line to a worksheet with other mortgage payments and keep a running total. Is this possible? I cannot think of a basic function that would work and the templates online only have the one worksheet with the check register info. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding and Naming Multiple Worksheets | Excel Worksheet Functions | |||
Functions across multiple worksheets | Excel Worksheet Functions | |||
Sumif with multiple worksheets | Excel Worksheet Functions | |||
fax multiple worksheets | Excel Worksheet Functions | |||
adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions |