Re: $$Excel-Macros$$ EXCELLENT MIND READING

Hi, Someone Noted how it works ? On Sat, Sep 1, 2012 at 12:58 PM, Sarika Parab wrote: > > >> EXCELLENT MIND READING >> >> *This will drive you up the wall!!* >> >> *CLICK ON HOUSE**[image: Description: >> cid:1.3658108220@web125205.mail.ne1.yahoo.com]*

Re: $$Excel-Macros$$ EXCELLENT MIND READING

Excellent Regards, Lalit Mohan On Sat, Sep 1, 2012 at 7:22 PM, Kuldeep Singh wrote: > > Woh!! > > Regards, > Kuldeep Singh > > > On Sat, Sep 1, 2012 at 10:48 PM, Rajan_Verma wrote: > >> * * >> >> *Ok* >> >> * I was choosing wrong color **J*** >> >> * * >> >> * * >> >> *Regards* >> >> *Rajan ver

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012

Congrats Mr. expert Regards, Lalit Mohan On Sun, Sep 2, 2012 at 7:58 AM, vijayajith VA wrote: > Congrats noorain Brother.. > > > On Sun, Sep 2, 2012 at 11:22 AM, rao wrote: > >> Congrats, u are the live wire of this group.please do continue the same. >> >> Cheers, >> Prabhakar

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012

Congrats noorain Brother.. On Sun, Sep 2, 2012 at 11:22 AM, rao wrote: > Congrats, u are the live wire of this group.please do continue the same. > > Cheers, > Prabhakar > > > On Sun, Sep 2, 2012 at 10:44 AM, wrote: > >> ** >> Congrats Noorain.. >> >> Rgds >> Vaibhav >>

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012

Congrats, u are the live wire of this group.please do continue the same. Cheers, Prabhakar On Sun, Sep 2, 2012 at 10:44 AM, wrote: > ** > Congrats Noorain.. > > Rgds > Vaibhav > -- > *From: * Ayush Jain > *Sender: * excel-macros@googlegroups.com > *Date: *Sun, 2 Sep

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012

Congrats Noorain.. Rgds Vaibhav -Original Message- From: Ayush Jain Sender: excel-macros@googlegroups.com Date: Sun, 2 Sep 2012 10:32:31 To: excel-macros Reply-To: excel-macros@googlegroups.com Cc: NOORAIN ANSARI Subject: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012

Re: $$Excel-Macros$$ Macro to Calculate a total upon a condition

Paul, Thanks for the help as usual. It's the one I expected. dguillett, Thank you for the solution and advice. I'm not very good in VB, therefore my programme may inefficient. However I will learn the find method too. Thank you very much. Regards, Dilan On Thu, Aug 30, 2012 at 6:12 PM, Paul Sc

Re: $$Excel-Macros$$ Gathering info from MySQL Bugzilla DB into Excel using VBA (is this even possible?)

So, you removed it? Complicated or not, someone might know part of a suction or at least point me in the right direction. Thanks, Marcus On Sep 1, 2012, at 10:38 AM, yogananda muthaiah wrote: > Its too complicate No hands on experience to solve ur thread. > > On Sat, Sep 1, 2012 at 2

Re: $$Excel-Macros$$

Sheet was VERYHIDDEN by code Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com -Original Message- From: Bé Trần Văn Sent: Saturday, September 01, 2012 1:36 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Trawets I help you complete File Obse

Re: $$Excel-Macros$$ Gathering info from MySQL Bugzilla DB into Excel using VBA (is this even possible?)

Its too complicate No hands on experience to solve ur thread. On Sat, Sep 1, 2012 at 2:43 AM, Marcus Polk wrote: > If these questions have been answered elsewhere, the post is too long or > you basically do not feel like reading it, please feel free to tell me so. > I am typing it out, in h

Re: $$Excel-Macros$$ EXCELLENT MIND READING

Woh!! Regards, Kuldeep Singh On Sat, Sep 1, 2012 at 10:48 PM, Rajan_Verma wrote: > * * > > *Ok* > > * I was choosing wrong color **J*** > > * * > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@google

RE: $$Excel-Macros$$ EXCELLENT MIND READING

