RE: $$Excel-Macros$$ Conditional Sum or Sumproduct.

[Chandra Gupt Kumar]

Objective is to calculate Sale for the financial year 2009-10 (April 2009 -
March 2010 )for each staff no. Data are in sheet named 'DATA' in different
column. It Starts with Staff No. then Start Date, End Date, Sale Type, and
Amount (It is Sale per month during start and end period).

 

1.   For example : if we have to calculate sale made by staff no.9465
during financial Year 2009-10, we see staff no.9465 and start with
identifying April 09 sale is at Row no 8 & monthly sale were 12850.00 (cell
E8) for April to June 10. Further, from July 09 to March 10, sale were 29100
per month. So, total sale for the financial Year should come : 12850*3(
April - June 09)  +29100*9( July - March 10) =300450.00. Output required
against this staff no is 300450.00

2.   Next if we calculate for Staff no.17442 , it comes 0 (Zero).
Because last data for him is for the period 01/07/2005 to 31/10/2007. 

3.   If we proceed to calculate for Staff No.17822, output should be
118200.00 . This is calculated in following manner; he sold for 9750  per
month from 01/10/2008 to 30/09/2009 ,since we are determining only for April
09 to March 10, we will consider 9750 for 6 months i.e. April 09- September
09.  Further, sale for the period 01/10/2009 to 31/12/ is/expected to
9950.00. We again have to consider only period for April 09 to March 10, and
hence sale is :9950*6 (for October to March 10). Total sale by Staff No.
17822 is 118200.00 {(9750*6(April-Sep09 months)  +9950*6(Sept 09-March 10) =
118200.)

 

Hope it helps you to solve the crux .

 

 

Regards,

 

C.G.Kumar

AMW-2

 

From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Aindril De
Sent: Friday, October 08, 2010 11:35 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Conditional Sum or Sumproduct.

 

Hi C.G.,

 

Could you please elaborate more on what condition you would like to put in
here?

 

Regards,

Andy

On Fri, Oct 8, 2010 at 10:34 AM, C.G.Kumar 
wrote:

I am looking for conditional sum i.e. sum based on criteria. But neither
Sumproduct nor SUMIFS and Pivot serve the purpose.

Attached sample file . Hope you will be able to solve the crux.

 

 
Regards,

 

C.G.Kumar

 

 

-- 

--
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


Conditional Summation.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

RE: $$Excel-Macros$$ Extract only from number from a text string

[Chandra Gupt Kumar]

Please follow the link.

http://www.ozgrid.com/VBA/ExtractNum.htm

 

 

Hope it serve the purpose.

 

 

 

Regards,

 

C.G.Kumar

 

From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent: Monday, August 23, 2010 5:23 PM
To: excel-macros@googlegroups.com
Cc: Kal xcel
Subject: Re: $$Excel-Macros$$ Extract only from number from a text string

 

Dear Kalyan..

 

Please see attached sheet..I think your problem has been soloved.

 

Thanks,

Noorain

On Mon, Aug 23, 2010 at 3:36 PM, Kal xcel  wrote:

Dear Experts,

 

I need a help. I have a list of alpha-numeric string, (Like : Skin Fruits
Instant Fairness Fruit Bleach 14gm), all strings are not equal. I want to
extract only Numeric part (like14gm) from that string.

 

File is attached 

 

Thanks in advance

 

Kalyan 

-- 

--
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




-- 

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
 
<><><><><><><><><><><><><><><><><><><><><><>
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$$ Rupee symbol on PC

[Chandra Gupt Kumar]

Its rocking.



Regards,

C.G.Kumar

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On 
Behalf Of viju mobile
Sent: Monday, August 23, 2010 3:30 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Rupee symbol on PC

Just use this custom format..

On Sat, Aug 21, 2010 at 6:57 PM, Dilip Pandey  wrote:
> Thanks Ashish...!!
>
> Can we do the comma formatting like we can do with the dollar sign?
>
> (Rupee Symbol)1,00,000
> Below is what we can do with Dollar sign.
> $100,000
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY
>  MBA-HR,B.Com(Hons),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 62, India
>
>
> On 8/21/10, ashish koul  wrote:
>> hi all
>>
>> Find  this add in  so sharing it with all . have a look
>>
>> http://blog.foradian.com/font-with-indian-rupee-symbol-download-and-u
>> s
>>
>>
>> Regards
>>
>> Ashish Koul
>> akoul.blogspot.com
>>
>> --
>> -
>> - 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
>>
>
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY
>  MBA-HR,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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> 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
>



--
The posting are downloaded from various sites so the sender is not liable for 
any mishape or damage or anything. download and install at your own rist. This 
might be posted somewhere else in the group, hence may be repeated...




--
Ï,¸,ø¤*°'°*¤ø,--_V  I  J  ā  Y   _--,ø¤*°'°*¤ø,¸¸,Ò©

-- 
--
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$$ sending e mail based on data in column in excel

[Chandra Gupt Kumar]

Sorry to interrupt, but I found I serious lapse in the macro. That is in
case I am not online (server down etc), then I am not able to know to whom
it was sending the mail. If it is possible to display the message body and
person to whom it is sending the mail , it will be much worthy.

 

 

Regards,

 

C.G.Kumar

 

 

From: Chandra Gupt Kumar [mailto:kumar.bemlmum...@gmail.com] 
Sent: Saturday, August 21, 2010 12:32 PM
To: 'ashish koul'
Cc: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ sending e mail based on data in column in
excel

 

Dear Koul,

 

Thanks for the help extended. But, I would like if possible, the following
modification;

 

1.   Two column for message to be sent. First for b day message and
other for congratulation.

2.Whether it is possible that the macro be scheduled to run
bimonthly. 

 

 

 

 

Regards,

 

C.G.Kumar

 

From: ashish koul [mailto:koul.ash...@gmail.com] 
Sent: Saturday, August 21, 2010 11:51 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ sending e mail based on data in column in
excel

 

check the attachment see if it helps you


Regards
Ashish koul
http://akoul.blogspot.com/

On Sat, Aug 21, 2010 at 10:31 AM, Chandra Gupt Kumar
 wrote:

Could you please share how it is possible.

 

 

 

Regards,

 

C.G.Kumar

 

 

From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Vasant
Sent: Friday, August 20, 2010 1:43 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ sending e mail based on data in column in
excel

 

Yes, it is possible to do

 

Regards

Vasant

 

 

 

On 8/20/10, Chandra Gupt Kumar  wrote: 

Dear All,

 

My requirements are as follows;

 

1.   Based on date of birth (Col D), mail to be sent on particular day
to respective office for good wishes.

2.   Based on date of joining , congratulation mail to be sent if the
concerned completes 5,10,15,20,25,35,40 years of service.

 

It is possible to do so ?

 

Regards,

 

C.G.Kumar

 

-- 

--
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
<http://www.excel-macros.blogspot.com/> 
4. Learn VBA Macros at http://www.quickvba.blogspot.com
<http://www.quickvba.blogspot.com/> 
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
<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

Vasant 

-- 

--
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
c

RE: $$Excel-Macros$$ sending e mail based on data in column in excel

[Chandra Gupt Kumar]

Dear Koul,

 

Thanks for the help extended. But, I would like if possible, the following
modification;

 

1.   Two column for message to be sent. First for b day message and
other for congratulation.

2.Whether it is possible that the macro be scheduled to run
bimonthly. 

 

 

 

 

Regards,

 

C.G.Kumar

 

From: ashish koul [mailto:koul.ash...@gmail.com] 
Sent: Saturday, August 21, 2010 11:51 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ sending e mail based on data in column in
excel

 

check the attachment see if it helps you


Regards
Ashish koul
http://akoul.blogspot.com/



On Sat, Aug 21, 2010 at 10:31 AM, Chandra Gupt Kumar
 wrote:

Could you please share how it is possible.

 

 

 

Regards,

 

C.G.Kumar

 

 

From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Vasant
Sent: Friday, August 20, 2010 1:43 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ sending e mail based on data in column in
excel

 

Yes, it is possible to do

 

Regards

Vasant

 

 

 

On 8/20/10, Chandra Gupt Kumar  wrote: 

Dear All,

 

My requirements are as follows;

 

1.   Based on date of birth (Col D), mail to be sent on particular day
to respective office for good wishes.

2.   Based on date of joining , congratulation mail to be sent if the
concerned completes 5,10,15,20,25,35,40 years of service.

 

It is possible to do so ?

 

Regards,

 

C.G.Kumar

 

-- 

--
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
<http://www.excel-macros.blogspot.com/> 
4. Learn VBA Macros at http://www.quickvba.blogspot.com
<http://www.quickvba.blogspot.com/> 
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
<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

Vasant 

-- 

--
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$$ Problem New1

[Chandra Gupt Kumar]

Could you please elaborate the problem so that I may suggest a solution. 


Regards,

C.G.Kumar

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of hemant shah
Sent: Thursday, August 19, 2010 10:54 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Problem New1

Hi Team,

I need your help in the attched excel.

I have explained everything in attached sheet.

Regards
Hemant shah

--

--
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$$ sending e mail based on data in column in excel

[Chandra Gupt Kumar]

Could you please share how it is possible.

 

 

 

Regards,

 

C.G.Kumar

 

 

From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Vasant
Sent: Friday, August 20, 2010 1:43 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ sending e mail based on data in column in
excel

 

Yes, it is possible to do

 

Regards

Vasant

 

 

 

On 8/20/10, Chandra Gupt Kumar  wrote: 

Dear All,

 

My requirements are as follows;

 

1.   Based on date of birth (Col D), mail to be sent on particular day
to respective office for good wishes.

2.   Based on date of joining , congratulation mail to be sent if the
concerned completes 5,10,15,20,25,35,40 years of service.

 

It is possible to do so ?

 

Regards,

 

C.G.Kumar

 

-- 

--
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
<http://www.excel-macros.blogspot.com/> 
4. Learn VBA Macros at http://www.quickvba.blogspot.com
<http://www.quickvba.blogspot.com/> 
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
<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

Vasant 

-- 

--
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

$$Excel-Macros$$ sending e mail based on data in column in excel

[Chandra Gupt Kumar]

Dear All,

 

My requirements are as follows;

 

1.   Based on date of birth (Col D), mail to be sent on particular day
to respective office for good wishes.

2.   Based on date of joining , congratulation mail to be sent if the
concerned completes 5,10,15,20,25,35,40 years of service.

 

It is possible to do so ?

 

Regards,

 

C.G.Kumar

 

-- 
--
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$$ Etracting sales data as per desired criteria

[Chandra Gupt Kumar]

Please find attached solution.

 

 

Regards,

 

C.G.Kumar

 

From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Kal xcel
Sent: Wednesday, August 18, 2010 6:49 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Etracting sales data as per desired criteria

 

Dear Experts,

 

I am attaching a file where I have raw data of Depot, Customer group, Month
and Sales data. There are 16 types of customer group. I need depot wise
month wise & Distributor+Super stockist wise(customer group) sale data. 

 

I tried with sumifs & sumproduct formula, but it's not working properly.

 

Pivot table is not my required solution.

 

Thanks in advance

 

Kalyan

-- 

--
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$$ Pdf of Excel Macro

[Chandra Gupt Kumar]

Thanks Neil .

 

 

Regards,

 

C.G.Kumar

AMW-2

 

From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of neil johnson
Sent: Thursday, July 15, 2010 10:22 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Pdf of Excel Macro

 

Hi Everyone,

Please find the attached Pdf of Excel macro

Thanks 

-- 

--
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$$ Outlook Problem

[Chandra Gupt Kumar]

Yes.  You can schedule the time of Message. First go to message option and
then select the delivery option. Enter the date and time  after which you
want the message to be sent and save. The message will be sent after that
time and provided your outlook is connected.

 

 

Regards,

 

C.G.Kumar

 

From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Deepak Rawat
Sent: Wednesday, July 14, 2010 2:17 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Outlook Problem

 

Hi guys

 

Sorry for outlook

but i just wnat to know that is it possible to send any saved mail in
outlook at any specified time automatically.

 

Suppose i want to send any mail automatically at 10 PM, is it possible.

 

Regards,

Deepak

-- 

--
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$$ Finding a cell based on multiple criteria typed into cells

[Chandra Gupt Kumar]

Could you please attach sample sheet.


Regards,

C.G.Kumar
AMW-2

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Sach1810
Sent: Wednesday, July 14, 2010 3:12 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Finding a cell based on multiple criteria typed
into cells

Hi, I have a table of data giving different prices of different items.
Below is a sample of that data. I want to be able to type in teh
criteria (Shape Weight  Colour  condition) and then the document to show
me the price for that criteria.

Say A1 = SHAPE
B1=Weight
c1 = colour
d1 = condition

And where the table says circle its cell b3

Circle   square
Blue Red BlueRed
old new old new old new old new
Weight
0.1 £1.00   £3.00   £2.00   £4.00   £1.50   £3.50   £2.50   £4.50
0.2 £2.00   £4.00   £3.00   £5.00   £2.50   £4.50   £3.50   £5.50
0.3 £3.00   £5.00   £4.00   £6.00   £3.50   £5.50   £4.50   £6.50
0.4 £4.00   £6.00   £5.00   £7.00   £4.50   £6.50   £5.50   £7.50
0.5 £5.00   £7.00   £6.00   £8.00   £5.50   £7.50   £6.50   £8.50
0.6 £6.00   £8.00   £7.00   £9.00   £6.50   £8.50   £7.50   £9.50

Thanks

Your help will be much appreciated

Sacha David

-- 

--
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$$ Exrtact only numbers.

[Chandra Gupt Kumar]

 

Could not understand the objective. 

 

Regards,

 

C.G.Kumar

 

From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of lucky singh
Sent: Tuesday, June 29, 2010 3:36 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Exrtact only numbers.

 

 

Hi All,

 

 

1. I want to extract all the numbers

2. I want to trim only the middle name

 

Regards,

Jay S

 

-- 

--
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$$ PAID LIST TRACER

[Chandra Gupt Kumar]

Kindly attach the worksheet.

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of siva
Sent: Friday, May 28, 2010 3:38 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ PAID LIST TRACER

Dear Team,

Please help me .  I HAVE LAST YEARS STUDENT PAID LIST .
 i have NEW paid list of students NOW I WANT TO COMPARE IT THE BOTH
PAID LIST.
 AND IN THE NEW PAID LIST I HAVE TO ADD SECTION FROM THE LAST YEARS
PAID LIST
AND HIGHLIGHT THOSE ARE NOT PAID.I THINK I AM NOT VERY CLEAR BUT I
DON'T NO HOW TO EXPLAIN TO YOU ALL IF SOME ONE CAN HELP WITH THIS

I kindly request and hoping a prompt reply from Mr. Paul, DilipPandey,
Ayush, Harmeet *other members* in the group.

Please help me out.

THANKS
SIVA

-- 

--
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$$ Automatic Detail Summary

[Chandra Gupt Kumar]

If you have not received any solution yet, I would like to see the Sample
data worksheet.


-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of SLF
Sent: Monday, May 31, 2010 10:45 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Automatic Detail Summary

Hello all!

I am building a complex spreadsheet to track 2 weeks of payroll and
projects.  It needs to be a completely automatic document that can
calculate everything for itself.  All that will be entered is the
hours.

So here's my problem.  I have a simple master payroll table on one tab
that looks like this:

Project #   Employee1/1/20101/2/20101/3/2010
1/4/20101/5/2010
Kevin   5   0   5   4   2
Julie   1   5   4   6   5
Logan   2   0   4   2   0
Ryan1   0   4   3   2
John0   4   4   8   2

My boss wants to have a detailed summary sheet for each project
number.  He wants to only see the pertinent hours for said project on
that sheet.  So he wants to see only this in the detailed sheet for
project :

Project #   Employee1/1/20101/3/20101/4/2010
1/5/2010
Kevin   5   5   4   2
Logan   2   4   2   0
Ryan1   4   3   2

As far as I figure, I CANNOT do the following:
**Use a filter.  It would be easy to filter the data in place, but to
get the data to the detailed project sheet, I would have to copy and
paste.  It has to happen automatically.  There will be a person
enetering hours everyday, but we have to assume that they are not
capable of anything else.
**Use a vlookup.  As far as I am aware, a vlookup can't return a list
of mulitple occurences of the same value.

My ideas:
**Create a pivot table in the background, then somehow use a getpivot
formula to pull out only the relevant data?  Can I somehow use
getpivot to return a whole section of a pivot table instead of one
cell?  I know I can easily build the info in a pivot table...but how
do i make it automatic?  how do I get this pivoted data to simply show
up in the other sheet?

**Use an index lookup to cross reference the employee names and dates
and return the pertinent hours.  However, this would require that I
already have the list of dates relevant to the project.  (maybe from a
pivot table again?)

Thanks for reading!  Hope you have some ideas for me!

-- 

--
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$$ Saving Files - Replacing existing files - "Yes to All"

[Chandra Gupt Kumar]

Could you all please provide a macro which save each Sheet in a separate
worksheet as directed. Further, each time it updates the records the same
file unless otherwise new sheet has been added to the master workbook.

Regards,

C.G.Kumar
AMW-2

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Sing
Sent: Tuesday, December 15, 2009 9:01 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Saving Files - Replacing existing files - "Yes to
All"

Hello,

I have an excel program that creates 6 different tabs and then
attempts to save these different tabs as files in a specified folder.
If the program has already run and the files already exist in this
folder, excel says "A file named 'D:\Spectra Files\SLB-H.SPC' already
exists in this location.  Do you want to replace it?"

I can run through and say yes to every one of these files, but it
would be much more convenient to be able to say "yes to all".  So the
program would then go through and replace every file it is attempting
to save.

Does anyone have any insight into how to make this work?

Thank you in advance!

Matt

-- 

--
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

RE: $$Excel-Macros$$ Require help on a condition

[Chandra Gupt Kumar]

Dear Pooja Jee,

 

Hope the solution provided by Dave serves the purpose.

 

Regards,

 

C.G.Kumar

From: Dave Bonallack [mailto:davebonall...@hotmail.com] 
Sent: Friday, November 20, 2009 9:57 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Require help on a condition

 

Hi Pooja,
Does the attached do what you need?
Regards - Dave.
 

  _  

Date: Thu, 19 Nov 2009 13:35:28 +0530
Subject: $$Excel-Macros$$ Require help on a condition
From: vatspoojav...@gmail.com
To: excel-macros@googlegroups.com

Hi All,

I've attached a file in which, a data is mentioned with the required
solution. If any body can help me in this, it will be of great help.

-- 
Best Regards
Pooja Sharma

-- 

--
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 

  _  

With all the lastest places, searching has never been easier. Look now!
Looking   to move this
spring?

-- 

--
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

Re: $$Excel-Macros$$ Plz needful request

[Chandra Gupt Kumar]

PLZ USE V LOOKUP...

On Wed, Nov 18, 2009 at 12:48 PM, Anil Saxena wrote:

>
> Hi All
>
> Plz suggest me how to use formula like these e. g. when i written any names
> automatically put value.
>
>
>
>Anil 100 Saxena 90 Guni 80 Sonu 70 Yash 60 Thakur 50 Mathur 40
>
> --
>
> --
> 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

Re: $$Excel-Macros$$ Change date format

[Chandra Gupt Kumar]

Just run the macro or press ctrl+g,it will do the needful you required.

Regards,

C.G.kumar



On Mon, Nov 16, 2009 at 1:23 PM, Nandkumar kakvipure <
nandkumar.hindust...@gmail.com> wrote:

> Hello
> Pls change the date format and tell me solution
> me manually nahi karsakta because 4500 customer same problem
>
> Problem Yellow mark
> find attach file
>
> 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 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

Daily Dep _Solution_C.G.K.Jha.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Re: Need a function or formula

[Chandra Gupt Kumar]

DEAR POOJA ,

I FEEL IT WILL BE BETTER TO PROVIDE THE SOLUTION YOU YOU COULD EXPLAIN ME
THE EXACT FORMAT OF THE SOLUTION REQUIRED. THIS IS SO BECOZ SOMETIMES YOUR
EXTERNAL REFERENCE DOES NOT HAVE WORD "e-" or "e_"OR "E" AT ALL  , WHEREAS
ON THE OTHER OCCASSION THE SOLUTION IS 16 CHARECTER ,17 CHARECTER AND SO ON
..


IT WOULD BE OF GREAT SUPPORT IF YOU COULD SPECIFY THE SOLUTION FORMAT LIKE

THE SOLUTION STARTS WITH "e-" AVAILABLE IN EXTERNAL PO NO SUCCEDED BY THREE
ALPHABETS FOLLOWED WITH "_" AND SIX DIGIT NO ...
*

THE ABOVE IS ONLY SAMPLE.. YOU MAY EXPLAIN ACCORDING TO YOUR REQUIREMENT ..


REGARDS,


C.G.KUMAR
On Sat, Nov 7, 2009 at 8:29 PM, Pooja Sharma wrote:

>  Hi Kumar,
>
> Thanks for your kind help and support. But still when I'm trying this
> function in my database it is not showing the accurate way as it should be.
> I'm attaching the complete sheet where I've tried it with more data.
> Hope you will again resolve this.
>
> Best Regards
> Pooja Sharma
>
>
>  On Wed, Nov 4, 2009 at 1:05 AM, Pooja Sharma wrote:
>
>>
>>
>>  -- Forwarded message --
>> From: Chandra Gupt Kumar 
>> Date: Tue, Nov 3, 2009 at 11:50 AM
>> Subject: RE: $$Excel-Macros$$ Re: Need a function or formula
>> To: excel-macros@googlegroups.com
>>  Cc: vatspoojav...@gmail.com
>>
>>
>>   Dear Pooja Jee,
>>
>>
>>
>> Let me first thank you for the confidence you have showered on me.
>>
>> Further, the solution is attached for your kind consideration.
>>
>>
>>
>> Regards,
>>
>>
>>
>> Kumar
>>
>>
>>  --
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-mac...@googlegroups.com] *On Behalf Of *Pooja Sharma
>> *Sent:* Monday, November 02, 2009 11:53 PM
>>
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ Re: Need a function or formula
>>
>>
>>
>> Hi Kumar,
>>
>> Thanks for the help, but still  difficulties are there, which is mentioned
>> in the sheet itself. I think you can and will resolve these problems too.
>>
>> Regards,
>> Pooja
>>
>> On Mon, Nov 2, 2009 at 1:05 PM, Chandra Gupt Kumar <
>> kumar.bemlmum...@gmail.com> wrote:
>>
>> Dear Pooja Jee,
>>
>>
>>
>> Attached the solution. Hope it serves the purpose.
>>
>>
>>
>> Regards,
>>
>>
>>
>> Kumar
>>  --
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-mac...@googlegroups.com] *On Behalf Of *Hemant Hegde
>> *Sent:* Sunday, November 01, 2009 11:49 AM
>>
>>
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ Re: Need a function or formula
>>
>>
>>
>> Hi Pooja
>>
>>
>>
>> Pls find the attached sheet
>>
>>
>>
>>
>> Hemant Hegde
>>
>> 2009/10/31 Pooja Sharma 
>>
>> Hi All,
>>
>> I need your help in extracting some words (having defined format) from one
>> cell in another cell. Attached is a sheet where I have mentioned the case
>> and the solution I require.
>>
>> Hope you will help me.
>>
>> Best Regards
>> Pooja Sharma
>> ***
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> --
>> Best Regards
>> Pooja Sharma
>
>
> --~--~-~--~~~---~--~~
> --
>
> 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 

