When using a pivot table, is there any way of
automatically selecting from a drop down menu.
By this I mean if I can select one of 5 colours,
If I put "red" in cell A1, can the pivot table be made to
take the value in cell A1 as the colour selection, rather
than me selecting red from the drop down list.

thanks in advance