Ok I was choosing wrong color J Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sam Mathai Chacko Sent: 01 September 2012 10:22 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ EXCE

Re: $$Excel-Macros$$ EXCELLENT MIND READING

It cannot give a wrong result. Look a little more closely! On Sat, Sep 1, 2012 at 2:39 PM, vaibhav joshi wrote: > Hi But got it correct > > > On Sat, Sep 1, 2012 at 1:38 PM, Rajan_Verma wrote: > >> *Wrong Result **J** * >> >> * * >> >> * * >> >> *Regards* >> >> *Rajan verma* >> >> *+91 783810065

Re: $$Excel-Macros$$ Required month name & year from the full date

Hi Pravin, Please try this. =RIGHT(TEXT(A2,""),10) Regards, Kuldeep Singh On Sat, Sep 1, 2012 at 2:43 PM, Rajan_Verma wrote: > * * > > *Well, in my system date format is dd/mm/yy , when I post this formula > that is given correct result, if you want to use my formula (which returns > a

Re: $$Excel-Macros$$ Need update on the attached Macro

I think you will need to use some if’s or selectcase. Test using this Sub selectcase() Select Case ActiveCell.Column Case Is = 14: x = "column 14" Case Is = 15: x = "column 15" Case Else End Select MsgBox x End Sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com F

RE: $$Excel-Macros$$ Required month name & year from the full date

Well, in my system date format is dd/mm/yy , when I post this formula that is given correct result, if you want to use my formula (which returns an actual date ) , you just need to change your Date Format from regional setting, Regards Rajan verma +91 7838100659 [IM-Gtalk] From: e

Re: $$Excel-Macros$$ EXCELLENT MIND READING

Hi But got it correct On Sat, Sep 1, 2012 at 1:38 PM, Rajan_Verma wrote: > *Wrong Result **J** * > > * * > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Sarika Parab

Re: $$Excel-Macros$$ Required month name & year from the full date

*Thanks for the reply with solutions.* Following is my observation with the formula given by you :- So Mr.Ashish's formula is working correctly. *Doc. Date* *Mr.Rajan* *Mr.Ashish* 06.04.2012 June-2012 April-2012 06.04.2012 June-2012 April-2012 06.04.2012 June-2012 April-2012 07.04.2012 July-2

RE: $$Excel-Macros$$ EXCELLENT MIND READING

Wrong Result J Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sarika Parab Sent: 01 September 2012 12:58 To: Reshma Shelar; gauri rane; Nishant Sakpal; Ashish Shinde //Kotak /Bank; DSOUZA Snowel; ex

RE: $$Excel-Macros$$ Required month name & year from the full date

=DATEVALUE(SUBSTITUTE(A3,".","/")) Apply - date formae Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Pravin Gunjal Sent: 01 September 2012 12:58 To: excel-macros@googlegroups.com Sub

Re: $$Excel-Macros$$ Required month name & year from the full date

TEXT(DATE(RIGHT(A2,4),MID(A2,4,2),1),"-") On Sat, Sep 1, 2012 at 12:57 PM, Pravin Gunjal wrote: > Dear Friends, > > I have attached an excel file for the subject mentioned above. > > In which there is column having full date in this format : DD.MM. > out of which I required only mont

Re: $$Excel-Macros$$ Help on Formula

Thanks for Reply Problem Solved Thanks once again Regards Shrinivas On Sat, Sep 1, 2012 at 1:05 PM, Rajan_Verma wrote: > *Are you changing sheet name in E2 also?* > > * * > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > * * > > *From:* excel-macros@googlegroups.com [m

RE: $$Excel-Macros$$ Help on Formula

Are you changing sheet name in E2 also? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shrinivas Shevde Sent: 01 September 2012 1:01 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ He

Re: $$Excel-Macros$$ Help on Formula

Dear Rajan Very Very thanks for reply and its working fine.Liitle extension of problem If I name sheet as "Jan" its working if I name it as "Jan-12" then it is not working what may be the reason and what is the solution. Thanks once again. Regards Shrini On Sat, Sep 1, 2012 at 10:36 AM, Rajan_