![]() |
|
#1
|
||||
|
||||
![]()
You won't be able to use =FILTER() within a table because by definition that cell with a formula in it has to be outside what it's filtering, that is, it has to be in another cell(s). Easy enough to do this while typing using an activeX text box and a linked cell. See attached where there's an activeX text box, linked to cell B10 whose value is used in a =FILTER function in cell D13. Of course, in this case it's just filtering the single column but it's very easy for that to apply to a whole table or a subset of the columns of a whole table.
Filtering the table itself is possible as you've said, with vba, but without vba there is the built-in functionality of the search box in the dropdowns of the headers of a table, this will visibly reduce the numbers of possibilities as you type (shown as checkboxes), but only for that column and within that dropdown's dialogue box. You'll only be able to see the full table result of that search-as-you-type when you finally OK that dialogue box. 2022-06-22_131304.png |
#2
|
|||
|
|||
![]()
Thanks for the reply and info. It seems like VBA is the best option for my needs.
I suppose I could place my filter in a separate sheet and link it back to the original data. That would solve my problem of having two massive tables on the same sheet, but it feels a little over the top for what I want to do. I might try it anyway if I have time. Thanks again. |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
LARGE function with 3 IF statements??? | FloorManager | Excel | 3 | 08-23-2017 01:06 PM |
Dynamic Dashboard w/ Search Criteria | Exceluser | Excel | 2 | 04-27-2017 11:57 AM |
Filter Search Button | lonniepoet | Excel Programming | 53 | 12-23-2015 02:27 PM |
![]() |
omtinole | Excel Programming | 1 | 07-13-2012 10:03 PM |
![]() |
stct | Project | 5 | 05-20-2011 03:30 AM |