I would think it would be easiest if you made the name column a page field in
the pivottable.

It'll even look kind of like data|validation.

FA wrote:

I have a cell that includes a list of names (data validation).
I want the pivot table page field to change following the name selected.
How can I do this?

Is it better with a combo box?

Thank you!

--

Dave Peterson