+ Reply to Thread
Results 1 to 2 of 2

Automatically filter range based on one cell value?

  1. #1
    Forum Contributor
    Join Date
    11-26-2014
    Location
    Bosnia&Herzegovina
    MS-Off Ver
    Office2013
    Posts
    281

    Automatically filter range based on one cell value?

    Hello, the great ExcelForum!

    How to automatically filter range based on one cell value?
    Let's say I have empty cell A1, dear Excel do nothing, do not filter range A2:A1048576.
    If there(A1) is some number then as I type in, do filtering on A2:A1048....
    If there(A1) is text or space(" ") display error, if is empty unfilter range-sort AZ column A2:A1048.....

    Thanks!

    P.s. Range A2:G1048.... will be constant, i will not delete rows, i just need to find(filter) row based on A1 search and then enter some data in G2 address.
    Last edited by B.W.B.; 11-23-2017 at 06:23 AM. Reason: P.s.

  2. #2
    Forum Contributor
    Join Date
    11-26-2014
    Location
    Bosnia&Herzegovina
    MS-Off Ver
    Office2013
    Posts
    281

    Re: Automatically filter range based on one cell value?

    le shifre
    A1 data
    how to draw a table?

    Book:
    Attached Files Attached Files
    Last edited by B.W.B.; 11-23-2017 at 06:30 AM.

+ 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: 2
    Last Post: 07-27-2014, 11:48 PM
  2. Automatically Filter Data Based on what is entered into cell
    By bpyoung83 in forum Excel Programming / VBA / Macros
    Replies: 34
    Last Post: 09-07-2013, 03:54 AM
  3. Filter Pivot based on Cell Value - Date Range
    By mfaustin in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-26-2013, 08:47 AM
  4. Automatically filter data in table based upon contents of one cell
    By m.g.williams in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-29-2013, 01:08 PM
  5. Replies: 2
    Last Post: 02-01-2013, 02:53 AM
  6. Replies: 9
    Last Post: 01-04-2013, 09:56 AM
  7. Filter range based of cell based on another range
    By Dieneces in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-03-2011, 02:53 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