ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2007 pivot table: select multiple data easier (https://www.excelbanter.com/excel-discussion-misc-queries/445688-excel-2007-pivot-table-select-multiple-data-easier.html)

Tony O[_3_]

Excel 2007 pivot table: select multiple data easier
 
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.



All times are GMT +1. The time now is 08:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com