+ Reply to Thread
Results 1 to 2 of 2

Link Pivot Item Question

  1. #1
    Registered User
    Join Date
    08-30-2005
    Posts
    44

    Link Pivot Item Question

    We have a workbook with what the users call the 'main' tab. This is nothing more than a pivot. There are two other tabs in the workbook, they call them the 'detail' tabs-again just pivots. Each of the 3 tabs has one item in the page area: MONTH. The users want whatever MONTH is chosen on the *main* tab to be applied to the *detail* tabs. In other words they just want to select MONTH once and have the 2 ancilary pivots filter to whatever the user chose on the main tab.

    How could I do this without using a form? Could I post some sort of vba code in the view code area of the main tab? What would it look like?

  2. #2
    Registered User
    Join Date
    04-26-2007
    Posts
    10

    Post

    Try this...
    Please Login or Register  to view this content.
    the code being in the worksheet object of the pivot that will be updated.

    "Number" being the name of the pagefield in the your pivots.
    "Sheet1" etc being your other sheets.

    hope this helps.

    rgds,
    David
    Last edited by VBA Noob; 04-28-2007 at 04:58 AM.

+ 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