D
DCSwearingen
We have several workbooks using basically the same philosophy - Column A
contains dates, and an additional 15 to 30 columns containing specific
production data for each date each spreadsheet contains its own type of
data.
Date Raw Finished $Labor $Material etc etc
1/1/06 125,000 62,300 $38,000 $52,000 250 300
1/2/06
etc
etc
In the past we have used another tab in the workbook and populated it
with formulas that will maintain a rolling seven day total, a third tab
that keeps a running total for Month-to-date, and a fourth to keep a
running total of YTD.
These tend to get quite large by the end of the year and I was
wondering if I could save size by using pivot tables for the various
totals.
My problem is how to have the 15 to 30 headsers and the summation in
each column. Excel tells me I must have the data area populated, but
when I do, my spreadsheet grinds to a halt and I get "Not Enough
Memory" errors.
I can create a pivot with a single data item and duplicate it for the
remaining 15-30 data items, but there has to be a better way.
contains dates, and an additional 15 to 30 columns containing specific
production data for each date each spreadsheet contains its own type of
data.
Date Raw Finished $Labor $Material etc etc
1/1/06 125,000 62,300 $38,000 $52,000 250 300
1/2/06
etc
etc
In the past we have used another tab in the workbook and populated it
with formulas that will maintain a rolling seven day total, a third tab
that keeps a running total for Month-to-date, and a fourth to keep a
running total of YTD.
These tend to get quite large by the end of the year and I was
wondering if I could save size by using pivot tables for the various
totals.
My problem is how to have the 15 to 30 headsers and the summation in
each column. Excel tells me I must have the data area populated, but
when I do, my spreadsheet grinds to a halt and I get "Not Enough
Memory" errors.
I can create a pivot with a single data item and duplicate it for the
remaining 15-30 data items, but there has to be a better way.
