Results 1 to 3 of 3

Automatically picking up new dates and excluding blanks

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-18-2014
    Location
    England
    MS-Off Ver
    365
    Posts
    132

    Automatically picking up new dates and excluding blanks

    I have a pivot table which has a filter on it that selects only data where a date is populated in column C the pivot table filter has blank unticked - however when new data is added creating a new date in the filter and I refresh the pivot table it doesn't pick up the new date as I have de selected all - please see the example attached. I selected ALL - deselected blanks and then added in row 8 and refreshed the pivot - it didn't pick up the new information and in the filter it is there but not selected.

    is there a way I can fix this so they always pick up the new data and leave blanks unselected? I tired recording a macro to change the filter but it didn't work as it picked up me selecting all but not deselecting blanks in the code,

    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Blanks cells against date picking row to column without duplication
    By silambarasan.J in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-24-2015, 04:52 AM
  2. [SOLVED] Blanks cells against date picking row to column without duplication
    By Vandini.S in forum Excel General
    Replies: 12
    Last Post: 08-20-2015, 02:17 AM
  3. Blanks cells against date picking without duplication in row to column
    By silambarasan.J in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-26-2015, 08:40 AM
  4. Replies: 3
    Last Post: 05-09-2015, 01:25 AM
  5. [SOLVED] Calc dates excluding weekends w/blanks
    By greeneggsandsam in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-29-2014, 02:54 PM
  6. Picking entries left to right and skipping blanks
    By Hitch75 in forum Excel General
    Replies: 8
    Last Post: 10-13-2011, 10:38 AM
  7. Picking Values from a row with blanks?
    By jbanks in forum Excel General
    Replies: 6
    Last Post: 10-06-2008, 05:50 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