$$Excel-Macros$$ Re: Need a function or formula

[Chandra Gupt Kumar]

Dear Pooja Jee,

 

Let me first thank you for the confidence you have showered on me. 

Further, the solution is attached for your kind consideration. 

 

Regards,

 

Kumar

 

  _  

From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Pooja Sharma
Sent: Monday, November 02, 2009 11:53 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Need a function or formula

 

Hi Kumar,

Thanks for the help, but still two difficulties are there, which is
mentioned in the sheet itself. I think you can and will resolve these
problems too.

Regards,
Pooja

On Mon, Nov 2, 2009 at 1:05 PM, Chandra Gupt Kumar
 wrote:

Dear Pooja Jee,

 

Attached the solution. Hope it serves the purpose.

 

Regards,

 

Kumar

  _  

From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Hemant Hegde
Sent: Sunday, November 01, 2009 11:49 AM


To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Need a function or formula

 

Hi Pooja

 

Pls find the attached sheet

 


Hemant Hegde

2009/10/31 Pooja Sharma 

Hi All,

I need your help in extracting some words (having defined format) from one
cell in another cell. Attached is a sheet where I have mentioned the case
and the solution I require.

Hope you will help me.

Best Regards
Pooja Sharma
***

 

 

 

 




-- 
Best Regards
Pooja Sharma



