I have 100+ unique data items that I need to drag into the data field in my
pivot table every quarter. Is there some way to select multiple data items
out of the pivot table field list so I do not have to drag/drop 100+ times?
I tried shift and/or ctlr to select multiple to drage but it does not work.
I can really use a timesaver for this one! Thanks.