stereotypeq
New Member
- Joined
- Nov 28, 2012
- Messages
- 3
I'm usually am able to find answers without creating a post, however this one baffles me.
I have certain people in a list in Column A (say, Smith, Miller, Howe) with data to the right (columns B-E say)
Say I filter to look at all the Smith rows.
Separately - on the top of the sheet I would like to be able to have the header change to "Smith". E.g. do formulas that recognize the criteria filtered. Similar to =A2 or something, but instead of a specific cell reference I would like it to equal the criteria value I selected on my filter of "Smith".
Ideally I could also then do other formulas, such as Vlookup("whatever I selected for filter",A:E,4,0)
The idea being I could filter by person and then bring up all sorts of stats on that person in a separate area.
If this isn't possible... there's the hail mary idea that I could do a dropdown validation list and select the person, and have it auto filter by the person selected. But guessing that might not be more involved.
I am not great with code but am able to copy / paste into macros and do a little bit.
Thoughts?
I have certain people in a list in Column A (say, Smith, Miller, Howe) with data to the right (columns B-E say)
Say I filter to look at all the Smith rows.
Separately - on the top of the sheet I would like to be able to have the header change to "Smith". E.g. do formulas that recognize the criteria filtered. Similar to =A2 or something, but instead of a specific cell reference I would like it to equal the criteria value I selected on my filter of "Smith".
Ideally I could also then do other formulas, such as Vlookup("whatever I selected for filter",A:E,4,0)
The idea being I could filter by person and then bring up all sorts of stats on that person in a separate area.
If this isn't possible... there's the hail mary idea that I could do a dropdown validation list and select the person, and have it auto filter by the person selected. But guessing that might not be more involved.
I am not great with code but am able to copy / paste into macros and do a little bit.
Thoughts?