--~--~-~--~~~---~--~~
--
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
-~--~~~~--~~--~--~---



Solution on the Data_Kumar.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Need a function or formula

[Chandra Gupt Kumar]

Dear Pooja Jee,

 

Attached the solution. Hope it serves the purpose.

 

Regards,

 

Kumar

  _  

From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Hemant Hegde
Sent: Sunday, November 01, 2009 11:49 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Need a function or formula

 

Hi Pooja

 

Pls find the attached sheet

 


Hemant Hegde



2009/10/31 Pooja Sharma 

Hi All,

I need your help in extracting some words (having defined format) from one
cell in another cell. Attached is a sheet where I have mentioned the case
and the solution I require.

Hope you will help me.

Best Regards
Pooja Sharma
***



 




--~--~-~--~~~---~--~~
--
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
-~--~~~~--~~--~--~---



Solution on the Data_Kumar.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Need a function or formula

[Chandra Gupt Kumar]

Hi Deepak,

 

You have provide good solution but when I drag the list it shows #NAME? .
Further you have used .xlfn in your formulae , may you please tell what it
is exactly and what it does.

 

Regards,

 

Kumar

 

  _  

From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Deepak Rai
Sent: Sunday, November 01, 2009 1:01 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Need a function or formula

 

Hi Pooja,

 

