+ Reply to Thread
Results 1 to 2 of 2

Linking static notes with pivot table

  1. #1
    Registered User
    Join Date
    03-06-2012
    Location
    singapore
    MS-Off Ver
    Excel 2010
    Posts
    3

    Angry Linking static notes with pivot table

    I have a pivot table which draws data from a dynamic worksheet.
    I want to include some notes in the static columns next to the pivot table; however, I want the notes to be associated with a record of the pivot table. i.e as the pivot table grows downwards, the notes should also follow the record they were originally posted beside.
    How do I do that?

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Linking static notes with pivot table

    Hi boooinky,

    Welcome to the forum.
    Try using Index - Match kind of formula arrangement and relate this with Row fields, in case of any issues, post an sample file. Thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

+ 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