+ Reply to Thread
Results 1 to 4 of 4

auto update pivot table and/or filters when data changes?

  1. #1
    Registered User
    Join Date
    06-29-2006
    Posts
    85

    auto update pivot table and/or filters when data changes?

    I've been told that a VBA script might be able to do this for me?
    but I really don't know anything about VBA stuff
    I have a a few data entry cells on page 1
    a data logged worksheet on page 2 that is a copy and paste page from the end user
    some lookup tables on page 3
    and a pivot table on page 4

    when the user changes the values on page 1 or 2 I would like it to auto update the Pivot table so that the graph based of of the pivot table changes accordingly right away with no extra user input
    can anybody help me with this as I don't even know where to start with it


    heres the worksheet if anybody is interested in seeing to to understand what I need it to do..
    for now I made a macro...but I would like it to do this automatically and with changing pages...
    I would like it even better if I could hide the pivot table page so the end user couldn't see it..but I understand and its not that big of a deal if it has to be visible

    http://www.audiohelix.com/excel/HP%20TQ%20Instant.xls
    sorry for the size 47.8 mb

    zipped version 5.2 mb
    http://www.audiohelix.com/excel/HP%20TQ%20Instant.zip
    Last edited by soundengineer; 04-28-2007 at 11:20 PM.

  2. #2
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983
    I do not use pivot tables

    If the macro code within Macro1 is all that you need to run when the changes are made then try this


    'These instructions pre typed & are worded to cater for the novice programmer
    'To install macro to correct location

    'Copy this macro
    'GoTo Excel
    'Select sheet this is to appy to
    'Right Click on Sheet Name Tab > select View Code
    'Past macro into the Worksheet Module displayed

    Please Login or Register  to view this content.
    You will need a copy of the macro in both sheets

    The pivot table sheet can be hidden without affecting the macro
    Please Read Forum Rules Before Posting
    Wrap VBA code by selecting the code and clicking the # icon or Read This
    How To Cross Post politely

    Top Excel links for beginners to Experts

    If you are pleased with a member's answer then use the Scales icon to rate it
    If my reply has assisted or failed to assist you I welcome your Feedback.

  3. #3
    Registered User
    Join Date
    06-29-2006
    Posts
    85
    Quote Originally Posted by mudraker
    I do not use pivot tables

    If the macro code within Macro1 is all that you need to run when the changes are made then try this


    'These instructions pre typed & are worded to cater for the novice programmer
    'To install macro to correct location

    'Copy this macro
    'GoTo Excel
    'Select sheet this is to appy to
    'Right Click on Sheet Name Tab > select View Code
    'Past macro into the Worksheet Module displayed

    Please Login or Register  to view this content.
    You will need a copy of the macro in both sheets

    The pivot table sheet can be hidden without affecting the macro

    it seems to be repeating in a never ending loop...

  4. #4
    Registered User
    Join Date
    06-29-2006
    Posts
    85
    Quote Originally Posted by soundengineer
    it seems to be repeating in a never ending loop...

    I think I figured it out..
    do it on all pages except for pivot table page

+ 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