ednesday, August 17, 2011 1:56 AM
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Update Data source range & converting "0" to
> "-"
>
> please ignore previous attachment ...just press cltr+shift+S then
> select new range for pivot...
-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of XLS S
Sent: Wednesday, August 17, 2011 1:56 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Update Data source range & converting "0" to
"-"
please ignore previous at
0520129
>
> Cell No.: 9867232534
>
> ** **
>
> *From:* Amit Desai (MERU) [mailto:amit.de...@merucabs.com]
> *Sent:* Thursday, August 11, 2011 4:16 PM
> *To:* 'excel-macros@googlegroups.com'
> *Subject:* RE: $$Excel-Macros$$ Update Data source range &
tant Manager, Fleet MIS (Corporate)
Desk No.: 022 40520129
Cell No.: 9867232534
From: Amit Desai (MERU) [mailto:amit.de...@merucabs.com]
Sent: Thursday, August 11, 2011 4:16 PM
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ Update Data source range & converting "
cros$$ Update Data source range & converting "0" to "-"
See if it helps, I use conditional Formatting
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of mrinal saha
Sent: Thursday, August 11, 2011 11:46 AM
To: excel-macros@googlegroups.com
See if it helps, I use conditional Formatting
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of mrinal saha
Sent: Thursday, August 11, 2011 11:46 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Update Data source range & convertin
Dear Amit,
try it
=SUBSTITUTE(E3,"-","0")
=Sum(- Range)
On Thu, Aug 11, 2011 at 10:37 AM, Amit Desai (MERU) wrote:
> Dear All,
>
> Please help me on the following;
>
> 1) I have created several pivot tables & want to update the data source
> range for all the pivot tables all together. (We do
See the attached file, does it make sense..
regards,
Mrinal Saha
On Thu, Aug 11, 2011 at 10:37 AM, Amit Desai (MERU) wrote:
> Dear All,
>
> Please help me on the following;
>
> 1) I have created several pivot tables & want to update the data source
> range for all the pivot tables all together.
Hi,
See below if helps...
*Replace "0" to"-" =IF(A1=0,"-",A1)*
*
**Replace "-" to"0"=**IF(A1="-","0",A1)**
*
*Best Regards,*
*Venkat *
*Chennai*
*
*
On Thu, Aug 11, 2011 at 10:37 AM, Amit Desai (MERU) wrote:
> Dear All,
>
> Please help me on the following;
>
> 1) I have created several pivot t
Dear All,
Please help me on the following;
1) I have created several pivot tables & want to update the data source
range for all the pivot tables all together. (We do have option as refresh
all for applying the preset pivot criteria in all pivots.)
2) I have few work sheets where in I get the dat
10 matches
Mail list logo
