2003 macro to output several files thru filtering Pivot Table

**tdbaileyco** · 02-19-2013, 05:03 PM

I need help to use a pivot table to create multiple output files!

I have read several forums and posts to figure this out and have had no luck finding a loop statement that would suit my needs, So I am turning to this forum for desperate help!

Since I could not find a suitable loop script to work (nor could I write one) I went thru and recorded a macro that does what I needed it to do for the first vendor, But I need it to loop for the other 68 vendors!!

Please Login or Register  to view this content.

**AlphaFrog** · 02-19-2013, 07:33 PM

Please Login or Register  to view this content.

**tdbaileyco** · 02-20-2013, 09:04 AM

AlphaFrog,

Thank you for the reply!

The code is giving me the following error when I run the macro.. "Run time error 1004", " Unable to set the visible property of the PivotItem class"

Please Login or Register  to view this content.

**AlphaFrog** · 02-20-2013, 09:15 AM

Can you provide an example workbook with your pivot tables?

**tdbaileyco** · 02-20-2013, 09:48 AM

The original file is massive ~11,000/Rows, queries, endless formulas.. It was 30M, but I got it down to 1.8m removing the queries, extra pivots, and all most of the data

I have tried to get the file under 1MG for the forum, and that has not worked, Can I e-mail it to you?

**AlphaFrog** · 02-20-2013, 01:07 PM

Make a new workbook with 100 or so rows of data with the same structure like your original and make two pivot tables. Copy your two macros and test if they function the same.

I just want to see your data structure and test the macro i provided to determine why it errors.

**tdbaileyco** · 02-20-2013, 01:19 PM

Master Forecast_CA2.zip

I have attached the file zipped,
I added a new pivot and ran it but still got the error

**AlphaFrog** · 02-20-2013, 10:42 PM

Try this one...

Please Login or Register  to view this content.

**tdbaileyco** · 02-21-2013, 09:36 AM

AlphaFrog,

Thank you,

Everything works great except one thing.. I changed the vendor names to vendor1, vendor2, etc... How do I make it save it as the actual vendor name like JBS, MST, Etc.. ? that way I dont have to open them and resave each one with the actual vendor name?

**tdbaileyco** · 02-21-2013, 10:28 AM

AlphaFrog,

I figured out the name change!

Again THANK YOU, very very much your Awesome!!!!

Troy

2003 macro to output several files thru filtering Pivot Table

LinkBack

Thread Tools

Rate This Thread

Display

2003 macro to output several files thru filtering Pivot Table

Re: 2003 macro to output several files thru filtering Pivot Table

Re: 2003 macro to output several files thru filtering Pivot Table

Re: 2003 macro to output several files thru filtering Pivot Table

Re: 2003 macro to output several files thru filtering Pivot Table

Re: 2003 macro to output several files thru filtering Pivot Table

Re: 2003 macro to output several files thru filtering Pivot Table

Re: 2003 macro to output several files thru filtering Pivot Table

Re: 2003 macro to output several files thru filtering Pivot Table

Re: 2003 macro to output several files thru filtering Pivot Table

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions