M
M in the Lyon's den
Warning: I am not an excel expert and don't know much of the technical lingo that I have read on the "threads" in the pursuit of an answer to my question...so here goes. I have a spreadsheet with about 10,000 rows and 100 cols of info. I run analyses on the data in this sheet by employing filters and subtotals based on the concept being run. I would like to do 2 things...1. have a few cells near A1 where I could type in a word and remotely filter a column (for example I would type "Joe" into a cell and it would know to filter for "Joe" in column G, and would execute the filter) 2. in another series of boxes near A1, have some cells named the same as many of my columns, if the field is currently under a filter it could be a color (for example, blue). This would allow me to run quick analyses and print the first part of the sheet as a record ......(I could see (and make) some selections I made in filter and could see which columns are being filtered)...almost like a "dashboard".
Any help would be appreciated.
Any help would be appreciated.