+ Reply to Thread
Results 1 to 3 of 3

Filter data and edit with a search istead of the filter button

  1. #1
    Registered User
    Join Date
    10-05-2013
    Location
    Nederland
    MS-Off Ver
    Excel 2013
    Posts
    3

    Filter data and edit with a search istead of the filter button

    Dear people,

    This is my first topic, so bear with me please

    I have a database in Excel 2013 and now I want that when a value (a person's name) is entered in a cell. That then the database sort of filters the list for me, so it's still possible to make changes in the entries.

    http://imgur.com/zt25vhR
    Picture above to specify the search, which I would therefore like to edit

    Dashboard_Action Pool Team 7.2.xlsm

    I have been all morning working on a simplified version of the tutorial from YouTube: Create your own Excel Search Pt. 4. But came back later so only then that I can not change the data:?

    Is this at all possible or is there something similar?

    My gratitude is great!

  2. #2
    Registered User
    Join Date
    10-05-2013
    Location
    Nederland
    MS-Off Ver
    Excel 2013
    Posts
    3

    Re: Filter data and edit with a search istead of the filter button

    Is there no solution for this :S

  3. #3
    Forum Contributor
    Join Date
    04-25-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2010
    Posts
    150

    Re: Filter data and edit with a search istead of the filter button

    Put this in the Worksheet code (right click on the worksheet tab, click View Code):

    Please Login or Register  to view this content.

+ 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] Macro/s to create Search Bar to filter to search terms entered activated by Command Button
    By JasonRay in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-08-2013, 03:44 PM
  2. [SOLVED] Macro button to filter data
    By Alice21 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-01-2012, 03:15 PM
  3. Great Combo Filter/Search form, cant get DATE filter to integrate. HELP
    By fau5tu5 in forum Access Programming / VBA / Macros
    Replies: 4
    Last Post: 05-18-2009, 05:05 PM
  4. Advance filter search does not filter an exact match
    By cfiiland in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-10-2005, 08:05 AM
  5. VBA Button to Filter & Un-Filter List
    By brianv in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-02-2005, 05:32 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