Pivot Tables from various worksheets

Hi,

Through macro I would like to prepare PT on all the existing worksheets in attached workbook. All worksheet having same fields into same cells (Object Id [Cell A2], Date Required [Cell B2], Qty[Cell C2], Vendor[Cell D2])

I have recorded Macro to generate a PT from Cargotec (a worksheet), in which some page set-up activity is included. The Macro is preparing PT but it stuck in Print Preview Screen without page set-up activity & some Hide command, can anybody help me to resolve the said error.

File is attached for your ready ref.

Apart from this I’d like to prepare same PT on all the existing worksheets in attached workbook through one click.

Please help !!!!

RK

I am sure you Excel Master will resolve my query

Excel Guru's Please help me

Masters Good Morning Please help me !!!!

Originally Posted by rvkadu1

Masters Good Morning Please help me !!!!

Please help me !!!!

HI , i think the enclosed file will be of a use to you

Originally Posted by gomathi7

HI , i think the enclosed file will be of a use to you

Thanks for your response,
but this file not useful to me from my requirement point of view

Through macro I would like to prepare PT on all the existing worksheets in attached workbook. All worksheet having same fields into same cells (Object Id [Cell A2], Date Required [Cell B2], Qty[Cell C2], Vendor[Cell D2])

I have recorded Macro to generate a PT from Cargotec (a worksheet), i would like to run this same macro through all the existing worksheets, is it possible

My attachement is for your ready ref.

Please help !!!!

RK

Is anybody there, who will help me in this case?