+ Reply to Thread
Results 1 to 3 of 3

Filter Table with values based in worksheet

  1. #1
    Registered User
    Join Date
    10-26-2007
    Posts
    55

    Filter Table with values based in worksheet

    I'm trying to filter a table between 2 dates but when I run the script the filter appears to have run correctly but nothing shows.

    I then manually go in the field filter and the correct dates show in the filter, I then press ok and the correct records now appear.

    Not sure why the table is empty until I go in manually and hit ok.

    Any suggestions appreciated.

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: Filter Table with values based in worksheet

    Hi,

    for filtering dates use them as long:

    Please Login or Register  to view this content.
    Please use [CODE]-TAGS
    When your problem is solved mark the thread SOLVED
    If an answer has helped you please click to give reputation
    Read the FORUM RULES

  3. #3
    Registered User
    Join Date
    10-26-2007
    Posts
    55

    Re: Filter Table with values based in worksheet

    Quote Originally Posted by tehneXus View Post
    Hi,

    for filtering dates use them as long:

    Please Login or Register  to view this content.

    thanks, now works

+ 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: 8
    Last Post: 06-24-2014, 03:35 PM
  2. Replies: 2
    Last Post: 06-11-2013, 12:43 AM
  3. [SOLVED] Using vba to change pivot table filter based on cell value in another worksheet
    By kidwispa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-05-2013, 11:10 AM
  4. Change pivot table filter with VBA based on cell values
    By ZeDoctor in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-08-2012, 09:03 AM
  5. Replies: 2
    Last Post: 02-11-2010, 03:12 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