Pivot table macro

[nickd via OfficeKB.com]

I have recorded a macro which creates a pivot table, when the macro runs
there is a run time error, at in the in VBA code whic is as follows :

ActiveSheet.PivotTables("PivotTable3").AddFields RowFields:=Array( _
"Payment Type 2", "Data")

Ant help appreciated.

Thanks

 

[Roger Govier]

Hi Nicki

What error do you get?
It may be that PivotTable3 already exists.

 

[nickd via OfficeKB.com]

Thanks for having a look error is as follows :
run-time error '1004'
AddField method of pivot table class falied


Question 2

I have several worksheets in a workbook, and I would like to retrieve in one
worksheet all accounts with detials that begin with a 4, or an account number
which has 8 numeric characters which are included in the the several work
sheets.

I am a novice on excel but need to learn very quickly, if you have an example
that would be very helpful.

Thanks for your time

Hi Nicki

What error do you get?
It may be that PivotTable3 already exists.

I have recorded a macro which creates a pivot table, when the macro runs
there is a run time error, at in the in VBA code whic is as follows :

[quoted text clipped - 5 lines]

Thanks

 

[Roger Govier]

Hi Nicki

I can't quite understand what it is that you want.
If you want, you can email me the file direct, with some more detail on what
you are trying to achieve.

To send direct email to
roger at technology4u dot co dot uk
Change the at and dots to make valid email address.

--
Regards
Roger Govier

Thanks for having a look error is as follows :
run-time error '1004'
AddField method of pivot table class falied


Question 2

I have several worksheets in a workbook, and I would like to retrieve in
one
worksheet all accounts with detials that begin with a 4, or an account
number
which has 8 numeric characters which are included in the the several work
sheets.

I am a novice on excel but need to learn very quickly, if you have an
example
that would be very helpful.

Thanks for your time

Hi Nicki

What error do you get?
It may be that PivotTable3 already exists.

I have recorded a macro which creates a pivot table, when the macro runs
there is a run time error, at in the in VBA code whic is as follows :

[quoted text clipped - 5 lines]

Thanks