Re: $$Excel-Macros$$ Creating Dynamic Hyperlink between Summary and Detail sheet

2013-05-06 Thread Eugene Bernard
Thanks Ashish for your lightening response !!!. This meets exactly, what I expected !!!. Thanks. Eugene On Mon, May 6, 2013 at 9:57 PM, ashish koul wrote: > try this see if it helps > > Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As > Boolean) > > Dim wk As Work

Re: $$Excel-Macros$$ Creating Dynamic Hyperlink between Summary and Detail sheet

2013-05-06 Thread ashish koul
try this see if it helps Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim wk As Worksheet Set wk = Sheets("Detail") Application.EnableEvents = False On Error GoTo Err: If Target.Count = 1 And Not Intersect(Target, Range("b2:e5")) Is Nothi

$$Excel-Macros$$ Creating Dynamic Hyperlink between Summary and Detail sheet

2013-05-06 Thread Eugene Bernard
Hi all, I have a requirement to create a hyper link between two sheets (Summary and detail) in the attached sheet. I need to create a hyperlink in summary sheet, for all the value cells from B2:E5. >From the created 16 hyperlinks from summary sheet, if for example , I click on cell B2, the detai

Re: $$Excel-Macros$$ Re: Find Distance and Time between two cities using Google Map In excel

2013-05-06 Thread ashish koul
hi if u r running multiple queries in a day. you have to purchase the Key Free usage limit is as - 100 elements per query. - 100 elements per 10 seconds. - 2 500 elements per 24 hour period. Visit below links for more info https://developers.google.com/maps/documentation/distancematrix/

RE: $$Excel-Macros$$ Vlookup Help **URGENT**

2013-05-06 Thread Amit Desai (MERU)
Is there any alternative other than array formala? Best Regards, Amit Desai +91 98672 32534 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of priti verma Sent: 06 May 2013 14:00 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Vlookup Help **U

Re: $$Excel-Macros$$ 8 become 0

2013-05-06 Thread koul . ashish
Change the format of cell to text or add ' in front of number Sent on my BlackBerry® from Vodafone -Original Message- From: priti verma Sender: excel-macros@googlegroups.com Date: Mon, 6 May 2013 16:29:14 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ 8 bec

Re: $$Excel-Macros$$ 8 become 0

2013-05-06 Thread priti verma
Hi Abhishek, Can you please share your file On Mon, May 6, 2013 at 4:25 PM, Abhishek Verma < ave...@salujaandassociates.com> wrote: > Dear Experts, > > I wish to type this no. 223400150004063*8* in excel when i type it > comes 223400150004063*0. Why last digit 8 becomes 0* > -- > Thanks & Regar

$$Excel-Macros$$ 8 become 0

2013-05-06 Thread Abhishek Verma
Dear Experts, I wish to type this no. 223400150004063*8* in excel when i type it comes 223400150004063*0. Why last digit 8 becomes 0* -- Thanks & Regards *CA Abhishek Verma* *ACA, DISA, MBA, B.Com (Hons)* *Partner* *SALUJA & ASSOCIATES.* *CHARTERED ACCOUNTANTS* 69,Desh Bandhu Gupta Road, Joll

Re: $$Excel-Macros$$ Vlookup Help **URGENT**

2013-05-06 Thread Prafull Jadhav
Find the same ..with useing sumproduct formula. On Mon, May 6, 2013 at 1:59 PM, priti verma wrote: > HI Bhanu , > please see the attachment. > > > On Mon, May 6, 2013 at 1:35 PM, bhanu prakash wrote: > >> Dear All, >> >> In Vlookup, when we have more than 3 to 4 return values, how to pick all >>

Re: $$Excel-Macros$$ Vlookup Help **URGENT**

2013-05-06 Thread priti verma
HI Bhanu , please see the attachment. On Mon, May 6, 2013 at 1:35 PM, bhanu prakash wrote: > Dear All, > > In Vlookup, when we have more than 3 to 4 return values, how to pick all > the return values..in Vlook up it picks the first value . > > Need your help at the earliest..let me know if my q

Re: $$Excel-Macros$$ Vlookup Help **URGENT**

2013-05-06 Thread Abhishek Jain
See this. On Mon, May 6, 2013 at 1:35 PM, bhanu prakash wrote: > Dear All, > > In Vlookup, when we have more than 3 to 4 return values, how to pick all > the return values..in Vlook up it picks the first value . > > Need your help at the earliest..let me know if my query is not > clear..will ela

$$Excel-Macros$$ Vlookup Help **URGENT**

2013-05-06 Thread bhanu prakash
Dear All, In Vlookup, when we have more than 3 to 4 return values, how to pick all the return values..in Vlook up it picks the first value . Need your help at the earliest..let me know if my query is not clear..will elaborate..thanks Regards, Bhanu -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in E