create named range from pivot table

[ajm]

how does one create a named range from a pivot table? actually, it will be multiple ranges. I have used a pivot table to show which stores are handled by our account managers. as such, in the pivot table, each account manager then has multiple stores. The number will change as business improves and will fall as it declines. Is there a way to create dynamic named ranges from the results of a pivot table?

i have earlier attempted, without success, to get the lists through advanced filter in thread
http://www.mrexcel.com/forum/showthread.php?t=576547

 

[ajm]

got my solution from the contextures website (yet again).

read http://blog.contextures.com/archives/2010/03/31/dependent-data-validation-from-pivot-tables/