Re: $$Excel-Macros$$ Need your help

2014-01-03 Thread Ashish Kumar
Dear Kartik, Please elaborate more. On 03/01/2014, karthik N wrote: > Dear Friends > > Please find the attached file. > > Please help.. > > *Regards* > karthik.N > > -- > 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 pa

Re: $$Excel-Macros$$ Need your help

2012-08-13 Thread Paul Schreiner
the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Mangesh Vimay To: excel-macros@googlegroups.com Sent: Mon, August 13, 2012 10:35

Re: $$Excel-Macros$$ Need your help

2012-08-13 Thread Mangesh Vimay
s you can, > In all the places you can, > At all the times you can, > To all the people you can, > As long as ever you can.” - John Wesley > *- > > > -- > *From:* David Grugeon > *To:* excel-macros@

Re: $$Excel-Macros$$ Need your help

2012-08-13 Thread Paul Schreiner
you can, To all the people you can, As long as ever you can.” - John Wesley - From: David Grugeon To: excel-macros@googlegroups.com Sent: Mon, August 13, 2012 9:25:56 AM Subject: Re: $$Excel-Macros$$ Need your help Magnesh and Paul

Re: $$Excel-Macros$$ Need your help

2012-08-13 Thread David Grugeon
Magnesh and Paul I think you could put an excel file (or a shortcut to one), in the startup folder. have an on open macro in the sheet to record the opening time. Then have a before close macro to record the time and save itself. My only concern would be whether Windows kills excel before the s

Re: $$Excel-Macros$$ Need your help

2012-08-13 Thread Paul Schreiner
This is going to be a tough one. It involves access to the Windows environment. I REALLY hope someone has an alternative, but I think you're going to have to write some  VBscript files that run at Windows Login and Logout that will make entries to a log file.   Paul

Re: $$Excel-Macros$$ Need your help !!!

2012-06-21 Thread Mohit Sharma
Thanks Noorain sir. you are simply superb. On Wed, Jun 20, 2012 at 7:23 PM, NOORAIN ANSARI wrote: > Dear Mohit, > > See attached sheet > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > On Wed, Jun 20, 2012 at 6:13 PM, Mohit Sharma wrote:

Re: $$Excel-Macros$$ Need your help !!!

2012-06-20 Thread NOORAIN ANSARI
Dear Mohit, See attached sheet -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Wed, Jun 20, 2012 at 6:13 PM, Mohit Sharma wrote: > Hi > Noorain sir, your method is simply great. but can be display the total no > of Value in one time. for eg. in th

Re: $$Excel-Macros$$ Need your help !!!

2012-06-20 Thread Mohit Sharma
Hi Noorain sir, your method is simply great. but can be display the total no of Value in one time. for eg. in this sheet every value like ABZ,XYZ,PQR are repeated three times. so can be display total of ABZ or XYZ or PQR in answer column with the help of VLookup On Tue, Jun 19, 2012 at 10:49 PM,

Re: $$Excel-Macros$$ Need your help !!!

2012-06-19 Thread Mangesh Vimay
Thanks Noorain Bhai, On Tue, Jun 19, 2012 at 9:08 PM, NOORAIN ANSARI wrote: > see attached sheet > > > On Tue, Jun 19, 2012 at 9:06 PM, NOORAIN ANSARI > wrote: > >> Dear Mangesh, >> >> Please try it.. >> >> =VLOOKUP($H9,IF($A$2:$A$10=$H$7,$B$2:$E$10,0),MATCH(I$8,$B$1:$E$1,0),0) >> with ctrl+Shif

Re: $$Excel-Macros$$ Need your help !!!

2012-06-19 Thread NOORAIN ANSARI
see attached sheet On Tue, Jun 19, 2012 at 9:06 PM, NOORAIN ANSARI wrote: > Dear Mangesh, > > Please try it.. > > =VLOOKUP($H9,IF($A$2:$A$10=$H$7,$B$2:$E$10,0),MATCH(I$8,$B$1:$E$1,0),0) > with ctrl+Shift+enter > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacrowor

Re: $$Excel-Macros$$ Need your help !!!

2012-06-19 Thread NOORAIN ANSARI
Dear Mangesh, Please try it.. =VLOOKUP($H9,IF($A$2:$A$10=$H$7,$B$2:$E$10,0),MATCH(I$8,$B$1:$E$1,0),0) with ctrl+Shift+enter -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, Jun 19, 2012 at 8:59 PM, Mangesh Vimay wrote: > Hi Friends, In above

Re: $$Excel-Macros$$ Need Your Help

2012-04-29 Thread dguillett1
Nicely done...!! Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: ╰» ℓαℓιт мσαнη Sent: Sunday, April 29, 2012 12:27 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need Your Help Hi karthik PFA Regards, Lalit Mohan On Sun, Apr 29

Re: $$Excel-Macros$$ Need Your Help

