Pivottable

J

johnb

I have a list of Parts (1000's) in rows and dates (dd/mm/yyy) across the
cols. I need to view several years of data grouped by Qtrs and Months. As
Excel XP is currently limited to 256 cols It will not complete the
pivottable. How can I group all my data on 1 worksheet? I hope this is clear.

reagrds
johnb
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivottable: 1 xlPageField but with many "Sub" pivottables 2
Advanced transpose/grouping question 7
Dates in Pivottables 0
Pivottable Qtr's 1
Grouping dates in PivotTable/Chart 1
import text 1
Problem with creating pivottable 0
VB converting UK to US dates, randomly, ignores cdate func! 3

Top