Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I have a spreadsheet showing my daily transactions that includes "Dates, Amounts, and Purposes". Now I would like to create some sort of table to check how many transactions I made per month. Counting the number isn't hard for me. The most difficult part is how to have it updated automatically for new transactions being processed later on. So basically, I gonna have two columns A and B: Column A (Month to be counted) Column B (# of Trans) Dec., 2007 23 Jan., 2008 11 Feb., 2008 09 Mar., 2008 16 <----New Row Added and if there's any new data for March added in, there will be a new row down there. Is it possible to make that happen? Thank you very much. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Graphs reference data in old worksheet | Excel Discussion (Misc queries) | |||
Reference data from another sheet | Excel Discussion (Misc queries) | |||
Data Reference Challenge | Excel Discussion (Misc queries) | |||
data label reference change | Charts and Charting in Excel | |||
Only Reference cell with data in them | Excel Worksheet Functions |