I have another question. I am not a true newbie but most of what I do
is what I have been shown and I change it to handle what ever project
I am working on.
I need to report sales figures by sales type, by total sales and total
profit,monthly and compare year over, month over and trend 6 months. I
currently have a data input sheet, a parameters sheet for calulating
report month, and a report generating sheet.
Input sheet has sales type in rows and months are one column sales on
profit for total year.
I need to have input for more than one year so I am going to setup a
new input sheet for each year.
The report sheet has foumluas that pull data by month by setup from
parameters formula. The report sheet works fine now. I am trying to
expand to show trends and multi year and the formulas are getting too
big. Maybe there is a different way to go about this. I was thinking
a database would be better idea but I never made a database before nor
made a form to pull data with.
Any ideas would be great...I can post my workbook. (How do I do
that?)

Thanks in advance