+ Reply to Thread
Results 1 to 2 of 2

Replicate clicking on data in pivot to by clicking on vlookup cell?

  1. #1
    Registered User
    Join Date
    02-01-2012
    Location
    Oxford
    MS-Off Ver
    Excel 2007
    Posts
    10

    Smile Replicate clicking on data in pivot to by clicking on vlookup cell?

    Hi,
    The title doesn't make much sense but what i am asking.

    I.E - If you click a field in a pivot table, it will open a new sheet within the workbook with a breakdown of information that you clicked on.

    If i have a VLOOKUP in sheet1 reading from a pivot table in sheet2, is there a way that if someone clicks on the VLOOKUP cell, it can open the a new sheet within the workbook, as if you clicked on it from the pivot table?

    Thanks :\

  2. #2
    Registered User
    Join Date
    02-01-2012
    Location
    Oxford
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Replicate clicking on data in pivot to by clicking on vlookup cell?

    Hi,
    Is there no way of doing this then? :<<<<

+ 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