Re: $$Excel-Macros$$ Re: VBA macro - WhatsApp group.

[Manoj Kumar]

Please add my number in what'sup group 9910243729
Thanks
Manoj

On Thu, Aug 11, 2016 at 11:24 AM, Manoj Garg  wrote:

> Please add 9927199217
>
> On Aug 11, 2016 8:51 AM, "Kishore P V K"  wrote:
>
>> Please add 9348264783
>>
>> On Wed, Aug 10, 2016 at 11:50 PM, mukesh kumar > > wrote:
>>
>>> Please add my number 9650590467
>>>
>>> On 8 Aug 2016 9:43 pm, "Rajeev Ranjan" <06raj...@gmail.com> wrote:
>>>
 please add the my number 9811503853

 On Friday, 5 August 2016 14:16:39 UTC+5:30, Prabhu Pinky wrote:
>
> Creating WhatsApp group for VBA macro... Pls msg me your contact, if
> you wants to join.
>
> Add me in WhatsApp and Msg me to - 9500087194
>
> Regards,
> Prabhu.R
>
 --
 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.
>>>
>>
>> --
>> 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
>
> 

$$Excel-Macros$$ want to learn excel VBA

[Manoj Kumar]

Dear Champs

I want to learn excel  VBA so can you send me the notes for the same.

Thanks  Regards
Manoj Kumar

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

$$Excel-Macros$$ Re: Excel Forum available @ discussexcel.com

[manoj kumar]

 Dear members,
   I  want to know the excel  formula's becoz write now i am making the 
 excel database if you have the information plz  send me the  excel 
 formula's.on my email id manoj3...@gmail.com  

 

  Thanks for your active participation in the group. Feel free to write 
 back if you have any feedback

 Best regards,
 Ayush Jain
 Group Manager
 Microsoft MVP


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

RE: $$Excel-Macros$$ Paste special using skip blank

[Manoj Kumar]

Hi Expert

I m not asking for any macro coding. I just want to know is there any sort
cut in excel.

Plz help me on this.

Thanks
Manoj
On Oct 19, 2013 10:16 AM, Ravi Kumar excellearn2...@gmail.com wrote:

 ** **

 Here is the solution…

 ** **

 Sub copypastconstants()

 Range(A1:A8).SpecialCells(xlCellTypeConstants, 2).Copy Range(C1)**
 **

 End Sub

 ** **

 ** **

 * *

 *Warm Regards,*

 *Ravi Kumar.*

 ** **

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *Manoj Kumar
 *Sent:* Friday, October 18, 2013 10:59 PM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ Paste special using skip blank

 ** **

 Hi Team

 Can anyone suggest me that. How can I paste data using skip blank.
 That all the blank cell ignore and data comes in series. 

 Please help me on this.

 Thanks
 Manoj

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


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

Re: $$Excel-Macros$$ Paste special using skip blank

[Manoj Kumar]

Hi Ravi

Thanks you so much. i got it.

Thanks  Regards
Manoj Kumar


On Sat, Oct 19, 2013 at 1:09 PM, Ravi Kumar excellearn2...@gmail.comwrote:

 Dear friend,

 ** **

 ** **

 I had also attached the screen shot of excel shortcut. Please see the
 attached file.

 ** **

 ** **

 * *

 *Warm Regards,*

 *Ravi Kumar.*

 ** **

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *Manoj Kumar
 *Sent:* Saturday, October 19, 2013 12:59 PM
 *To:* excel-macros@googlegroups.com
 *Subject:* RE: $$Excel-Macros$$ Paste special using skip blank

 ** **

 Hi Expert 

 I m not asking for any macro coding. I just want to know is there any sort
 cut in excel. 

 Plz help me on this.

 Thanks
 Manoj

 On Oct 19, 2013 10:16 AM, Ravi Kumar excellearn2...@gmail.com wrote:**
 **

  

 Here is the solution…

  

 Sub copypastconstants()

 Range(A1:A8).SpecialCells(xlCellTypeConstants, 2).Copy Range(C1)**
 **

 End Sub

  

  

 * *

 *Warm Regards,*

 *Ravi Kumar.*

  

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *Manoj Kumar
 *Sent:* Friday, October 18, 2013 10:59 PM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ Paste special using skip blank

  

 Hi Team

 Can anyone suggest me that. How can I paste data using skip blank.
 That all the blank cell ignore and data comes in series. 

 Please help me on this.

 Thanks
 Manoj

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

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

$$Excel-Macros$$ Paste special using skip blank

[Manoj Kumar]

Hi Team

Can anyone suggest me that. How can I paste data using skip blank.
That all the blank cell ignore and data comes in series.

Please help me on this.

Thanks
Manoj

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

$$Excel-Macros$$ Re: Interview Questions with Answers (Excel+VBA+Access+SQL Server)

[Manoj Kumar Singh]

On Thursday, May 10, 2012 4:19:25 AM UTC-7, NOORAIN ANSARI wrote:

 Dear Group,

 Please find attached Interview questions and answers for MS Excel+VBA+MS 
 Access+SQL Server.

 If any one have this type of question and answers, Kindly share with group.


 Thanks ! it really Help to me.

 



 -- 
 Thanks  regards,
 Noorain Ansari
 www.noorainansari.com
 www.excelmacroworld.blogspot.com
  





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

Re: $$Excel-Macros$$ Total Count of Unique ID's

[Manoj Kumar]

Try the below formula:

=SUM(1/COUNTIF(A2:A595,A2:A595))

After entering this formula, you must press *Ctrl-Shift-Enter.* It will
give the desired result*.

*
Best,
Manoj Kumar*
*


On Mon, Sep 23, 2013 at 11:48 AM, Ashish Kumar kumar.ashish...@gmail.comwrote:



 Dear Seniors,


 I want total count of unique User ID's. These are 594 ID's in data. But
 unique is 308. I want only unique user ID's count. and the output is 308
 which i want. kindly help. and find the attachment.

 Thanks,
 Ashish

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


Count - Query_MKV.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Different Validateion

[Manoj Kumar]

Dear Expert,

In validation we select a range and put the text but i want a different
validation.

We can put any value in a cell but when we put No it will be not consider.

Regard
Manoj

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

$$Excel-Macros$$ Error in Excel Report

[Manoj Kumar]

Dear Expert,

Please help to sove my Quiry file attached in mail.

i need fill all data with p how many count in header.

Regard
Manoj

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

Re: $$Excel-Macros$$ Error in Excel Report

[Manoj Kumar]

On Thu, Jul 4, 2013 at 4:47 PM, Manoj Kumar manoj.11...@gmail.com wrote:


 Dear Expert,

 Please help to sove my Quiry file attached in mail.

 i need fill all data with p how many count in header.

 Regard
 Manoj

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




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

Re: $$Excel-Macros$$ Error in Excel Report

[Manoj Kumar]

please see the example what i need


On Thu, Jul 4, 2013 at 5:02 PM, De Premor d...@premor.net wrote:

  On cell C5, paste this =IF($B5=C$3,REPT(p,C$3),0)

 Rgds,
 [dp]
  Pada 04/07/2013 18:19, Manoj Kumar menulis:





 On Thu, Jul 4, 2013 at 4:47 PM, Manoj Kumar manoj.11...@gmail.com wrote:


 Dear Expert,

  Please help to sove my Quiry file attached in mail.

  i need fill all data with p how many count in header.

  Regard
 Manoj
  --
 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.




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

$$Excel-Macros$$ Need City in Blanck Coloume.

[Manoj Kumar]

Dear Expert.

please help to solve query.

regd
Manoj

-- 
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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




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

Re: $$Excel-Macros$$ formula required

[Manoj Kumar]

Dear Prashant,

Please use this..

SUMPRODUCT(($D$2:$D$5=A7)*($G$2:$M$5))

Regard
Manoj

On Mon, Jan 14, 2013 at 12:19 PM, Prashant Pawle ppawle.ex...@gmail.comwrote:

 Dear Team,

 Need a formula to look up a filed  give sum of figure , sample file
 attached

 Regards,

 Prashant

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




-- 
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 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: how to remove space between numbers only.

[Manoj Kumar]

Wow!!

Thank you very much.

Problem solved..

On Wednesday, 2 January 2013 14:10:36 UTC+5:30, Enrique Martin wrote:

 Replace the code with following one. Remember you are concatenating text 
 and Numeric.

 Find attached the updated one


 Function RemoveSpaces(str As String) As String
 Dim myLen As Long
 Dim myChar As String
 Dim myWrd As String
 Dim iCount As Integer
 Dim myGet As String
 Dim myGet1 As String
 myLen = Len(str)
 myWrd = str
 For iCount = 1 To myLen
 myChar = Mid$(myWrd, iCount, 1)
 If IsNumeric(myChar) Then
 myGet = myGet  myChar
 Else
 myGet1 = myGet1  myChar
 End If
 Next iCount
 RemoveSpaces = myGet1  Space(1)  myGet
 End Function


 On Wed, Jan 2, 2013 at 1:45 PM, Francis Mukobi 
 franci...@gmail.comjavascript:
  wrote:

 Beginning to like it in this group. It works but would have preferred if 
 text was returned also

 Francis Mukobi
 Frank Web Hosts
 Your affordable  quality web hosts
 http://frankhost.net

 Phone: +256 752 954 723

 For every domain you purchase from us, we host your website for the first 
 3 months for FREE!

 Manoj Kumar manoj...@gmail.com javascript: wrote:

 Thanks Anoop.
 
 Solved My Problem. but it would be nice if formula also return the name
 along with phone number.
 
 On Wednesday, 2 January 2013 13:17:35 UTC+5:30, Enrique Martin wrote:
 
  Paste the following code in the module. this will extract all the 
 numbers
  removing spaces.
 
  Please see the example in attached file.
 
  Function RemoveSpaces(str As String) As String
  Dim myLen As Long
  Dim myChar As String
  Dim myWrd As String
  Dim iCount As Integer
  Dim myGet As String
  myLen = Len(str)
  myWrd = str
  For iCount = 1 To myLen
  myChar = Mid$(myWrd, iCount, 1)
  If IsNumeric(myChar) Then
  myGet = myGet  myChar
  End If
  Debug.Print myChar
  Next iCount
  RemoveSpaces = myGet
  End Function
 
  Regards,
  Anoop
 
 
  On Wed, Jan 2, 2013 at 1:01 PM, Prince 
  prince...@gmail.comjavascript:wrote:
 
  In this case we need to have a fomula that can count the existence of
  number in the text so in that case we need to modify this formula.
 
  that i let u know how.
 
  Regards
  Prince
 
 
  On Wednesday, January 2, 2013 12:54:34 PM UTC+5:30, Francis Mukobi 
 wrote:
 
  What if it is a list of phone numbers and these numbers have 
 different
  lengths? I mean some phone numbers are from India (10 digits ) and 
 some
  numbers are from say Indonesia (14 digits ) etc. How do I remove 
 spaces
  from such a list of numbers?
 
  Over to you Prince.
 
  Francis Mukobi
  Frank Web Hosts
  Your affordable  quality web hosts
  http://frankhost.net
 
  For every domain purchased from us, we host you for the first 3 
 months
  FREE!
 
  Prince prince...@gmail.com wrote:
 
  Hi Francis,
  
  This formula cut the string from first charactor up the number of
  numeric
  value inside that text i mean i have assumed that numeric value is a
  mobile
  number and every mobile number contains 10 digits in india so i cut 
 the
  last 12 digit including space and concat that with first string 
 that i
  got
  from left.
  
  Regards
  Prince
  
  On Wednesday, January 2, 2013 12:00:56 PM UTC+5:30, Francis Mukobi
  wrote:
  
   Could you please elaborate on the formula you have given, Prince?
  
   Francis Mukobi
   Frank Web Hosts
   Your affordable  quality web hosts
   http://frankhost.net
  
  
   Manoj Kumar manoj...@gmail.com javascript: wrote:
  
   there is some text at end also. Sorry for inconvenience.
   
   
   On Wed, Jan 2, 2013 at 11:20 AM, Prince prince...@gmail.com
 **javascript:
 
   wrote:
   
