+ Reply to Thread
Results 1 to 5 of 5

Create Filter automatic filter of list in other sheet

  1. #1
    Registered User
    Join Date
    02-22-2017
    Location
    Haarlem
    MS-Off Ver
    Excel 2010/2013
    Posts
    56

    Create Filter automatic filter of list in other sheet

    I need to select the numbers 3 and 6 in colom D in the Source data.

    How can a select these numbers automatically?

    This is just a small list but a need this for bigger file with a lot numbers

    See attached file
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Create Filter automatic filter of list in other sheet

    What is to happen with these selected numbers?
    Please Login or Register  to view this content.

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Create Filter automatic filter of list in other sheet

    It's rarely necessary to select cells and always slows things down.

    What's the end goal that you want to achieve after identifying the cells?
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Registered User
    Join Date
    02-22-2017
    Location
    Haarlem
    MS-Off Ver
    Excel 2010/2013
    Posts
    56

    Re: Create Filter automatic filter of list in other sheet

    I need to make a selection of a lot of cells manually it is to much work.

  5. #5
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Create Filter automatic filter of list in other sheet

    Quote Originally Posted by martijnrikkert View Post
    I need to make a selection of a lot of cells manually it is to much work.
    My question was aimed at understanding what you do once you have selected them. Are you copying them , deleting them...? Knowing that may mean you don't need to select them

+ 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: 0
    Last Post: 08-04-2017, 02:39 AM
  2. filter the date with filter automatic
    By max_max in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-24-2017, 04:59 PM
  3. [SOLVED] Select Automatic Report Filter in Pivot where Filter exist in Data table else select Blank
    By vinaynaran in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-02-2016, 08:47 AM
  4. automatic filter and copy to new sheet
    By oeyandyprawira in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-26-2015, 08:16 PM
  5. Automatic reset of filter and show selected sheet
    By lucremonkey in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-01-2015, 11:04 AM
  6. Replies: 0
    Last Post: 06-21-2011, 10:40 PM
  7. Extract filter items from Drop-Down Automatic Filter
    By karpatov in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-26-2006, 02:10 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