+ Reply to Thread
Results 1 to 2 of 2

Update filtered data when base data is changed

  1. #1
    Registered User
    Join Date
    12-16-2018
    Location
    Denmark
    MS-Off Ver
    1811
    Posts
    3

    Update filtered data when base data is changed

    Hello
    So i have a problem where when i change the values of the filtered data i have to go and press the filter icon at the top of the column, scroll down and deselect #VALUE! for it to update.
    Is there a way of coding so that this happens automatically?
    Thanks for the help.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,910

    Re: Update filtered data when base data is changed

    I don't know if this is what you want, but use a helper column: =ISERROR(A2) and filter for false. I am fairly certain that filtering is NOT volatile, that is, it is not changed automatically when the data changes. However a VB event could probably change that. At worst this column will only have two items to scroll through.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. Cell reference to filtered data auto update as Filtered result changes
    By Irajoo in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-22-2017, 02:17 AM
  2. [SOLVED] Auto update (addition) based on base data
    By Amolvijay in forum Excel General
    Replies: 2
    Last Post: 02-10-2014, 11:12 AM
  3. [SOLVED] looking to be able to search and update data base for inventory control
    By cocataro in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-31-2012, 10:09 AM
  4. update production sheet from data base.
    By johncena in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-23-2010, 12:05 PM
  5. extracting data from a filtered data base
    By Camelhump in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 04-06-2008, 03:22 PM
  6. Update E-Mail Data Base
    By Brian Matlack in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-07-2006, 02:17 PM
  7. Charts don't update when data is changed, why not?
    By Frank in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-08-2005, 08:05 PM

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