chrono2483
Board Regular
- Joined
- Aug 23, 2014
- Messages
- 164
- Office Version
- 2016
Hello,
Hoping for some help/point in the right direction. I have searched this forum, as well as Google and YouTube. I have a filter enabled, and rather than having to select every specific value each time, I want to be able to point to a list of values that I would be filtering by.
Example: I have a sheet with 20,000 rows. In Column A, there are names, including Homer, Bart, Lisa, Marge. Rather than having to select these each time, I want to have a range in the sheet, that I can put these names (and maybe add to it), so that it filters automatically.
Is this do-able?
Thank you.
Hoping for some help/point in the right direction. I have searched this forum, as well as Google and YouTube. I have a filter enabled, and rather than having to select every specific value each time, I want to be able to point to a list of values that I would be filtering by.
Example: I have a sheet with 20,000 rows. In Column A, there are names, including Homer, Bart, Lisa, Marge. Rather than having to select these each time, I want to have a range in the sheet, that I can put these names (and maybe add to it), so that it filters automatically.
Is this do-able?
Thank you.