D
Darin Kramer
Howdie,
I have created a pivot table that refers to several columns of data.
Simple question, but difficult to explain...
Several of the columns are percentages (and the cols are for example
entitled xxx %efg or yyy % abcd etc)
When I use the PivotTable Field list to drag the item into the body of
my table, excel defaults the item to a COUNT and NUMBER FORMAT GENERAL.
I want it to default to SUM and number format to be PERCENTAGE with one
decimal place
I can do it manually each time, but as different users are going to be
extracting their own data to display I would like to automate the
process - IS there VB that can be written that automatically formats all
fields with the % sign in them (within the currently displayed pivot
table) to the predefined charachteristics (ie SUM and PERCENTAGE)
Any other ideas also welcomed!
Thanks and regards
D
*** Sent via Developersdex http://www.developersdex.com ***
I have created a pivot table that refers to several columns of data.
Simple question, but difficult to explain...
Several of the columns are percentages (and the cols are for example
entitled xxx %efg or yyy % abcd etc)
When I use the PivotTable Field list to drag the item into the body of
my table, excel defaults the item to a COUNT and NUMBER FORMAT GENERAL.
I want it to default to SUM and number format to be PERCENTAGE with one
decimal place
I can do it manually each time, but as different users are going to be
extracting their own data to display I would like to automate the
process - IS there VB that can be written that automatically formats all
fields with the % sign in them (within the currently displayed pivot
table) to the predefined charachteristics (ie SUM and PERCENTAGE)
Any other ideas also welcomed!
Thanks and regards
D
*** Sent via Developersdex http://www.developersdex.com ***