+ Reply to Thread
Results 1 to 2 of 2

Can you "stick" manually entered cell data next to pivot table to info in the pivot table

  1. #1
    Registered User
    Join Date
    08-26-2013
    Location
    Kansas
    MS-Off Ver
    Excel 2010
    Posts
    70

    Can you "stick" manually entered cell data next to pivot table to info in the pivot table

    I've attached a very shortened example of the Raw data (Columns A-E) and the small pivot table that summarizes that for a team to analyze. The team enters a project description (Column K) on any site that needs action. My issue is if in a second review....lets say multiple sites are added, or even deleted from the raw data (there can be hundreds of lines in the raw data) then any of the Project Descriptions that were entered in Column K no longer line up with their original site location. Is there anyway to work around/solve this where you can allow a user to add manual info, yet still keep it with the pivot line? Any help/suggestions are greatly appreciated!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Can you "stick" manually entered cell data next to pivot table to info in the pivot ta

    You need to add a secondary table that has each Site # then do a lookup.

    If you wanted you could then do a lookup into the raw pivot table so it comes over in the pivot instead of a formula to the right of the pivot. Or you could have a simple macro run to automatically drag the formulas down to the bottom of the pivot table.

    OR you could use powerpivot and link both tables (raw data & Project Description), create a relationship then make a power pivot table.
    Attached Files Attached Files
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pivot Table query regarding "SUMPRODUCT" vs function "SUM" on pivot
    By sfyris.c in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-10-2015, 07:42 AM
  2. Replies: 6
    Last Post: 11-07-2015, 02:03 PM
  3. [SOLVED] Filter Pivot Table with a fixed value called "TOTAL" in Pivot Field Name
    By trizzo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-06-2015, 12:57 PM
  4. Display "TEXT" in "Values" field in PIVOT TABLE using VBA!!
    By meus in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-04-2015, 06:14 AM
  5. Replies: 0
    Last Post: 10-21-2013, 05:06 PM
  6. Replies: 2
    Last Post: 06-06-2013, 12:45 PM
  7. Replies: 1
    Last Post: 03-10-2005, 01:07 AM

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