How do I write in VBA "I want the 1st row grouping of table X to be the field
name which is shown in cell A1"?

Assume that in A1, the name of the field has been selected. I want the user
to basically be able to select (outside of the pivot dropdowns) the name of a
field (State, Account, Rep) and have that field be the grouping in my pivot.
If there is a way to indicate what the second row is also, that would be good
(as then I can have them select which order of two different fields they want
to see).

I know that in this forum it sounds stupid, but for my users, learning how
to drag field names into an actual table to force the pivot to react is too
hard. So I am trying to work around it with simple dropdowns.

Thx for the help.
--
Boris