Re: $$Excel-Macros$$ Re: Help Required

[Mandeep Baluja]

>
> Your Date is not date but to convert a date to number you can simply 
> multiply it with one this scenario works most of the cases but not for all. 
>

For Example your date is in A1 put formula in b1 = A1*1

Regards,
Mandeep baluja 

ticket closed
 

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

RE: $$Excel-Macros$$ Re: Help Required

[Neeraj Chauhan]

Dear sir

 

I cannot understand kindly brief/example

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Mandeep Baluja
Sent: Thursday, January 14, 2016 6:15 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Re: Help Required

 

Multiply date with 1

On Thursday, January 14, 2016 at 5:54:19 PM UTC+5:30, neeraj chauhan wrote:

Dear sir,

 

Thanks sir !!

Kindly share the formula.

 

From: excel-...@googlegroups.com   
[mailto:excel-...@googlegroups.com  ] On Behalf Of Mandeep Baluja
Sent: Thursday, January 14, 2016 4:50 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Re: Help Required

 

PFA !! Ticket closed 

Regards,

Mandeep baluja  

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros...@googlegroups.com  .
To post to this group, send email to excel-...@googlegroups.com  .
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Help Required

[Mandeep Baluja]

Multiply date with 1

On Thursday, January 14, 2016 at 5:54:19 PM UTC+5:30, neeraj chauhan wrote:
>
> Dear sir,
>
>  
>
> Thanks sir !!
>
> Kindly share the formula.
>
>  
>
> *From:* excel-...@googlegroups.com  [mailto:
> excel-...@googlegroups.com ] *On Behalf Of *Mandeep Baluja
> *Sent:* Thursday, January 14, 2016 4:50 PM
> *To:* MS EXCEL AND VBA MACROS
> *Subject:* $$Excel-Macros$$ Re: Help Required
>
>  
>
> PFA !! Ticket closed 
>
> Regards,
>
> Mandeep baluja  
>
> -- 
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
> https://www.facebook.com/discussexcel
>  
> FORUM RULES
>  
> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security 
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>  
> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
> members are not responsible for any loss.
> --- 
> You received this message because you are subscribed to the Google Groups 
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to excel-macros...@googlegroups.com .
> To post to this group, send email to excel-...@googlegroups.com 
> .
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

RE: $$Excel-Macros$$ Re: Help Required

[Neeraj Chauhan]

Dear sir,

 

Thanks sir !!

Kindly share the formula.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Mandeep Baluja
Sent: Thursday, January 14, 2016 4:50 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Re: Help Required

 

PFA !! Ticket closed 

Regards,

Mandeep baluja  

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ RE: Help required

[Gaurav Devrani]

Either Press Cntl + 1 and then change the date format

Or try this code in number format (VBA)

= "[$-409]dd-mmm-yy;@"

 "DD-MMM-YY"

On Tue, Aug 4, 2015 at 4:59 AM, Neeraj Chauhan 
wrote:

> Thanks Anand
>
>
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Anand Tiwari
> *Sent:* Tuesday, August 04, 2015 4:24 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ RE: Help required
>
>
>
> Hi Neeraj
>
>
>
> Please use this,
>
> ​
>
> Alt+D+E then Delimited next click Date and choose format DMY then finish.
> ​
>
>
>
>
> *Regards,*
>
> *Anand Tiwari*
>
>
>
> On 4 August 2015 at 16:14, Neeraj Chauhan 
> wrote:
>
> Dear experts I want to change the date format
>
>
>
> Date
>
> I want this format
>
> 31/7/2015
>
> 31-Jul-15
>
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@

RE: $$Excel-Macros$$ RE: Help required

[Neeraj Chauhan]

Thanks Anand

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Anand Tiwari
Sent: Tuesday, August 04, 2015 4:24 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ RE: Help required

 

Hi Neeraj

 

Please use this,

​

Alt+D+E then Delimited next click Date and choose format DMY then finish. ​

 




Regards,

Anand Tiwari

 

On 4 August 2015 at 16:14, Neeraj Chauhan  wrote:

Dear experts I want to change the date format

 


Date

I want this format


31/7/2015

31-Jul-15

 

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

 

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ RE: Help required

[Anand Tiwari]

Hi Neeraj

Please use this,
​
Alt+D+E then Delimited next click Date and choose format DMY then finish. ​


*Regards,*
*Anand Tiwari*

On 4 August 2015 at 16:14, Neeraj Chauhan 
wrote:

> Dear experts I want to change the date format
>
>
>
> Date
>
> I want this format
>
> 31/7/2015
>
> 31-Jul-15
>
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

RE: $$Excel-Macros$$ Re: Help Required

[Neeraj]

Thanks sir

its working and I want this

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Mandeep Baluja
Sent: Wednesday, May 20, 2015 3:25 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Help Required

 

Want this ?

 

Regards, 

MandeepBaluja

Learningzmypassion.

https://www.facebook.com/VBAEXCELSQL?ref=hl

https://www.linkedin.com/profile/view?id=312532939


On Wednesday, May 20, 2015 at 2:59:09 PM UTC+5:30, neeraj chauhan wrote:

Dear Experts,

 

Kindly find the sheet and do the needful formula

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Help required for conslidate

[Mandeep Baluja]

Glad to help :) 

Regards, 
Mandeep Baluja 
Email :-mandeep.bal...@snapdeal.com
mandeep.bal...@gmail.com
https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77
https://www.facebook.com/groups/825221420889809/

On Wednesday, May 6, 2015 at 12:28:39 PM UTC+5:30, rk sharma wrote:
>
> Thanks alot Mandeep ji.
>
> its working.
>
> br//
> rakesh 
>
>
> RAKESH SHARMA
> NPI –Team
> Ericsson India Pvt. Ltd.
> 4th Floor, Gupta Towers, Commercial Block, Rail Head
> Jammu & Kashmir, INDIA
> Phone 01912477440/ 01912477473/441
> Fax 01912477442 
> Mobile +91 9906115140
> rakesh.kum...@ericsson.com 
> www.ericsson.com 
>
> “If You fall, fall like a seed to germinate, not like a leaf to die.”
>
> On Wed, May 6, 2015 at 12:25 PM, Mandeep Baluja  > wrote:
>
>> when you select your blank cells just see the buttons in home tab where 
>> insert,delete,format  button is showing you need to press delete ->delete 
>> cells -> shift cells to left .
>>
>>
>>
>>
>> On Wednesday, May 6, 2015 at 12:17:59 PM UTC+5:30, rk sharma wrote:
>>>
>>> Thanks Mandeep ji,
>>>
>>> but dear i didn't under stand what your are talking about this line 
>>>
>>> *go into home tab delete cells and shift cells left you will get your 
>>> data*
>>>
>>> Pl help
>>>
>>>
>>>
>>> RAKESH SHARMA
>>> NPI –Team
>>> Ericsson India Pvt. Ltd.
>>> 4th Floor, Gupta Towers, Commercial Block, Rail Head
>>> Jammu & Kashmir, INDIA
>>> Phone 01912477440/ 01912477473/441
>>> Fax 01912477442 
>>> Mobile +91 9906115140
>>> rakesh.kum...@ericsson.com
>>> www.ericsson.com 
>>>
>>> “If You fall, fall like a seed to germinate, not like a leaf to die.”
>>>
>>> On Wed, May 6, 2015 at 12:13 PM, Mandeep Baluja  
>>> wrote:
>>>
 Select b3:m5  press f5 -> click special option->tick blank->go into 
 home tab delete cells and shift cells left you will get your data.


 Regards, 
 Mandeep Baluja 
 Email :-mandeep...@snapdeal.com
 mandeep...@gmail.com
 https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77
 https://www.facebook.com/groups/825221420889809/







 On Wednesday, May 6, 2015 at 12:04:15 PM UTC+5:30, rk sharma wrote:
>
> Dear Experts,
>
> Kindly Help on urgent basis to get it resolve as below .
>
> suggest any formula to get the exact data as i required. reference 
> sheet attached
>
> ​
>I have data as below   source 1 1 1 1 1 1 1 1 1 1 1 1  RAKESH   
>   A B C   DMUKESH A   B   C   D E  GAURAV   A   B 
>   C   D E   F   requirment( I WANT DATA WITH NON 
> BLANKS AGAINST SOURCE)  source 1 1 1 1 1 1 1 1 1 1 1 1  RAKESH A B C D 
>  MUKESH A B C D EGAURAV A B C D E F   
>   
> ​
> Thanks in adv. 
> Rakesh Sharma 
>  
  -- 
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
 https://www.facebook.com/discussexcel
  
 FORUM RULES
  
 1) Use concise, accurate thread titles. Poor thread titles, like Please 
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security 
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.
  
 NOTE : Don't ever post confidential data in a workbook. Forum owners 
 and members are not responsible for any loss.
 --- 
 You received this message because you are subscribed to the Google 
 Groups "MS EXCEL AND VBA MACROS" group.
 To unsubscribe from this group and stop receiving emails from it, send 
 an email to excel-macros...@googlegroups.com.
 To post to this group, send email to excel-...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.

>>>
>>>  -- 
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post confidential data in a workbook. Forum ow

Re: $$Excel-Macros$$ Re: Help required for conslidate

[Rakesh]

Thanks alot Mandeep ji.

its working.

br//
rakesh


RAKESH SHARMA
NPI –Team
Ericsson India Pvt. Ltd.
4th Floor, Gupta Towers, Commercial Block, Rail Head
Jammu & Kashmir, INDIA
Phone 01912477440/ 01912477473/441
Fax 01912477442
Mobile +91 9906115140
rakesh.kumar.d.sha...@ericsson.com
www.ericsson.com

“If You fall, fall like a seed to germinate, not like a leaf to die.”

On Wed, May 6, 2015 at 12:25 PM, Mandeep Baluja 
wrote:

> when you select your blank cells just see the buttons in home tab where
> insert,delete,format  button is showing you need to press delete ->delete
> cells -> shift cells to left .
>
>
>
>
> On Wednesday, May 6, 2015 at 12:17:59 PM UTC+5:30, rk sharma wrote:
>>
>> Thanks Mandeep ji,
>>
>> but dear i didn't under stand what your are talking about this line
>>
>> *go into home tab delete cells and shift cells left you will get your
>> data*
>>
>> Pl help
>>
>>
>>
>> RAKESH SHARMA
>> NPI –Team
>> Ericsson India Pvt. Ltd.
>> 4th Floor, Gupta Towers, Commercial Block, Rail Head
>> Jammu & Kashmir, INDIA
>> Phone 01912477440/ 01912477473/441
>> Fax 01912477442
>> Mobile +91 9906115140
>> rakesh.kum...@ericsson.com
>> www.ericsson.com
>>
>> “If You fall, fall like a seed to germinate, not like a leaf to die.”
>>
>> On Wed, May 6, 2015 at 12:13 PM, Mandeep Baluja 
>> wrote:
>>
>>> Select b3:m5  press f5 -> click special option->tick blank->go into home
>>> tab delete cells and shift cells left you will get your data.
>>>
>>>
>>> Regards,
>>> Mandeep Baluja
>>> Email :-mandeep...@snapdeal.com
>>> mandeep...@gmail.com
>>> https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77
>>> https://www.facebook.com/groups/825221420889809/
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> On Wednesday, May 6, 2015 at 12:04:15 PM UTC+5:30, rk sharma wrote:

 Dear Experts,

 Kindly Help on urgent basis to get it resolve as below .

 suggest any formula to get the exact data as i required. reference
 sheet attached

 ​
I have data as below   source 1 1 1 1 1 1 1 1 1 1 1 1  RAKESH
   A B C   DMUKESH A   B   C   D E  GAURAV   A   B
 C   D E   F   requirment( I WANT DATA WITH NON BLANKS
 AGAINST SOURCE)  source 1 1 1 1 1 1 1 1 1 1 1 1  RAKESH A B C D
  MUKESH A B C D EGAURAV A B C D E F
 ​
 Thanks in adv.
 Rakesh Sharma

>>>  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros...@googlegroups.com.
>>> To post to this group, send email to excel-...@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you 

Re: $$Excel-Macros$$ Re: Help required for conslidate

[Mandeep Baluja]

when you select your blank cells just see the buttons in home tab where 
insert,delete,format  button is showing you need to press delete ->delete 
cells -> shift cells to left .




On Wednesday, May 6, 2015 at 12:17:59 PM UTC+5:30, rk sharma wrote:
>
> Thanks Mandeep ji,
>
> but dear i didn't under stand what your are talking about this line 
>
> *go into home tab delete cells and shift cells left you will get your data*
>
> Pl help
>
>
>
> RAKESH SHARMA
> NPI –Team
> Ericsson India Pvt. Ltd.
> 4th Floor, Gupta Towers, Commercial Block, Rail Head
> Jammu & Kashmir, INDIA
> Phone 01912477440/ 01912477473/441
> Fax 01912477442 
> Mobile +91 9906115140
> rakesh.kum...@ericsson.com 
> www.ericsson.com 
>
> “If You fall, fall like a seed to germinate, not like a leaf to die.”
>
> On Wed, May 6, 2015 at 12:13 PM, Mandeep Baluja  > wrote:
>
>> Select b3:m5  press f5 -> click special option->tick blank->go into home 
>> tab delete cells and shift cells left you will get your data.
>>
>>
>> Regards, 
>> Mandeep Baluja 
>> Email :-mandeep...@snapdeal.com 
>> mandeep...@gmail.com 
>> https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77
>> https://www.facebook.com/groups/825221420889809/
>>
>>
>>
>>
>>
>>
>>
>> On Wednesday, May 6, 2015 at 12:04:15 PM UTC+5:30, rk sharma wrote:
>>>
>>> Dear Experts,
>>>
>>> Kindly Help on urgent basis to get it resolve as below .
>>>
>>> suggest any formula to get the exact data as i required. reference sheet 
>>> attached
>>>
>>> ​
>>>I have data as below   source 1 1 1 1 1 1 1 1 1 1 1 1  RAKESH 
>>> A B C   DMUKESH A   B   C   D E  GAURAV   A   B   C 
>>>   D E   F   requirment( I WANT DATA WITH NON BLANKS 
>>> AGAINST SOURCE)  source 1 1 1 1 1 1 1 1 1 1 1 1  RAKESH A B C D 
>>>  MUKESH A B C D EGAURAV A B C D E F 
>>> ​
>>> Thanks in adv. 
>>> Rakesh Sharma 
>>>  
>>  -- 
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
>> members are not responsible for any loss.
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to excel-macros...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com 
>> .
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Help required for conslidate

[Rakesh]

Thanks Mandeep ji,

but dear i didn't under stand what your are talking about this line

*go into home tab delete cells and shift cells left you will get your data*

Pl help



RAKESH SHARMA
NPI –Team
Ericsson India Pvt. Ltd.
4th Floor, Gupta Towers, Commercial Block, Rail Head
Jammu & Kashmir, INDIA
Phone 01912477440/ 01912477473/441
Fax 01912477442
Mobile +91 9906115140
rakesh.kumar.d.sha...@ericsson.com
www.ericsson.com

“If You fall, fall like a seed to germinate, not like a leaf to die.”

On Wed, May 6, 2015 at 12:13 PM, Mandeep Baluja 
wrote:

> Select b3:m5  press f5 -> click special option->tick blank->go into home
> tab delete cells and shift cells left you will get your data.
>
>
> Regards,
> Mandeep Baluja
> Email :-mandeep.bal...@snapdeal.com
> mandeep.bal...@gmail.com
> https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77
> https://www.facebook.com/groups/825221420889809/
>
>
>
>
>
>
>
> On Wednesday, May 6, 2015 at 12:04:15 PM UTC+5:30, rk sharma wrote:
>>
>> Dear Experts,
>>
>> Kindly Help on urgent basis to get it resolve as below .
>>
>> suggest any formula to get the exact data as i required. reference sheet
>> attached
>>
>> ​
>>I have data as below   source 1 1 1 1 1 1 1 1 1 1 1 1  RAKESH
>> A B C   DMUKESH A   B   C   D E  GAURAV   A   B   C
>> D E   F   requirment( I WANT DATA WITH NON BLANKS
>> AGAINST SOURCE)  source 1 1 1 1 1 1 1 1 1 1 1 1  RAKESH A B C D
>>MUKESH A B C D EGAURAV A B C D E F
>> ​
>> Thanks in adv.
>> Rakesh Sharma
>>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Help required for Match DATA

[Ashu k]

Ok Sir, I am trying.


Regards
Ashu Kenith

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Help required for Match DATA

[Ashu k]

Dear Mandeep Sir,

All are enabled.

PFA the attachment.

Please provide Support.

Regards
Ashu Kenith

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Help required for Match DATA

[Mandeep baluja]

in this attachment did you enabled this library in refrences go to  vba 
editior enalble these library and then go to sheet1 and click the button 
send mails . 

microsoft outlook 14.0 object library
ole auotmation
microsoft excel 14.0 object library
visual basic for applications
microsoft forms 2.0 object library








On Tuesday, 17 March 2015 11:49:13 UTC+5:30, Ashu k wrote:
>
> Dear Mandeep Sir, 
>
> Now, Getting error. 
>
> When i try to run code - Getting error (M-1) imageis attached 
> and 
> If i click on debug button - Getting Problem (M-2) image is attached 
>
> I think think the macro is provided by you is recorded. that's why 
> it's not functing well. 
>
> Please help. 
>
> PFA, the error attachments. 
>
> Regards 
> Ashu Kenith 
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Sendmails_tomerchants.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Re: Help required for Match DATA

[Ashu k]

Dear Mandeep Sir,

Query is still pending from last 2 months. Last time you said that,
you will send the answer shortly.

Revert awaited from your side.

Please help.

Regards
Ashu kenith.

On 1/15/15, Ashu k  wrote:
Dear Mandeep Sir,

Please Help on the same issue. Can i explain again my query.

Please help sir.

Regards
Ashu Kenith

On Thu, Jan 15, 2015 at 12:30 PM, Ashu k  wrote:

Dear Mandeep Sir,

Please help.

Regards
Ashu Kenith.


On Tue, Jan 13, 2015 at 6:37 PM, Ashu k  wrote:

Dear Mandeep Sir,

Thanks a lot for your help.

one more help required.

If the Merchant ID is same then paste the data (Order No., Item ID, Item
Name, RTO Date) on mail body which was belongs to Same Merchant ID.

Example : - Merchant ID is  12345 and 10 orders is placed by this
merchant, then paste the all details on mail body which is belongs to
the
same merchant in the same format which was provided by you in previous
mail.

kindly help.

Regards
Ashu Kenith.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Help required for Match DATA

[Ashu k]

Dear Mandeep Sir,

Please help.

kindly send the macro.

Regards
Ashu Kenith.

On Thu, Jan 15, 2015 at 6:41 PM, Ashu k  wrote:

> Dear Mandeep Sir,
>
> Please Help on the same issue. Can i explain again my query.
>
> Please help sir.
>
> Regards
> Ashu Kenith
>
> On Thu, Jan 15, 2015 at 12:30 PM, Ashu k  wrote:
>
>> Dear Mandeep Sir,
>>
>> Please help.
>>
>> Regards
>> Ashu Kenith.
>>
>>
>> On Tue, Jan 13, 2015 at 6:37 PM, Ashu k  wrote:
>>
>>> Dear Mandeep Sir,
>>>
>>> Thanks a lot for your help.
>>>
>>> one more help required.
>>>
>>> If the Merchant ID is same then paste the data (Order No., Item ID, Item
>>> Name, RTO Date) on mail body which was belongs to Same Merchant ID.
>>>
>>> Example : - Merchant ID is  12345 and 10 orders is placed by this
>>> merchant, then paste the all details on mail body which is belongs to the
>>> same merchant in the same format which was provided by you in previous mail.
>>>
>>> kindly help.
>>>
>>> Regards
>>> Ashu Kenith.
>>>
>>
>>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Help required for Match DATA

[Ashu k]

Dear Mandeep Sir,

Thanks a lot for your help.

I don't have an facebook account. So, request you to please share the macro
when you have time.

Thanks for your help and kind support.

Regards
Ashu Kenith

On Thu, Jan 15, 2015 at 9:33 PM, Mandeep Baluja 
wrote:

> https://m.facebook.com/VBAEXCELSQL?__tn__=C
>
> This is my page i have posted your macro on this blog top post is yours,
> Copy the same and run in your sheet.
>
> Sorry i forgot to send you the sheet.will send the same as i will be in
> office.
>
> Regards,
> Mandeep
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Help required for Match DATA

[Mandeep Baluja]

https://m.facebook.com/VBAEXCELSQL?__tn__=C

This is my page i have posted your macro on this blog top post is yours,
Copy the same and run in your sheet.

Sorry i forgot to send you the sheet.will send the same as i will be in office.

Regards,
Mandeep

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Help required for Match DATA

[Ashu k]

Dear Mandeep Sir,

Please Help on the same issue. Can i explain again my query.

Please help sir.

Regards
Ashu Kenith

On Thu, Jan 15, 2015 at 12:30 PM, Ashu k  wrote:

> Dear Mandeep Sir,
>
> Please help.
>
> Regards
> Ashu Kenith.
>
>
> On Tue, Jan 13, 2015 at 6:37 PM, Ashu k  wrote:
>
>> Dear Mandeep Sir,
>>
>> Thanks a lot for your help.
>>
>> one more help required.
>>
>> If the Merchant ID is same then paste the data (Order No., Item ID, Item
>> Name, RTO Date) on mail body which was belongs to Same Merchant ID.
>>
>> Example : - Merchant ID is  12345 and 10 orders is placed by this
>> merchant, then paste the all details on mail body which is belongs to the
>> same merchant in the same format which was provided by you in previous mail.
>>
>> kindly help.
>>
>> Regards
>> Ashu Kenith.
>>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Help required for Match DATA

[Ashu k]

Dear Mandeep Sir,

Please help.

Regards
Ashu Kenith.

On Tue, Jan 13, 2015 at 6:37 PM, Ashu k  wrote:

> Dear Mandeep Sir,
>
> Thanks a lot for your help.
>
> one more help required.
>
> If the Merchant ID is same then paste the data (Order No., Item ID, Item
> Name, RTO Date) on mail body which was belongs to Same Merchant ID.
>
> Example : - Merchant ID is  12345 and 10 orders is placed by this
> merchant, then paste the all details on mail body which is belongs to the
> same merchant in the same format which was provided by you in previous mail.
>
> kindly help.
>
> Regards
> Ashu Kenith.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Help required for Match DATA

[Ashu k]

Dear Mandeep Sir,

Thanks a lot for your help.

one more help required.

If the Merchant ID is same then paste the data (Order No., Item ID, Item
Name, RTO Date) on mail body which was belongs to Same Merchant ID.

Example : - Merchant ID is  12345 and 10 orders is placed by this merchant,
then paste the all details on mail body which is belongs to the same
merchant in the same format which was provided by you in previous mail.

kindly help.

Regards
Ashu Kenith.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Help required for Match DATA

[Ashu k]

Dear Mandeep Sir,

Please Help.


Regards
Ashu Kenith.

On Wed, Jan 7, 2015 at 4:18 PM, Ashu k  wrote:

> Dear Mandeep Sir,
>
>
> Solution was perfect. But i want Paste the data in Mail body.
>
> Please check below sample Email :-
>
>
> Dear Business Partner,
>
>
>
> This is to inform you that as per our logistic partner report you have
> received RTO shipments with details as follow:
>
>
> *Order No*
>
> *Item ID*
>
> *Item Name*
>
> *RTO Date*
>
> 630555472
>
> 642613247
>
> Mtg Black Round Watch For Men
>
> 2014-11-07
>
> 641027033
>
> 654193139
>
> Dezine Dz-Gr030-Black-Black Watch For Male
>
> 2014-11-09
>
> 639464853
>
> 652508262
>
> Dezine Dz-Gr094-Black-Chain Watch For Male
>
> 2014-11-17
>
> 656430483
>
> 670912436
>
> Dezine Dz-Gr080-Black-Brown Watch For Male
>
> 2014-12-02
>
> 658588670
>
> 673243501
>
> Mtg Black Round Watch For Men
>
> 2014-12-02
>
> 662189679
>
> 677119327
>
> Mtg Black Round Watch For Men
>
> 2014-12-03
>
> 609739141
>
> 679370383
>
> Mtg Black Round Watch For Men
>
> 2014-12-01
>
>
> Thanks for your continuous support & cooperation.Kindly revert immediately
> in case of any dispute.
>
>
> Regards
>
> SFS Enterprises.
>
>
>
> Please Help.
>
>
>
> Thanks
>
> Ashu Kenith
>
> On Wed, Jan 7, 2015 at 4:03 PM, Mandeep Baluja 
> wrote:
>
>> Done !!
>>
>> Regards,
>> Mandeep Baluja
>> LearningZmyPassion
>> https://www.linkedin.com/profile/view?id=312532939
>> https://www.facebook.com/VBAEXCELSQL?ref=hl
>>
>>>
>>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Help required for Match DATA

[Ashu k]

Dear Mandeep Sir,

Please Help!!


Thanks
Ashu Kenith.


On Wed, Jan 7, 2015 at 4:18 PM, Ashu k  wrote:

> Dear Mandeep Sir,
>
>
> Solution was perfect. But i want Paste the data in Mail body.
>
> Please check below sample Email :-
>
>
> Dear Business Partner,
>
>
>
> This is to inform you that as per our logistic partner report you have
> received RTO shipments with details as follow:
>
>
> *Order No*
>
> *Item ID*
>
> *Item Name*
>
> *RTO Date*
>
> 630555472
>
> 642613247
>
> Mtg Black Round Watch For Men
>
> 2014-11-07
>
> 641027033
>
> 654193139
>
> Dezine Dz-Gr030-Black-Black Watch For Male
>
> 2014-11-09
>
> 639464853
>
> 652508262
>
> Dezine Dz-Gr094-Black-Chain Watch For Male
>
> 2014-11-17
>
> 656430483
>
> 670912436
>
> Dezine Dz-Gr080-Black-Brown Watch For Male
>
> 2014-12-02
>
> 658588670
>
> 673243501
>
> Mtg Black Round Watch For Men
>
> 2014-12-02
>
> 662189679
>
> 677119327
>
> Mtg Black Round Watch For Men
>
> 2014-12-03
>
> 609739141
>
> 679370383
>
> Mtg Black Round Watch For Men
>
> 2014-12-01
>
>
> Thanks for your continuous support & cooperation.Kindly revert immediately
> in case of any dispute.
>
>
> Regards
>
> SFS Enterprises.
>
>
>
> Please Help.
>
>
>
> Thanks
>
> Ashu Kenith
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Help required for Match DATA

[Ashu k]

Dear Mandeep Sir,


Solution was perfect. But i want Paste the data in Mail body.

Please check below sample Email :-


Dear Business Partner,



This is to inform you that as per our logistic partner report you have
received RTO shipments with details as follow:


*Order No*

*Item ID*

*Item Name*

*RTO Date*

630555472

642613247

Mtg Black Round Watch For Men

2014-11-07

641027033

654193139

Dezine Dz-Gr030-Black-Black Watch For Male

2014-11-09

639464853

652508262

Dezine Dz-Gr094-Black-Chain Watch For Male

2014-11-17

656430483

670912436

Dezine Dz-Gr080-Black-Brown Watch For Male

2014-12-02

658588670

673243501

Mtg Black Round Watch For Men

2014-12-02

662189679

677119327

Mtg Black Round Watch For Men

2014-12-03

609739141

679370383

Mtg Black Round Watch For Men

2014-12-01


Thanks for your continuous support & cooperation.Kindly revert immediately
in case of any dispute.


Regards

SFS Enterprises.



Please Help.



Thanks

Ashu Kenith

On Wed, Jan 7, 2015 at 4:03 PM, Mandeep Baluja 
wrote:

> Done !!
>
> Regards,
> Mandeep Baluja
> LearningZmyPassion
> https://www.linkedin.com/profile/view?id=312532939
> https://www.facebook.com/VBAEXCELSQL?ref=hl
>
>>
>>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Help required for Match DATA

[Ashu k]

Dear Mandeep Sir,

I don't want to send mail with attachment. I want send different mail to
different customers according to the merchant ID.

Subject and message body should be changed automatically with all the
details (order no., rto date, item name, item id) when i punch the merchant
id,order no., rto date, item name, item id in sheet.

Please check the query again in sheet 1.

@Mandeep Sir, Looking forward to your reply Sir.

Thanks
Ashu Kenith

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Help required for Match DATA

[Ashu k]

Dear Anil Sir,

Thanks for your reply. But, i dont want to send mail with attachment. I
want send different mail to different customers according to the merchant
ID.

Subject and message body should be changed automatically with all the
details (order no., rto date, item name, item id) when i punch the merchant
id,order no., rto date, item name, item id in sheet.

Please check the query again in sheet 1.

Thanks
Ashu Kenith

On Wed, Jan 7, 2015 at 3:09 PM, Anil Gawli  wrote:

> Dear Mr. Ashu,
>
> Pls find attached as per you requirement.
> P.S  pls change the address of the attachment as you req.
>
> .Add ("T:\Commercial\Common\Shailendra\Data" & Format(Now(),
> "mm-dd-yy") & ".xls")
>
> Warm regards,
> Gawli Anil.
>
> On Wed, Jan 7, 2015 at 1:24 PM, Ashu k  wrote:
> > Dear Mandeep Sir,
> >
> > PLease help. I want send mail to the customers. Example is attached.
> >
> > Thanks
> > Ashu Kenith
> >
> > --
> > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> > https://www.facebook.com/discussexcel
> >
> > FORUM RULES
> >
> > 1) Use concise, accurate thread titles. Poor thread titles, like Please
> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will
> > not get quick attention or may not be answered.
> > 2) Don't post a question in the thread of another member.
> > 3) Don't post questions regarding breaking or bypassing any security
> > measure.
> > 4) Acknowledge the responses you receive, good or bad.
> > 5) Jobs posting is not allowed.
> > 6) Sharing copyrighted material and their links is not allowed.
> >
> > NOTE : Don't ever post confidential data in a workbook. Forum owners and
> > members are not responsible for any loss.
> > ---
> > You received this message because you are subscribed to the Google Groups
> > "MS EXCEL AND VBA MACROS" group.
> > To unsubscribe from this group and stop receiving emails from it, send an
> > email to excel-macros+unsubscr...@googlegroups.com.
> > To post to this group, send email to excel-macros@googlegroups.com.
> > Visit this group at http://groups.google.com/group/excel-macros.
> > For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Help required for Match DATA

[Anil Gawli]

Dear Mr. Ashu,

Pls find attached as per you requirement.
P.S  pls change the address of the attachment as you req.

.Add ("T:\Commercial\Common\Shailendra\Data" & Format(Now(),
"mm-dd-yy") & ".xls")

Warm regards,
Gawli Anil.

On Wed, Jan 7, 2015 at 1:24 PM, Ashu k  wrote:
> Dear Mandeep Sir,
>
> PLease help. I want send mail to the customers. Example is attached.
>
> Thanks
> Ashu Kenith
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


QerySendMail.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Re: Help required for Match DATA

[Ashu k]

Dear Mandeep Sir,

PLease help. I want send mail to the customers. Example is attached.

Thanks
Ashu Kenith

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


QerySendMail.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Re: Help required for Match DATA

[Ashu k]

Dear Paul Sir,

Thanks for your help and explaining me..

Dear Mandeep Sir,

Thanks a lot for your help, Please check the attached sheet. Result was not
showing in Last cell.

Please help.

Thanks
Ashu Kenith.

On Wed, Jan 7, 2015 at 10:21 AM, Mandeep Baluja 
wrote:

> Hey Ashu,
>
>
> Check this sheet .* Note :- be careful to check this macro can only give
> you error if the number are actually numbers not the Text values as your
> sheet contain 1 value which was text that is the only reason it gives error
> as paul has explained to you mostly people copy numbers from internet or
> various websites which are text. *
>
> *Regards,Mandeep
> Baluja LearningZmyPassionhttps://www.linkedin.com/profile/view?id=312532939
> https://www.facebook.com/VBAEXCELSQL?ref=hl
>  *
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Ashu (2)twolookup (3).xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Re: Help required for Match DATA

[Ashu k]

Dear Mandeep Sir,

It gives NA# again. Kindly run macro and See the result in Cell C1 and C12.
Sheet attached.


Thanks
Ashu Kenith

On Tue, Dec 23, 2014 at 10:52 AM, Mandeep Baluja 
wrote:

> Now this macro works for 3 lakh rows you can increase the range as per
> your convenience.
>
> Regards,
> Mandeep Baluja
> LearningZmyPassion
> https://www.linkedin.com/profile/view?id=312532939
> https://www.facebook.com/VBAEXCELSQL?ref=hl
>
>
>
> On Wednesday, December 17, 2014 6:30:29 PM UTC+5:30, Ashu k wrote:
>>
>> Dear Seniors,
>>
>> I have data in sheet 1
>>
>> Name   Class   Roll NO.  Exam Date
>>
>>
>> and,
>>
>> I have data in Sheet 2
>>
>> Name  Class  Roll No. Exam Date
>>
>>
>> But some Names are not in Name Column and Some Class are not in Class
>> Column, I want to get all Roll No. in Sheet 2 from Sheet 1.
>>
>> Example data attached. Please help me.
>>
>> Regards
>> Ashu Kenith
>>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Ashu (2)twolookup.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Re: Help required for Match DATA

[Ashu k]

Dear Mandeep Sir,

It's not working.

Thanks
Ashu Kenith.

On Thu, Dec 18, 2014 at 8:00 PM, Ashu k  wrote:
>
> Dear Mandeep Sir,
>
> The code which is provided by you is not working properly. It's giving NA#
> in sheet 2.
>
> Formula is working fine for me which is provided by Ashish Sir & Vaibhav
> Sir.
>
> Kindly check the output and Please Help me.
>
> Sheet attached.
>
> Thanks
> Ashu Kenith
>
>
> On Thu, Dec 18, 2014 at 12:42 PM, Ashu k  wrote:
>>
>> Dear  Sir,
>>
>> Thank you very much.
>>
>> Thanks
>> Ashu Kenith
>>
>>
>> On Thu, Dec 18, 2014 at 10:56 AM, Mandeep Baluja 
>> wrote:
>>>
>>> check this out.
>>>
>>> Regards,
>>> Mandeep Baluja
>>> LearningZmyPassion
>>> https://www.linkedin.com/profile/view?id=312532939
>>> https://www.facebook.com/VBAEXCELSQL?ref=hl
>>>
>>> On Wednesday, December 17, 2014 6:30:29 PM UTC+5:30, Ashu k wrote:

 Dear Seniors,

 I have data in sheet 1

 Name   Class   Roll NO.  Exam Date


 and,

 I have data in Sheet 2

 Name  Class  Roll No. Exam Date


 But some Names are not in Name Column and Some Class are not in Class
 Column, I want to get all Roll No. in Sheet 2 from Sheet 1.

 Example data attached. Please help me.

 Regards
 Ashu Kenith

>>>  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Help required for Match DATA

[Ashu k]

Dear Mandeep Sir,

The code which is provided by you is not working properly. It's giving NA#
in sheet 2.

Formula is working fine for me which is provided by Ashish Sir & Vaibhav
Sir.

Kindly check the output and Please Help me.

Sheet attached.

Thanks
Ashu Kenith

On Thu, Dec 18, 2014 at 12:42 PM, Ashu k  wrote:
>
> Dear  Sir,
>
> Thank you very much.
>
> Thanks
> Ashu Kenith
>
>
> On Thu, Dec 18, 2014 at 10:56 AM, Mandeep Baluja 
> wrote:
>>
>> check this out.
>>
>> Regards,
>> Mandeep Baluja
>> LearningZmyPassion
>> https://www.linkedin.com/profile/view?id=312532939
>> https://www.facebook.com/VBAEXCELSQL?ref=hl
>>
>> On Wednesday, December 17, 2014 6:30:29 PM UTC+5:30, Ashu k wrote:
>>>
>>> Dear Seniors,
>>>
>>> I have data in sheet 1
>>>
>>> Name   Class   Roll NO.  Exam Date
>>>
>>>
>>> and,
>>>
>>> I have data in Sheet 2
>>>
>>> Name  Class  Roll No. Exam Date
>>>
>>>
>>> But some Names are not in Name Column and Some Class are not in Class
>>> Column, I want to get all Roll No. in Sheet 2 from Sheet 1.
>>>
>>> Example data attached. Please help me.
>>>
>>> Regards
>>> Ashu Kenith
>>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Ashu.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Re: Help required for Match DATA

[Ashu k]

Dear  Sir,

Thank you very much.

Thanks
Ashu Kenith

On Thu, Dec 18, 2014 at 10:56 AM, Mandeep Baluja 
wrote:
>
> check this out.
>
> Regards,
> Mandeep Baluja
> LearningZmyPassion
> https://www.linkedin.com/profile/view?id=312532939
> https://www.facebook.com/VBAEXCELSQL?ref=hl
>
> On Wednesday, December 17, 2014 6:30:29 PM UTC+5:30, Ashu k wrote:
>>
>> Dear Seniors,
>>
>> I have data in sheet 1
>>
>> Name   Class   Roll NO.  Exam Date
>>
>>
>> and,
>>
>> I have data in Sheet 2
>>
>> Name  Class  Roll No. Exam Date
>>
>>
>> But some Names are not in Name Column and Some Class are not in Class
>> Column, I want to get all Roll No. in Sheet 2 from Sheet 1.
>>
>> Example data attached. Please help me.
>>
>> Regards
>> Ashu Kenith
>>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ RE: help required urgently

[Vabs]

Hi

You can format cell as DD-Mmm- or

you can use formula =text(ref,"DD-Mmm-) where ref is your reference
cell.

Thanks


On Thu, Mar 27, 2014 at 4:52 PM, Neeraj Chauhan
wrote:

>  Dear experts,
>
>
>
> We have given below date format how to convert right format of date like
> 13-Jan-2014
>
>
>
> TT Modified Date & Time
>
> 13/01/2014
>
> 15/01/2014 19:51
>
> 2-Nov-14
>
> 1-Jun-14
>
> 2-Nov-14
>
> 15/01/2014 19:57
>
> 1-Jun-14
>
> 13/01/2014 17:10
>
> 15/01/2014 19:47
>
> 18/01/2014 15:44
>
>
>
>
>
>
>
> *From:* Neeraj Chauhan [mailto:neerajchauhan...@gmail.com]
> *Sent:* Thursday, March 27, 2014 4:04 PM
> *To:* 'excel-macros@googlegroups.com'
> *Subject:* help required urgently
>
>
>
> Dear experts,
>
>
>
> We have givne below date format how to convert right format of date like
> 13-Jan-2014
>
>
>
> TT Modified Date & Time
>
> 13/01/2014
>
> 15/01/2014 19:51
>
> 2-Nov-14
>
> 1-Jun-14
>
> 2-Nov-14
>
> 15/01/2014 19:57
>
> 1-Jun-14
>
> 13/01/2014 17:10
>
> 15/01/2014 19:47
>
> 18/01/2014 15:44
>
>
>
>
>
>
>
> [image: Description: Description: image001]
>
> *Neeraj Chauhan*
>
> *+91-9756706350*
>
>
>
>
> --
>
>
> This email is free from viruses and malware because avast! 
> Antivirusprotection is active.
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
<>

Re: $$Excel-Macros$$ Re: Help Required : How i import Data in Excel from DBF File & Get Max voucher Number

[De Premor]

No it's not, that file protected by simple method to prevent user 
opening it they change the file header structure


Try attached DBF, i've repair the header by changing 1st byte on file 
with correct value.


Pada 11/09/2013 21:19, Basole menulis:

Hi, the dbf attachment is corrupted.



Em quarta-feira, 11 de setembro de 2013 05h48min30s UTC-3, rashid 
memon escreveu:


Dear All,


I have a DBF Table containing Vouchers Month wise like

70001 (Dated : 05-July-13)
70002 (Dated : 08-July-13)
80001 (Dated : 02-August-13)


Now i want to get New voucher # by month wise

like :

New # 70003 dated 15-July-13
or New # 80002 dated 18-Aug-13


Kindly Help me in this regards

--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel


FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like 
Please Help, Urgent, Need Help, Formula Problem, Code Problem, and 
Need Advice will not get quick attention or may not be answered.

2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security 
measure.

4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post confidential data in a workbook. Forum owners 
and members are not responsible for any loss.

---
You received this message because you are subscribed to the Google 
Groups "MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send 
an email to excel-macros+unsubscr...@googlegroups.com.

To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group.

To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


0.DBF
Description: Binary data

Re: $$Excel-Macros$$ Re: Help Required

[Aamir Shahzad]

Hi Cheer,

Please use the same mail chain for solution instead of new mail.

Aamir Shahzad

On Fri, Nov 2, 2012 at 5:21 PM, CoRe  wrote:

> Hello Neeraj
>
> CTRL+1  on the value column -->  Custom --> select type *0.00*
>
>
> cheers
>
>
> On Friday, November 2, 2012 2:10:58 PM UTC+2, neeraj chauhan wrote:
>>
>> Dear Experts,
>>
>> kindly find the attached sheet.
>>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>



-- 

Regards,
Aamir Shahzad

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Re: Help Required

[Aamir Shahzad]

Hi Cheer,

Please use the same mail chane for solution instead of new mail.

Aamir Shahzad


On Fri, Nov 2, 2012 at 5:21 PM, CoRe  wrote:

> Hello Neeraj
>
> CTRL+1  on the value column -->  Custom --> select type *0.00*
>
>
> cheers
>
>
> On Friday, November 2, 2012 2:10:58 PM UTC+2, neeraj chauhan wrote:
>>
>> Dear Experts,
>>
>> kindly find the attached sheet.
>>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>



-- 

Regards,
Aamir Shahzad

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Re: help required for creating a formula

[dguillett1]

Core. Please REPLY to messages instead of creating a new one.

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com

From: CoRe 
Sent: Wednesday, May 16, 2012 4:57 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Re: help required for creating a formula

Hello, 

PFA! 



On Wednesday, May 16, 2012 12:48:35 PM UTC+3, ashish damor wrote:
  Dear All, 

  I have a list of industry in one column and in corresponding column 
  the rates as per industry are given. I want to create a formula 
  whereby when i selected a specific industry from the dropdown list 
  automatically the corresponding rate is displayed in next cell. I am 
  enclosing my worksheet. 

  Please help me. 

  Thanks all in advance. 

  -- 
  Thanking you. 

  With regards, 

  Ashish Damor 

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Re: help required for creating a formula

[╰» ℓαℓιт мσαнη]

Dear Ashish

PFA

Regards,
Lalit Mohan
https://www.facebook.com/buzinesstransformation


On Wed, May 16, 2012 at 3:27 PM, CoRe  wrote:
> Hello,
>
> PFA!
>
>
>
> On Wednesday, May 16, 2012 12:48:35 PM UTC+3, ashish damor wrote:
>>
>> Dear All,
>>
>> I have a list of industry in one column and in corresponding column
>> the rates as per industry are given. I want to create a formula
>> whereby when i selected a specific industry from the dropdown list
>> automatically the corresponding rate is displayed in next cell. I am
>> enclosing my worksheet.
>>
>> Please help me.
>>
>> Thanks all in advance.
>>
>> --
>> Thanking you.
>>
>> With regards,
>>
>> Ashish Damor
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


exp_CoRe Solved(Lalit Mohan).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

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

[amrahs k]

Hi,

I have attached a spreadsheet which contains list of document numbers and
their respective names. What I want is I need a word macro that will do the
following.

Note:

The file name will always starts with the Doc Number (5 digits). Ex: 12345
(Refer "Sample_Findlaw.xls" for list of Doc Number)

User will enter the "Name" of the corresponding Doc Number in the word
document.

I need a macro that would populate a message box like "Mismatch between Name
and Doc Number" when they enter wrong name in the word document.

Example:

Consider File Name is "97854Test1.doc" (Refer the spreadsheet
"Sample_Findlaw.xls")
Name for this Doc Number is : New York

If the user enter "Texas" instead of "New York" then the macro would
populate a message box.

Please help me to fix this.

Thanks,
Sharma

On Mon, Nov 1, 2010 at 10:41 AM, amrahs k  wrote:

> Hi,
>
> This is what I actually looking for. It works great and solves my query.
>
> Thanks for your efforts and help.
>
> Regards,
> Sharma
>   On Sun, Oct 31, 2010 at 4:11 AM, roberto mensa wrote:
>
>> the sub test is just one example of how to use the function into a
>> routine.
>>
>> Sub test()
>> Dim s As String
>> s = "AGREEMENT. THE ADOPTION THE ADULT OR MARRIED MINOR "
>> s = ProperCase_r(s)
>> Debug.Print s
>> End Sub
>>
>> r
>>
>> --
>>
>> --
>> 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


97854Test1.doc
Description: MS-Word document


Sample_Findlaw.xls
Description: MS-Excel spreadsheet

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

[amrahs k]

Hi,

This is what I actually looking for. It works great and solves my query.

Thanks for your efforts and help.

Regards,
Sharma
On Sun, Oct 31, 2010 at 4:11 AM, roberto mensa  wrote:

> the sub test is just one example of how to use the function into a routine.
>
> Sub test()
> Dim s As String
> s = "AGREEMENT. THE ADOPTION THE ADULT OR MARRIED MINOR "
> s = ProperCase_r(s)
> Debug.Print s
> End Sub
>
> r
>
> --
>
> --
> 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$$ Re: Help Required!

[roberto mensa]

the sub test is just one example of how to use the function into a routine.

Sub test()
Dim s As String
s = "AGREEMENT. THE ADOPTION THE ADULT OR MARRIED MINOR "
s = ProperCase_r(s)
Debug.Print s
End Sub

r

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

[amrahs k]

Hi,

I meant to say every time I need to change the "S" value as Input which is
taking more time.

I am unable to copy the result since it is showed via message box. I want to
copy the result and updated in documents.

It would be helpful if you could change the code as per the need.(Macro have
to replace the input with the output instead of populating through message
box.)
Thanks,
Sharma
On Thu, Oct 28, 2010 at 3:41 PM, roberto mensa  wrote:

> I don't understand
> which linguage do you use?
> In visual basic as I have proposed is a function you can pass any text and
> use its result
>
>
> regards
> r
>
>
>
>
> 2010/10/28 amrahs k 
>
>>   Hi,
>>
>> This works great. Thanks for your efforts and help. Though I have a small
>> need as well.
>>
>> The code gives the output through message box. Due to this I am unable to
>> copy the value (i.e) Output.
>>
>> Also the code is only execute for the input "AGREEMENT. THE ADOPTION THE
>> ADULT OR MARRIED MINOR". What I need to have is to applicable for any kind
>> of inputs (i.e) the input value is not constant it may change as per the
>> user requirement.
>>
>> Please help me to overcome this and many thanks in advance.
>>
>> Regards,
>> Sharma
>>
>>On Wed, Oct 27, 2010 at 9:49 PM, r  wrote:
>>
>>> try this function:
>>>
>>> Function ProperCase_r( _
>>> ByVal s As String) As String
>>> '__
>>> '¯¯
>>> 'https://sites.google.com/site/e90e50/vbscript/regexp
>>> '__
>>> '¯¯
>>> Dim v, i As Long, x
>>> Dim re As Object
>>> Set re = CreateObject("vbscript.regexp")
>>> re.Global = True
>>>
>>> s = VBA.StrConv(s, vbProperCase)
>>> v = Split("an|a|the|or|and|on|over|abore|" & _
>>>"under|blow|between|near|beside|among", "|")
>>>
>>> For Each x In v
>>>re.Pattern = "\b" & VBA.StrConv(x, vbProperCase) & "\b"
>>>s = re.Replace(s, x)
>>> Next
>>> Debug.Print s
>>> re.Pattern = _
>>> "(^|[.!?]\b|[.!?]\s+\b|\r\b|\f\b|\n\b)(.)"
>>>
>>> ProperCase_r = _
>>> re.Replace(s, "$1§$2§")
>>> v = Split(ProperCase_r, _
>>> "§", , vbTextCompare)
>>> For i = 1 To UBound(v) Step 2
>>> v(i) = VBA.StrConv(v(i), vbUpperCase)
>>> Next
>>> ProperCase_r = Join(v, "")
>>> End Function
>>>
>>> Sub test()
>>> Dim s As String
>>> s = "AGREEMENT. THE ADOPTION THE ADULT OR MARRIED MINOR "
>>> MsgBox ProperCase_r(s)
>>> End Sub
>>>
>>> regards
>>> r
>>>
>>>
>>> On 27 Ott, 11:25, amrahs k  wrote:
>>> > Hi Team,
>>> >
>>> > I want a macro in MS word that will do the following.
>>> >
>>> > It will first convert the upper case into title case and then replace
>>> every
>>> > connecting word with lower case.
>>> >
>>> > *Example:*  AGREEMENT. THE ADOPTION THE ADULT OR MARRIED MINOR
>>> >
>>> > *Required Output:*  Agreement. The Adoption the Adult or Married Minor
>>> >
>>> > *Note:* The connecting word “THE” has been replaced by “the” however
>>> the
>>> > macro left the first connecting word “THE” that followed by dot (.)
>>> >
>>> > Your help would be greatly appreciated.
>>> >
>>> > Thanks,
>>> > Sharma
>>>
>>> --
>>>
>>> --
>>> 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-ma

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

[roberto mensa]

I don't understand
which linguage do you use?
In visual basic as I have proposed is a function you can pass any text and
use its result


regards
r




2010/10/28 amrahs k 

> Hi,
>
> This works great. Thanks for your efforts and help. Though I have a small
> need as well.
>
> The code gives the output through message box. Due to this I am unable to
> copy the value (i.e) Output.
>
> Also the code is only execute for the input "AGREEMENT. THE ADOPTION THE
> ADULT OR MARRIED MINOR". What I need to have is to applicable for any kind
> of inputs (i.e) the input value is not constant it may change as per the
> user requirement.
>
> Please help me to overcome this and many thanks in advance.
>
> Regards,
> Sharma
>
>   On Wed, Oct 27, 2010 at 9:49 PM, r  wrote:
>
>> try this function:
>>
>> Function ProperCase_r( _
>> ByVal s As String) As String
>> '__
>> '¯¯
>> 'https://sites.google.com/site/e90e50/vbscript/regexp
>> '__
>> '¯¯
>> Dim v, i As Long, x
>> Dim re As Object
>> Set re = CreateObject("vbscript.regexp")
>> re.Global = True
>>
>> s = VBA.StrConv(s, vbProperCase)
>> v = Split("an|a|the|or|and|on|over|abore|" & _
>>"under|blow|between|near|beside|among", "|")
>>
>> For Each x In v
>>re.Pattern = "\b" & VBA.StrConv(x, vbProperCase) & "\b"
>>s = re.Replace(s, x)
>> Next
>> Debug.Print s
>> re.Pattern = _
>> "(^|[.!?]\b|[.!?]\s+\b|\r\b|\f\b|\n\b)(.)"
>>
>> ProperCase_r = _
>> re.Replace(s, "$1§$2§")
>> v = Split(ProperCase_r, _
>> "§", , vbTextCompare)
>> For i = 1 To UBound(v) Step 2
>> v(i) = VBA.StrConv(v(i), vbUpperCase)
>> Next
>> ProperCase_r = Join(v, "")
>> End Function
>>
>> Sub test()
>> Dim s As String
>> s = "AGREEMENT. THE ADOPTION THE ADULT OR MARRIED MINOR "
>> MsgBox ProperCase_r(s)
>> End Sub
>>
>> regards
>> r
>>
>>
>> On 27 Ott, 11:25, amrahs k  wrote:
>> > Hi Team,
>> >
>> > I want a macro in MS word that will do the following.
>> >
>> > It will first convert the upper case into title case and then replace
>> every
>> > connecting word with lower case.
>> >
>> > *Example:*  AGREEMENT. THE ADOPTION THE ADULT OR MARRIED MINOR
>> >
>> > *Required Output:*  Agreement. The Adoption the Adult or Married Minor
>> >
>> > *Note:* The connecting word “THE” has been replaced by “the” however the
>> > macro left the first connecting word “THE” that followed by dot (.)
>> >
>> > Your help would be greatly appreciated.
>> >
>> > Thanks,
>> > Sharma
>>
>> --
>>
>> --
>> 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$$ Re: Help Required!

[amrahs k]

Hi,

This works great. Thanks for your efforts and help. Though I have a small
need as well.

The code gives the output through message box. Due to this I am unable to
copy the value (i.e) Output.

Also the code is only execute for the input "AGREEMENT. THE ADOPTION THE
ADULT OR MARRIED MINOR". What I need to have is to applicable for any kind
of inputs (i.e) the input value is not constant it may change as per the
user requirement.

Please help me to overcome this and many thanks in advance.

Regards,
Sharma

On Wed, Oct 27, 2010 at 9:49 PM, r  wrote:

> try this function:
>
> Function ProperCase_r( _
> ByVal s As String) As String
> '__
> '¯¯
> 'https://sites.google.com/site/e90e50/vbscript/regexp
> '__
> '¯¯
> Dim v, i As Long, x
> Dim re As Object
> Set re = CreateObject("vbscript.regexp")
> re.Global = True
>
> s = VBA.StrConv(s, vbProperCase)
> v = Split("an|a|the|or|and|on|over|abore|" & _
>"under|blow|between|near|beside|among", "|")
>
> For Each x In v
>re.Pattern = "\b" & VBA.StrConv(x, vbProperCase) & "\b"
>s = re.Replace(s, x)
> Next
> Debug.Print s
> re.Pattern = _
> "(^|[.!?]\b|[.!?]\s+\b|\r\b|\f\b|\n\b)(.)"
>
> ProperCase_r = _
> re.Replace(s, "$1§$2§")
> v = Split(ProperCase_r, _
> "§", , vbTextCompare)
> For i = 1 To UBound(v) Step 2
> v(i) = VBA.StrConv(v(i), vbUpperCase)
> Next
> ProperCase_r = Join(v, "")
> End Function
>
> Sub test()
> Dim s As String
> s = "AGREEMENT. THE ADOPTION THE ADULT OR MARRIED MINOR "
> MsgBox ProperCase_r(s)
> End Sub
>
> regards
> r
>
>
> On 27 Ott, 11:25, amrahs k  wrote:
> > Hi Team,
> >
> > I want a macro in MS word that will do the following.
> >
> > It will first convert the upper case into title case and then replace
> every
> > connecting word with lower case.
> >
> > *Example:*  AGREEMENT. THE ADOPTION THE ADULT OR MARRIED MINOR
> >
> > *Required Output:*  Agreement. The Adoption the Adult or Married Minor
> >
> > *Note:* The connecting word “THE” has been replaced by “the” however the
> > macro left the first connecting word “THE” that followed by dot (.)
> >
> > Your help would be greatly appreciated.
> >
> > Thanks,
> > Sharma
>
> --
>
> --
> 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