T
Tony O
I am using Excel 2007 (many individual spreadsheets every day with
pivot tables).
On each pivot table, I want to select all the fields that start with
the same four letters. Here's
an example:
Acme Boston
Acme Dallas
Acme Ontario
Every month the amount of divisions may go up or down, depending on
how much (if any)
each city's division buys. It's taking quite a bit of time to click
all the check boxes (could be more than twenty
for each spreadsheet, sales are posted monthly on separate sheets).
Is there a way I could have Excel click all the check boxes that start
with "Acme"?
(ideally, with just one click) Please explain.
pivot tables).
On each pivot table, I want to select all the fields that start with
the same four letters. Here's
an example:
Acme Boston
Acme Dallas
Acme Ontario
Every month the amount of divisions may go up or down, depending on
how much (if any)
each city's division buys. It's taking quite a bit of time to click
all the check boxes (could be more than twenty
for each spreadsheet, sales are posted monthly on separate sheets).
Is there a way I could have Excel click all the check boxes that start
with "Acme"?
(ideally, with just one click) Please explain.