PDA

View Full Version : Splitting summary sheet based on workorder ColA.



aligahk06
04-13-2010, 07:08 AM
Dear All,

I have a pivot table having the following fields.
Col A is Workorder Colb is Eqpt # and Col C is total Amount.

In Col A there is so many workorder Starting from A5:A358 and their respective Eqpt# and Total Amount.
Is there any way that if i could select a few workorder from colA then a new summary sheet of selected workorder generated and vanished
the selected workorder from the sheet then again select a few workorder from colA then a new summary sheet generated and this process continue till
we divide the entire workorder into different worksheet.

Please assist any ideas or help ?

Attachment is for ur ref.


Rgds,
Aligahk06