Hi Manoj,
   
use this this may help you incase if the Number is any Mobile
  number:
   
=MID(A1,1,LEN(A1)-12)**SUBSTITUTE(RIGHT(A1,12), ,)
   
regards
Prince
   
On Wednesday, January 2, 2013 11:04:37 AM UTC+5:30, Manoj Kumar
  wrote:
   
Hi,
   
Is there any way out for removing spaces between numbers only.
  Spaces
between the text should be removed.
   
For example.
   
Manoj Kumar 9015 408 078 Manoj Kumar 9015418078
   
The text at the front is not always fixed. It can contain any
  number
   text
and spaces.
   
Regards,
Manoj
   
 --
Join official Facebook page of this forum @
https://www.facebook.com/**discussexcel
 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

$$Excel-Macros$$ how to remove space between numbers only.

[Manoj Kumar]

Hi,

Is there any way out for removing spaces between numbers only. Spaces 
between the text should be removed.

For example.

Manoj Kumar 9015 408 078 Manoj Kumar 9015418078

The text at the front is not always fixed. It can contain any number text 
and spaces.

Regards,
Manoj

-- 
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 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: how to remove space between numbers only.

[Manoj Kumar]

there is some text at end also. Sorry for inconvenience.


On Wed, Jan 2, 2013 at 11:20 AM, Prince prince141...@gmail.com wrote:

 Hi Manoj,

 use this this may help you incase if the Number is any Mobile number:

 =MID(A1,1,LEN(A1)-12)SUBSTITUTE(RIGHT(A1,12), ,)

 regards
 Prince

 On Wednesday, January 2, 2013 11:04:37 AM UTC+5:30, Manoj Kumar wrote:

 Hi,

 Is there any way out for removing spaces between numbers only. Spaces
 between the text should be removed.

 For example.

 Manoj Kumar 9015 408 078 Manoj Kumar 9015418078

 The text at the front is not always fixed. It can contain any number text
 and spaces.

 Regards,
 Manoj

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

-- 
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 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: how to remove space between numbers only.

[Manoj Kumar]

Thanks Anoop.

Solved My Problem. but it would be nice if formula also return the name 
along with phone number.

On Wednesday, 2 January 2013 13:17:35 UTC+5:30, Enrique Martin wrote:

 Paste the following code in the module. this will extract all the numbers 
 removing spaces.

 Please see the example in attached file.

 Function RemoveSpaces(str As String) As String
 Dim myLen As Long
 Dim myChar As String
 Dim myWrd As String
 Dim iCount As Integer
 Dim myGet As String
 myLen = Len(str)
 myWrd = str
 For iCount = 1 To myLen
 myChar = Mid$(myWrd, iCount, 1)
 If IsNumeric(myChar) Then
 myGet = myGet  myChar
 End If
 Debug.Print myChar
 Next iCount
 RemoveSpaces = myGet
 End Function

 Regards,
 Anoop


 On Wed, Jan 2, 2013 at 1:01 PM, Prince prince...@gmail.com 
 javascript:wrote:

 In this case we need to have a fomula that can count the existence of 
 number in the text so in that case we need to modify this formula.

 that i let u know how.

 Regards
 Prince


 On Wednesday, January 2, 2013 12:54:34 PM UTC+5:30, Francis Mukobi wrote:

 What if it is a list of phone numbers and these numbers have different 
 lengths? I mean some phone numbers are from India (10 digits ) and some 
 numbers are from say Indonesia (14 digits ) etc. How do I remove spaces 
 from such a list of numbers?

 Over to you Prince. 

 Francis Mukobi
 Frank Web Hosts
 Your affordable  quality web hosts 
 http://frankhost.net

 For every domain purchased from us, we host you for the first 3 months 
 FREE!

 Prince prince...@gmail.com wrote:

 Hi Francis,
 
 This formula cut the string from first charactor up the number of 
 numeric 
 value inside that text i mean i have assumed that numeric value is a 
 mobile 
 number and every mobile number contains 10 digits in india so i cut the 
 last 12 digit including space and concat that with first string that i 
 got 
 from left.
 
 Regards
 Prince
 
 On Wednesday, January 2, 2013 12:00:56 PM UTC+5:30, Francis Mukobi 
 wrote:
 
  Could you please elaborate on the formula you have given, Prince?
 
  Francis Mukobi
  Frank Web Hosts
  Your affordable  quality web hosts
  http://frankhost.net
 
 
  Manoj Kumar manoj...@gmail.com javascript: wrote:
 
  there is some text at end also. Sorry for inconvenience.
  
  
  On Wed, Jan 2, 2013 at 11:20 AM, Prince 
  prince...@gmail.com**javascript: 

  wrote:
  
   Hi Manoj,
  
   use this this may help you incase if the Number is any Mobile 
 number:
  
   =MID(A1,1,LEN(A1)-12)**SUBSTITUTE(RIGHT(A1,12), ,)
  
   regards
   Prince
  
   On Wednesday, January 2, 2013 11:04:37 AM UTC+5:30, Manoj Kumar 
 wrote:
  
   Hi,
  
   Is there any way out for removing spaces between numbers only. 
 Spaces
   between the text should be removed.
  
   For example.
  
   Manoj Kumar 9015 408 078 Manoj Kumar 9015418078
  
   The text at the front is not always fixed. It can contain any 
 number 
  text
   and spaces.
  
   Regards,
   Manoj
  
--
   Join official Facebook page of this forum @
   https://www.facebook.com/**discussexcelhttps://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 post to this group, send email to excel-...@googlegroups.com**
 javascript:
  .
   To unsubscribe from this group, send email to
   excel-macros...@googlegroups.**com javascript:.
   Visit this group at http://groups.google.com/**
 group/excel-macros?hl=enhttp://groups.google.com/group/excel-macros?hl=en
 .
  
  
  
  
  
  
  -- 
  Regards,
  Manoj
  
  -- 
  Join official Facebook page of this forum @ 
  https://www.facebook.com/**discussexcelhttps://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

Re: $$Excel-Macros$$ convert excel file to text file

[Manoj Kumar]

but i cant share a document to you. if using dos is this possible.

Thanks
Manoj

On 12/6/12, Paul Schreiner schreiner_p...@att.net wrote:
 There IS a way to get to the data in an excel file without opening it,
 but I've not worked with that much.
 Mainly because it's very convenient to simply have Excel disable display
 updating.
 In which case a macro can open hundreds of excel files and file/save them as

 text files
 in a relatively short period of time.

 To write a macro for this, we'd need to know some things.
 Where are the files you want to process?
 How do you want to identify them?
 (that is:  do you have a specific list of file names, or do you want to
 process
 all files in a specific folder or subfolders)



 Paul
 -
 “Do all the good you can,
 By all the means you can,
 In all the ways you can,
 In all the places you can,
 At all the times you can,
 To all the people you can,
 As long as ever you can.” - John Wesley
 -




 
 From: Manoj Kumar kmrmanoj1...@gmail.com
 To: excel-macros@googlegroups.com
 Sent: Thu, December 6, 2012 12:54:18 PM
 Subject: $$Excel-Macros$$ convert excel file to text file

 Hi Expert

 I want to convert many excel file in text format. So is this possible
 to convert file without open a file or save as options. becouse i have
 to consolidated many excel file in one excel so is this any suggestion
 so please help

 Thanks
 Manoj

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

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




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

$$Excel-Macros$$ convert excel file to text file

[Manoj Kumar]

Hi Expert

I want to convert many excel file in text format. So is this possible
to convert file without open a file or save as options. becouse i have
to consolidated many excel file in one excel so is this any suggestion
so please help

Thanks
Manoj

-- 
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 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$$ Sum required from different sheet..

[Manoj Kumar]

Hi,

Anybody please help me...


Regard
Manoj


On Wed, Nov 7, 2012 at 12:53 PM, Manoj Kumar manoj.11...@gmail.com wrote:

 Dear Expert,

 Please help me ...when I add new sheet (3) it should be change like
 that..SUM('1:3'!B2)

 Regard
 Manoj

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




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




sum from different sheet.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Sum required from different sheet..

[Manoj Kumar]

Sorry for delay...

yes Pravin..

On Wed, Nov 7, 2012 at 6:42 PM, Pravin Gunjal isk1...@gmail.com wrote:

 *you mean to say that the formula should be changed automatically,
 whenever you create a new sheet?
 *

 -- Forwarded message --
 From: Manoj Kumar manoj.11...@gmail.com
 Date: Wed, Nov 7, 2012 at 2:05 PM
 Subject: Re: $$Excel-Macros$$ Sum required from different sheet..
 To: excel-macros@googlegroups.com



 Hi,

 Anybody please help me...


 Regard
 Manoj


 On Wed, Nov 7, 2012 at 12:53 PM, Manoj Kumar manoj.11...@gmail.comwrote:

 Dear Expert,

 Please help me ...when I add new sheet (3) it should be change like
 that..SUM('1:3'!B2)

 Regard
 Manoj

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




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



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




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

Re: $$Excel-Macros$$ inquiry

[Manoj Kumar]

I found it...

Me.Pictures.Visible = False change false to true...
u can see all picture one by one..

Regard
Manoj

On Tue, Nov 6, 2012 at 1:50 PM, DELIN FRANCIS delin_1...@yahoo.co.inwrote:

 Dear Anil,

 if add more names then how can add more pics 
 please tell me the way boss

 regards

 *Delin.F*


   --
 *From:* DELIN FRANCIS delin_1...@yahoo.co.in
 *To:* excel-macros@googlegroups.com excel-macros@googlegroups.com
 *Sent:* Tuesday, 6 November 2012 12:11 PM
 *Subject:* Re: $$Excel-Macros$$ inquiry

 Dear Anil,

 thank you very much

 Its wonder full man 

 and were did you hide the picture


 *Delin.F*

  अनिल नारायण गवली gawlianil8...@gmail.com
 *To:* excel-macros@googlegroups.com; delin_1...@yahoo.co.in
 *Sent:* Tuesday, 6 November 2012 10:50 AM
 *Subject:* Re: $$Excel-Macros$$ inquiry

 Pl find Attached Sheet herewith

 Regards,
 Gawli Anil

 On Tue, Nov 6, 2012 at 12:07 PM, DELIN FRANCIS delin_1...@yahoo.co.inwrote:


  Dear Members,

 is that possible in excel sheets
 if we input a name or some code of person in cell  and i need his / her
 image to pop up in the specified space.

 here i attached file with some ex




 *Delin.F*

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






 --
 Thanks  Regards,
 Gawli Anil Narayan
 Software Developer,
 Abacus Software Services Pvt Ltd
 --
 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.






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

Re: $$Excel-Macros$$ Can cursor will go to cell D1 when we press enter

[Manoj Kumar]

May be this will work for you.

Thanks shekar. It was very helpful to me.

On Sunday, 4 November 2012 05:51:21 UTC+5:30, shekar wrote:

 edit a cell and press enter


 On 3 November 2012 22:10, Rohan Young rohan...@gmail.com javascript:wrote:

 hi raja,

 its not working

 regds



 On Sat, Nov 3, 2012 at 10:03 PM, RAJA SEKAR apkr...@gmail.comjavascript:
  wrote:




 On 3 November 2012 15:44, Pravin Gunjal isk...@gmail.com 
 javascript:wrote:

 *Thanks Kuldeep for your reply.*
 *I want the cursor should go in the cell D1 when the ENTER key is 
 pressed.*
  *
 *
 On Sat, Nov 3, 2012 at 3:35 PM, Kuldeep Singh 
 naukri...@gmail.comjavascript:
  wrote:


 Hi Pravin,

 You want to press enter -- D1,D2,D3 OR, D1,E1,F1,G1

 Regads,
 Kuldeep Singh

 On Sat, Nov 3, 2012 at 3:32 PM, Pravin Gunjal 
 isk...@gmail.comjavascript:
  wrote:

 *Dear Friends,*
 *
 *
 *Is it possible to move the cursor automatically in to the cell D1 
 when we hit the ENTER key.*
 *Please inform.. Thank you.*
 *
 *
 *Regards*
 *Pravin Gunjal*
 *
 *

 -- 
 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-...@googlegroups.comjavascript:
 .
 To unsubscribe from this group, send email to 
 excel-macros...@googlegroups.com javascript:.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en
 .

  -- 
 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-...@googlegroups.comjavascript:
 .
 To unsubscribe from this group, send email to 
 excel-macros...@googlegroups.com javascript:.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
  
  


  -- 
 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-...@googlegroups.comjavascript:
 .
 To unsubscribe from this group, send email to 
 excel-macros...@googlegroups.com javascript:.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
  
  




 -- 
 Making a million friends is not a miracle, the miracle is to make a 
 friend who will stand by you when a 

$$Excel-Macros$$ Recover Excel File

[Manoj Kumar]

Dear Expert,

Please tell me any body how can i Restore my excel file after save...

I save my excel file and closed. can i get old..

Regard
Manoj

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

$$Excel-Macros$$ Need sale report combine with Date, XX Airtel from next sheet'

[Manoj Kumar]

Dear Expert,

Please help me to get the currect ans with attached file..


Regard
Manoj

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




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

Re: $$Excel-Macros$$ Need sale report combine with Date, XX Airtel from next sheet'

[Manoj Kumar]

Anybody Please help me

On Fri, Oct 26, 2012 at 11:59 AM, Manoj Kumar manoj.11...@gmail.com wrote:

 Dear Expert,

 Please help me to get the currect ans with attached file..


 Regard
 Manoj
 --
 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.




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

Re: $$Excel-Macros$$ Need sale report combine with Date, XX Airtel from next sheet'

[Manoj Kumar]

File allready attached...

On Fri, Oct 26, 2012 at 1:02 PM, Amresh Maurya amreshkushw...@gmail.comwrote:

 send me attachment.

 On Fri, Oct 26, 2012 at 1:01 PM, Manoj Kumar manoj.11...@gmail.com
 wrote:
  Anybody Please help me
 
  On Fri, Oct 26, 2012 at 11:59 AM, Manoj Kumar manoj.11...@gmail.com
 wrote:
 
  Dear Expert,
 
  Please help me to get the currect ans with attached file..
 
 
  Regard
  Manoj
  --
  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.
 
 
 
 
  --
  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.
 
 

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




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

Re: $$Excel-Macros$$ Re: Need sale report combine with Date, XX Airtel from next sheet'

[Manoj Kumar]

Thanks yaar..

it realy wonderful, it help me to make report so easy..


On Fri, Oct 26, 2012 at 2:16 PM, Vabz v...@vabs.in wrote:

 PFA

 Cheers//Vabs


 On Friday, October 26, 2012 12:00:00 PM UTC+5:30, Manoj Kumar wrote:

 Dear Expert,

 Please help me to get the currect ans with attached file..


 Regard
 Manoj

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




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

Re: $$Excel-Macros$$ Re: Need sale report combine with Date, XX Airtel from next sheet'

[Manoj Kumar]

hello,,

formula is wrong.


On Fri, Oct 26, 2012 at 2:30 PM, Manoj Kumar manoj.11...@gmail.com wrote:

 Thanks yaar..

 it realy wonderful, it help me to make report so easy..


 On Fri, Oct 26, 2012 at 2:16 PM, Vabz v...@vabs.in wrote:

 PFA

 Cheers//Vabs


 On Friday, October 26, 2012 12:00:00 PM UTC+5:30, Manoj Kumar wrote:

 Dear Expert,

 Please help me to get the currect ans with attached file..


 Regard
 Manoj

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






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

Re: $$Excel-Macros$$ Re: Text need in different collume

[Manoj Kumar]

Please confirm it is possible without macro

Regard
Manoj

On Tue, Oct 23, 2012 at 12:17 PM, Vabz v...@vabs.in wrote:


 Hi

 PFA Att

 It contains various methods..


 Chherz//Vabz

 On Tuesday, October 23, 2012 11:19:06 AM UTC+5:30, Manoj Kumar wrote:

 Dear Expert,


 I have data witch has Text and Number i want to do saperate text and
 number in next collume.

  man25oj  kuma112r  ro444ha25n  25s26on7



 Regard
 Manoj


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




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

Re: $$Excel-Macros$$ Re: Good Laptop to Buy..

[Manoj Kumar]

Hi,

U Can buy Acer Aspire S3-I5..

Regard
Manoj

On Mon, Oct 22, 2012 at 4:49 PM, v...@vabs.in wrote:

 **
 Wooww! Gud input..


 Cheers//Vabs
 Sent on my BlackBerry® from Vodafone
 --
 *From: * CoRe neculae.vale...@gmail.com
 *Date: *Mon, 22 Oct 2012 04:17:49 -0700 (PDT)
 *To: *excel-macros@googlegroups.com
 *Cc: *v...@vabs.in
 *Subject: *Re: Good Laptop to Buy..

 Hello,

 The configuration is oke , video card should be separated not integrated

 and as for company that you should choose , i rather opt for Asus ,Toshiba.




 On Saturday, October 20, 2012 3:03:22 PM UTC+3, Vabz wrote:

 Hi,

 All I want to buy good laptop for my personal use, pl experts suggest on
 it.

 Min. Configuration required:

 4GB Ram, Intel I5, 1TB HD..

 It should be value for money also..

 Which company to go for ..

 Thanks a lot..

 Cheers//Vabs

 Sent on my BlackBerry® from Vodafone

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




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

$$Excel-Macros$$ Re: Text need in different collume

[Manoj Kumar]

Dear Expert,


 I have data witch has Text and Number i want to do saperate text and
 number in next collume.

  man25oj  kuma112r  ro444ha25n  25s26on7



 Regard
 Manoj


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

Re: $$Excel-Macros$$ Abc in a column

[Manoj Kumar]

Hi
it's really work thanks a lots experts.

Regards
Manoj
On Oct 20, 2012 10:05 PM, Manoj Kumar kmrmanoj1...@gmail.com wrote:

 Hi expert

 I want ABC in a  column. So can u help me on this. In a  column ABC from a
 to z.

 Thanks
 Manoj

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




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

$$Excel-Macros$$ Abc in a column

[Manoj Kumar]

Hi expert

I want ABC in a  column. So can u help me on this. In a  column ABC from a
to z.

Thanks
Manoj

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

$$Excel-Macros$$ Fwd: Need formula to update status

[Manoj Kumar]

-- Forwarded message --
From: Manoj Kumar manoj.11...@gmail.com
Date: Thu, Oct 18, 2012 at 12:29 PM
Subject: Need formula to update status
To: excelvbacli...@googlegroups.com


Dear Expert,

Please Find the attachment..

Please provide me a formula to update status in coll F


Regard
Manoj

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




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

Re: $$Excel-Macros$$ Re: Need formula to update status

[Manoj Kumar]

Thanks


On Thu, Oct 18, 2012 at 1:05 PM, Vabz v...@vabs.in wrote:

 Hi

 PFA..
 Cheers..
 Rgds//Vabs
 On Thursday, October 18, 2012 12:32:21 PM UTC+5:30, Manoj Kumar wrote:



 -- Forwarded message --
 From: Manoj Kumar manoj...@gmail.com
 Date: Thu, Oct 18, 2012 at 12:29 PM
 Subject: Need formula to update status
 To: excelvb...@googlegroups.com


 Dear Expert,

 Please Find the attachment..

 Please provide me a formula to update status in coll F


 Regard
 Manoj

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




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

$$Excel-Macros$$ Hard to find Status for me...

[Manoj Kumar]

Dear Expert.

Please help me..
File attached below..

Regard
Manoj

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




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

$$Excel-Macros$$ Re: Introduce Yourself !!

[Manoj Kumar]

Hi,

This is manoj kumar from new delhi..

I am add my new id on this group..

Regard
Manoj

On Saturday, June 9, 2012 12:51:59 AM UTC+5:30, Ayush Jain wrote:

 Hey all new and current posters,
  
 Welcome to excel group,one of the largest online community of excel Fans!
  
 I hope you enjoy your time here  find this forum to be a friendly and 
 knowledgeable community. Please feel free to post a small introduction, a 
 friendly hello or tell us a bit about yourself. Why not tell us where are 
 you from, what you do, what your interests are, how old you are, which is 
 your favourite excel site or blog is or anything else that comes to mind!

 Thanks for your time
 Ayush Jain
 Group Manager
 Microsoft MVP


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

RE: $$Excel-Macros$$ Automation in excel

[Manoj Kumar]

Waiting for reply 
On Oct 10, 2012 11:52 PM, Manoj Kumar kmrmanoj1...@gmail.com wrote:

 Actually I don't know about the coding in vba where I can learn coding for
 vba. I know only record macro.  I want to do coding in my way. What I want
 I get it from my data.

 Thanks
 Manoj
  On Oct 10, 2012 11:20 PM, Rajan_Verma rajanverma1...@gmail.com wrote:

 *Just a quick Example :*

 * *

 ***1)  You are an analyst in Vodafone, you daily receive lot of
 Customer application form on your mail in Excel Sheet, and you want to know
 -*

 ***a.   how many are from Gurgaon, Delhi,Noida ??*

 ***b.  How many are Corporate Connection ?*

 ***c.   Count of different Plans sold?*

 ***d.  And many more questions*

 * *

 *What is the first things comes in mind.. how to get forms data in table
 format to get answers of all questions?*

 * *

 ***2)  You have data in Table format , you want to send Thank
 you note to every customer by mail.*

 ***a.   How much time will you take to convert that data in a
 particular format?*

 ***b.  Will you send every mail one by one ?*

 * *

 *  So , automation is a process to save time and manpower to
 accomplish any task [in office], when you will learn Automation in Excel ,
 you will be able to do this job on a single Click **J***

 * *

 *How this works in excel?*

 *Computer programming skills required to automate excel, Visual basic
 for application (VBA) comes with Excel (office), by which we can manipulate
 excel objects programmatically.*

 * *

 *How will you learn?*

 *Lot of website, forums, online classes are available where you can get
 the sound knowledge about Excel VBA , some of them are below :*

 * *

 *This Forum as well **J***

 *www.ExcelFox.Com*

 *www.excelpoweruser.wordpress.com*

 *http://excelvbaprogramming.wordpress.com/*http://excelvbaprogramming.wordpress.com/
 

 * *

 * *

 *Regards*

 *Rajan verma*

 *+91 7838100659 [IM-Gtalk]*

 * *

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *Manoj Kumar
 *Sent:* 10 October 2012 10:48
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ Automation in excel

 ** **

 Hi experts

 I want to learn automation in excel first of all tell me. What is
 automation. how I use in excel. Please give any notes and suggestions to
 learn. Waiting for reply.

 Thanks
 Manoj

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

  

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





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

$$Excel-Macros$$ Automation in excel

[Manoj Kumar]

Hi experts

I want to learn automation in excel first of all tell me. What is
automation. how I use in excel. Please give any notes and suggestions to
learn. Waiting for reply.

Thanks
Manoj

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

RE: $$Excel-Macros$$ Automation in excel

[Manoj Kumar]

Actually I don't know about the coding in vba where I can learn coding for
vba. I know only record macro.  I want to do coding in my way. What I want
I get it from my data.

Thanks
Manoj
 On Oct 10, 2012 11:20 PM, Rajan_Verma rajanverma1...@gmail.com wrote:

 *Just a quick Example :*

 * *

 ***1)  You are an analyst in Vodafone, you daily receive lot of
 Customer application form on your mail in Excel Sheet, and you want to know
 -*

 ***a.   how many are from Gurgaon, Delhi,Noida ??*

 ***b.  How many are Corporate Connection ?*

 ***c.   Count of different Plans sold?*

 ***d.  And many more questions*

 * *

 *What is the first things comes in mind.. how to get forms data in table
 format to get answers of all questions?*

 * *

 ***2)  You have data in Table format , you want to send Thank you
 note to every customer by mail.*

 ***a.   How much time will you take to convert that data in a
 particular format?*

 ***b.  Will you send every mail one by one ?*

 * *

 *  So , automation is a process to save time and manpower to
 accomplish any task [in office], when you will learn Automation in Excel ,
 you will be able to do this job on a single Click **J***

 * *

 *How this works in excel?*

 *Computer programming skills required to automate excel, Visual basic for
 application (VBA) comes with Excel (office), by which we can manipulate
 excel objects programmatically.*

 * *

 *How will you learn?*

 *Lot of website, forums, online classes are available where you can get
 the sound knowledge about Excel VBA , some of them are below :*

 * *

 *This Forum as well **J***

 *www.ExcelFox.Com*

 *www.excelpoweruser.wordpress.com*

 *http://excelvbaprogramming.wordpress.com/*http://excelvbaprogramming.wordpress.com/
 

 * *

 * *

 *Regards*

 *Rajan verma*

 *+91 7838100659 [IM-Gtalk]*

 * *

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *Manoj Kumar
 *Sent:* 10 October 2012 10:48
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ Automation in excel

 ** **

 Hi experts

 I want to learn automation in excel first of all tell me. What is
 automation. how I use in excel. Please give any notes and suggestions to
 learn. Waiting for reply.

 Thanks
 Manoj

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

  

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




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

Re: $$Excel-Macros$$ St id Reqd on Max Date

[Manoj Kumar]

Dear Viper,

Please can you solve it without erry..please help..

On Fri, Oct 5, 2012 at 11:47 AM, The Viper viper@gmail.com wrote:

 pfa


 On Fri, Oct 5, 2012 at 10:58 AM, Manoj Kumar 
 kumarmanoj.11...@gmail.comwrote:

 Dear Expert,


 Request you to kindly help me on this matter...
 Please find the attachment..

  I want id witch has on max dateeg:- if name1 max date is 3-Oct it
 show 9564




 Regard
 Manoj

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






 --
 *Great day,*
 *viper*

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




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

Re: $$Excel-Macros$$ St id Reqd on Max Date

[Manoj Kumar]

 Thanks to all

On Fri, Oct 5, 2012 at 1:32 PM, Ms-Exl-Learner .
ms.exl.lear...@gmail.comwrote:

 Hi Manoj,

 Go through the below for Non Array Formula Solution.

 *Try this for getting the Maximum Date based on Name*

 =SUMPRODUCT(MAX($A$2:$A$47*($C$2:$C$47=$E2)))

 *Try this for getting the ID based on Maximum Date of a name*


 =SUMPRODUCT(($C$2:$C$47=$E2)*($A$2:$A$47=SUMPRODUCT(MAX($A$2:$A$47*($C$2:$C$47=$E2*($B$2:$B$47))

 Refer the attachment for details.

 Hope that helps!

 Please let us know, in case of any further assistance.

 ---

 

 *Ms.Exl.Learner*
  







 On Fri, Oct 5, 2012 at 11:51 AM, Manoj Kumar 
 kumarmanoj.11...@gmail.comwrote:

 Dear Viper,

 Please can you solve it without erry..please help..


 On Fri, Oct 5, 2012 at 11:47 AM, The Viper viper@gmail.com wrote:

 pfa


 On Fri, Oct 5, 2012 at 10:58 AM, Manoj Kumar kumarmanoj.11...@gmail.com
  wrote:

 Dear Expert,


 Request you to kindly help me on this matter...
 Please find the attachment..

  I want id witch has on max dateeg:- if name1 max date is 3-Oct it
 show 9564




 Regard
 Manoj

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






 --
 *Great day,*
 *viper*

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




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




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

$$Excel-Macros$$ Excel Macro Reqd for Folder to Folder

[Manoj Kumar]

Dear Export,

I have one folder x witch has contain mail's, every mail contain an excel
file,
i want to copy all excel file from folder x to onther folder with
different name..


Regard
Manoj

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

Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder

[Manoj Kumar]

Hi Prince,

X is my folder name witch has many mail's of outlook..every mail has a
excel attachment..

Regard
Manoj

On Wed, Oct 3, 2012 at 12:52 PM, Prince Dubey prince141...@gmail.comwrote:

 Hi Manoj,

 I their any sub folder inside forlder X ?


 Regards
 Prince

 On Wednesday, October 3, 2012 12:47:18 PM UTC+5:30, Manoj Kumar wrote:

 Dear Export,

 I have one folder x witch has contain mail's, every mail contain an
 excel file,
 i want to copy all excel file from folder x to onther folder with
 different name..


 Regard
 Manoj

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




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

Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder

[Manoj Kumar]

Dear vabz,

Thanks.

but it's not working..

Regard
Manoj

On Wed, Oct 3, 2012 at 1:15 PM, Vabz v...@vabs.in wrote:

 Hi

 PFA Files..

 Cheers..

 Rgds//Vabs

 On Wednesday, October 3, 2012 12:47:18 PM UTC+5:30, Manoj Kumar wrote:

 Dear Export,

 I have one folder x witch has contain mail's, every mail contain an
 excel file,
 i want to copy all excel file from folder x to onther folder with
 different name..


 Regard
 Manoj

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




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

Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder

[Manoj Kumar]

Sorry for delay

i have outlook mail save in folder every mail has excel attachment...
i want to extract all excel in onether folder..

Regard
Manoj


On Wed, Oct 3, 2012 at 4:57 PM, Paul Schreiner schreiner_p...@att.netwrote:

 Are you saying that the folders are IN Outlook?
 Not on your filesystem?
 (that is like C:\temp\X)


 *Paul*

 -
 *“Do all the good you can,
 By all the means you can,
 In all the ways you can,
 In all the places you can,
 At all the times you can,
 To all the people you can,
 As long as ever you can.” - John Wesley
 *-


  --
 *From:* Manoj Kumar kumarmanoj.11...@gmail.com
 *To:* excel-macros@googlegroups.com
 *Sent:* Wed, October 3, 2012 3:52:31 AM
 *Subject:* Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder

 Dear vabz,

 Thanks.

 but it's not working..

 Regard
 Manoj

 On Wed, Oct 3, 2012 at 1:15 PM, Vabz v...@vabs.in wrote:

 Hi

 PFA Files..

 Cheers..

 Rgds//Vabs

 On Wednesday, October 3, 2012 12:47:18 PM UTC+5:30, Manoj Kumar wrote:

 Dear Export,

 I have one folder x witch has contain mail's, every mail contain an
 excel file,
 i want to copy all excel file from folder x to onther folder with
 different name..


 Regard
 Manoj

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




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



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




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

Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder

[Manoj Kumar]

now i have a folder in outlook, folder contain many mail, every mail has a
attachment with same name.
i want to save all attachment in my desktop folder with different name..



On Wed, Oct 3, 2012 at 5:54 PM, Paul Schreiner schreiner_p...@att.netwrote:

 OK... I'm going to try one more time.
 Please be CLEAR.

 Are the folders IN OUTLOOK?


 *Paul*

 -
 *“Do all the good you can,
 By all the means you can,
 In all the ways you can,
 In all the places you can,
 At all the times you can,
 To all the people you can,
 As long as ever you can.” - John Wesley
 *-


  --
 *From:* Manoj Kumar kumarmanoj.11...@gmail.com
 *To:* excel-macros@googlegroups.com
 *Sent:* Wed, October 3, 2012 7:34:09 AM

 *Subject:* Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder

 Sorry for delay

 i have outlook mail save in folder every mail has excel attachment...
 i want to extract all excel in onether folder..

 Regard
 Manoj


 On Wed, Oct 3, 2012 at 4:57 PM, Paul Schreiner schreiner_p...@att.netwrote:

   Are you saying that the folders are IN Outlook?
 Not on your filesystem?
 (that is like C:\temp\X)


 *Paul*

 -
 *“Do all the good you can,
 By all the means you can,
 In all the ways you can,
 In all the places you can,
 At all the times you can,
 To all the people you can,
 As long as ever you can.” - John Wesley
 *-


  --
 *From:* Manoj Kumar kumarmanoj.11...@gmail.com
 *To:* excel-macros@googlegroups.com
 *Sent:* Wed, October 3, 2012 3:52:31 AM
 *Subject:* Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder

 Dear vabz,

 Thanks.

 but it's not working..

 Regard
 Manoj

 On Wed, Oct 3, 2012 at 1:15 PM, Vabz v...@vabs.in wrote:

 Hi

 PFA Files..

 Cheers..

 Rgds//Vabs

 On Wednesday, October 3, 2012 12:47:18 PM UTC+5:30, Manoj Kumar wrote:

 Dear Export,

 I have one folder x witch has contain mail's, every mail contain an
 excel file,
 i want to copy all excel file from folder x to onther folder with
 different name..


 Regard
 Manoj

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




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



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

Re: $$Excel-Macros$$ Presentation Vba Code

[Manoj Kumar]

anybody please help me.


On Thu, Sep 27, 2012 at 11:58 AM, Manoj Kumar kumarmanoj.11...@gmail.comwrote:

 Dear Expert,

 i am making Power point presentation i have a macro to do same size of
 all pitcher. but all pitcher showing in different aria.

 i want to do all picture in center of slide...

 Please help.


 Regard
 Manoj

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




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

$$Excel-Macros$$ Need Help in AutoComplete with Custom List

[Manoj Kumar]

Hi,

Is there an way to autocomplete the words from the custom list. When 
someone type the first word, the word should be automatically filled and 
display the rest word in should be in selection.

Regards,
Manoj

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




AutoComplete List.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Re: Need Help in AutoComplete with Custom List

[Manoj Kumar]

Not able to understand clearly. can you please the solution in the attached
file.

On Tue, Sep 25, 2012 at 5:07 PM, Vabz v...@vabs.in wrote:

 Hi

 Please refer link for details:

 Link http://www.ozgrid.com/Excel/autocomplete-validation.htm


 Rgds//Vabs

 On Tuesday, September 25, 2012 3:24:58 PM UTC+5:30, Manoj Kumar wrote:

 Hi,

 Is there an way to autocomplete the words from the custom list. When
 someone type the first word, the word should be automatically filled and
 display the rest word in should be in selection.

 Regards,
 Manoj

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






-- 
Regards,
Manoj9

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




AutoComplete List.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Re: Need Help in AutoComplete with Custom List

[Manoj Kumar]

Thnks for reply. The validation list need to be updated in  regular basis
and also i have very long list and also can not hide too much rows in the
sheet.

Is there any VBA solution for this?

I am looking for quite a long time and but didnot manage to get it.

On Tue, Sep 25, 2012 at 5:40 PM, Swapnil Palande 
palande.swapni...@gmail.com wrote:

 Hi,

 Attached is the solution based on link provided by Vabz. But it only work
 for consecutive cells.

 Other solution is use Data Validation. It will not give you auto
 complete option. It will give you dropdown for cell and user have to select
 value from drop down.

 Regards,

 Swapnil.

 On Tue, Sep 25, 2012 at 5:16 PM, Manoj Kumar manoj.s...@gmail.com wrote:

 Not able to understand clearly. can you please the solution in the
 attached file.


 On Tue, Sep 25, 2012 at 5:07 PM, Vabz v...@vabs.in wrote:

 Hi

 Please refer link for details:

 Link http://www.ozgrid.com/Excel/autocomplete-validation.htm


 Rgds//Vabs

 On Tuesday, September 25, 2012 3:24:58 PM UTC+5:30, Manoj Kumar wrote:

 Hi,

 Is there an way to autocomplete the words from the custom list. When
 someone type the first word, the word should be automatically filled and
 display the rest word in should be in selection.

 Regards,
 Manoj

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






 --
 Regards,
 Manoj9

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




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






-- 
Regards,
Manoj9

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

Re: $$Excel-Macros$$ Re: Need Help in AutoComplete with Custom List

[Manoj Kumar]

Ideally What i want is  I have a long list in one sheet. In other sheet, if
someone enters the data, suggestion should be displayed inform of
autocomplete matching from the sheet. Any solution would be appreciated.

On Tue, Sep 25, 2012 at 7:49 PM, Rajan_Verma rajanverma1...@gmail.comwrote:

 *Can I use your Solution in second column also?*

 * *

 * *

 *Regards*

 *Rajan verma*

 *+91 7838100659 [IM-Gtalk]*

 * *

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *Swapnil Palande
 *Sent:* 25 September 2012 5:40
 *To:* excel-macros@googlegroups.com
 *Subject:* Re: $$Excel-Macros$$ Re: Need Help in AutoComplete with Custom
 List

 ** **

 Hi,

  

 Attached is the solution based on link provided by Vabz. But it only work
 for consecutive cells.

  

 Other solution is use Data Validation. It will not give you auto
 complete option. It will give you dropdown for cell and user have to select
 value from drop down.

  

 Regards,

  

 Swapnil.

 On Tue, Sep 25, 2012 at 5:16 PM, Manoj Kumar manoj.s...@gmail.com wrote:
 

 Not able to understand clearly. can you please the solution in the
 attached file. 

 ** **

 On Tue, Sep 25, 2012 at 5:07 PM, Vabz v...@vabs.in wrote:

 Hi 

 ** **

 Please refer link for details:

 ** **

 Link http://www.ozgrid.com/Excel/autocomplete-validation.htm

 ** **

 ** **

 Rgds//Vabs

 ** **

 On Tuesday, September 25, 2012 3:24:58 PM UTC+5:30, Manoj Kumar wrote: ***
 *

 Hi,

 Is there an way to autocomplete the words from the custom list. When
 someone type the first word, the word should be automatically filled and
 display the rest word in should be in selection.

 Regards,
 Manoj

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

  



 

 -- 

 Regards,

 Manoj9

 ** **

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

  

 ** **

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

Re: $$Excel-Macros$$ subtitute function infirmation required

[Manoj Kumar]

Thanks to all...


On Wed, Sep 19, 2012 at 11:24 AM, Karan Singh karan1...@gmail.com wrote:

 Please find below :

 http://blog.contextures.com/archives/2011/01/28/30-excel-functions-in-30-days-27-substitute/


 Karan Singh




 On Wed, Sep 19, 2012 at 11:23 AM, Kuldeep Singh 
 naukrikuld...@gmail.comwrote:


 Hi see below links:


 http://office.microsoft.com/en-us/excel-help/substitute-function-HP010062578.aspx


 http://www.techonthenet.com/excel/formulas/substitute.php

 Regards,
 Kuldeep Singh

 On Wed, Sep 19, 2012 at 11:17 AM, Manoj Kumar kumarmanoj.11...@gmail.com
  wrote:

 Dear Expert,

 i want know about subtitute. anybody tell me about subtitute function..


 Regard
 Manoj

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


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




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




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

$$Excel-Macros$$ subtitute function infirmation required

[Manoj Kumar]

Dear Expert,

i want know about subtitute. anybody tell me about subtitute function..


Regard
Manoj

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

Re: $$Excel-Macros$$ Need help - To divide the string into three parts

[Manoj Kumar]

Dear Mangesh,

you can use text to colum

Regard
Manoj

On Mon, Sep 10, 2012 at 4:34 PM, Mangesh Vimay mangesh.da...@gmail.comwrote:

 Hi Friends,

 I need your help to divide the string into three parts.
 The description and sample is given below :
 [image: Inline image 1]
 Waiting for your response.

 Thanks.

 --
 With regards,

 *MaNgEsH*

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




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


image.png

$$Excel-Macros$$ help on Power point

[Manoj Kumar]

Dear Expert.


Please tell me how can i re-size all slide in one time..


Regard
Manoj

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

Re: $$Excel-Macros$$ Required Passing formula (More confusing)

[Manoj Kumar]

Dear amar,

Please tell what is passing marks...

Regard
Manoj

On Wed, Sep 5, 2012 at 1:06 PM, amar takale amartak...@gmail.com wrote:

 Hi All Experts,
 Pl solved challenging formula for passing.

 Appreciate the help very much

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




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

Re: $$Excel-Macros$$ Required Passing formula (More confusing)

[Manoj Kumar]

Dear Amar,

Please Use it...

=IF(OR(F11$F$10,G11$G$10,H11$H$10,I11$I$10,J11$J$10,K11$K$10,L11$L$10),Failed,Pass)


Regard
Manoj

On Wed, Sep 5, 2012 at 1:10 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote:

 Dear amar,

 Please tell what is passing marks...

 Regard
 Manoj

 On Wed, Sep 5, 2012 at 1:06 PM, amar takale amartak...@gmail.com wrote:

 Hi All Experts,
 Pl solved challenging formula for passing.

 Appreciate the help very much

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






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

Re: $$Excel-Macros$$ Required Passing formula (More confusing)

[Manoj Kumar]

Dear Amar,

Please Use it...

=IF(OR(F11$F$10,G11$G$10,H11$H$10,I11$I$10,J11$J$10,K11$K$10,L11$L$10),Failed,Pass)

you can use conditional formatting to change color.

Regard


On Wed, Sep 5, 2012 at 1:20 PM, amar takale amartak...@gmail.com wrote:

 Hi manoj,
 If  failed minmum one subject then show failed (required output in yellow)
 (looking Minmum marks on Row numbers 10) F10:L10.
 If anyone got marks less than minimum marks then show failed.

 On Wed, Sep 5, 2012 at 1:10 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote:

 Dear amar,

 Please tell what is passing marks...

 Regard
 Manoj

 On Wed, Sep 5, 2012 at 1:06 PM, amar takale amartak...@gmail.com wrote:

 Hi All Experts,
 Pl solved challenging formula for passing.

 Appreciate the help very much

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




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




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




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

Re: $$Excel-Macros$$ Required Passing formula (More confusing)

[Manoj Kumar]

Dear Amar,

Please find the attachment.. hope it will help you..


Regard
Manoj

On Wed, Sep 5, 2012 at 1:43 PM, amar takale amartak...@gmail.com wrote:

 Hi Manoj,
 Now I attached sheet.See it


 On Wed, Sep 5, 2012 at 1:42 PM, amar takale amartak...@gmail.com wrote:

 Hi Manoj,
 This is valuable formula for me,Thanks for it.But I think it is also show
 in short formula but now I forget it how to use it.I attached sheet with
 your formula. Can you solved little more solution for Grade, I show Grade
 table in sheet.

 Thanks for your valuable time.
 Pls see it

 Thank you in advance for your help!
 Pls 

 Amar


 On Wed, Sep 5, 2012 at 1:20 PM, amar takale amartak...@gmail.com wrote:

 Hi manoj,
 If  failed minmum one subject then show failed (required output in
 yellow) (looking Minmum marks on Row numbers 10) F10:L10.
 If anyone got marks less than minimum marks then show failed.

 On Wed, Sep 5, 2012 at 1:10 PM, Manoj Kumar 
 kumarmanoj.11...@gmail.comwrote:

 Dear amar,

 Please tell what is passing marks...

 Regard
 Manoj

 On Wed, Sep 5, 2012 at 1:06 PM, amar takale amartak...@gmail.comwrote:

 Hi All Experts,
 Pl solved challenging formula for passing.

 Appreciate the help very much

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




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






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




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

Re: $$Excel-Macros$$ How to count the items except repetition

[Manoj Kumar]

Dear Amresh,

if we need unique agency and unique city how can we find...


Regard
Manoj

On Wed, Sep 5, 2012 at 11:04 AM, Amresh Maurya amreshkushw...@gmail.comwrote:

 Hi Pravin,

 find the attached solution.

 use this small formula.

 =COUNTA(C3:C39)

 Regards
 Amresh


 On Wed, Sep 5, 2012 at 10:50 AM, Pravin Gunjal isk1...@gmail.com wrote:

 Dear Friends,

 Greetings !

 Request for your help on the subject matter.

 I have attached the file for your reference, in which there are two
 different rows which are having repetition entries and I need to count them
 without deleting the records/ any of the rows.

 Thank you.

 Regards,
 Pravin Gunjal.

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




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




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

Re: $$Excel-Macros$$ Lookup data when there are repeated data with diff amt

[Manoj Kumar]

Dear Rakesh,


Use *=SUMIFS(Sheet1!$D$2:$D$18,Sheet1!$B$2:$B$18,A2)*


Regd
Manoj

On Mon, Sep 3, 2012 at 1:00 PM, Rakesh Kumar Sharma
rakeshks@gmail.comwrote:

 Hi Experts,

 I need the actual remit amt agnst tracking on sheet2 when data was found
 repeated on sheet1 with positive or nigative amt.
 See the attachment...



 --
 Regards,

 Rakesh Kumar Sharma
 Contact: +91-9971024741


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




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

$$Excel-Macros$$ Need Help

[Manoj Kumar]

Dear Expert,

Please help me to find rank in attached file..


Regard
Manoj

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




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

Re: $$Excel-Macros$$ Need Help

[Manoj Kumar]

Dear Pravin,

Please provide ans..

Regard
Manoj

On Mon, Sep 3, 2012 at 4:15 PM, Pravin Gunjal isk1...@gmail.com wrote:

 Pl use a meaningful subject for immediate response on your issues


 On Mon, Sep 3, 2012 at 3:59 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote:

 Dear Expert,

 Please help me to find rank in attached file..


 Regard
 Manoj

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




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




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

Re: $$Excel-Macros$$ Need Help

[Manoj Kumar]

Thanks for all

Amresh's formula is ok for me..

Regard
manoj

On Mon, Sep 3, 2012 at 4:39 PM, Amresh Maurya amreshkushw...@gmail.comwrote:

 Hi Manoj,

 Find the attached file.

 use this formula hope it will help you.

 =RANK(B2,$B$1:$B$6,0)

 if you need anything else Pls explain properly.

 Regards
 Amresh


 On Mon, Sep 3, 2012 at 4:30 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote:

 Dear Pravin,

 Please provide ans..

 Regard
 Manoj


 On Mon, Sep 3, 2012 at 4:15 PM, Pravin Gunjal isk1...@gmail.com wrote:

 Pl use a meaningful subject for immediate response on your issues


 On Mon, Sep 3, 2012 at 3:59 PM, Manoj Kumar 
 kumarmanoj.11...@gmail.comwrote:

 Dear Expert,

 Please help me to find rank in attached file..


 Regard
 Manoj

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




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




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




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

Re: $$Excel-Macros$$ Need Help

[Manoj Kumar]

Dear Kuldeep,

Amresh put formule in value but i change range in percentage it's working..

Regard
Manoj

On Mon, Sep 3, 2012 at 4:45 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote:

 Thanks for all

 Amresh's formula is ok for me..

 Regard
 manoj

 On Mon, Sep 3, 2012 at 4:39 PM, Amresh Maurya amreshkushw...@gmail.comwrote:

 Hi Manoj,

 Find the attached file.

 use this formula hope it will help you.

 =RANK(B2,$B$1:$B$6,0)

 if you need anything else Pls explain properly.

 Regards
 Amresh


 On Mon, Sep 3, 2012 at 4:30 PM, Manoj Kumar 
 kumarmanoj.11...@gmail.comwrote:

 Dear Pravin,

 Please provide ans..

 Regard
 Manoj


 On Mon, Sep 3, 2012 at 4:15 PM, Pravin Gunjal isk1...@gmail.com wrote:

 Pl use a meaningful subject for immediate response on your issues


 On Mon, Sep 3, 2012 at 3:59 PM, Manoj Kumar kumarmanoj.11...@gmail.com
  wrote:

 Dear Expert,

 Please help me to find rank in attached file..


 Regard
 Manoj

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




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




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




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

Re: $$Excel-Macros$$ Need Help

[Manoj Kumar]

ok kuldeep it's my mistake...cell N4 value is wrong...

Regard
Manoj

On Mon, Sep 3, 2012 at 4:47 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote:

 Dear Kuldeep,

 Amresh put formule in value but i change range in percentage it's working..

 Regard
 Manoj


 On Mon, Sep 3, 2012 at 4:45 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote:

 Thanks for all

 Amresh's formula is ok for me..

 Regard
 manoj

 On Mon, Sep 3, 2012 at 4:39 PM, Amresh Maurya 
 amreshkushw...@gmail.comwrote:

 Hi Manoj,

 Find the attached file.

 use this formula hope it will help you.

 =RANK(B2,$B$1:$B$6,0)

 if you need anything else Pls explain properly.

 Regards
 Amresh


 On Mon, Sep 3, 2012 at 4:30 PM, Manoj Kumar 
 kumarmanoj.11...@gmail.comwrote:

 Dear Pravin,

 Please provide ans..

 Regard
 Manoj


 On Mon, Sep 3, 2012 at 4:15 PM, Pravin Gunjal isk1...@gmail.comwrote:

 Pl use a meaningful subject for immediate response on your issues


 On Mon, Sep 3, 2012 at 3:59 PM, Manoj Kumar 
 kumarmanoj.11...@gmail.com wrote:

 Dear Expert,

 Please help me to find rank in attached file..


 Regard
 Manoj

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




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




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




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

$$Excel-Macros$$ Need help

[Manoj Kumar]

Hi,

Please help me to collect data in attached file..


Regard
Manoj

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




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

Re: $$Excel-Macros$$ Need help

[Manoj Kumar]

i need the formula witch divide randomly A3, in cell A4 to A8
when i add A4 to A8 it show 200..


On Wed, Aug 22, 2012 at 3:01 PM, Pravin Gunjal isk1...@gmail.com wrote:

 *Dear Mr. Manoj*
 *
 *
 *Type the value first to get the total.*
 * *

  *With regards,
 **Pravin Gunjal**
 *


 On Wed, Aug 22, 2012 at 2:50 PM, Manoj Kumar 
 kumarmanoj.11...@gmail.comwrote:

 Hi,

 Please help me to collect data in attached file..


 Regard
 Manoj

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




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




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

Re: $$Excel-Macros$$ Need help

[Manoj Kumar]

But in next coll my range is increasing

Regard
Manoj

On Wed, Aug 22, 2012 at 3:49 PM, Ms-Exl-Learner .
ms.exl.lear...@gmail.comwrote:

 Type or copy and paste the below formula in A4 cell.

 A4 cell
 =A$3/5

 Drag the A4 cell formula upto A8 cell and drag it to the right if required.

 ---
 Ms.Exl.Learner
 ---



 On Wed, Aug 22, 2012 at 3:41 PM, Manoj Kumar 
 kumarmanoj.11...@gmail.comwrote:

 i need the formula witch divide randomly A3, in cell A4 to A8
 when i add A4 to A8 it show 200..


 On Wed, Aug 22, 2012 at 3:01 PM, Pravin Gunjal isk1...@gmail.com wrote:

 *Dear Mr. Manoj*
 *
 *
 *Type the value first to get the total.*
 * *

  *With regards,
 **Pravin Gunjal**
 *


 On Wed, Aug 22, 2012 at 2:50 PM, Manoj Kumar kumarmanoj.11...@gmail.com
  wrote:

 Hi,

 Please help me to collect data in attached file..


 Regard
 Manoj

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




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




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



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

Re: $$Excel-Macros$$ Need help

[Manoj Kumar]

Many many Thanks for solution...

On Wed, Aug 22, 2012 at 4:23 PM, Ms-Exl-Learner .
ms.exl.lear...@gmail.comwrote:

 For Macro Solution Try the below code

 Option Explicit
 Sub SplitNumber()
 Dim i As Long, j As Long, EndCol As Long

 EndCol = Range(A2).CurrentRegion.Rows(1).Cells.Count

 For i = 1 To EndCol
 For j = 1 To Cells(2, i).Value
 Cells(3 + j, i).Value = Cells(3, i).Value / Cells(2, i).Value
 Next j
 Next i
 End Sub

 ---
 Ms.Exl.Learner
 ---


 On Wed, Aug 22, 2012 at 2:50 PM, Manoj Kumar 
 kumarmanoj.11...@gmail.comwrote:

 Hi,

 Please help me to collect data in attached file..


 Regard
 Manoj

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



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




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

Re: $$Excel-Macros$$ is that is sunday

[Manoj Kumar]

Hi Sundarvelan,

Tri it..

=Text(a1,ddd)

Regard
Manoj

On Fri, Aug 17, 2012 at 3:12 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:


 Hi Sundarvelan,

 Please share a sample worksheet.

 Regards,
 Kuldeep Singh


 On Fri, Aug 17, 2012 at 3:09 PM, Sundarvelan N nsund...@gmail.com wrote:

 Dear friends,

 I need to find is the date in the cell is sunday

 8/3/2012 10:30 8/3/2012 11:47  8/3/2012 10:26  8/3/2012 10:03  8/3/2012
 11:09  8/3/2012 10:55 8/4/2012 10:57  8/3/2012 16:17  8/3/2012 14:21  
 8/3/2012
 11:29  8/3/2012 11:28  8/3/2012 11:53  8/3/2012 14:33
 Thanks
 N.Sundarvelan
 9600160150

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

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




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

$$Excel-Macros$$ Barcode

[Manoj Kumar]

Dear group

I want to make a barcode in excel. So i how make a barcode plz help me on
this.

Thanks
Manoj

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

Re: $$Excel-Macros$$ Barcode

[Manoj Kumar]

Thanks dear

Manoj
On Aug 9, 2012 8:58 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote:

 Dear Manoj,

 One easy way to create bar code in excel

 Please visit here
 http://strokescribe.com/en/create-barcode-excel-2007-activex.html

 On Thu, Aug 9, 2012 at 8:31 PM, Manoj Kumar kmrmanoj1...@gmail.comwrote:

 Dear group

 I want to make a barcode in excel. So i how make a barcode plz help me on
 this.

 Thanks
 Manoj

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






 --
 With Regards,
 Noorain Ansari
 http:// 
 http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com
 http:// 
 http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/


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




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

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

[Manoj Kumar]

*Cong Noorain! Ji*

On Sat, Aug 4, 2012 at 4:16 AM, dguillett1 dguille...@gmail.com wrote:

   Good work!

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

  *From:* Ayush Jain jainayus...@gmail.com
 *Sent:* Friday, August 03, 2012 12:40 PM
 *To:* excel-macros excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

  Dear members,

 Noorain Ansari has been selected as 'Most Helpful Member' for the month of
 July'12. He has posted 143 posts in July 2012 and helped many forum members
 through his excel expertise.

 I truly appreciate his consistency and commitment to the group. He is
 really doing great job.

 Thanks to Don, Deba Ranjan, Magnesh, Ashish, Rajan, bpascal, Prince,
 Sunita and other folks for helping excel enthusiasts voluntarily !!
 Keep posting.

 Regards,
 Ayush Jain
 Group Manager
 Microsoft MVP
 --
 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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Can anybody tell me about Indirect

[Manoj Kumar]

Hi,

Please provide value from use Indirect..



Regard
Manoj

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




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

Re: $$Excel-Macros$$ conditional formatting

[Manoj Kumar]

Dear Smitha,

Please find the attachment..

it will help you...

Regard
Manoj

On Thu, Jul 26, 2012 at 11:44 AM, Smitha S R sperdwo...@gmail.com wrote:

 Hi,

 Please help in conditional formatting or use of if formula in the
 following case. Excel attached.

   Closing Stock Verification stock required  1 1 if closing
 Stock=Verification Stock blue colour should be filled in cell B3  5 4 if
 closing StockVerification Stock  green colour should be filled in cell B4
 3 5 if closing StockVerification Stock yellow  colour should be filled
 in cell B5

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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




fill colour.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Please provide me Excel 2003 2007 Short Key

[Manoj Kumar]

Hi.

Please provide me Excel 2003  2007 Short Key

Regard
Manoj

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Please provide me Excel 2003 2007 Short Key

[Manoj Kumar]

Thanks dear..€.

On Thu, Jul 19, 2012 at 12:50 AM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:

 Dear Manoj,

 Please find attached short cut for excel 2003,2007 and 2010.


 On Thu, Jul 19, 2012 at 1:18 PM, Manoj Kumar 
 kumarmanoj.11...@gmail.comwrote:

 Hi.

 Please provide me Excel 2003  2007 Short Key

 Regard
 Manoj

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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com






 --
 Thanks  regards,
 Noorain Ansari
 www.noorainansari.com
 www.excelvbaclinic.blogspot.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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Help Me

[Manoj Kumar]

Thanks Noorain Ji...

On Mon, Jul 16, 2012 at 3:39 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:

 Dear Manoj,

 Please try it.


 =INDEX(Data!$B$2:$I$13,MATCH(B$1,Data!$A$2:$A$13,0),MATCH($A2,Data!$B$1:$I$1,0))


 --
 Thanks  regards,
 Noorain Ansari
 www.noorainansari.com
 www.excelmacroworld.blogspot.com



 On Mon, Jul 16, 2012 at 3:26 PM, Manoj Kumar 
 kumarmanoj.11...@gmail.comwrote:

 Dear Expert,

 Please help me to make report
 I have data in 1 sheet I want make report in sheet 2.

 Regard
 Manoj

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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Help Me

[Manoj Kumar]

Dear Kuldeep,

thanks..


I need function witch I already provide by Noorain...



On Mon, Jul 16, 2012 at 3:47 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:


 Hi,

 Use this

 Regards,
 Kuldeep Singh
 Info Edge India Limited (naukri.com)
 naukrikuld...@gmail.com || www.naukri.com
 *Please* *Consider the environment. Please don't print this e-mail unless
 you really need to.*


 On Mon, Jul 16, 2012 at 3:41 PM, Manoj Kumar 
 kumarmanoj.11...@gmail.comwrote:

 Thanks Noorain Ji...


 On Mon, Jul 16, 2012 at 3:39 PM, NOORAIN ANSARI noorain.ans...@gmail.com
  wrote:

 Dear Manoj,

 Please try it.


 =INDEX(Data!$B$2:$I$13,MATCH(B$1,Data!$A$2:$A$13,0),MATCH($A2,Data!$B$1:$I$1,0))


 --
 Thanks  regards,
 Noorain Ansari
 www.noorainansari.com
 www.excelmacroworld.blogspot.com



 On Mon, Jul 16, 2012 at 3:26 PM, Manoj Kumar kumarmanoj.11...@gmail.com
  wrote:

 Dear Expert,

 Please help me to make report
 I have data in 1 sheet I want make report in sheet 2.

 Regard
 Manoj

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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@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

Re: $$Excel-Macros$$ Please help me.

[Manoj Kumar]

Thanks Noorain Ji...
its working..


On Wed, Jul 11, 2012 at 1:28 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:

 Dear Manoj,

 You can also try
 =IF(ISERROR(SEARCH(C9,B9))=TRUE,Not Found,Found)

 On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar 
 kumarmanoj.11...@gmail.comwrote:

 Dear Expert.

 i have 2 Coll A1  B2

 A1 Contain (Foto Fast Elec)
 B1 Contain (Fast)

 I want khow B1 is in A1 or not...

 Regard
 Manoj

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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com




 --
 Thanks  regards,
 Noorain Ansari
 www.noorainansari.com
 www.excelmacroworld.blogspot.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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Text - Splitting - Help Required through Formula

[Manoj Kumar]

Dear Jp.

find the attachment...

i hope it will help you..

Regard
Manoj

On Wed, Jul 11, 2012 at 5:38 PM, Jayaprakash S
bhat.jayaprak...@gmail.comwrote:

 Dear Deba Rajan Sir,

 thank you... Your formula is working fine except for

 Baddi to Sunder Nagar Case..

 Any updation in your formula

 thank you.

 Jp.


 On Wed, Jul 11, 2012 at 5:31 PM, Deba Ranjan drdeva...@gmail.com wrote:

 Dear Jaya,

  You can also use:-
 First Word:-
 =IFERROR(LEFT(A3,FIND( ,A3,1)),)

 Second word-
 =TRIM(IFERROR(LEFT(RIGHT(A3,LEN(A3)-FIND( ,A3,1)),FIND(
 ,RIGHT(A3,LEN(A3)-FIND( ,A3,1,))
 Third word:-
 =RIGHT(A3,LEN(A3)-FIND(#,SUBSTITUTE(A3,
 ,#,LEN(A3)-LEN(SUBSTITUTE(A3, ,)



 Thanks  Regards,
 *Deba Ranjan P*


  


 On Wed, Jul 11, 2012 at 5:26 PM, Manoj Kumar 
 kumarmanoj.11...@gmail.comwrote:

 Dear JP,

Select the range Press ALT+D+E Click Delimited Next Click Space Click
 Finish
 Regard
 Manoj


 On Wed, Jul 11, 2012 at 5:20 PM, Jayaprakash S 
 bhat.jayaprak...@gmail.com wrote:

 Dear Masters,

 Greetings!!

 Could you please help me to split the Text thruough a Formula for the
 attached example...


 Thank you.

 JP.

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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com




 --
 Regards, Jayaprakash. S (JAYAPRAKASH. S.) Adaptability is the most
 desirable habit for success - Swamy Vivekananda. This message is for
 the designated recipient only and may contain privileged, proprietary,
 or otherwise private information. If you have received it in error,
 please notify the sender immediately and delete the original. Any other
 use of the email by you is prohibited.

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

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

[Manoj Kumar]

Dear Sudhir


Please find the attachment...


Regard
Manoj

On Mon, Jul 2, 2012 at 10:58 AM, SUDHIR VERMA newinex...@gmail.com wrote:

 Dear All,

 Please look at attachment and help me.


 thanking u

 Regards


 Sudhir

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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

Re: $$Excel-Macros$$ Re: Help in Access

[Manoj Kumar]

where is the option of Tab_Data...



On Fri, Jun 29, 2012 at 3:37 PM, Lalit_Mohan mohan.pande...@gmail.comwrote:

 HI Manoj,

 You can try this query in database may be it helps you

 select id from Tab_Data GROUP BY id

 (where id is the field name and Tab_Data is table name. you can add more
 columns to it just by adding column name with , and the same column in
 group by seperated by ,)

 Regards,
 Lalit Mohan

 On Friday, 29 June 2012 15:14:18 UTC+5:30, Manoj Kumar wrote:

 Dear Experts,


 I have data in month wise data in Access in different query..
 Please help me to find unique id From DATA in attached file..



 Regard
 Manoj

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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Re: Help in Access

[Manoj Kumar]

Sorry for delay

Thanks Dear...

On Sat, Jun 30, 2012 at 12:51 AM, Prince Dubey prince141...@gmail.comwrote:

 Hi manoj,

 Please Use this I hope this will work for you..


 SELECT distinct [Store ID]
 FROM [Acer All Data];

 union


 SELECT distinct [Store ID]
 FROM [Mar'12];
 union
 SELECT distinct [Store ID]
 FROM [Apr'12];
 union
 SELECT distinct [Store ID]
 FROM [May'12];

 Regards
 Prince Dubey.




 On Friday, 29 June 2012 15:14:18 UTC+5:30, Manoj Kumar wrote:

 Dear Experts,


 I have data in month wise data in Access in different query..
 Please help me to find unique id From DATA in attached file..



 Regard
 Manoj

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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Excel Q A

[Manoj Kumar]

Tkanks Krishna

On Thu, Jun 21, 2012 at 12:09 PM, Maries talk2mar...@gmail.com wrote:

 Nice Collection Thanks


 On Wed, Jun 20, 2012 at 9:11 PM, Anil Gawli gawlianil8...@gmail.comwrote:

 Hi Krishna,

 Thanks 4 sharing ...

 Regards,
 Gawli Anil

 On Wed, Jun 20, 2012 at 8:35 PM, NOORAIN ANSARI noorain.ans...@gmail.com
  wrote:

 Nice collection, Kirshna

 Thanks to sharing with group.

 --
 Thanks  regards,
 Noorain Ansari
 www.noorainansari.com
 www.excelmacroworld.blogspot.com

  On Wed, Jun 20, 2012 at 6:50 PM, Krishnaraddi excelkris...@in.comwrote:

 Hi Experts,

 I have collected few questions regarding excel and updated in single
 document. I have also attached answers in separate excel sheet.

 I hope this will help few who are learning Excel.



 Dear *excel-macros !* Get Yourself a cool, short *@in.com* Email ID
 now!http://www3.in.com/sso/commonregister.php?ref=INutm_source=inviteutm_medium=outgoing

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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com




 --
 Thanks  Regards,
 Gawli Anil Narayan
 Software Developer,
 Abacus Software Services Pvt Ltd

 --
 -- 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 To
 unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com




 --
 *
 *
 *  MARIES*
 Excel Inspiration http://xcel-inspiration.blogspot.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 To
 unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com


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

1) Use 

Re: $$Excel-Macros$$ Progress Bas for macro status - Help Required

[Manoj Kumar]

Dear Avinash.


Sub gg()

For a = 1 To Sheets.Count
Sheets(a).Activate
Range(a1:dd5).Select

Selection.Font.Bold = True


Next

End Sub

Regard
Manoj


On Sun, Jun 17, 2012 at 11:39 PM, Avinash avinash007pa...@gmail.com wrote:

 Dear Experts,

 I have 1 workbook and there are 10 subsheets in that workbook.
 i have created 1 macro to format those 10 subsheets.

 every sheet does have different formatting e.g. sheet 1 bold text for row 1
 and and sheet 2 bold italic text for row 2.

 so now i want macro to show the progress bar (progress bar should be VBA
 USERFORM ) in % which shows me how much formatting is completed like after
 sheet 1 formatting progress bar should show 10% completed after sheet 2 it
 should show 20%

 and after all formatting done it should say 100% with how much time taken
 for formatting all thease sheets.

 Please help me in this as i want to incorporate the same type of macro in
 other projects.

 My macro style

 Sub Formatting ()

 Step1
 format sheet 1

 Step2
 format sheet 2

 Step3
 format sheet 3

 Step4
 format sheet 4

 Step5
 format sheet 5

 Step6
 format sheet 6

 Step7
 format sheet 7

 Step7
 format sheet 7

 Step8
 format sheet 8

 Step9
 format sheet 9

 Step10
 format sheet 10


 End Sub



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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ formula

[Manoj Kumar]

thanks to all its very usefull for me..

On 1/17/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
 Most Welcome Darwin..

 On Tue, Jan 17, 2012 at 9:59 AM, Darwin Chan
 darwin.chankaw...@gmail.comwrote:

 Thanks for Noorain reading notes, some tricks i even dun know.


 2012/1/17 NOORAIN ANSARI noorain.ans...@gmail.com

 Dear Manoj,

 Please study attached material and follow this Excel-Macro group
 regularly.

 Hope it will help to u
 --
 Thanks  regards,
 Noorain Ansari

 *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
 *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/

 On Mon, Jan 16, 2012 at 11:51 PM, Manoj Kumar
 kmrmanoj1...@gmail.comwrote:

 Hello Members

 i want grow my excel formula knowledge.  Please provide help and some
 notes .

 regards
 Manoj

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




 --
 Darwin Chan
 darwin.chankaw...@gmail.com
 kw42c...@yahoo.com.hk

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




 --
 Thanks  regards,
 Noorain Ansari
 *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
 *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.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


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

$$Excel-Macros$$ formula

[Manoj Kumar]

Hello Members

i want grow my excel formula knowledge.  Please provide help and some notes .

regards
Manoj

-- 
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$$ Advance HappyChristmas

[Manoj Kumar]

merry christmas to all

regards
manoj

On 12/23/11, sunil bn bnsuni...@gmail.com wrote:
 Hi Friends,
 Happy Merry Christmas In Advance...[?][?]

 --
 [image]
 *Regards*
 **Sunil B.N
 ***9035858585
 [image]

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

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
 not get quick 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 (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick 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
343.gif360.gif

Re: $$Excel-Macros$$ MIS Opening

[Manoj Kumar]

Dear Sir,

Thanks for your suggestion...

Regards
Manoj

On Mon, Aug 29, 2011 at 7:10 PM, Manoj Kumar kmrmanoj1...@gmail.com wrote:

 Dear Sir,

 Please find the attached CV in this mail, and revert for the same ASAP.

 Regards
 Manoj Kumar


 On 8/25/11, Rahul Gandhi myname.ra...@gmail.com wrote:
  I Have 2 Off-roll Opening with me, One in Videocon as an Off-roll
  Employee and One in Master Franchisee of United Colors of Benetton.
 
  Package 2.5-3 Lac.
 
  Please call @ 9711772297
 
 
  Regards
  Rahul Gandhi
 
  --
 
 --
  Some important links for excel users:
  1. Follow us on TWITTER for tips tricks and links :
  http://twitter.com/exceldailytip
  2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
  3. Excel tutorials at http://www.excel-macros.blogspot.com
  4. Learn VBA Macros at http://www.quickvba.blogspot.com
  5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
  To post to this group, send email to excel-macros@googlegroups.com
 
  
  Like our page on facebook , Just follow below link
  http://www.facebook.com/discussexcel
 


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

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick 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$$ Prefix 0 before the number- Help

[Manoj Kumar]

See if this helps...


Best,
Manoj Kumar

On Tue, Oct 11, 2011 at 1:14 PM, waheedb...@gmail.com wrote:

 Hi group,

 I have numeric data in column, each cell contains 5 to 6 numeric values but
 are less 7 characters.
 For example: 12345,
 385469.

 What I want is, what ever is the count it should round upto 7 characters.

 Exampl 1): 12345.
 Result: 0012345.

 Ex; 2) 384569
 Result: 0384569

 0 should be prefixed here...

 Thanks in advance,

 Regards,
 waheed

 --

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

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

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


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


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


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

Re: $$Excel-Macros$$ kindly suggest me how can I Unhide all the hide sheet in a single go.

[Manoj kumar]

u can try this code...

*Sub UnhideAllSheets()*

*Dim wsSheet As Worksheet*

* *

*For Each wsSheet In ActiveWorkbook.Worksheets*

*wsSheet.Visible = xlSheetVisible*

*Next wsSheet*

*End Sub*



Best,

MKV



On Wed, Aug 24, 2011 at 12:54 PM, jayendra gaurav jayendra.gau...@gmail.com
 wrote:


 Team,

 I have hide 50 sheet in a work book kindly suggest me how can I Unhide all
 the hidden sheet in a single go.



 --
 J.Gaurav

 Cell - 9327348097

 --

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

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

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


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


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

Re: $$Excel-Macros$$ Re: The Most Accurate PDF-to-Excel Converter

[Manoj kumar]

Me Too... Thanks...



Regards,
Manoj Kumar

On Mon, Aug 22, 2011 at 9:33 AM, pankaj gmail account
pankaji...@gmail.comwrote:

 Please forward same to me also

 Thanks Pankaj

 2011/8/20 Venkat CV venkat1@gmail.com

 You are welcome

 *Best Regards,*
 *Venkat *
 *Chennai*
 *
 *
 On Sat, Aug 20, 2011 at 3:52 PM, bé trần văn 
 betnmtdongna...@gmail.comwrote:

 Thank venkat1@gmail.com has provided me the software conversion from
 PDF to Excel, very useful information.

 Thank you very much.




 --
 *
 *
 *
 *


  --

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

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

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




 --
 Pankaj Kumar

 --

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

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

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


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


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

Re: $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING

[Manoj kumar]

Hi,

you can use this formula as well in cell B2:-

=LOOKUP(99^99,--(0MID(A2,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A20123456789)),ROW(INDIRECT(1:LEN(A2))



Best,
Manoj Kumar
On Tue, Jul 5, 2011 at 2:06 PM, MITTAL AJAY amit...@iocl.co.in wrote:

  I WANT TO EXTRACT  11 DIGIT NUMBER IN CLOUMN B.

 ** **

 Can anybody suggest a suitable formula ?

 ** **

 *With Warm Regards,*

 * *

 *CA. Ajay Mittal*

 *Finance Manager*

 * *

 *[image: cid:image001.jpg@01CC1029.98246F90]*

 *Pipelines Division,*

 *Noida - 201 301
 **Tel: 0120-2448312***

 ** **

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *ashish koul
 *Sent:* Tuesday, July 05, 2011 1:33 PM
 *To:* excel-macros@googlegroups.com
 *Subject:* Re: $$Excel-Macros$$ copy data without opening file

 ** **

 i suggest you hide the workbook from which you are copying the data if you
 dont want to show it to the user 

  

  


 http://akoul.blogspot.com/search/label/Hide%20and%20Unhide%20a%20workbook%20in%20vba
 

  


  

 On Tue, Jul 5, 2011 at 12:53 PM, Rajan_Verma rajanverma1...@gmail.com
 wrote:

 *No, We cant Copy the data from Closed Workbook.. but we can get the Data
 by Using Full Reference of cell .. Like*

 * *

 *='C:\Users\Xl_Lover\Desktop\[ForDownload[Sheet1]]Sheet1'!A1*

 * *

 * *

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *ankur
 *Sent:* Tuesday, July 05, 2011 12:13 PM
 *To:* excel-macros@googlegroups.com
 *Subject:* Re: $$Excel-Macros$$ copy data without opening file

  

 hi hanumant

 you may find this to be useful

 http://spreadsheetpage.com/index.php...a_closed_file/http://spreadsheetpage.com/index.php/tip/a_vba_function_to_get_a_value_from_a_closed_file/
 

 [image: Image removed by sender. Reply With 
 Quote]http://www.excelforum.com/newreply.php?do=newreplyp=2079066
 


 Have A Nice Time  Enjoy Life

 Regards:
 CMA Ankur Pandey
 (Someone Different)

 I'm not the best but i'm not like the rest~~

 On Tue, Jul 5, 2011 at 12:40 AM, hanumant shinde arsfan2...@yahoo.co.in
 wrote:

 Hi friends,

 is there any way where we can copy data from closed workbook A and paste
 it
 into workbook B which is open?

 --

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

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

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

  

 --

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

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

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

 -- 


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

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

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




 -- 

 *Regards*

 * *

 *Ashish Koul*

 *akoul*.*blogspot*.com http://akoul.blogspot.com/*
 http://akoul.posterous.com/*

 *akoul*.wordpress.com http://akoul.wordpress.com/

 My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830***
 *

  

 P Before printing, think about the environment.

  

 ** **

 --

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

Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - May'11

[Manoj kumar]

Congrats Ashish, keep it up.



Best,
Manoj Kumar

On Thu, Jun 2, 2011 at 10:29 PM, Ayush Jain jainayus...@gmail.com wrote:

  Hello Everyone,

 Ashish Koul has been selected as 'Most Helpful Member' for the month of
 May'11
 He has posted 67 posts in May 2011 and helped many people through his
 expertise. He has been consistent contributor to this excel forum and
 achieved this recognition from last six months consecutively.This is really
 awesome.

 ASHISH, Many Many thanks for the valuable support to group. We are proud to
 have you in this forum.

 *I have published the same on discussexcel.com homepage.*

 Regards
 Ayush Jain
 Group Manager





 --

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

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

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


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


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

Re: $$Excel-Macros$$ Recovering corrupted excel file

[Manoj Kumar]

Dear experts

Can you tell me  what is use of snerios in excel.

Regards
Manoj


On 5/24/11, Rajan_Verma rajanverma1...@gmail.com wrote:
 Send your File..



 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
 On Behalf Of Chandra Shekar
 Sent: Monday, May 23, 2011 11:33 AM
 To: excel-macros@googlegroups.com
 Subject: Re: $$Excel-Macros$$ Recovering corrupted excel file



 Hi,



 This I tried but still I could not able to recover the file. Let me know is
 there any other way to recover file.



 Thanks,



 Chandra Shekar B

 On Sat, May 21, 2011 at 10:11 AM, ashish koul koul.ash...@gmail.com wrote:

 http://office.microsoft.com/en-us/excel-help/repairing-corrupted-files-in-ex
 cel-HA001034656.aspx







 On Fri, May 20, 2011 at 5:13 PM, Chandra Shekar
 chandrashekarb@gmail.com wrote:

 Hi can u expalin briefly in steps.



 Thanks,



 Chandra Shekar B

 On Fri, May 20, 2011 at 5:02 PM, rajan verma rajanverma1...@gmail.com
 wrote:

 Use a Function Like this



 ='C:\Users\Xl_Lover\Desktop\[Book2[Sheet1]]Index'!A1





 On Fri, May 20, 2011 at 4:00 PM, Chandra Shekar
 chandrashekarb@gmail.com wrote:

 Hi,



 Is there any way to recover corrupted excel file.



 Thanks,



 Chandra Shekar B

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

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

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





 --
 Regards
 Rajan verma
 +91 9158998701

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

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

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



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

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

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




 --

 Regards



 Ashish Koul

  http://akoul.blogspot.com/ akoul.blogspot.com

  http://akoul.wordpress.com/ akoul.wordpress.com

 My http://in.linkedin.com/pub/ashish-koul/10/400/830  Linkedin Profile



 P Before printing, think about the environment.





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

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

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



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