software

This is probably something simple, but I'm such a novice I don't know where
to start. I want to track my attendance at monthly meetings. I have five
defined (don't know if that's the right term) plus numerous miscellaneous
meetings I attend every month. I would like to be able to track them by date
and category and see a running total of each category for the year. I would
also like to be able to integrate new categories of meetings in as they come
along.

I don't know if this is enough info to help me get started or if this
question even makes sense, but thanks for your help!Makes perfect sense.
Row 1 is your headings only (use Alt Enter to enter a paragraph return if
your heading needs to be 2 lines).
You can use data validation to choose the meeting type in column A (select
A2 to A65536):
See:
www.officearticles.com/excel/...soft_excel.htm
Then, put Date in column B. (select the column and Format--gt;Cells and choose
a date format.)
Enter all your current meetings.
Use Autofilter when you only want to see a certain meeting type:
www.officearticles.com/excel/...soft_excel.htm
Use Subtotals to quot;countquot; the meetings by meeting type:
www.officearticles.com/excel/...soft_excel.htm
That should give you a really good start.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

quot;craezerquot; gt; wrote in message
...
gt; This is probably something simple, but I'm such a novice I don't know
gt; where
gt; to start. I want to track my attendance at monthly meetings. I have five
gt; defined (don't know if that's the right term) plus numerous miscellaneous
gt; meetings I attend every month. I would like to be able to track them by
gt; date
gt; and category and see a running total of each category for the year. I
gt; would
gt; also like to be able to integrate new categories of meetings in as they
gt; come
gt; along.
gt;
gt; I don't know if this is enough info to help me get started or if this
gt; question even makes sense, but thanks for your help!
gt;
Thank you very much for the great information!

quot;Anne Troyquot; wrote:

gt; Makes perfect sense.
gt; Row 1 is your headings only (use Alt Enter to enter a paragraph return if
gt; your heading needs to be 2 lines).
gt; You can use data validation to choose the meeting type in column A (select
gt; A2 to A65536):
gt; See:
gt; www.officearticles.com/excel/...soft_excel.htm
gt; Then, put Date in column B. (select the column and Format--gt;Cells and choose
gt; a date format.)
gt; Enter all your current meetings.
gt; Use Autofilter when you only want to see a certain meeting type:
gt; www.officearticles.com/excel/...soft_excel.htm
gt; Use Subtotals to quot;countquot; the meetings by meeting type:
gt; www.officearticles.com/excel/...soft_excel.htm
gt; That should give you a really good start.
gt; ************
gt; Hope it helps!
gt; Anne Troy
gt; www.OfficeArticles.com
gt; Check out the NEWsgroup stats!
gt; Check out: www.ExcelUserConference.com
gt;
gt; quot;craezerquot; gt; wrote in message
gt; ...
gt; gt; This is probably something simple, but I'm such a novice I don't know
gt; gt; where
gt; gt; to start. I want to track my attendance at monthly meetings. I have five
gt; gt; defined (don't know if that's the right term) plus numerous miscellaneous
gt; gt; meetings I attend every month. I would like to be able to track them by
gt; gt; date
gt; gt; and category and see a running total of each category for the year. I
gt; gt; would
gt; gt; also like to be able to integrate new categories of meetings in as they
gt; gt; come
gt; gt; along.
gt; gt;
gt; gt; I don't know if this is enough info to help me get started or if this
gt; gt; question even makes sense, but thanks for your help!
gt; gt;
gt;
gt;
gt;

You're welcome.

************
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

quot;craezerquot; gt; wrote in message
...
gt; Thank you very much for the great information!
gt;
gt; quot;Anne Troyquot; wrote:
gt;
gt;gt; Makes perfect sense.
gt;gt; Row 1 is your headings only (use Alt Enter to enter a paragraph return if
gt;gt; your heading needs to be 2 lines).
gt;gt; You can use data validation to choose the meeting type in column A
gt;gt; (select
gt;gt; A2 to A65536):
gt;gt; See:
gt;gt; www.officearticles.com/excel/...soft_excel.htm
gt;gt; Then, put Date in column B. (select the column and Format--gt;Cells and
gt;gt; choose
gt;gt; a date format.)
gt;gt; Enter all your current meetings.
gt;gt; Use Autofilter when you only want to see a certain meeting type:
gt;gt; www.officearticles.com/excel/...soft_excel.htm
gt;gt; Use Subtotals to quot;countquot; the meetings by meeting type:
gt;gt; www.officearticles.com/excel/...soft_excel.htm
gt;gt; That should give you a really good start.
gt;gt; ************
gt;gt; Hope it helps!
gt;gt; Anne Troy
gt;gt; www.OfficeArticles.com
gt;gt; Check out the NEWsgroup stats!
gt;gt; Check out: www.ExcelUserConference.com
gt;gt;
gt;gt; quot;craezerquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; This is probably something simple, but I'm such a novice I don't know
gt;gt; gt; where
gt;gt; gt; to start. I want to track my attendance at monthly meetings. I have
gt;gt; gt; five
gt;gt; gt; defined (don't know if that's the right term) plus numerous
gt;gt; gt; miscellaneous
gt;gt; gt; meetings I attend every month. I would like to be able to track them by
gt;gt; gt; date
gt;gt; gt; and category and see a running total of each category for the year. I
gt;gt; gt; would
gt;gt; gt; also like to be able to integrate new categories of meetings in as they
gt;gt; gt; come
gt;gt; gt; along.
gt;gt; gt;
gt;gt; gt; I don't know if this is enough info to help me get started or if this
gt;gt; gt; question even makes sense, but thanks for your help!
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;