I can do this email me at excelvba...@gmail.com On Tue, Aug 16, 2011 at 6:00 AM, Amit Desai (MERU) <amit.de...@merucabs.com>wrote:
> Dear All,**** > > ** ** > > Still waiting a solution for below issue…**** > > ** ** > > 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.)**** > > Best Regards,**** > > Amit Desai**** > > ** ** > > Assistant 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 "0" > to "-"**** > > ** ** > > Thanks this one helped me….**** > > ** ** > > Can you please also reply on below request;**** > > ** ** > > 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.)**** > > ** ** > > Best Regards,**** > > Amit Desai**** > > ** ** > > Assistant Manager, Fleet MIS (Corporate)**** > > Desk No.: 022 40520129**** > > Cell No.: 9867232534**** > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Rajan_Verma > *Sent:* Thursday, August 11, 2011 3:02 PM > *To:* excel-macros@googlegroups.com > *Subject:* RE: $$Excel-Macros$$ 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 > *Subject:* Re: $$Excel-Macros$$ Update Data source range & converting "0" > to "-"**** > > ** ** > > See the attached file, does it make sense..**** > > **** > > regards,**** > > Mrinal Saha**** > > On Thu, Aug 11, 2011 at 10:37 AM, Amit Desai (MERU) < > amit.de...@merucabs.com> 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 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 data through formula. There > may > be many cells where I might get data as "0"(zero). I want to make all the > "0" as "-". But the total of these "-" I want as "0". > > Best Regards, > Amit Desai > > > Disclaimer: This message and its attachments contain confidential > information and may also contain legally privileged information. This > message is intended solely for the named addressee. If you are not the > addressee indicated in this message (or authorized to receive for > addressee), you may not copy or deliver any part of this message or its > attachments to anyone or use any part of this message or its attachments. > Rather, you should permanently delete this message and its attachments (and > all copies) from your system and kindly notify the sender by reply e-mail. > Any content of this message and its attachments that does not relate to the > official business of Meru Cab Company Pvt. Ltd. must be taken not to have > been sent or endorsed by any of them. Email communications are not private > and no warranty is made that e-mail communications are timely, secure or > free from computer virus or other defect. > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel**** > > ** ** > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel**** > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel**** > > ------------------------------ > Disclaimer: This message and its attachments contain confidential > information and may also contain legally privileged information. This > message is intended solely for the named addressee. If you are not the > addressee indicated in this message (or authorized to receive for > addressee), you may not copy or deliver any part of this message or its > attachments to anyone or use any part of this message or its attachments. > Rather, you should permanently delete this message and its attachments (and > all copies) from your system and kindly notify the sender by reply e-mail. > Any content of this message and its attachments that does not relate to the > official business of Meru Cab Company Pvt. Ltd. must be taken not to have > been sent or endorsed by any of them. Email communications are not private > and no warranty is made that e-mail communications are timely, secure or > free from computer virus or other defect. > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
