#1
|
|||
|
|||
Auto Filter base on a value in another cell in same worksheet
Good day, I have a worksheet that I would to filter a range A7:AP20000 base on the value in cell B1. The column in the range that contains the value that is in B1 is column "C" Thanks in advance Z941714 |
#2
|
||||
|
||||
Hello
perhaps look at http://www.ozgrid.com/forum/showthread.php?t=91151
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Cell Background Color: Base it on Content of Cell? | tatihulot | Excel | 4 | 08-14-2013 03:24 PM |
getting the worksheet name in a cell | derohanes | Excel | 9 | 02-14-2013 01:29 PM |
is it possible, filter data come in a2, b2 cell | gsrikanth | Excel | 1 | 07-05-2012 04:08 PM |
"Auto-populating" data-worksheet to worksheet. | meggenm | Excel | 4 | 02-04-2012 02:04 AM |
Junk filter: auto delete blocked senders ONLY | andrew@murphymckay.com | Outlook | 1 | 11-10-2011 02:30 PM |