Defined name in auto filter

[cornepiek]

hi all

im trying to use a defied name in autofilter

i have a defined name that is the result of a formula
the value of the defined name will be one of several fixed results

on the next sheet i have a list of clients. each of these will be assigned one of the values used in the defined name.

how can i set an autofilter to filter the list of clients depending on the value of the defined name.

defined name = agent
values: Maxtel
Webcall


sheet 2

a b c
1 Customer Name Agent Name Commisson
2 BM Foods Maxtel 1500
3 ABC print Webcall 800
4 Trollies4Us Maxtel 200
5 SA Fruit Webcall 900


autofilter = {defined Name: agent}
Defined Name current value = Maxtel
Result:

sheet 2

a b c
1 Customer Name Agent Name Commisson
2 BM Foods Maxtel 1500
4 Trollies4Us Maxtel 200


i hope this is clear enough

thanks