Hello,

Does anyone know a way within XL to change multiple data fields (ex.
from sum to count) at the same time? If not, could someone please help
me start to develop a macro to do so?

Thank you in advance!

Select the cells where you want a change then try EditReplace

What: count

With: sum

Replace all


Gord

On Wed, 11 Jan 2012 06:47:56 -0800 (PST), wesley holtman
wrote:

Hello,

Does anyone know a way within XL to change multiple data fields (ex.
from sum to count) at the same time? If not, could someone please help
me start to develop a macro to do so?

Thank you in advance!

Hi Gord,

I don't think I explained my request that well. I am trying to change
multiple pivot table data fields at one time. I tried the replace you
mentioned and recieved a message stating that XL couln't find any data
to replace.

Any thoughts?



On Jan 11, 10:02*am, Gord Dibben wrote:
Select the cells where you want a change then try EditReplace

What: *count

With: sum

Replace all

Gord

On Wed, 11 Jan 2012 06:47:56 -0800 (PST), wesley holtman



wrote:
Hello,

Does anyone know a way within XL to change multiple data fields (ex.
from sum to count) at the same time? If not, could someone please help
me start to develop a macro to do so?

Thank you in advance!- Hide quoted text -

- Show quoted text -

ooops!

Sorry Wesley...........What I know about PivotTables would make a very
tiny footnote in a book on growing Chrystanthemums.

Hang in.......someone will come to your aid.


Gord

On Wed, 11 Jan 2012 07:49:37 -0800 (PST), wesley24
wrote:

Hi Gord,

I don't think I explained my request that well. I am trying to change
multiple pivot table data fields at one time. I tried the replace you
mentioned and recieved a message stating that XL couln't find any data
to replace.

Any thoughts?



On Jan 11, 10:02*am, Gord Dibben wrote:
Select the cells where you want a change then try EditReplace

What: *count

With: sum

Replace all

Gord

On Wed, 11 Jan 2012 06:47:56 -0800 (PST), wesley holtman



wrote:
Hello,

Does anyone know a way within XL to change multiple data fields (ex.
from sum to count) at the same time? If not, could someone please help
me start to develop a macro to do so?

Thank you in advance!- Hide quoted text -

- Show quoted text -

Debra Dalgleish has some very nice notes about pivottables at her site:
http://www.contextures.com/
http://www.contextures.com/tiptech.html

She has an addin that can change Count's to Sum's:
http://www.contextures.com/xlPivotAddIn.html



On 01/11/2012 08:47, wesley holtman wrote:
Hello,

Does anyone know a way within XL to change multiple data fields (ex.
from sum to count) at the same time? If not, could someone please help
me start to develop a macro to do so?

Thank you in advance!

--
Dave Peterson

The add-in works great! Thanks Dave:)


On Jan 12, 7:54*am, Dave Peterson wrote:
Debra Dalgleish has some very nice notes about pivottables at her site:http://www.contextures.com/http://ww...m/tiptech.html

She has an addin that can change Count's to Sum's:http://www.contextures.com/xlPivotAddIn.html

On 01/11/2012 08:47, wesley holtman wrote:

Hello,

Does anyone know a way within XL to change multiple data fields (ex.
from sum to count) at the same time? If not, could someone please help
me start to develop a macro to do so?

Thank you in advance!

--
Dave Peterson