you certainly can filter by a value manually.
but to have something change automatically when someone clicks something will require VBA, no way around this fact.
ok. I'll have to pass on that. Thanks.
Hi there and welcome
You will always have VBA set up as it is within Excel, so you can use a VBA procedure within your sheet, this will work for you Shannon.