Results 1 to 6 of 6

Pivot table that references a Cell in another sheet

Threaded View

  1. #1
    Registered User
    Join Date
    09-05-2012
    Location
    Brisbane
    MS-Off Ver
    Excel 2010
    Posts
    3

    Pivot table that references a Cell in another sheet

    Hi

    This is what I currently have:

    Sheets("PLOC Previous 12 months").Select
        Range("A3").Select
        With ActiveSheet.PivotTables("PLOC_12Months").PivotFields("Graph solution")
            .PivotItems(Range("p6").Text).Visible = False    End With
        Sheets("DATA INPUTS").Select
        Range("C7").Select
    End Sub
    I want the red row to reference 'DATA INPUTS'!P6.....any ideas?

    Thanks for the help

    Wil
    Last edited by Cutter; 09-07-2012 at 03:59 PM. Reason: Added code tags

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