+ Reply to Thread
Results 1 to 3 of 3

Automating a pivot table for data analysis

  1. #1
    Forum Contributor
    Join Date
    03-28-2012
    Location
    Pennsylvania, USA
    MS-Off Ver
    Excel 2010
    Posts
    166

    Automating a pivot table for data analysis

    Is there a way to automate the pivot table sheet I have in the example? If not in a pivot table report maybe via vba to extrapolate the same data.
    I can use pivot tables, but others who want to analyis the data might not know how utilize them. Take a look and if anyone has any ideas how to allow future users to extrapolate this data please let me know.

    Thank You!
    LeapingLizardPivottableQuestions.zip

  2. #2
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,122

    Re: Automating a pivot table for data analysis

    Do you mean auto refreshing a pivot table? That is to say when you change the source data, you do not have to go to each source data to manually refresh(update the data). Yes, you can do auto refresh. I do not think lots of people on many formus are keen to write a code for PT and this refelects party on the number of responses you see when a PT question pops up. I suspect part of the reason could be not many people see the advantage of auto PT. The existing excel's functions would be suffice for most users and no need to learn any code. This just my own expereince.

  3. #3
    Forum Contributor
    Join Date
    03-28-2012
    Location
    Pennsylvania, USA
    MS-Off Ver
    Excel 2010
    Posts
    166

    Re: Automating a pivot table for data analysis

    Thank you AB33. I never thought about that. See that is why I figured I could run it by you all. I guess vba coding for this would be rather tedious?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1