Hello, the great OzGrid!
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.....
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.
Also asked on: https://www.excelforum.com/exc…ed-on-one-cell-value.html