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 Edit>Replace

What: count

With: sum

Replace all


Gord

On Wed, 11 Jan 2012 06:47:56 -0800 (PST), wesley holtman
<(E-Mail Removed)> 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 <phnor...@shaw.ca> wrote:
> Select the cells where you want a change then try Edit>Replace
>
> What: *count
>
> With: sum
>
> Replace all
>
> Gord
>
> On Wed, 11 Jan 2012 06:47:56 -0800 (PST), wesley holtman
>
>
>
> <wesleyholt...@gmail.com> 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
<(E-Mail Removed)> 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 <phnor...@shaw.ca> wrote:
>> Select the cells where you want a change then try Edit>Replace
>>
>> What: *count
>>
>> With: sum
>>
>> Replace all
>>
>> Gord
>>
>> On Wed, 11 Jan 2012 06:47:56 -0800 (PST), wesley holtman
>>
>>
>>
>> <wesleyholt...@gmail.com> 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 <peter...@XSPAMverizon.net> 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