Re: $$Excel-Macros$$ Excel learning Institute

2011-11-24 Thread jmothilal
THANKS SO MUCH J.MOTHILAL On Fri, Nov 25, 2011 at 11:46 AM, NOORAIN ANSARI wrote: > Dear Group, > > Please find attached some tips to learn Excel. > > - > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/* > *http://noorain-ansari.b

$$Excel-Macros$$ Advanced Excel Formula's

2011-11-24 Thread Jayaprakash S
Dear Noorain, Good Morning... First of all... i would like to "Thank You" for your timely help & valuable Advise !!! Just a small suggetion... As previously mentioned by the members that most of us are un-familiar with these advanced formula's and finding it bit difficult to understand the techn

Re: $$Excel-Macros$$ Excel learning Institute

2011-11-24 Thread jmothilal
sir , select read only , see the files On Thu, Nov 24, 2011 at 9:39 PM, SAGAR KASANGOTTUWAR < sagarkasangottu...@gmail.com> wrote: > Dear, > > I need password for those files. > > Thanks. > Sagar > > > On Thu, Nov 24, 2011 at 4:50 PM, Surbhi Agarwal < > surbhi.agarwal0...@gmail.com> wrote: > >>

Re: $$Excel-Macros$$ Excel learning Institute

2011-11-24 Thread jmothilal
Sir , if possible send me also, Thanks in advance. Mothilal.j On Fri, Nov 25, 2011 at 10:58 AM, smitha.kumari wrote: > Hi Noorain, > > ** ** > > Expecting the Training material at the earliest. > > ** ** > > Regards > > Smitha > > *From:* smitha.kumari [mailto:smitha.kum...@spe

Re: $$Excel-Macros$$ Convert text to date using formula...

2011-11-24 Thread krishnanm2006
Sundarvelan thanks for your response.. As per my question I need a FORMULA that converts text to date.. Sent on my BlackBerry® from Vodafone -Original Message- From: Sundarvelan N Sender: excel-macros@googlegroups.com Date: Fri, 25 Nov 2011 11:21:27 To: Reply-To: excel-macros@googleg

Re: $$Excel-Macros$$ Convert text to date using formula...

2011-11-24 Thread krishnanm2006
Awesome... Thanks buddy :) Sent on my BlackBerry® from Vodafone -Original Message- From: NOORAIN ANSARI Sender: excel-macros@googlegroups.com Date: Fri, 25 Nov 2011 11:21:04 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Convert text to date using formula...

Re: $$Excel-Macros$$ Convert text to date using formula...

2011-11-24 Thread Sundarvelan N
Hi, Just convert the cell to date format Thanks N.Sundarvelan 9600160150 On Fri, Nov 25, 2011 at 11:18 AM, wrote: > All, > > Is there a formula which converts text to date? > > PFA the sample file which I am trying to convert.. > > Thanks in advance > > Best regards! > > -- > FORUM RULES (934

Re: $$Excel-Macros$$ Convert text to date using formula...

2011-11-24 Thread NOORAIN ANSARI
Dear Krishnann, Press Ctrl+shift+# or use =TEXT(VLOOKUP(A6,A1:B4,2,0),"dd/mm/") On Fri, Nov 25, 2011 at 11:18 AM, wrote: > All, > > Is there a formula which converts text to date? > > PFA the sample file which I am trying to convert.. > > Thanks in advance > > Best regards! > > -- > FORUM

Re: $$Excel-Macros$$ Excel learning Institute

2011-11-24 Thread jmothilal
Pls send the that training material for me. Thanks sir. On Fri, Nov 25, 2011 at 11:02 AM, wrote: > Hi Noorian- appreciate if you can send it to the entire group... It will > be very helpful.. > > Thanks in advance > > Warm Regards! > Sent on my BlackBerry® from Vodafone >

$$Excel-Macros$$ Convert text to date using formula...

2011-11-24 Thread krishnanm2006
All, Is there a formula which converts text to date? PFA the sample file which I am trying to convert.. Thanks in advance Best regards! -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Hel

Re: $$Excel-Macros$$ Excel learning Institute

2011-11-24 Thread SAGAR KASANGOTTUWAR
Dear, I need password for those files. Thanks. Sagar On Thu, Nov 24, 2011 at 4:50 PM, Surbhi Agarwal < surbhi.agarwal0...@gmail.com> wrote: > Hi, > > These files need password. Please tell me the password. > > Thanx > Surbhi > > On Thu, Nov 24, 2011 at 4:18 PM, jmothilal wrote: > >> Herewith i

RE: $$Excel-Macros$$ Excel learning Institute

2011-11-24 Thread Amit Desai (MERU)
Can u please forward this file in zip format? From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Surbhi Agarwal Sent: 24 November 2011 16:51 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel learning Institute Hi, These files need password

Re: $$Excel-Macros$$ Excel learning Institute

2011-11-24 Thread krishnanm2006
Hi Noorian- appreciate if you can send it to the entire group... It will be very helpful.. Thanks in advance Warm Regards! Sent on my BlackBerry® from Vodafone -Original Message- From: "smitha.kumari" Sender: excel-macros@googlegroups.com Date: Fri, 25 Nov 2011 10:58:29 To: Reply-To:

RE: $$Excel-Macros$$ Excel learning Institute

2011-11-24 Thread smitha.kumari
Hi Noorain, Expecting the Training material at the earliest. Regards Smitha From: smitha.kumari [mailto:smitha.kum...@speridian.com] Sent: Thursday, November 24, 2011 1:32 PM To: 'NOORAIN ANSARI' Subject: RE: $$Excel-Macros$$ Excel learning Institute Thanks a lot Noorain. My mail

$$Excel-Macros$$ Job

2011-11-24 Thread ashish koul
*Recruiter: *ut...@ecsindia.co.in *Dear Candidate,* I have your old profile in my Database. Here with this mail, I would like to inform you that at present we have opening with Top MNCs in Gurgaon (NCR Delhi) for the position of Assistant Manager and Manager. We are looking for candidates who is

Re: $$Excel-Macros$$ JOB

2011-11-24 Thread Bé Trần Văn
2011/11/24 ashish koul > *Recruiter : j...@colosseumconsulting.co.in* > * > * > * > * > *E**xperience required for the Job:* 1 - 5 years > *Annual Salary of the Job:* 3.0 - 5.0 Lacs > *Job Location:* Delhi/NCR > > *Dear Candidate,* > > Dear Candidate, > > Colosseum, an Executive Search & Recrui

Re: $$Excel-Macros$$ exls

2011-11-24 Thread Bé Trần Văn
2011/11/24 jmothilal > Thanks for sending shortcut keys. > > Mothilal > > > On Thu, Nov 24, 2011 at 2:17 PM, mangesh bavalekar > wrote: > >> >> -- >> FORUM RULES (934+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urg

Re: $$Excel-Macros$$ Urgent opening for MIS data analytics

2011-11-24 Thread Bé Trần Văn
2011/11/24 Gyana Ranjan Das > > From: Impetus HR Consultants Private Limited > > > > > The sender of this email is registered with Naukri.com as Impetus HR > Consultants Private Limited > > *Experience required for the Job:* 3 - 6 years > *Job Location:* Delhi/NCR > > *Dear Candidate,* > > De

Re: $$Excel-Macros$$ Excel learning Institute

2011-11-24 Thread Bé Trần Văn
2011/11/24 Surbhi Agarwal > Hi, > > These files need password. Please tell me the password. > > Thanx > Surbhi > > On Thu, Nov 24, 2011 at 4:18 PM, jmothilal wrote: > >> Herewith i attache 42 excel files. its for beginners. >> >> Thanks with >> >> Mothilal.J >> >> >> On Thu, Nov 24, 2011 at 2:3

Re: $$Excel-Macros$$ Seeking MS Access database file password

2011-11-24 Thread dguillett1
3) Don't post questions regarding breaking or bypassing any security measure. Don Guillett SalesAid Software dguille...@gmail.com From: ♥.•:*¨¨*:•.♥.•:V.Kiran Kumar :•.♥.•:*¨¨*:•.♥ Sent: Thursday, November 24, 2011 10:52 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Seeking MS

Re: $$Excel-Macros$$ Connect Access Database

2011-11-24 Thread Sam Mathai Chacko
Hi Sharma, Here's how you open a recordset after connecting with an access database through visual basic set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open "c:/mydatabase.mdb" set rs=Server.CreateObject("ADODB.recordset") rs.Open "Select * from Emp

Re: $$Excel-Macros$$ Excel learning Institute

2011-11-24 Thread Surbhi Agarwal
Hi, These files need password. Please tell me the password. Thanx Surbhi On Thu, Nov 24, 2011 at 4:18 PM, jmothilal wrote: > Herewith i attache 42 excel files. its for beginners. > > Thanks with > > Mothilal.J > > > On Thu, Nov 24, 2011 at 2:37 PM, wrote: > >> ** >> Andheri east >> >> >> Sent

Re: $$Excel-Macros$$ Excel learning Institute

2011-11-24 Thread mangesh bavalekar
thank you very much! On 24 November 2011 16:18, jmothilal wrote: > Herewith i attache 42 excel files. its for beginners. > > Thanks with > > Mothilal.J > > > On Thu, Nov 24, 2011 at 2:37 PM, wrote: > >> ** >> Andheri east >> >> >> Sent on my BlackBerry® from Vodafone >> ---

Re: $$Excel-Macros$$ exls

2011-11-24 Thread jmothilal
Thanks for sending shortcut keys. Mothilal On Thu, Nov 24, 2011 at 2:17 PM, mangesh bavalekar wrote: > > -- > FORUM RULES (934+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Prob

RE: $$Excel-Macros$$ exls

2011-11-24 Thread smitha.kumari
Really Very much helpful, Mangesh Thank a lot.. Regards Smitha From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of mangesh bavalekar Sent: Thursday, November 24, 2011 2:17 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ exls --

Re: $$Excel-Macros$$ Excel learning Institute

2011-11-24 Thread krishnanm2006
Andheri east Sent on my BlackBerry® from Vodafone -Original Message- From: mangesh bavalekar Sender: excel-macros@googlegroups.com Date: Thu, 24 Nov 2011 14:16:44 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel learning Institute where I can learn adv

Re: $$Excel-Macros$$ Excel learning Institute

2011-11-24 Thread mangesh bavalekar
where I can learn advance excel.im mumbai ? > Mangesh V. B. > -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick atten