Thanks Ed and KC...It's snowin here so nobody came to work but me!....I
shoud have some "free" time later.

Linda


"Linda RQ" wrote in message
...
Hi Everyone,

Using Excel 2003. I usually use excel to make forms (glorified word
processing) I have recently started to paste data from an Access database
tables, and queries into excel. I would like to know how I should set up
my spreadsheet to show my data by month, quarter and then yearly. I want
my report to show an average percent for the month of April, May, etc then
other cells that show the percent per quarter.

I don't necessarily need you to tell me how to do it step by step because
I think it is going to be alot of steps. For right now, I have 2 sheets
and on the one I have the data and the other is my report with the months
listed and in the cell next to the month, I insert the average funciton
then go back to my 1st sheet and manually select the dates for each month.
I just need maybe some online examples of the reports excel can give and
hopefully there will be tutorials to go with it that maybe automatically
can select my months with one two swift clicks.

I need basic excel info and not the visual basic or macro way to do it.

Thanks,
Linda