2012-04-29 Thread ╰» ℓαℓιт мσαнη
*Hi karthik* * * *PFA* * * *Regards,* *Lalit Mohan* On Sun, Apr 29, 2012 at 10:56 PM, ╰» ℓαℓιт мσαнη wrote: > *Hi karthik* > * > * > *PFA* > > *Regards,* > *Lalit Mohan* > > > > On Sun, Apr 29, 2012 at 1:38 PM, karthik N wrote: > >> Hi friends, >> >> Find the attachment of company address,how

Re: $$Excel-Macros$$ Need Your Help

2012-04-29 Thread ╰» ℓαℓιт мσαнη
*Hi karthik* * * *PFA* *Regards,* *Lalit Mohan* On Sun, Apr 29, 2012 at 1:38 PM, karthik N wrote: > Hi friends, > > Find the attachment of company address,how to spreat'up the colomn wise > data > > Sample data is attached. > > > Regards > karthik.N > > -- > FORUM RULES (986+ members already

Re: $$Excel-Macros$$ Need your help in Vlookup formula.....

2011-08-20 Thread rajan verma
_Verma wrote: >> >>> Thanks and Welcome >>> >>> >>> -Original Message- >>> From: excel-macros@googlegroups.com [mailto: >>> excel-macros@googlegroups.com] >>> On Behalf Of Lawali >>> Sent: Friday, August 19, 2011 7:

Re: $$Excel-Macros$$ Need your help in Vlookup formula.....

2011-08-20 Thread Indrajit $nai
.com [mailto:excel-macros@googlegroups.com] > On Behalf Of Lawali > Sent: Friday, August 19, 2011 7:57 PM > To: MS EXCEL AND VBA MACROS > Subject: Re: $$Excel-Macros$$ Need your help in Vlookup formula. > > Rajan, > Your solution is awesome!!! > > On Aug 19, 9:39 am, "Rajan_

Re: $$Excel-Macros$$ Need your help in Vlookup formula.....

2011-08-19 Thread Indrajit $nai
ay, August 19, 2011 7:57 PM > To: MS EXCEL AND VBA MACROS > Subject: Re: $$Excel-Macros$$ Need your help in Vlookup formula. > > Rajan, > Your solution is awesome!!! > > On Aug 19, 9:39 am, "Rajan_Verma" wrote: > > You Can Tri this : > > > > Pri

RE: $$Excel-Macros$$ Need your help in Vlookup formula.....

2011-08-19 Thread Rajan_Verma
Thanks and Welcome -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Lawali Sent: Friday, August 19, 2011 7:57 PM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ Need your help in Vlookup formula. Rajan, Your

Re: $$Excel-Macros$$ Need your help in Vlookup formula.....

2011-08-19 Thread Lawali
Range("F9").Offset(0, k).Value = Range("A" & i).Offset(0, > 1).Value > >             k = k + 1 > >         End If > >     Next > > End If > > Err: > > Application.EnableEvents = True > > End Sub > > From: excel-macros@google

Re: $$Excel-Macros$$ Need your help in Vlookup formula.....

2011-08-18 Thread XLS S
Hey Inderjit, please find the attachment... On Fri, Aug 19, 2011 at 1:02 AM, Indrajit $nai wrote: > Hi All, > I need your small help in Vlookup formula. I have attached a file with this > mail, where you can see  2 columns in the left. One is Qty. another is Sr. > no. > Now I want to search Sr.

Re: $$Excel-Macros$$ Need your help in Vlookup formula.....

2011-08-18 Thread NOORAIN ANSARI
Dear indajit, Please see attached sheet.. On Fri, Aug 19, 2011 at 1:02 AM, Indrajit $nai wrote: > Hi All, > > I need your small help in Vlookup formula. I have attached a file with this > mail, where you can see 2 columns in the left. One is Qty. another is Sr. > no. > Now I want to search Sr.

Re: $$Excel-Macros$$ Need your help in Vlookup formula.....

2011-08-18 Thread ashish koul
try this On Fri, Aug 19, 2011 at 1:02 AM, Indrajit $nai wrote: > Hi All, > > I need your small help in Vlookup formula. I have attached a file with this > mail, where you can see 2 columns in the left. One is Qty. another is Sr. > no. > Now I want to search Sr. no. through Qty. Suppose if I put

Re: $$Excel-Macros$$ need your help on Validation

2010-12-14 Thread ashish koul
check this link http://www.contextures.com/xldataval13.html#Create On Tue, Dec 14, 2010 at 11:32 AM, lucky singh wrote: > > Hi All, > > need your help on validation > > if i select softdiet then only the menu of soft diet should be shown in > dropdown & not hard diet similarly to hard diet on h

Re: $$Excel-Macros$$ need your help

2010-02-11 Thread Abhishek Jain
Hi Shammi, I am not sure if I have understood your query correctly. This is what I have done: > On the basis of the total score, the Band in the range G11 to H15 will be highlighted with blue color. > The amount of proposed growth on the basis of percentage relevant to to Band # would be reflecte