Re: $$Excel-Macros$$ Data Validation issue

Thanks Viper sir On Thu, Feb 28, 2013 at 1:01 PM, The Viper wrote: > "Maruti Kadam" is available in a9. but the original named range is > "Maruti_Kadam". an underscore is missing. > > > On Thu, Feb 28, 2013 at 12:54 PM, amar takale wrote: > >> Dear All, >> I have Data validation sheet in which I

Re: $$Excel-Macros$$ Need formula for sum

Use this formula with Ctrl+Shift+enter =SUM(IF($D$2:$AB$2=AC$2,$D$3:$AB$3)) On Thu, Feb 28, 2013 at 10:25 AM, Anoop K Sharma wrote: > Use attached one. This'll take care of text values also. > > > On Thu, Feb 28, 2013 at 10:41 AM, Deepak Rawat wrote: > >> But if some in some place text exists t

Re: $$Excel-Macros$$ Data Validation issue

"Maruti Kadam" is available in a9. but the original named range is "Maruti_Kadam". an underscore is missing. On Thu, Feb 28, 2013 at 12:54 PM, amar takale wrote: > Dear All, > I have Data validation sheet in which In output sheet cell B6,I put data > validation with Indirect formula that time I

Re: $$Excel-Macros$$ Need formula for sum

Use attached one. This'll take care of text values also. On Thu, Feb 28, 2013 at 10:41 AM, Deepak Rawat wrote: > But if some in some place text exists then what to do > > Regards, > Deepak > > > On Wed, Feb 27, 2013 at 8:47 PM, Maries wrote: > >> Hi, >> >> Try it, >> >> =SUMIF($D$2:$AB$2,AC2,D$

Re: $$Excel-Macros$$ Is it possible to Create a macro that gives URL as output after giving the advertiser name as Input

No Noorain, this is not what Abhishek looking for. As I can understand he wants a "text box" or "input box" on excel in which he can give his input and find related urls in excel from google. Time investment is required for this to extract urls from IE or Mozila. On Wed, Feb 27, 2013 at 6:05 PM,

Re: $$Excel-Macros$$ Need formula for sum

Hi, Try it, =SUMIF($D$2:$AB$2,AC2,D$3:AB$3) On Wed, Feb 27, 2013 at 6:26 PM, Deepak Rawat wrote: > Sorry attached wrong one > now attached the correct one. > > Regards, > Deepak > > > On Wed, Feb 27, 2013 at 5:41 PM, David Grugeon wrote: > >> We need more information. What do you want the sum

Re: $$Excel-Macros$$ Is it possible to Create a macro that gives URL as output after giving the advertiser name as Input

Dear Abhishek, Please try through attached sheet, hope it will help to you. -- With Regards, Noorain Ansari http:// noorainansari.com http:// excelvbaclinic.com

Re: $$Excel-Macros$$ Need formula for sum

We need more information. What do you want the sum of? There does not seem to be anything in the worksheet provided that you could possibly want to add up. On Wednesday, 27 February 2013, Deepak Rawat wrote: > Hi, > > need formula for sum in attach > > Regards, > Deepak > > -- > Are you =EXP(E:

$$Excel-Macros$$ Re: Need formula for sum

Hi On which column you want sum ? Regards Prince On Wednesday, February 27, 2013 5:27:38 PM UTC+5:30, Deepak Rawat wrote: > > Hi, > > need formula for sum in attach > > Regards, > Deepak > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join

$$Excel-Macros$$ Need formula for sum

Hi, need formula for sum in attach Regards, Deepak -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor th

Re: $$Excel-Macros$$ Insert the Blank rows by Macro

thanks On Wed, Feb 27, 2013 at 3:53 PM, ravinder negi wrote: > There are two files attached for solution. First one is normal Excel > file and other one is Addins file. > > --- On *Wed, 2/27/13, Aamir Shahzad * wrote: > > > From: Aamir Shahzad > Subject: $$Excel-Macros$$ Insert the Blank rows

$$Excel-Macros$$ Re:

http://kalnet.fr/coffee/mygKevinKoons.html -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titl

Re: $$Excel-Macros$$ Is it possible to Create a macro that gives URL as output after giving the advertiser name as Input

Thanks for replying. Well the database is google search. After you search for the advertisers name, the first result that comes up contains the URL. Let's assume we are using mozilla browser. Thanks Abhishek -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,

Re: $$Excel-Macros$$ Insert the Blank rows by Macro

Thanks you Gawli Anil, it's working nice On Wed, Feb 27, 2013 at 1:50 PM, अनिल नारायण गवली wrote: > Dear Amir, > > Pl find enclosed herewith . > > Warm Regards, > Gawli Anil > > On Wed, Feb 27, 2013 at 1:43 PM, Aamir Shahzad > wrote: > >> Hi Group, >> I need the Macro, when I run, it insert the

Re: $$Excel-Macros$$ Insert the Blank rows by Macro

Thank you very much Noorain Sir. On Wed, Feb 27, 2013 at 1:50 PM, अनिल नारायण गवली wrote: > Dear Amir, > > Pl find enclosed herewith . > > Warm Regards, > Gawli Anil > > On Wed, Feb 27, 2013 at 1:43 PM, Aamir Shahzad > wrote: > >> Hi Group, >> I need the Macro, when I run, it insert the blank r

Re: $$Excel-Macros$$ Insert the Blank rows by Macro

Dear Amir, Pl find enclosed herewith . Warm Regards, Gawli Anil On Wed, Feb 27, 2013 at 1:43 PM, Aamir Shahzad wrote: > Hi Group, > I need the Macro, when I run, it insert the blank rows but ask me by > message box "How many" when I give number e.g. 15, macro insert the blank > 15 rows after th

$$Excel-Macros$$ Insert the Blank rows by Macro

Hi Group, I need the Macro, when I run, it insert the blank rows but ask me by message box "How many" when I give number e.g. 15, macro insert the blank 15 rows after the active cell. Thanks in Advance. Aamir Shahzad -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =