Results 1 to 2 of 2

Retaining fill-in data adjacent to pivot table

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-16-2011
    Location
    Abu Dhabi, UAE
    MS-Off Ver
    Excel 2010
    Posts
    234

    Retaining fill-in data adjacent to pivot table

    I have a pivot table that extracts data that meets a certain criteria. When the data is extracted, it needs to be 'signed off' in a cell adjacent to the row that contains that data using a drop-down for the person's name and the date of the sign-off.

    However, if the original data changes, the extracted data may now appear in a different row, but the signed-off name and data cells stay in their original row and now don't match up to the exracted data.

    Is there any way to ensure that the extracted pivot table data and the signed-off cells always stay in the same row?

    Thanks!
    Last edited by Hambone70; 02-16-2011 at 11:01 AM.

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