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
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