excel ideas

[Bassman]

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

 

[Joerg Mochikun]

Pivot Tables will probably do what you need. Much faster and without any
formulas to pull data from your input sheet. You will love it.

JM

 

[Bassman]

Pivot Tables will probably do what you need. Much faster and without any
formulas to pull data from your input sheet. You will love it.

JM







- Show quoted text -

Well, I have used pivot tables, not sure how I would use in this
situation. I have a sheet that has say 25 rows of sales types and I
have two columns for each month. One for total sales and the other for
profit. I merge the top cell with month name. I have this sheet for
each year. I don't believe a pivot table will take two columns with
one name, correct. Maybe I need to re think how I orginize my Data.

 

[Joerg Mochikun]

The problem is: You are pulling your data from a formatted report instead of
a database, and that prevents you from using pivot tables. But since you
have used pivot tables before and are already contemplating to change your
data layout, I'm sure that you are on the right track. You will need extra
columns for month and year, but I guess you know this already. If you need
help to convert your report into a data table you may post back and I can
send you a macro to do this automatically.

Cheers,
JM

Pivot Tables will probably do what you need. Much faster and without any
formulas to pull data from your input sheet. You will love it.

JM







- Show quoted text -

Well, I have used pivot tables, not sure how I would use in this
situation. I have a sheet that has say 25 rows of sales types and I
have two columns for each month. One for total sales and the other for
profit. I merge the top cell with month name. I have this sheet for
each year. I don't believe a pivot table will take two columns with
one name, correct. Maybe I need to re think how I orginize my Data.

 

[Bassman]

The problem is: You are pulling your data from a formatted report insteadof
a database, and that prevents you from using pivot tables. But  since you
have used pivot tables before and are already contemplating to change your
data layout, I'm sure that you are on the right track. You will need extra
columns for month and year, but I guess you know this already. If you need
help to convert your report into a data table you may post back and I can
send you a macro to do this automatically.

Cheers,
JM





Well, I have used pivot tables, not sure how I would use in this
situation.   I have a sheet that has say 25 rows of sales types and I
have two columns for each month. One for total sales and the other for
profit. I merge the top cell with month name.  I have this sheet for
each year.  I don't believe a pivot table will take two columns with
one name, correct. Maybe I need to re think how I orginize my Data.- Hidequoted text -

- Show quoted text -

Yes, if you get a chance please send the macro.

Thanks in advance

 

[Joerg Mochikun]

You've got mail
JM

The problem is: You are pulling your data from a formatted report instead
of
a database, and that prevents you from using pivot tables. But since you
have used pivot tables before and are already contemplating to change your
data layout, I'm sure that you are on the right track. You will need extra
columns for month and year, but I guess you know this already. If you need
help to convert your report into a data table you may post back and I can
send you a macro to do this automatically.

Cheers,
JM





Well, I have used pivot tables, not sure how I would use in this
situation. I have a sheet that has say 25 rows of sales types and I
have two columns for each month. One for total sales and the other for
profit. I merge the top cell with month name. I have this sheet for
each year. I don't believe a pivot table will take two columns with
one name, correct. Maybe I need to re think how I orginize my Data.- Hide
quoted text -

- Show quoted text -

Yes, if you get a chance please send the macro.

Thanks in advance

 

[Bassman]

You've got mail
JM







Yes, if you get a chance please send the macro.

Thanks in advance- Hide quoted text -

- Show quoted text -

I can not get it to work..

 

[Joerg Mochikun]

You've got mail
JM







Yes, if you get a chance please send the macro.

Thanks in advance- Hide quoted text -

- Show quoted text -

I can not get it to work..

That's not very specific ;-( Send me a sample and I'll see what I can do.
JM

 

[Bassman]

I can not get it to work..

That's not very specific ;-( Send me a sample and I'll see what I can do.
JM

Sorry, I meant I can not get your macro to work.