RE: $$Excel-Macros$$ PivotTable_Calculated Field

2014-05-12 Thread Amit Desai (MERU)
Hi Does this also work on column containing Non-Numeric data? Regards, Amit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Vaibhav Joshi Sent: 05-Mon-2014 19:43 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ PivotTable_Calculated Field H

$$Excel-Macros$$ E book related..

2014-05-12 Thread Renukachari Kasee
Dear Group, any one please provide the ebook for excel macros i.e. 101 READY-TO-USE EXCEL MACROS by Michael Alexander , John Walkenbach (Thanks & Regards´¨) ¸ •´ ¸.•*´¨) ¸.•*¨) (¸.•´ (¸.•* ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪ P Let us do our best to save nature, save wa

$$Excel-Macros$$ Hide and Unhide

2014-05-12 Thread googley
I have three similar products with a yes, no list that when anyone of the three is yes the following formula changes CELL I9 to yes or no and hides or unhides rows on a proposal. Those yes , no cells F15,F23,F31 also hide, unhide single row entries that describe those products. This currently do

Re: $$Excel-Macros$$ PivotTable_Calculated Field

2014-05-12 Thread Vaibhav Joshi
Hi Refer: http://www.contextures.com/excel-pivot-table-calculated-field.html CHeers!! On Mon, May 12, 2014 at 7:08 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hi, > > How to add calculated field in the attached file here I need to calculate > Grand Total/Y. > > Thanks in advanc

Re: $$Excel-Macros$$ doc compare vba

2014-05-12 Thread Vaibhav Joshi
which version of MS-Office you are using? On Sat, May 10, 2014 at 12:32 PM, Arindam Das wrote: > > > I got stuck at one place.If I compare 2 documents entirely(not page by > page) how will I get the page numbers where we have the discrepancies.In > the below mentioned code I want the page numbe

Re: $$Excel-Macros$$ Macro required

2014-05-12 Thread Vaibhav Joshi
This is really cool... Cheers!! On Sun, May 11, 2014 at 10:24 PM, Bé Trần Văn wrote: > TEAR SHEET: Press the button "Separation sheet and name". > > ELIMINATION OF SHEET: Press the button "Delete sheet detached". > > > > > > 2014-05-07 14:12 GMT+07:00 Shrinivas Shevde : > > Very very thanks >>