Hi,

Please follow the undermentioned steps:

1. Highlight the range and go to Data Pivot Table and Pivot Chart
Multiple Consolidation Ranges Ok
2. Let the default remain on the next screen;
3. Highlight the range to be pivoted and say OK

Now in the pivot table which emerges, drag out row and column fields so that
you see only one number inside the pivot table. Double click the number and
data will be organised by rows in another sheet. Now create a simple pivot
of this with column field in the page area. Now while in the pivot table,
click on Show Pages in the pivot table in the toolbar and you will notice
that you will get one sheet per category

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Jose Mourinho" wrote in message
...
I have Sheet1 laid out as follows:

Month CatA CatD CatJ
Month 1 10 50 10
Month 2 5 10 5
Month 3 5 10 10

I need to divide data into 1 sheet per Category (Cat) data i.e.

Month CatA
Month 1 10
Month 2 5
Month 3 5

Huge sheet, many categories, finding HLOOKUP ("CatA", Sheet1!RefTable, x)
very cumbersome. There must be a simpler way...