Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 28
Default DATA REFERENCE

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Graphs reference data in old worksheet fmistry Excel Discussion (Misc queries) 0 October 4th 06 06:16 PM
Reference data from another sheet alexwren Excel Discussion (Misc queries) 0 July 25th 06 07:01 PM
Data Reference Challenge FishHead Excel Discussion (Misc queries) 0 April 26th 06 06:16 PM
data label reference change dogween Charts and Charting in Excel 1 November 8th 05 10:53 PM
Only Reference cell with data in them Monsterman Excel Worksheet Functions 0 April 5th 05 09:45 PM


All times are GMT +1. The time now is 09:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"