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:
http://www.officearticles.com/excel/...soft_excel.htm
Then, put Date in column B. (select the column and Format--Cells and choose
a date format.)
Enter all your current meetings.
Use Autofilter when you only want to see a certain meeting type:
http://www.officearticles.com/excel/...soft_excel.htm
Use Subtotals to "count" the meetings by meeting type:
http://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

"craezer" wrote in message
...
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!

Thank you very much for the great information!

"Anne Troy" wrote:

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:
http://www.officearticles.com/excel/...soft_excel.htm
Then, put Date in column B. (select the column and Format--Cells and choose
a date format.)
Enter all your current meetings.
Use Autofilter when you only want to see a certain meeting type:
http://www.officearticles.com/excel/...soft_excel.htm
Use Subtotals to "count" the meetings by meeting type:
http://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

"craezer" wrote in message
...
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!

You're welcome. :)

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

"craezer" wrote in message
...
Thank you very much for the great information!

"Anne Troy" wrote:

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:
http://www.officearticles.com/excel/...soft_excel.htm
Then, put Date in column B. (select the column and Format--Cells and
choose
a date format.)
Enter all your current meetings.
Use Autofilter when you only want to see a certain meeting type:
http://www.officearticles.com/excel/...soft_excel.htm
Use Subtotals to "count" the meetings by meeting type:
http://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

"craezer" wrote in message
...
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!