Automate pivot table selection
XL 2003; Win XP
I've created a PT with one row field "Customer" which lists all my
customers. I want to click on the Customer drop-down, deselect "Show
All" and select several customers from the list.
I tried recording a macro to do this, but it didn't record the
selecting and deselecting.
Any ideas?
TIA
Steve
|