Please find the enclosed file with the solution.

 

Regards,

 

Deepak Rai

On Sat, Oct 31, 2009 at 9:25 PM, Pooja Sharma 
wrote:

Hi All,

I need your help in extracting some words (having defined format) from one
cell in another cell. Attached is a sheet where I have mentioned the case
and the solution I require.

Hope you will help me.

Best Regards
Pooja Sharma
***




-- 
Thanks, 

Deepak Rai



--~--~-~--~~~---~--~~
--
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
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Help with user defined function

[Chandra Gupt Kumar]

Could you please attach one example of using the function i.e. left lookup
function using the user defined function.

 

 

Regards,

 

C.G.Kumar

 

  _  

From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Paul Schreiner
Sent: Thursday, October 29, 2009 8:09 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Help with user defined function

 

The problem is with the LOCATION of your UDF.

VBA itself will look in Personal.xls and Personal.xlsb,

but the Excel worksheet is NOT.

 

If you had a sheet called "Sheet1" and another called "Sheet2",

and you wanted the cell B4 of Sheet1 to display the contents

of cell C10 of Sheet2, you couldn't use:

 =C10 in B4, because it would show you the contents of C10

in the CURRENT SHEET.

You would have to use:  =Sheet2!C10

so that Excel knows WHERE the cell is located.

 

