Calculating formulas onto a Year End page.
 

I have a workbook with 12 months of data and I want to transfer all data from
each month to create a year to date percentage in each category. How do I do
this?
--
Lisa

Calculating formulas onto a Year End page.
 

Detail is sadly lacking for any meaningful guesses to be hazarded. That's why
you haven't got any responses so far. We don't know where to start in
responding. Illustrate by pasting some sample data. Are the "monthly" data
sheets identically structured? How are they named? Show us via an example or
two how the calcs should flow to derive the results for "year to date
percentage in each category". Etc.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Lisa" wrote:
I have a workbook with 12 months of data and I want to transfer all data from
each month to create a year to date percentage in each category. How do I do
this?

Calculating formulas onto a Year End page.
 

Sorry about that. All cells are the same on every sheet.

Year To Date Sheet:
Each column is identified with a certain category that is the same
information that I have on each sheet label Jan-Dec.

I need to obtain the year to date stats and compile it into a year to date
stat.

B2 = Sales
C2 = Liquor
D2 = Liquor Percentage (C2/B2)
E2 through M2 is other categories that just need the average from all 12
months.

Lisa
--
Lisa


"Max" wrote:

Detail is sadly lacking for any meaningful guesses to be hazarded. That's why
you haven't got any responses so far. We don't know where to start in
responding. Illustrate by pasting some sample data. Are the "monthly" data
sheets identically structured? How are they named? Show us via an example or
two how the calcs should flow to derive the results for "year to date
percentage in each category". Etc.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Lisa" wrote:
I have a workbook with 12 months of data and I want to transfer all data from
each month to create a year to date percentage in each category. How do I do
this?

Calculating formulas onto a Year End page.
 

Try a new posting. Include more detail in your new post.
I'm not able to suggest anything, sorry
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Lisa" wrote in message
...
Sorry about that. All cells are the same on every sheet.

Year To Date Sheet:
Each column is identified with a certain category that is the same
information that I have on each sheet label Jan-Dec.

I need to obtain the year to date stats and compile it into a year to date
stat.

B2 = Sales
C2 = Liquor
D2 = Liquor Percentage (C2/B2)
E2 through M2 is other categories that just need the average from all 12
months.

Lisa