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

2011-04-08 Thread SAJID MANSOOR 
As per my observation this is producing wrong result, please check it once
again.

On Fri, Apr 8, 2011 at 9:34 AM, §»VIPER«§  wrote:

> hi syed,
>
> find the attached without array.
>
> --
> *Thanks & Regards
>
> Thamu
> *
>
> On Fri, Apr 8, 2011 at 2:45 AM, syed aliya raza hashim <
> hashim...@gmail.com> wrote:
>
>> Hi,
>> Hi i have attached my file i want in sheet 2 there are column c in that i
>> want the name from sheet 1 but there are two condition first is match by ID
>> then match by Name as well then how can we do this
>>
>>
>>
>> --
>> syed aliya
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
>
> *
> *
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ regd: drop down button

2011-02-27 Thread SAJID MANSOOR 
Why are you using this lengthy formula?
=INDIRECT(VLOOKUP($B$15,I$2:I$6,1,0))
instead of
=INDIRECT($B$15)   (Working Fine as above one)


On Sun, Feb 27, 2011 at 10:19 PM, Dilip Pandey  wrote:

> Hi Naresh,
>
> Please check the attached file for required solution.
>
> I have used Name definition manager, data validation with V-lookup
> option to achieve the desired result.
>
> Thanks & Regards,
> DILIPandey
>
>
> On 2/25/11, naresh v  wrote:
> > Hi Experts,
> >
> > I need some help regarding drop downs.
> >
> >Please find the attached sheet for your reference.
> >
> >Please help me in this regard.
> >
> >
> >
> > Thanks and Regards,
> > Naresh V
> >
> > --
> >
> --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> > http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> > http://www.facebook.com/discussexcel
> >
>
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY, mvp
>   MBA,B.Com(Hons),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 62, India
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Creating directories

2011-02-23 Thread SAJID MANSOOR 
good

On Wed, Feb 23, 2011 at 11:13 AM, Harmeet Singh wrote:

> I Hope this will help.
>
>
> Warm Regards,
>
> Harmeet Singh
> IT Analyst
> McKinsey & Company
> http://www.facebook.com/Harmeeet
>
>
>
> On Wed, Feb 23, 2011 at 4:03 PM, ashish koul wrote:
>
>> you want to save blank excel files in the path or what
>>
>>
>> On Wed, Feb 23, 2011 at 1:13 AM, Hems  wrote:
>>
>>> Hello Experts
>>>
>>> Please find attached excel. I want to create directory, sub directory and
>>> file name as per excel columns and save the file as per the file name.
>>>
>>> Kindly let me if it is possible with the help of excel macros.
>>>
>>> Thanks in advance.
>>>
>>> Cheers...
>>>
>>>  
>>>
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>> *akoul*.*blogspot*.com 
>> *akoul*.wordpress.com 
>> My Linkedin Profile 
>>
>>
>> P Before printing, think about the environment.
>>
>>
>>  --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Formula

2011-01-17 Thread SAJID MANSOOR 
Good Formula! Please brief its logic especially about 2.

On Sun, Jan 16, 2011 at 10:27 AM, Ms-Exl-Learner .  wrote:

> Hi John,
>
> It will work in version 2003 if you refer the cell reference to part of the
> column range instead of referring it to the whole column.
>
> =LOOKUP(2,FIND(A1,Sheet2!A1:A65535),Sheet2!B1:B65535)
>
> See the attached file for detail.
>
> ---
> Ms.Exl.Learner
> ---
>
>
>
> On Sat, Jan 15, 2011 at 12:59 AM, John A. Smith wrote:
>
>> Dave,
>>
>> Why am I getting #NUM! with the formula?  (See Attached)
>>
>> Thank you.
>>
>> John
>>
>> On Fri, Jan 14, 2011 at 10:35 AM, Dave Bonallack <
>> davebonall...@hotmail.com> wrote:
>>
>>> Hi,
>>> I would like to submit the following formula as one I like.
>>> It performs a case-sensitive Vlookup, and is non-array.
>>>
>>> *=LOOKUP(2,FIND(A1,Sheet2!A:A),Sheet2!B:B)*
>>>
>>> A1 contains the lookup value
>>> Sheet2!A:A is the lookup column
>>> Sheet2!B:B is the return column
>>>
>>> I hasten to add that this formula is not my own, but is a very neat
>>> solution to a common problem.
>>>
>>> Regards - Dave.
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>  --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ how to get month Occurrence in no.

2010-12-29 Thread SAJID MANSOOR 
Really Impressive!
Let me know how this formula works

On Tue, Dec 28, 2010 at 3:43 PM, Dave Bonallack
wrote:

>  Hi,
> A shorter version would be:
> =MONTH(--(1&A1))
> This works for 3-lettered abbreviatios (eg Mar, Oct) as well as extended
> abbreviations (eg Sept) and also unabbreviated (eg June, November)
> Regards - Dave.
>
> --
> Date: Tue, 28 Dec 2010 15:34:01 +0700
> Subject: Re: $$Excel-Macros$$ how to get month Occurrence in no.
> From: villager.g...@gmail.com
> To: excel-macros@googlegroups.com
>
>
> If  the word "April" or *another month name *is type correctly in cell A1
> try this formula in B1
>
> =TEXT(DATEVALUE("1 "&A1&" 2010"),"M")
>
>
>
> On Tue, Dec 28, 2010 at 1:56 PM, Rohan Young  wrote:
>
> Hi experts,
>
> is there any formula, if i only type in cell April and the other cell
> return the value 4, remember if i type simply April not 04/01/2010 etc. etc.
>
> please provide your feedback
>
>  thanks & regards
>
> ROHAN
> 9818247278, 8860567680
>
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Amount Format

2010-12-29 Thread SAJID MANSOOR 
Good.

On Tue, Dec 28, 2010 at 7:39 PM, Daniel  wrote:

> Please, see attached file.
> Regards.
> Daniel
>
> -Message d'origine-
> De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
> De
> la part de Rajiv Kumar
> Envoyé : lundi 20 décembre 2010 15:11
> À : excel-macros@googlegroups.com
> Objet : $$Excel-Macros$$ Amount Format
>
> Dear sir how can I write excel sheet dis format 1,85,000 in excel.
>
>  It yes then please give me tips. Awating your positive replay…
>
>
>
>
> Raj
>
> --
>
> 
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip 2. Join our LinkedIN group @
> http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and
> Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Execute a macro while attaching to send

2010-11-25 Thread SAJID MANSOOR 
Note my question and resolve, Please...

I want to execute a process through Excel VBA while;
Any user is working on a Workbook he want to send the same workbook as
attachment from Excel menu (already available) and excel save this file in
temp folder of outlook before attaching, while the open workbook remain
unsaved. how can i determine through VBA when "send as attachment command"
save workbook temporarily.

Waiting for A Good solution.
Thanks.
Sajid Mansoor

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ time running

2010-11-22 Thread SAJID MANSOOR 
Very Good!

On Thu, Nov 18, 2010 at 12:55 PM, johnson john wrote:

> just try this.,
>
> Sub Y_1()
> Range("a1") = Format(Now(), "HH:MM:SS")
> Application.OnTime Now() + TimeValue("00:00:01"), "Y_1"
> End Sub
>
> Best regards.,
>
> On Thu, Nov 18, 2010 at 12:50 PM, siti Vi  wrote:
>
>> Anda belum searching di old posting milis XL-mania  ataupun belajar-excel
>> ?
>>
>>
>>
>> On 11/18/10, ratu elissa  wrote:
>> > hot to create time update per second in vba
>> >
>> > --
>> >
>> --
>> > Some important links for excel users:
>> > 1. Follow us on TWITTER for tips tricks and links :
>> > http://twitter.com/exceldailytip
>> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>> >
>> > To post to this group, send email to excel-macros@googlegroups.com
>> >
>> > <><><><><><><><><><><><><><><><><><><><><><>
>> > Like our page on facebook , Just follow below link
>> >
>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>> >
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>>
>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
>
>
> --
> Johnson Dara
> American Power Conversion
> Lavelle Road
> Bangalore 560 001
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Please help regard this question

2010-11-12 Thread SAJID MANSOOR 
Very simple! Good

On Fri, Nov 12, 2010 at 11:49 AM, NOORAIN ANSARI
wrote:

> Dear Jai...
>
> Please see attachment..
>
> =TEXT(D5-D6,"YY ")&"YEAR,  "&TEXT((D5-D6),"mm")&" MONTH,
> "&TEXT((D5-D6),"dd")&"  DAYS"
> Thanks,
> Noorain
> On Thu, Nov 11, 2010 at 9:47 PM, Jai  wrote:
>
>>   Dear  Groups
>>
>> First Cell
>>
>>  20/12/2011
>>
>>  Secound Cell
>>
>> 12/11/2010
>>
>>   Required Results
>>
>> 1 YEAR ,1 MONTH ,8 DAYS LEFT
>>
>> DEAR GROUP MEMBER PLEASE HELP ME,
>>
>> I WANT TO NEED THAT WHEN WE LESS FIRST CELL TO SECOUND CELL
>>
>>  Required Results
>>
>> 1 YEAR ,1 MONTH ,8 DAYS LEFT
>>
>>   --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>>
>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ data cleaning in excel

2010-10-27 Thread SAJID MANSOOR 
Good!