the same thing applies to Functions.

the worksheet looks in standard Excel functions, then

in the functions defined in the CURRENT WORKBOOK.

but it doesn't automatically go looking in other workbooks.

 

What you need to do is EITHER

put the function in the workbook where you intend to use it,

or..

 

use the Function Wizard to add the formula to the cell.

the last category entry of the Function Wizard is "User Defined".

 

You'll find that the function is inserted as:

 

=PERSONAL.XLS!VLOOKNEW(.

 

Paul

 

  _  

From: Mayank 
To: excel-macros@googlegroups.com
Sent: Thursday, October 29, 2009 9:23:50 AM
Subject: $$Excel-Macros$$ Help with user defined function

Dear friends,

I HAVE FOUND THIS USER DEFINED VLOOKUP FUNCTION WHICH FIND THE RESULT FROM
LEFT SIDE. 

CAN ANYONE HELP WITH THIS USER DEFINED FUNCTION, DONT KNOW WHY THIS IS NOT
WORKING WHEN I PASTE THIS CODE IN MODULE OF MY PERSONAL WORKBOOK. IT IS
GIVING ERROR #NAME?

 

 

Function VLOOKNEW(lookup_value, table_array As Range, _

col_index_num As Integer, CloseMatch As Boolean)

Dim nRow As Long

Dim nVal As Integer

Dim bFound As Boolean

VLOOKNEW = "Not Found"

If col_index_num > 0 Then

VLOOKNEW = Application.WorksheetFunction.VLookup(lookup_value, _

table_array, col_index_num, CloseMatch)

Else

nRow = Application.WorksheetFunction.Match(lookup_value, _

table_array.Resize(, 1), CloseMatch)

VLOOKNEW = table_array(nRow, 1).Offset(0, col_index_num)

End If

End Function

  

Please send me the solution.

I wud appreciate if u can mark the solution to mkpat...@gmail.com

 

 

Regards
Mayank Patel
ITC LTD
9822978041
9422749110









--~--~-~--~~~---~--~~
--
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
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Happy Deepawali...

[Chandra Gupt Kumar]

♫ “Let this diwali burn all your bad times and enter you in good times”


Wish you & your family very happy & joyful Deepawali...


Regards,


C.G.Kumar

--~--~-~--~~~---~--~~
--
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
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Write numbers in word

[Chandra Gupt Kumar]

Dear Dilip,

I am not as good as you are. So, could you pls modify the Macro to suite
Indian Curreny i.e. Rupees (Rs) and Paisa.

Thanks

On Sun, Oct 4, 2009 at 4:58 PM, Dilip Pandey  wrote:

> Hi Zaheer,
>
> Just answered this one a while ago.  Check out and let me know if you
> did'nt find that email.  Thanks,
> --
> DILIP KUMAR PANDEY
>MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 110062
>
>
> On 10/2/09, ~ Z A H E E R ~  wrote:
>>
>> Dear group members,
>>
>> Please help to to write numbers into words automatically.
>>
>> for. eg. if i enter "1,250/365" in any cell then formula or code should
>> give me asnswer in words in any other cell "[Currency Name] Öne Thousand Two
>> Hundred Fifty & [Currency Name for change] 365/1000 Only"
>>
>> i.e Kuwaiti Dinars One Thousand Two Hundred Fifty & Fils 365/1000 Only.
>>
>> Number could be answer of any formula.
>>
>> Please help me.
>>
>> Thanx 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 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
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Date Format

[Chandra Gupt Kumar]

Alternatively,

Do the following, 

1.  Select the column where you want to apply the date format
2.  Go to >Data>Text to Coulmn>Fixed Width>Click Next>Click at the end
of date (this will insert a column break)
3.  Click Next>Select from Coiumn data format Date (DMY if u like)
4.  Click Finish
5.  You shall have your desired output without any long and cumbersome
formulae.

 

Hope u find it easy and use successfully.

 

Regards,

 

AMW-2

 

  _  

From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Dilip Pandey
Sent: Thursday, October 01, 2009 9:52 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Date Format

 

Hi Kaustubh,

 

If you have these dates in column A, then try the following formula in
column B and drag it down.  Thanks.

 

=DATE(RIGHT(A1,2),MID(A1,FIND(".",A1)+1,FIND(".",A1,2)-1),LEFT(A1,FIND(".",A
1)-1))
 

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 9/28/09, Kaustubh K  wrote: 


Hi,

I have around 500 entries which have format of date dd.mm.yy say
21.05.08 ( And the difficulty is that they are not in date format but
text format) I wish to convert them to mm/dd/  date format. Is
there any trick to do so fast.

Regards
Kaustubh
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
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: When some data is filtered how to find unique values in excel

[Chandra Gupt Kumar]

Used Find option.

On Tue, Sep 29, 2009 at 10:40 AM, Vikas Agarwal  wrote:

> Dear All,
>
> Need a small help.
>
> Is there a way to find unique values in excel when some data is filtered.
>
> Eg:
>
> There are 1-100 rows in a particular sheet
>
> If the filter contains some 20 odd rows based on certain selection
> criteria, is it possible to find unique values in those filtered cells (20
> rows) ?
>
> Please reply ASAP.
>
>
> Rgds,
>
> Vikas
>
>
> >
>

--~--~-~--~~~---~--~~
--
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
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Computation of Tax payment Tax Code Wise.

[Chandra Gupt Kumar]

Dear Member,
Monthly i take report of Sales for the previous months with respect to which
Sales Tax is payable from our database. It gives in the format
attached.Since, for filling of return, i require the sales tax payable tax
rate wise, i have to mannualy insert a column and sort it first by CST then
by rate and then do the manual add the Sales, Sales tax and Invoice. For
example, i took the report for the month of 01.08.09 - 31.08.2009, (deleted
the more than 100 recods as it would have file bulky) and then did
accordingly to get the report as attached.


Could you provide a macro to ease the manoeuvre.

I am looking farward for your reply.


Regards,

Kumar

--~--~-~--~~~---~--~~
--
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
-~--~~~~--~~--~--~---



TAX PAYMENT.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Help Needed for Debit Credit entries

[Chandra Gupt Kumar]

Dear Dilip,

 

You provided good answer .

I have two 

1. 1st possible solution based on "Identifying the rowsin earlier problem ''
leaves the first data matched as it is.

2. Could you tell how to do this in case I have two columns on named Dr and
other named Cr. Both Columns have matching figures. How to identify these
equal figures..

Regards,

Kumar

 

  _  

From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Dilip Pandey
Sent: Thursday, September 17, 2009 9:38 AM
To: excel-macros@googlegroups.com
Cc: excel-macros group; pradeep170...@gmail.com
Subject: $$Excel-Macros$$ Re: Help Needed for Debit Credit entries

 

Hi Pradeep (Deep)

 

Attached workbook has the scenario provided by you along with two possible
solutions based on "identiying the rows" and "coloring of the rows".
Thanks.
-- 
DILIP KUMAR PANDEY  
   MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062 

 

On 9/16/09, Deep  wrote: 

Dear Freinds,

  I am attaching one file which contains debit & credit
amounts in same column. But previous column have D or C written which
represents the amount is Debit or Credit [D for debit & C for Credit]

  I want to nullify {neutralise} if debit & credit
amount is same. For example 

 

 


00630033275492006033020060330OWN CHQ XFER DP

 

C

1000


00630033275492006033020060330WDL TFR

TRF TO 0099514300813

D

1000

 

That means this two rows get seperated or colour change or get delected of
represented as Zero Value. This all work I have to do manually by searing
each an every entry.

 

The aim of this work is to find out those entries which do not have
corresponding debit entries or viceversa.

 

Is some solution is there in excel programing.

 

If possible, please provide me. Thanks a lot in advance.

 

 

Pradeep Agarwal

pradeep170...@gmail.com

pradeep.agra...@licindia.com

 

 






--~--~-~--~~~---~--~~
--
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
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Fwd: Name Matching In Excel

[Chandra Gupt Kumar]

Dear Sonal, 

 

I am afraid that the macro you are looking for may not be possible since
name to be matched should be identical.

 

If you find some solution, please let me know also.

 

Regards,

 

Kumar

 

  _  

From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Sonal Gadgil
Sent: Tuesday, September 22, 2009 10:29 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Fwd: Name Matching In Excel

 

Hi All.

Please help me in this

Thanks & Regards
Sonal Gadgil



-- Forwarded message --
From: Sonal Gadgil 
Date: Mon, Sep 21, 2009 at 9:46 PM
Subject: Name Matching In Excel
To: excel-macros@googlegroups.com


Hi...

I am new in this group.

I am facing one proble while working in the excel.

I am having two excel files where i have to map the customer based on
customer name by matching customer name manually.

Now, in case there is any macro available which help me to search & map
names this will be great help to me & other users

Example:





--~--~-~--~~~---~--~~
--
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
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Pivot Table on Date should show the result on Manth Basis

[Chandra Gupt Kumar]

Dear S.Deshpande,

 

Saw the excel file but couldn't able to understand how you did it. Could you
plz explain ?

 

 

Regards,

 

Kumar

 

  _  

From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Swanand Deshpande
Sent: Thursday, September 24, 2009 10:45 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Pivot Table on Date should show the result on
Manth Basis

 

Here you go Rajeev.

 

Regards,
Swanand Deshpande
Cell: +91- 90110 99165

 

From: Rajeev Nandan   

Sent: Wednesday, September 23, 2009 11:34 PM

To: excel-macros@googlegroups.com 

Subject: $$Excel-Macros$$ Pivot Table on Date should show the result on
Manth Basis

 

Please find attached a sample file in which I applied Pivot Table. The Row
label is based on Date but I require the Result on Month basis. I have to do
the manual work by inserting a column in which i put a dummy date of that
month against all entries of that  particular month(Refer Col. B). Then only
I get desired result.

Please help if there is any way to get the desired result without doing
manual work.

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
-~--~~~~--~~--~--~---