+ Reply to Thread
Results 1 to 2 of 2

Help with GetPivotData

  1. #1
    Registered User
    Join Date
    05-21-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    43

    Help with GetPivotData

    I have a pivot table and I am looking at a way to use certain data columns to insert into a separate worksheet "CHANGE". I am having issues taking the values to the other worksheet. Any help is appreciated!

    Pivot Field: ACCOUNT = Column A
    Pivot Field: DEMO = Column B
    Pivot Field: Deal YR = Column C
    Pivot Field: Deal Name = Column D
    Pivot Field: PREV. BAL $ = Column E
    Pivot Field: CUR. BAL $ = Column F
    Pivot Field: CASH $ = Column H
    Pivot Field: AD $ = Column K

  2. #2
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Help with GetPivotData

    Hello
    It's not clear exactly what data you're trying to bring back. Do you want specific accounts, names, years etc. Perhaps if you could upload a sample file of non-sensitive data to show more clearly what you require.

    DBY

+ 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. [SOLVED] GETPIVOTDATA – How to force getpivotdata to accept missing data
    By scottc_00 in forum Excel Formulas & Functions
    Replies: 39
    Last Post: 02-11-2015, 03:23 PM
  2. getpivotdata
    By Raanan in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-09-2013, 06:32 AM
  3. Using GETPIVOTDATA
    By JakeMann in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-17-2013, 08:42 AM
  4. getpivotdata bug?
    By Barry Au in forum Excel General
    Replies: 4
    Last Post: 06-05-2007, 01:43 PM
  5. GETPIVOTDATA Bug
    By SthOzNewbie in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-03-2006, 03:10 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