On Sun, Dec 13, 2009 at 6:01 PM, Dilip Pandey  wrote:

> Ok,  The solution is revised as per your needs. One thing the data scenario
> given by you has some conflict.  Explained below:-
>
> 11/1/09  123456  -> duplicate
> 10/19/09123456  -> original
> 12/1/09  123456  -> duplicate
> Let me know if I am correct in understanding.  Thanks.
>
> --
> DILIP KUMAR PANDEY
>MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 110062
>
>
> On 12/11/09, azim...@gmail.com  wrote:
>>
>> Thanks Dilip sir for your help. however what i am looking for is a
>> logic which will get duplicates. there are two condition for this.
>> first telephone numbers should be repeated. secondly, only those
>> entries will be duplicate where date is later one. say for example 123
>> is a telephone number which is repeated more than once, then we have
>> to mark the most earlier earlier date as original and all later dates
>> as duplicate. data here is unorganized for which earlier date may have
>> been recorded after the later date. continuing with the above example.
>>
>> 11/1/09  123456
>> 10/19/09123456
>>
>> 12/1/09  123456
>> 11/1/09  456789
>> 12/1/09  456789
>> 10/1/09  456789
>>
>> additional information: i may not be able to play with source data
>> which means and i can't sort it. we use excel 2003 version and i am
>> looking for solution in function. as i am not well versed with VBA, i
>> may not be able to reproduce it. so solution in function will help me
>> in future also.
>>
>> Regards,
>>
>> Azim
>>
>>
>> On Dec 11, 12:41 pm, Dilip Pandey  wrote:
>> > Dear Azimullah,
>> >
>> > Choose any of the below formual and paste it in third column i.e, column
>> C
>> > Row 2 onwards and you are done.
>> >
>> > =IF(SUMPRODUCT(($B$1:B2=B3)*($A$1:A20,"Duplicate","Unique")
>> > OR,
>> > =IF(COUNTIF($B$1:B1,B2)=0,"Unique","Duplicate")
>> >
>> > solved workbook is also attached.
>> >
>> > Best Regards,
>> > --
>> > DILIP KUMAR PANDEY
>> >MBA-HR,B COM(Hons.),BCA
>> > Mobile: +91 9810929744
>> > dilipan...@gmail.com
>> > dilipan...@yahoo.com
>> > New Delhi - 110062
>>
>> >
>> > On 12/10/09, azim...@gmail.com  wrote:
>> >
>> >
>> >
>> >
>> >
>> > > Hi i have market research data that i need to clean in terms of
>> > > finding out duplicate surveys. there are two criteria for this.
>> > > firstly telephone number from which it was done. if it is repeated
>> > > more han once then it means its duplicate, its the first criteria.
>> > > second criteria is date. so if there is a single phone number repeated
>> > > twice, then the earlier date/time should be original survey and later
>> > > date/time to be counted as duplicate.
>> >
>> > > example
>> >
>> > > Date   Phone number
>> > > 11/1/09   123456
>> > > 12/1/09   123456
>> > > 11/1/09   456789
>> > > 12/1/09   456789
>> >
>> > > Thanks in advance!
>> >
>> > > --
>> >
>> > >
>> ---
>> ---
>> > > Some important links for excel users:
>> > > 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>> > >http://www.excelitems.com
>> > > 2. Excel tutorials athttp://www.excel-macros.blogspot.com
>> > > 3. Learn VBA Macros athttp://www.vbamacros.blogspot.com
>> > > 4. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>>
>> >
>> > > To post to this group, send email to excel-macros@googlegroups.com
>> > > If you find any spam message in the group, please send an email to:
>> > > Ayush Jain  @ jainayus...@gmail.com or
>> > > Ashish Jain @ 26may.1...@gmail.com
>>
>> > > <><><><><><><><><><><><><><><><><><><><><><>
>> > > HELP US GROW !!
>> >
>> > > We reach over 6,500 subscribers worldwide and receive many nice notes
>> about
>> > > the learning and support from the group. Our goal is to have 10,000
>> > > subscribers by the end of 2009. Let friends and co-workers know they
>> can
>> > > subscribe to group at
>> > >http://groups.google.com/group/excel-macros/subscribe
>> >
>> >
>> >
>> >  Identifying repeated survey - By DILipandey.xls
>> > 18KViewDownload
>
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com or
> Ashish Jain @ 26may.1...@gmail.com
> <><><><><><><><><><><><><

Re: $$Excel-Macros$$ Removing or extracting lettres from List in Excel

2010-10-26 Thread SAJID MANSOOR 
I think your solution is best.

On Wed, Dec 23, 2009 at 3:18 PM, Dilip Pandey  wrote:

> Dear Gobet,
>
> Use following formula in the column B and drag it down.
>
>  =RIGHT(A2,LEN(A2)-FIND("@",A2)+1)
>
> solved workbook is also attached.  Thanks
> --
> DILIP KUMAR PANDEY
>   MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 110062
>
>
> On Tue, Dec 22, 2009 at 11:25 PM, Andre Gobet wrote:
>
>> Hello
>>
>> I've a list in Excel of about 1000 e-mail adresses from our internal
>> Database. Now i want to extract from this list only the domain names
>> to put in to our Spam Filter for Whitelisting.
>>
>> Example List in Excel
>> andre.go...@sesamnet.ch
>> g...@bluewin.ch
>>
>> Now i'd like to have a list with only the Domain Names like
>> sesamnet.ch or bluewin.ch. Are there an easy way to do this ?
>>
>> Thanks in advance
>>
>> - André
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>> http://www.excelitems.com
>> 2. Excel tutorials at http://www.excel-macros.blogspot.com
>> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
>> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>> If you find any spam message in the group, please send an email to:
>> Ayush Jain  @ jainayus...@gmail.com or
>> Ashish Jain @ 26may.1...@gmail.com
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,500 subscribers worldwide and receive many nice notes
>> about the learning and support from the group. Our goal is to have 10,000
>> subscribers by the end of 2009. Let friends and co-workers know they can
>> subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com or
> Ashish Jain @ 26may.1...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,500 subscribers worldwide and receive many nice notes about
> the learning and support from the group. Our goal is to have 10,000
> subscribers by the end of 2009. Let friends and co-workers know they can
> subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Re: help in understanding code

2010-10-22 Thread SAJID MANSOOR 
Very Good Information!

On Fri, Oct 22, 2010 at 1:33 PM, Ashish Jain <26may.1...@gmail.com> wrote:

> Hi Omar
>
> Here is line by line description of the VBA code you provided:
>
>
> Sub OMAR_QUERY()
> 'Error Handling ON: In case of error, it will skip to next line.
>On Error Resume Next
>'Error handling used specifically for this line of code.
>'If there are more than 16 worksheets, it will execute else will
> throw an error.
>'It will display the 'activate' window to activate the worksheet
> required.
>Application.CommandBars("Workbook Tabs").Controls("More
> Sheets...").Execute
>'In case of less than 16 sheets, error will be thrown and
> execution will enter in IF block.
>If Err.Number > 0 Then
>'Clear the error cache.
>Err.Clear
>'It will display a pop-up to activate the worksheet
> required.
>Application.CommandBars("Workbook Tabs").ShowPopup
>'End of If Block
>End If
>'Scroll to the first column of activated worksheet.
>ActiveWindow.ScrollColumn = 1
>'Scroll to the first row of activated worksheet.
>ActiveWindow.ScrollRow = 1
> 'Error Handling OFF
>On Error GoTo 0
> End Sub
>
>
>
> Regards
> Ashish Jain
> McKinsey India Knowledge Center
> (Microsoft Certified Application Specialist)
> (Microsoft Certified Professional)
>
>
>
>
>
> On Oct 21, 10:13 pm, عمر  wrote:
> > This code make a popup  with sheetsList
> >
> > But I don't understand how it works
> >
> > On Error Resume Next
> >
> >   Application.CommandBars("Workbook Tabs").Controls("More
> > Sheets...").Execute
> >
> >   If Err.Number > 0 Then
> >
> > Err.Clear
> >
> > Application.CommandBars("Workbook Tabs").ShowPopup
> >
> >   End If
> >
> >   ActiveWindow.ScrollColumn = 1
> >
> >   ActiveWindow.ScrollRow = 1
> >
> >   On Error GoTo 0
> >
> > Except this
> >
> > Application.CommandBars("Workbook Tabs").Controls("More
> Sheets...").Execute
> >
> >   If Err.Number > 0 Then
> >
> > Err.Clear
> >
> > Application.CommandBars("Workbook Tabs").ShowPopup
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ XLSB and XLSX related problem

2010-10-21 Thread SAJID MANSOOR 
Very Good information!

On Thu, Oct 14, 2010 at 6:30 PM, Paul Schreiner wrote:

> Do you mean to change the file associations?
>
> For that, what you do is change your own associations.
> Then go to the system registry (using run -Regedit)
> Find your .xlsx extensions, right-click and "export" the settings
> to a file (it'll put a .reg extension)
> You should get something like:
>
> [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Sheet.12\shell\Open]
> @="&Open"
> [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Sheet.12\shell\Open\command]
> @="\"C:\\Program Files\\Microsoft Office\\Office12\\EXCEL.EXE\" /e \"%1\""
> [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Sheet.12\shell\Open\ddeexec]
> @="[open(\"%1\")]"
>
> [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Sheet.12\shell\Open\ddeexec\Application]
> @="Excel"
>
> [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Sheet.12\shell\Open\ddeexec\IfExec]
> @="[Rem Comment]"
>
> [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Sheet.12\shell\Open\ddeexec\Topic]
> @="system"
>
>
> Do this again for .xlsb, .xls, .xlsm
>
> then edit the files you've created and combine them into one file.
>
> if you sent THIS file to the users, and have the execute it, the file
> will update the settings.
>
>
> hope this helps.
>
> Paul
>
>
> *From:* sudheer lolla 
> *To:* excel-macros@googlegroups.com
> *Sent:* Thu, October 14, 2010 2:00:25 AM
> *Subject:* Re: $$Excel-Macros$$ XLSB and XLSX related problem
>
> HI PAUL
>
> THANKS A LOT PAUL..IT REALLY WORKED..THAT WAS A PATIENT ANSWERFULL
> PRAISES FOR YOU
> JUST ANOTHER DOUBT..CAN THIS BE DONE THROUGH WINDOWS DOS COMMAND..I DONT
> WANT USERS TO DO ALL THIS.. ANY HOW AM RUNNING A SHELL COMMAND FROM EXCEL
> ..IS THERE ANY WAY TO DO THIS WORK ALSO..
>
> REGARDS
> L SUDHEER
>
> On Wed, Oct 13, 2010 at 7:34 PM, Paul Schreiner wrote:
>
>>  Is the XLSTART folder on a network drive?
>>
>> How are you opening "any other excel"?
>> Are you double-clicking on an excel file?
>>
>> First: a couple of definitions:
>>  when you double-click the Excel icon (not a file, but the Excel
>> application icon)
>> It opens an "instance" of Excel.
>> It's like loading the entire Excel "software" into memory (ok, not really,
>> but it's an analogy)
>>
>> If you double-click the Excel icon again, it opens a SECOND "instance".
>> If you've ever opened two excel files and tried to do a formula like
>> "=WB2!A3"
>> so that it brings the content of the A3 cell of the second workbook (WB2)
>> into the current
>> workbook, you'd find that this only works if the two workbooks are in the
>> same "instance".
>>
>> NORMALLY, when you double-click an excel file, it opens in a SHARED
>> instance.
>> That way, data can be exchanged, and Windows doesn't have the extra
>> "overhead" of having
>> the application loaded more than once.
>>
>> Now.. your configuration is "normally" set up to opan all files in the
>> xlstart folder whenever
>> you open an INSTANCE of Excel.
>> That means that if Excel is not open, and you double-click on any Excel
>> file, it opens that file,
>> but then opens all files in the XLstart folder.
>>
>> But if your Windows setup is designed to open SEPARATE instances when you
>> open
>> workbooks, then the files in XLstart will open IN EACH INSTANCE.
>>
>> When you open a second file, since the files in the XLstart folder were
>> already opened in the
>> FIRST instance, it will notify you that you're opening them as Read-Only
>> in the second instance.
>>
>> So.. I THINK your problem is actually that your Windows setup is opening
>> Excel in separate instances.
>>
>> To fix that,
>> Open "My Computer" (or Windows Explorer)
>> Go to Tools->Folder Options
>> and select the File Types tab.
>>
>> Go to the .XLSB extension and click the "Advanced" button.
>>
>> select "Open" and the "Edit" button.
>>
>> Your application should read:
>> "C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e "%1"
>>  the "Use DDE" checkbox should be SELECTED.
>> DDE Message:
>> [Open("%1")]
>>
>> then, here's something that I discovered several months ago.
>> It seems that the %1 in the Application box, and the %1 in the DDE Message
>> box causes the file to be opened TWICE!
>> (I found it in opening some LARGE files with EXTENSIVE macros)
>>
>> the trick I found is that you need to make an entry in the
>> DDE Application Not Running box:
>> [Rem Comment]
>>
>> this is a non-executable comment, so it doesn't DO anything, but evidently
>> it makes it work properly...
>>
>> You'll need to change these settings for .XLS, .XLSX, .XLSM
>>
>> hope this helps,
>>
>> Paul
>>
>>
>> *From:* sudheer lolla 
>> *To:* MS EXCEL AND VBA MACROS 
>> *Sent:* Wed, October 13, 2010 7:18:46 AM
>> *Subject:* $$Excel-Macros$$ XLSB and XLSX related problem
>>
>> Hi
>>
>> This is a very peculiar problem which am facing
>>
>> i have an *xlsb* which has some macros and is placed in *XLSTART* folder
>>
>> when an excel is opened the *XLSB* is attached to the *XLSX* file
>>
>> i*am saying attached because when any

Re: $$Excel-Macros$$ GNATT CHART

2010-07-06 Thread SAJID MANSOOR 
Very Good!

On Tue, Jul 6, 2010 at 1:19 PM, Intelligent But Crazy
wrote:

> Hi Zaf
>
> PFA the gantt chart
>
> Thanks
> SecretShot
>
> On 7/6/10, zafnu  wrote:
> > Hi,
> > Can u please help me to create a '*Gnatt Chart*' in excel. your immediate
> > action is highly appreciated.
> >
> > Thanks & regards
> > Zafnim backer.
> >
> > --
> >
> --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> > http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
> >
> > We reach over 7000 subscribers worldwide and receive many nice notes
> about
> > the learning and support from the group.Let friends and co-workers know
> they
> > can subscribe to group at
> > http://groups.google.com/group/excel-macros/subscribe
> >
>
>
> --
> Pankaj Pandey
> Bhopal
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Hi, need your help - urgent

2010-07-06 Thread SAJID MANSOOR 
Good!
But instead of copy paste we can use bring to front by keeping all images on
same position.

On Thu, Jul 1, 2010 at 7:38 PM, ashish koul  wrote:

> hi
>
>
> Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
> Boolean)
>
>
> If ActiveCell.Row = 2 And ActiveCell.Column = 1 Then
>
> Call deletshape
>
>
>
>  Sheets("Sheet1").Select
> Range("E9").Select
> Selection.Delete
>
>  Sheets(2).Shapes(1).Copy
> Sheets("Sheet1").Select
> Range("E9").Select
> ActiveSheet.Paste
>
>
> ElseIf ActiveCell.Row = 3 And ActiveCell.Column = 1 Then
> Call deletshape
>  Sheets(2).Shapes(2).Copy
> Sheets("Sheet1").Select
> Range("E9").Select
> ActiveSheet.Paste
>
>
> ElseIf ActiveCell.Row = 4 And ActiveCell.Column = 1 Then
> Call deletshape
>
>  Sheets(2).Shapes(3).Copy
> Sheets("Sheet1").Select
> Range("E9").Select
> ActiveSheet.Paste
>
>
> ElseIf ActiveCell.Row = 5 And ActiveCell.Column = 1 Then
> Call deletshape
>
>  Sheets(2).Shapes(4).Copy
> Sheets("Sheet1").Select
> Range("E9").Select
> ActiveSheet.Paste
>
> End If
>
> End Sub
>
> Sub deletshape()
> Dim sh As Shape
>
>
>For Each sh In Sheets(1).Shapes
>
>  If sh.Type = msoPicture Then
>   sh.Delete
>End If
> Next sh
>
> End Sub
>
>
> ashish koul
>
> akoul.blogspot.com
>
>
>
> On Thu, Jul 1, 2010 at 5:44 PM, Rajender Soni wrote:
>
>> Hi
>>
>> Pls find attached the excel file, I just want that when I move my mouse
>> cursor over a cell, the image having the name equal to cell's value will get
>> displayed, pls open the attached excel file for more clarification.
>>
>> Regards
>> Rajender Soni
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 7000 subscribers worldwide and receive many nice notes about
>> the learning and support from the group.Let friends and co-workers know they
>> can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Fwd:

2010-07-06 Thread SAJID MANSOOR 
Very Good!

On Sat, Jul 3, 2010 at 2:15 PM, ashish koul  wrote:

> Thanks a lot Dave.
>
>
>
> On Sat, Jul 3, 2010 at 2:22 PM, Dave Bonallack 
> wrote:
>
>>  Hi,
>> A1 = *United States of America*
>>
>> =FIND(CHAR(1),SUBSTITUTE(A1," ",CHAR(1),LEN(TRIM(A1))-LEN(SUBSTITUTE(A1,"
>> ",""
>>  Firstly, we need to find out how many spaces there are in the text. We do
>> this by finding the text length of the original text, *Len(TRIM(A1))*then 
>> the text length of the text with all the spaces removed
>> *LEN(SUBSTITUTE(A1," ",""))*. Then find the difference 
>> *LEN(TRIM(A1))*-*LEN(SUBSTITUTE(A1,"
>> ",""))*. In our case, 3. So the last instance of the space character is
>> the 3rd one.
>> The SUBSTITUTE function takes 4 arguements. 1: The original text, 2: text
>> string you don't want, 3: text string you want instead, and 4: the optional
>> arguement of what instance. So in our case, we want to replace the 3rd
>> instance of the space character with something (anything) unique; for this,
>> we use CHAR(1) (whatever that is). *SUBSTITUTE(A1," ",CHAR(1),3)*
>> So replacing the 3rd instance of the space character with Char(1) we get
>> *United States ofCHAR(1)America*
>> Now we just use the FIND function to return the position of the CHAR(1)
>> character.
>>
>> Cool Huh!
>>
>> Regards - Dave.
>>
>>
>> **
>> **
>>
>> --
>> Date: Sat, 3 Jul 2010 10:52:12 +0530
>> Subject: Re: $$Excel-Macros$$ Fwd:
>> From: koul.ash...@gmail.com
>>
>> To: excel-macros@googlegroups.com
>>
>> hi dave
>>
>> can you explain the formula  how it is working
>>
>> =FIND(CHAR(1),SUBSTITUTE(A1," ",CHAR(1),LEN(TRIM(A1))-LEN(
>> SUBSTITUTE(A1," ",""
>>
>>
>> On Fri, Jul 2, 2010 at 10:29 PM, praveen kumar wrote:
>>
>> Here with have attached one pdf file. from that if i copy paste data
>> to excel then it will show country name & numbers together like this
>>
>> 1 United States 14,093,310
>>
>> 2 China 7,909,261
>>
>>  I want to seprate this country names & numbers here. If have found
>> out the position of the space from the right can use mid & other
>> formula to get the numbers separately.
>>
>> I hope this will makes you clear about my objective.
>>
>> Also let me if there is any other way to do the same.
>>
>> Thanks in advance
>>
>> On Fri, Jul 2, 2010 at 9:38 PM, krishna mummina 
>> wrote:
>> > Hi praveen,
>> >
>> > we can find the position and could you please tell me why you need it.
>> >
>> > Bye
>> >
>> > On 7/2/10, praveen kumar  wrote:
>> >> Hi Friends,
>> >>
>> >> Is there any way to find the position of the space in a word from right
>> >> side.
>> >>
>> >> Ex: United States of America - here the position of the space from
>> >> right side is 8.
>> >>
>> >>
>> >> --
>> >>
>> >> Regards,
>> >> praveen
>> >>
>> >> --
>> >>
>> --
>> >> Some important links for excel users:
>> >> 1. Follow us on TWITTER for tips tricks and links :
>> >> http://twitter.com/exceldailytip
>> >> 2. Join our LinkedIN group @
>> http://www.linkedin.com/groups?gid=1871310
>> >> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>> >>
>> >> To post to this group, send email to excel-macros@googlegroups.com
>> >>
>> >> <><><><><><><><><><><><><><><><><><><><><><>
>> >> HELP US GROW !!
>> >>
>> >> We reach over 7000 subscribers worldwide and receive many nice notes
>> about
>> >> the learning and support from the group.Let friends and co-workers know
>> they
>> >> can subscribe to group at
>> >> http://groups.google.com/group/excel-macros/subscribe
>> >>
>> >
>> > --
>> >
>> --
>> > Some important links for excel users:
>> > 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>> >
>> > To post to this group, send email to excel-macros@googlegroups.com
>> >
>> > <><><><><><><><><><><><><><><><><><><><><><>
>> > HELP US GROW !!
>> >
>> > We reach over 7000 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>> >
>>
>>
>>
>> --
>>
>>
>>
>> Regards,
>> praveen
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Exc

Re: $$Excel-Macros$$ Problem in list box when using refedit control

2010-07-06 Thread SAJID MANSOOR 
it's not working...

On Sun, Jul 4, 2010 at 3:03 PM, ayush jain  wrote:

> Hi Neil,
>
> As there are multiple items in a range, You need to use FOR EACH statement
> to add items of range one by one in listbox.
> Attached is the solution for your reference.
>
> I hope it helps. Please let me know if any further assistance is required.
>
>
> Best Regards,
> Ayush Jain
> Group Manager.
>
>
>
>
>
> On Sun, Jul 4, 2010 at 1:24 PM, neil johnson wrote:
>
>> Hi Everyone
>>
>> I make user form , and i reterive cell range through refedit contorl .
>> when i select the range in refedit control and it show single range value
>> in listbox
>> MY *problem is that when i select more range it show error in list box.*
>> *Can you sort out that prolblem as soon as possible.* I need to select
>> the range("A1:B11"). And should be shown in list box . How it can be
>> possible
>> Please find the attachment sheet .
>>
>>
>> Thanks and Regards
>>
>>  --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 7000 subscribers worldwide and receive many nice notes about
>> the learning and support from the group.Let friends and co-workers know they
>> can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
>
>
> --
> Best regards,
> Ayush Jain
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Running Count for particular data

2010-07-05 Thread SAJID MANSOOR 
Good!

On Tue, Jul 6, 2010 at 8:55 AM, WizExcel  wrote:

> This is just too good Ayush ,
> thanks for the explanation.
>
>
> On Jul 5, 8:16 pm, Ayush  wrote:
> > Thanks Ankit.
> > As the running count was required, The formula should have running
> > range. I have used Row f(x) to return the current row number and used
> > the indirect f(x) to convert the test string into range.
> > The two functions returns the running range and countif formula is
> > used to count the values in running range.
> >
> > Example:-
> >
> > A2 cell will refer to range A2:A2 for counting
> > A3 cell will refer to range A2:A3 for counting
> > A4 cell will refer to range A2:A4 for counting
> > and so on...
> >
> > I hope this helps.
> >
> > Best regards,
> > Ayush Jain
> > Group Manager.
> >
> > On Jul 5, 7:52 pm, Ankit Agarwal  wrote:
> >
> >
> >
> > > Hi Ayush,
> >
> > > This formula is perfect. I would appreciate if you would pls. explain
> it.
> >
> > > Thanks,
> > > Ankit
> >
> > > On Mon, Jul 5, 2010 at 7:56 PM, ayush jain 
> wrote:
> > > > Hi Wizexcel,
> >
> > > > Attached is the solution. You have to use the combination of countif,
> > > > indirect and row function.
> >
> > > > The formula is :- *=COUNTIF(INDIRECT("$A$2:$A$" & ROW(A2)),A2)*
> >
> > > > Please let us know if any further assistance is required.
> >
> > > > Best regards,
> > > > Ayush Jain
> > > > Group Manager
> >
> > > > On Mon, Jul 5, 2010 at 5:49 PM, WizExcel  wrote:
> >
> > > >> Dear Experts,
> >
> > > >> want to know if there is way / function for having a "running" count
> > > >> in Excel. I have tried COUNTIF and most of the Count Functions , but
> > > >> all give "total" count and not the "Running" Count.
> >
> > > >> Example: See below.
> >
> > > >> The Count for HDFC Bank should be 1, 2 . and then finally 3. and
> > > >> then similarly for other Banks. What the CountIF function shows is
> the
> > > >> TOTAL count.
> >
> > > >>  How it is happening now using CountIF:
> >
> > > >> BankCount
> > > >> HFDC Bank 3
> > > >> SBI Bank2
> > > >> SBI Bank2
> > > >> HDFC Bank 3
> > > >> Axis Bank   1
> > > >> HDFC Bank 3
> >
> > > >> How  I want it :
> >
> > > >> BankCount
> > > >> HFDC Bank 1
> > > >> SBI Bank1
> > > >> SBI Bank2
> > > >> HDFC Bank 2
> > > >> Axis Bank   1
> > > >> HDFC Bank 3
> >
> > > >> --
> >
> > > >>
> ---­---
> > > >> Some important links for excel users:
> > > >> 1. Follow us on TWITTER for tips tricks and links :
> > > >>http://twitter.com/exceldailytip
> > > >> 2. Join our LinkedIN group @
> http://www.linkedin.com/groups?gid=1871310
> > > >> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > > >> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > > >> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
> >
> > > >> To post to this group, send email to excel-macros@googlegroups.com
> >
> > > >> <><><><><><><><><><><><><><><><><><><><><><>
> > > >> HELP US GROW !!
> >
> > > >> We reach over 7000 subscribers worldwide and receive many nice notes
> about
> > > >> the learning and support from the group.Let friends and co-workers
> know they
> > > >> can subscribe to group at
> > > >>http://groups.google.com/group/excel-macros/subscribe
> >
> > > > --
> > > > Best regards,
> > > > Ayush Jain
> >
> > > >  --
> >
> > > >
> ---­---
> > > > Some important links for excel users:
> > > > 1. Follow us on TWITTER for tips tricks and links :
> > > >http://twitter.com/exceldailytip
> > > > 2. Join our LinkedIN group @
> http://www.linkedin.com/groups?gid=1871310
> > > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
> >
> > > > To post to this group, send email to excel-macros@googlegroups.com
> >
> > > > <><><><><><><><><><><><><><><><><><><><><><>
> > > > HELP US GROW !!
> >
> > > > We reach over 7000 subscribers worldwide and receive many nice notes
> about
> > > > the learning and support from the group.Let friends and co-workers
> know they
> > > > can subscribe to group at
> > > >http://groups.google.com/group/excel-macros/subscribe- Hide quoted
> text -
> >
> > - Show quoted text -
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/gr

$$Excel-Macros$$ EXCEL count in multiple sheets with criteria

2010-01-06 Thread SAJID MANSOOR 
Please help me in attached sheet.

i have 5 sheets, sheet1 to sheet5 each sheet contain 97%, 98%, 99%, 58%,
100% of recovery in Cell a respectively.
Now i want to cot count only those recoveries which are above to 97%.

Urgent Please.
-- 
--
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe