$$Excel-Macros$$ plz, check how many categories are there in the column A totally by formula that is applied in single cell to display the result?

2012-02-14 Thread Mohammed Muneer
Book3.xls Description: Book3.xls

Re: $$Excel-Macros$$ need help for hyperlink execution without using mouse PFA

2012-02-14 Thread PrIyAnKa
Dear Renuka kindly check the below link , it might be helpful to u http://www.rondebruin.nl/mail/folder2/mail5.htm On Wed, Feb 15, 2012 at 11:55 AM, renuka chari wrote: > ya, sending on daily basis > > On Feb 14, 12:25 pm, Mahesh parab wrote: > > Hi > > > > Do you want to send bulk emails t

Re: $$Excel-Macros$$ need help for hyperlink execution without using mouse PFA

2012-02-14 Thread renuka chari
thanks maries And All On Feb 14, 2:02 pm, Maries wrote: > Hi, > > Find the attached file. > > Regards, > > MARIES. > > > > > > > > On Tue, Feb 14, 2012 at 9:25 PM, Mahesh parab wrote: > > Hi > > > Do you want to send bulk emails to respective person from that worksheet ? > > > HTH > > Mahesh > >

Re: $$Excel-Macros$$ need help for hyperlink execution without using mouse PFA

2012-02-14 Thread renuka chari
Hi dguillett1 Its working Good Thank you so much On Feb 14, 10:44 am, "dguillett1" wrote: > Right click sheet tab>view code insert this. Now when you select col G (no > need for col H) > > Private Sub Worksheet_SelectionChange(ByVal Target As Range) > On Error GoTo nomo > If Target.Colu

Re: $$Excel-Macros$$ need help for hyperlink execution without using mouse PFA

2012-02-14 Thread renuka chari
ya, sending on daily basis On Feb 14, 12:25 pm, Mahesh parab wrote: > Hi > > Do you want to send bulk emails to respective person from that worksheet ? > > HTH > Mahesh > > > > > > > > On Tue, Feb 14, 2012 at 9:14 PM, dguillett1 wrote: > > > Don Guillett > > SalesAid Software > > dguille...@gmai

Re: $$Excel-Macros$$ Pivot Table data range update

2012-02-14 Thread anandydr
Although I have not tested it on Excel 2010 in Excel 2007 the shortcut key to Name Manager dialog box is Ctrl + F3 I hope it works for 2010 also. As for explanation given by Noorain it's excellent and most complete. You can also achieve this through VBA but it would effect the speed/ performance of

Re: $$Excel-Macros$$ Pivot Table data range update

2012-02-14 Thread Awal
Thanks Noorain. That was very thorough. I am using excel 2010 but I can find the Name Manager. I will encourage all our Excel gurus to follow your footsteps. This little tutorial made me like this forum even more!!! Thanks a lot and best regards. On Feb 13, 11:11 pm, NOORAIN ANSARI wrote: > Dear

$$Excel-Macros$$ Find & copy row into New sheet

2012-02-14 Thread Cab Boose
Hi Excel 2000 Attached workbook 'Sheet!List' tab. For standardising descriptions, (different users!) I need to be able to extract a string and copy /paste all instances into a new sheet, sheet to be named the string of the search. Full list 2000+ rows. eg If I am looking for 'Bolt' the ma

Re: $$Excel-Macros$$ need help for hyperlink execution without using mouse PFA

2012-02-14 Thread Maries
Hi, Find the attached file. Regards, MARIES. On Tue, Feb 14, 2012 at 9:25 PM, Mahesh parab wrote: > Hi > > Do you want to send bulk emails to respective person from that worksheet ? > > > HTH > Mahesh > > > On Tue, Feb 14, 2012 at 9:14 PM, dguillett1 wrote: > >> >> >> Don Guillett >> SalesAid

Re: $$Excel-Macros$$ need help for hyperlink execution without using mouse PFA

2012-02-14 Thread Mahesh parab
Hi Do you want to send bulk emails to respective person from that worksheet ? HTH Mahesh On Tue, Feb 14, 2012 at 9:14 PM, dguillett1 wrote: > > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* Renukachari Kasee > *Sent:* Tuesday, February 14, 2012 6:21 AM > *To:* excel-

Re: $$Excel-Macros$$ internetexplorer.application add an alias to a link

2012-02-14 Thread Sam Mathai Chacko
Why don't you use FireFox or Maxthon. These have the feature you are talking about. If you are worried about the address being displayed to users, why don't you just hide the address bar in IE. By the way, Don, I for one, do not understand how the solution posted before can be a solution to the OP

Re: $$Excel-Macros$$ internetexplorer.application add an alias to a link

2012-02-14 Thread dguillett1
I, for one, do not understand the question. Don Guillett SalesAid Software dguille...@gmail.com From: Philehof Sent: Monday, February 13, 2012 2:12 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ internetexplorer.application add an alias to a link Hi Group With the below code,

Re: $$Excel-Macros$$ Need pivot & subtotal code

2012-02-14 Thread NOORAIN ANSARI
Hi Rekha, Please check below link.. Hope it will help to you.. http://www.contextures.com/excel-pivot-table-subtotals.html On Tue, Feb 14, 2012 at 9:15 PM, rekha siri wrote: > can any one please assist my query... > > > On Tue, Feb 14, 2012 at 1:02 AM, rekha siri wrote: > >> hi Raj, >> >> Than

Re: $$Excel-Macros$$ 1,000 missing survey data points to be fixed by interpolation

2012-02-14 Thread Bé Trần Văn
2012/2/14 PrIyAnKa > Dear Yogananda > > Instead of sharing such details kindly send a input or output sheet > > As your details are too long to read and understand and then provide u any > answer > > SO kindly share an excel with group > > On Tue, Feb 14, 2012 at 6:40 AM, yogananda muthaiah < > y

Re: $$Excel-Macros$$ Need pivot & subtotal code

2012-02-14 Thread rekha siri
can any one please assist my query... On Tue, Feb 14, 2012 at 1:02 AM, rekha siri wrote: > hi Raj, > > Thanks for your macro but i am sorry this is not performing vlookup > function inthis. > > can you please look into this > > > On Tue, Feb 14, 2012 at 12:37 AM, Raj Mahapatra wrote: > >> Hi

Re: $$Excel-Macros$$ need help for hyperlink execution without using mouse PFA

2012-02-14 Thread dguillett1
Don Guillett SalesAid Software dguille...@gmail.com From: Renukachari Kasee Sent: Tuesday, February 14, 2012 6:21 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ need help for hyperlink execution without using mouse PFA Hi All experts good evening here one sheet is having h

Re: $$Excel-Macros$$ need help for hyperlink execution without using mouse PFA

2012-02-14 Thread dguillett1
Right click sheet tab>view code insert this. Now when you select col G (no need for col H) Private Sub Worksheet_SelectionChange(ByVal Target As Range) On Error GoTo nomo If Target.Column = 7 And Target <> "" Then ActiveWorkbook.FollowHyperlink Address:= _ "mailto:"; & Target & "?bcc=$J$1," & Tar

$$Excel-Macros$$ need help for hyperlink execution without using mouse PFA

2012-02-14 Thread Renukachari Kasee
Hi All experts good evening here one sheet is having hyperlinks click on that link(with the help of mouse) outlook new mail window will be open, but i am expecting without using mouse. *(¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling!! `•.¸.•´ Thanks & Regards´¨) ¸ •´ ¸.•*´¨) ¸