+ Reply to Thread
Results 1 to 2 of 2

pivot table compare current data with refresh data and format new values

  1. #1
    Registered User
    Join Date
    06-18-2014
    Location
    Oslo, Norway
    MS-Off Ver
    2013
    Posts
    2

    Post pivot table compare current data with refresh data and format new values

    vba in excel 2013 pivot table that updates from an online CRM rows are a to h and it can be any number of rows.
    What I am trying to do is track progress. In column f values indicate probability for success 10 25 45 90, which can go up or down. The pivot table is refreshed to get the latest values from CRM. the update is handled by a connection to the crm not in the vba.

    So far I been researching methods to conditionally format values that went up, down or remained the same since the last refresh with up down and across arrows. I have managed to piece together what I think should work but alas it is not. So I have come to you internet.

    My code first clears any formatting and goes down the column avoiding null or empty cells, comparing the values in column f to values in column j.
    I have 3 conditions greater than, less than or equal to, and would like add an icon for each based on the result of the comparison.

    Finally when it finishes the column the code copies the current values in the pivot table column f to column j outside the pivot table which i hope to be able to hide once the cf works. The code is below, any help in understanding where the problem is would be a big help.

    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    06-18-2014
    Location
    Oslo, Norway
    MS-Off Ver
    2013
    Posts
    2

    Re: pivot table compare current data with refresh data and format new values

    Any ideas on how I use Selection.FormatConditions

+ 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. Replies: 6
    Last Post: 02-23-2024, 02:11 PM
  2. Replies: 0
    Last Post: 08-14-2013, 06:31 AM
  3. import data from access table to excel pivot table - Enable Auto Refresh
    By okl in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 02-01-2010, 09:38 AM
  4. How to refresh a pivot table with new data
    By MarkAnderson in forum Excel General
    Replies: 1
    Last Post: 03-28-2009, 07:55 AM
  5. [SOLVED] Pivot table Data refresh
    By SSD1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM

Tags for this Thread

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