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

[Saleem Ansari]

Question not clear

On Mon, Jul 17, 2017 at 9:13 AM, Rakesh kumar 
wrote:

> Hi Friends,
>
> I need urgent help, If any one can help me.
>
> actually I have got one assignment, I need to solve it, but I'm completely
> stuck into this.
>
> Please see the attachment and help.
>
>
> --
> Thanks £ Regards
> Rakesh 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 https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

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

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

[Rakesh kumar]

see this attachment. hope it makes you understand.


On Mon, Jul 17, 2017 at 11:59 AM, Saleem Ansari 
wrote:

> Question not clear
>
> On Mon, Jul 17, 2017 at 9:13 AM, Rakesh kumar 
> wrote:
>
>> Hi Friends,
>>
>> I need urgent help, If any one can help me.
>>
>> actually I have got one assignment, I need to solve it, but I'm
>> completely stuck into this.
>>
>> Please see the attachment and help.
>>
>>
>> --
>> Thanks £ Regards
>> Rakesh 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 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.
>



-- 
Thanks £ Regards
Rakesh Kumar
+91-9650303464

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


Help needed1.xlsx
Description: MS-Excel 2007 spreadsheet

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

['Storey Thomas' via MS EXCEL AND VBA MACROS]

On Mon, 7/17/17, Saleem Ansari  wrote:

 Subject: Re: $$Excel-Macros$$ Urgent Help required
 To: excel-macros@googlegroups.com
 Date: Monday, July 17, 2017, 9:29 AM
 
 Question not clear
 On Mon, Jul 17, 2017 at
 9:13 AM, Rakesh kumar 
 wrote:
 Hi Friends,
 I need urgent help, If any one can
 help me.
 actually I
 have got one assignment, I need to solve it, but I'm
 completely stuck into this.
 Please see the attachment and
 help.
 
 -- 
 Thanks
 £ Regards 
 Rakesh 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+unsubscribe@
 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.
 ncriminare la adresa boierilor greci si romani: ridicarea noastra nu este 
pentru

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ urgent help required

[Bipin Singh]

Does that mean you would like to have color from 09th October till 23rd
Oct. in this case.


On Sun, Sep 28, 2014 at 12:20 PM, Rakesh kumar 
wrote:

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

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

FORUM RULES

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

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

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

[Paul Schreiner]

First of all:I enjoy helping.Normally, I sort my list of emails (sometimes a 
hundred or more)and immediately delete the emails with subjects like:"Please 
Help", "Urgent" and "Help Required".Because ALL the people that post to these 
sites are doing so because they need assistance, and to THEM, it is "urgent".
and, as the "Forum Rules" state:1) Use concise, accurate thread titles. Poor 
thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code 
Problem, and Need Advice will not get quick attention or may not be answered.
But today, after deleting a response from another discussion thread, this one 
appeared in my preview screen...
Second:There are HUNDREDS (OK, maybe only 50) ways to search a worksheet for a 
cell value.What ways have you tried?how do you WANT it to work?
It can be as simple as:
For NameRow = 1 to 50   If (Cells(NameRow,"H").Value = "Name") then exit 
forNext NameRow
the loop exits when the "Name" value is found, so the last number assigned to 
NameRow ends up being the row with the "Name" heading.
so, please provide a description of what you're trying to do, what you've 
accomplished so far, and what you're having trouble with.
I'm sure someone would be glad to help. 
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: Soumyendu Paul 
 To: excel-macros@googlegroups.com 
 Sent: Wednesday, August 26, 2015 1:24 AM
 Subject: $$Excel-Macros$$ Urgent Help Required
   
Hi,
Want to search header "Name" in attached file through vba but unable to do with 
find method. Please help Regards,Soumyendu-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


   

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

FORUM RULES

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

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

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

[Shaik Waheed]

Hi,

Do you want to chek whether the master file ph.# are callable or
non-callable by verying it with NDNC sheet?



On Sat, Mar 3, 2012 at 4:16 AM, Satvik  wrote:

> Hi Every One,
>
> Friend I need a big help from you all, as I work in BPO company as a MIS
> executive but I am not aware about Access or SQL. But every day I need to
> scrub the NDNC data which I receive it from my client side.. Volume of a
> data will be around 5 to 6 lake. Where I get NDNC scrubbed file from the
> NDNC link using this file I need to map the NDNC status to my Master file.
> Will any one help me to do my work easier and do my other work @ the same
> time. Attached the sample files...
>
> Sample 1 - master file &
> Sample 2 - NDNC file.
>
> Regards,
> Satvik
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

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

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

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

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

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

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

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

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

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

[Sourabh Salgotra]

chk attachments solved




On Fri, Mar 2, 2012 at 6:11 PM, Shaik Waheed  wrote:

> Hi,
>
> Do you want to chek whether the master file ph.# are callable or
> non-callable by verying it with NDNC sheet?
>
>
>
> On Sat, Mar 3, 2012 at 4:16 AM, Satvik  wrote:
>
>> Hi Every One,
>>
>> Friend I need a big help from you all, as I work in BPO company as a MIS
>> executive but I am not aware about Access or SQL. But every day I need to
>> scrub the NDNC data which I receive it from my client side.. Volume of a
>> data will be around 5 to 6 lake. Where I get NDNC scrubbed file from the
>> NDNC link using this file I need to map the NDNC status to my Master file.
>> Will any one help me to do my work easier and do my other work @ the same
>> time. Attached the sample files...
>>
>> Sample 1 - master file &
>> Sample 2 - NDNC file.
>>
>> Regards,
>> Satvik
>>
>> --
>> 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
>



-- 
mujhay dukh is baat ka nahin kay meri zaat ko
muntashir karny walay haath tairy thy
mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko
samaitnay walay haath tairy na thy





Thanks & Regards
Sourabh
Contact Numbers: +91-94630-49202
Website:http://adhurapyaar.co.cc

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


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


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

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

[Satvik]

Thanks for the replay Shaik...

Yes I need to check with DNC.. 
Sent from BlackBerry® on Airtel

-Original Message-
From: Shaik Waheed 
Sender: excel-macros@googlegroups.com
Date: Fri, 2 Mar 2012 18:11:44 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Urgent Help Required...!

Hi,

Do you want to chek whether the master file ph.# are callable or
non-callable by verying it with NDNC sheet?



On Sat, Mar 3, 2012 at 4:16 AM, Satvik  wrote:

> Hi Every One,
>
> Friend I need a big help from you all, as I work in BPO company as a MIS
> executive but I am not aware about Access or SQL. But every day I need to
> scrub the NDNC data which I receive it from my client side.. Volume of a
> data will be around 5 to 6 lake. Where I get NDNC scrubbed file from the
> NDNC link using this file I need to map the NDNC status to my Master file.
> Will any one help me to do my work easier and do my other work @ the same
> time. Attached the sample files...
>
> Sample 1 - master file &
> Sample 2 - NDNC file.
>
> Regards,
> Satvik
>
> --
> 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

-- 
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$$ Urgent Help Required...!

[Shaik Waheed]

Hi,
You can use vlookup to find the callable # from DNC sheet. Find the
attached file for ur reference.

On Sat, Mar 3, 2012 at 6:59 AM, Satvik  wrote:

> **
> Thanks for the replay Shaik...
>
> Yes I need to check with DNC..
> Sent from BlackBerry® on Airtel
> --
> *From: *Shaik Waheed 
> *Sender: *excel-macros@googlegroups.com
> *Date: *Fri, 2 Mar 2012 18:11:44 +0530
> *To: *
> *ReplyTo: *excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ Urgent Help Required...!
>
> Hi,
>
> Do you want to chek whether the master file ph.# are callable or
> non-callable by verying it with NDNC sheet?
>
>
>
> On Sat, Mar 3, 2012 at 4:16 AM, Satvik  wrote:
>
>> Hi Every One,
>>
>> Friend I need a big help from you all, as I work in BPO company as a MIS
>> executive but I am not aware about Access or SQL. But every day I need to
>> scrub the NDNC data which I receive it from my client side.. Volume of a
>> data will be around 5 to 6 lake. Where I get NDNC scrubbed file from the
>> NDNC link using this file I need to map the NDNC status to my Master file.
>> Will any one help me to do my work easier and do my other work @ the same
>> time. Attached the sample files...
>>
>> Sample 1 - master file &
>> Sample 2 - NDNC file.
>>
>> Regards,
>> Satvik
>>
>> --
>> 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
>
> --
> 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


master file(1).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

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

[Satvik]

Shaik,

As off now I'm doing the same logic. Where as my data volume is too high! 
Is there any other logic to map the same... 

Regards,
Satvik
Sent from BlackBerry® on Airtel

-Original Message-
From: Shaik Waheed 
Sender: excel-macros@googlegroups.com
Date: Fri, 2 Mar 2012 20:43:19 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Urgent Help Required...!

Hi,
You can use vlookup to find the callable # from DNC sheet. Find the
attached file for ur reference.

On Sat, Mar 3, 2012 at 6:59 AM, Satvik  wrote:

> **
> Thanks for the replay Shaik...
>
> Yes I need to check with DNC..
> Sent from BlackBerry® on Airtel
> --
> *From: *Shaik Waheed 
> *Sender: *excel-macros@googlegroups.com
> *Date: *Fri, 2 Mar 2012 18:11:44 +0530
> *To: *
> *ReplyTo: *excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ Urgent Help Required...!
>
> Hi,
>
> Do you want to chek whether the master file ph.# are callable or
> non-callable by verying it with NDNC sheet?
>
>
>
> On Sat, Mar 3, 2012 at 4:16 AM, Satvik  wrote:
>
>> Hi Every One,
>>
>> Friend I need a big help from you all, as I work in BPO company as a MIS
>> executive but I am not aware about Access or SQL. But every day I need to
>> scrub the NDNC data which I receive it from my client side.. Volume of a
>> data will be around 5 to 6 lake. Where I get NDNC scrubbed file from the
>> NDNC link using this file I need to map the NDNC status to my Master file.
>> Will any one help me to do my work easier and do my other work @ the same
>> time. Attached the sample files...
>>
>> Sample 1 - master file &
>> Sample 2 - NDNC file.
>>
>> Regards,
>> Satvik
>>
>> --
>> 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
>
> --
> 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 

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

[Sourabh Salgotra]

u can try this one

=INDEX('E:\Desktop\[NDNC
file.xlsx]Sheet1'!$A$2:$B$11,MATCH(A2,'E:\Desktop\[NDNC
file.xlsx]Sheet1'!$A$2:$A$11,0),2)

On Sat, Mar 3, 2012 at 7:19 AM, Satvik  wrote:

> **
> Shaik,
>
> As off now I'm doing the same logic. Where as my data volume is too
> high! Is there any other logic to map the same...
>
> Regards,
> Satvik
> Sent from BlackBerry® on Airtel
> --
> *From: *Shaik Waheed 
> *Sender: *excel-macros@googlegroups.com
> *Date: *Fri, 2 Mar 2012 20:43:19 +0530
>  *To: *
> *ReplyTo: *excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ Urgent Help Required...!
>
> Hi,
> You can use vlookup to find the callable # from DNC sheet. Find the
> attached file for ur reference.
>
> On Sat, Mar 3, 2012 at 6:59 AM, Satvik  wrote:
>
>> **
>> Thanks for the replay Shaik...
>>
>> Yes I need to check with DNC..
>> Sent from BlackBerry® on Airtel
>> --
>> *From: *Shaik Waheed 
>> *Sender: *excel-macros@googlegroups.com
>> *Date: *Fri, 2 Mar 2012 18:11:44 +0530
>> *To: *
>> *ReplyTo: *excel-macros@googlegroups.com
>> *Subject: *Re: $$Excel-Macros$$ Urgent Help Required...!
>>
>> Hi,
>>
>> Do you want to chek whether the master file ph.# are callable or
>> non-callable by verying it with NDNC sheet?
>>
>>
>>
>> On Sat, Mar 3, 2012 at 4:16 AM, Satvik  wrote:
>>
>>> Hi Every One,
>>>
>>> Friend I need a big help from you all, as I work in BPO company as a MIS
>>> executive but I am not aware about Access or SQL. But every day I need to
>>> scrub the NDNC data which I receive it from my client side.. Volume of a
>>> data will be around 5 to 6 lake. Where I get NDNC scrubbed file from the
>>> NDNC link using this file I need to map the NDNC status to my Master file.
>>> Will any one help me to do my work easier and do my other work @ the same
>>> time. Attached the sample files...
>>>
>>> Sample 1 - master file &
>>> Sample 2 - NDNC file.
>>>
>>> Regards,
>>> Satvik
>>>
>>> --
>>> 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
>>
>> --
>> 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.

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

[Satvik]

Thanks for helping me Sourabh..

Surly I will try the formula.. I will let you know the results by morning...

Regards,
Satvik 
Sent from BlackBerry® on Airtel

-Original Message-
From: Sourabh Salgotra 
Sender: excel-macros@googlegroups.com
Date: Fri, 2 Mar 2012 21:10:14 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Urgent Help Required...!

u can try this one

=INDEX('E:\Desktop\[NDNC
file.xlsx]Sheet1'!$A$2:$B$11,MATCH(A2,'E:\Desktop\[NDNC
file.xlsx]Sheet1'!$A$2:$A$11,0),2)

On Sat, Mar 3, 2012 at 7:19 AM, Satvik  wrote:

> **
> Shaik,
>
> As off now I'm doing the same logic. Where as my data volume is too
> high! Is there any other logic to map the same...
>
> Regards,
> Satvik
> Sent from BlackBerry® on Airtel
> --
> *From: *Shaik Waheed 
> *Sender: *excel-macros@googlegroups.com
> *Date: *Fri, 2 Mar 2012 20:43:19 +0530
>  *To: *
> *ReplyTo: *excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ Urgent Help Required...!
>
> Hi,
> You can use vlookup to find the callable # from DNC sheet. Find the
> attached file for ur reference.
>
> On Sat, Mar 3, 2012 at 6:59 AM, Satvik  wrote:
>
>> **
>> Thanks for the replay Shaik...
>>
>> Yes I need to check with DNC..
>> Sent from BlackBerry® on Airtel
>> --
>> *From: *Shaik Waheed 
>> *Sender: *excel-macros@googlegroups.com
>> *Date: *Fri, 2 Mar 2012 18:11:44 +0530
>> *To: *
>> *ReplyTo: *excel-macros@googlegroups.com
>> *Subject: *Re: $$Excel-Macros$$ Urgent Help Required...!
>>
>> Hi,
>>
>> Do you want to chek whether the master file ph.# are callable or
>> non-callable by verying it with NDNC sheet?
>>
>>
>>
>> On Sat, Mar 3, 2012 at 4:16 AM, Satvik  wrote:
>>
>>> Hi Every One,
>>>
>>> Friend I need a big help from you all, as I work in BPO company as a MIS
>>> executive but I am not aware about Access or SQL. But every day I need to
>>> scrub the NDNC data which I receive it from my client side.. Volume of a
>>> data will be around 5 to 6 lake. Where I get NDNC scrubbed file from the
>>> NDNC link using this file I need to map the NDNC status to my Master file.
>>> Will any one help me to do my work easier and do my other work @ the same
>>> time. Attached the sample files...
>>>
>>> Sample 1 - master file &
>>> Sample 2 - NDNC file.
>>>
>>> Regards,
>>> Satvik
>>>
>>> --
>>> 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 

RE: $$Excel-Macros$$ Urgent Help Required...!

[Asa Rossoff]

Hi Satvik,

MATCH is faster than vlookup.

 

If your master file is unsorted, here are my best suggestions:

1.   =IF(ISERROR(MATCH($A2,'[master
file.xlsx]Sheet1'!$A$2:$A$11,0)),"Non Callable","Callable")

2.   {=IF(ISERROR(MATCH($A2:$A11,'[master
file.xlsx]Sheet1'!$A$2:$A$11,0)),"Non Callable","Callable")}

Option 2 is a multi-cell array formula that should be a bit faster than
option 1 and will also make your file a little smaller.  Enter the formula
in A2 of your DNC sheet, making sure the range $A2:$A11 references every row
in your DNC sheet.  Highlight the Callable column all the way down to the
last row and then confirm your multi-cell array formula by hitting
ctrl-shift-enter.  If you take this route the DNC sheet will not be sortable
and it will be hard to delete rows due to the formula spanning all those
rows.  That's the downside and the benefit may be only slight.

 

If your master file is sorted, you can use these versions that should be
even faster:

1.   =IF(INDEX('[master file.xlsx]Sheet1'!$A$2:$A$11,MATCH($A2,'[master
file.xlsx]Sheet1'!$A$2:$A$11))=$A2,"Callable","Non Callable")

2.   {=IF(INDEX('[master
file.xlsx]Sheet1'!$A$2:$A$11,MATCH($A2:$A11,'[master
file.xlsx]Sheet1'!$A$2:$A$11))=$A2:$A11,"Callable","Non Callable")}

 

Notice that for an unsorted master file, there is no need to include INDEX
in the formula.  All you need to know is if the tel. no. is in the file.
Match determines that and it's position.  Index would do unneeded work to
rerieve the number.

 

I use Index in the formula for a sorted list, because although Match is
blazing fast with a sorted list, it will not return an error if the number
is not found, so we need to verify that it found the correct number.

 

Asa

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Satvik
Sent: Friday, March 02, 2012 5:49 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Urgent Help Required...!

 

Shaik,

As off now I'm doing the same logic. Where as my data volume is too
high! Is there any other logic to map the same... 

Regards,
Satvik

Sent from BlackBerryR on Airtel

  _  

From: Shaik Waheed  

Sender: excel-macros@googlegroups.com 

Date: Fri, 2 Mar 2012 20:43:19 +0530

To: 

ReplyTo: excel-macros@googlegroups.com 

Subject: Re: $$Excel-Macros$$ Urgent Help Required...!

 

Hi,

You can use vlookup to find the callable # from DNC sheet. Find the attached
file for ur reference.

On Sat, Mar 3, 2012 at 6:59 AM, Satvik  wrote:

Thanks for the replay Shaik...

Yes I need to check with DNC.. 

Sent from BlackBerryR on Airtel

  _  

From: Shaik Waheed  

Sender: excel-macros@googlegroups.com 

Date: Fri, 2 Mar 2012 18:11:44 +0530

To: 

ReplyTo: excel-macros@googlegroups.com 

Subject: Re: $$Excel-Macros$$ Urgent Help Required...!

 

Hi,

 

Do you want to chek whether the master file ph.# are callable or
non-callable by verying it with NDNC sheet?



 

On Sat, Mar 3, 2012 at 4:16 AM, Satvik  wrote:

Hi Every One,

Friend I need a big help from you all, as I work in BPO company as a MIS
executive but I am not aware about Access or SQL. But every day I need to
scrub the NDNC data which I receive it from my client side.. Volume of a
data will be around 5 to 6 lake. Where I get NDNC scrubbed file from the
NDNC link using this file I need to map the NDNC status to my Master file.
Will any one help me to do my work easier and do my other work @ the same
time. Attached the sample files...

Sample 1 - master file &
Sample 2 - NDNC file.

Regards,
Satvik

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

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

[bhupsi1982]

 Hi Deepak,

Pls find attached shet with the soultion as per your requirement.

Let me know if its find you helpful.

Best,
Bhupendra Chaudhari

On 9/7/2010 10:21 AM, Deepak Pal Singh wrote:

Hi Guy's,
I've a worksheet containing three columns Serial No, Month and 
New/CarryForward. I want to get count of New & Carry Forward on 
Monthly basis using an excel formula not by pivot table, I've tried to 
done it using COUNTIF but couldn't get success.

Please Help
Thanks
Deepak Kumar
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

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

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

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


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

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

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

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


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

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

[Dave Bonallack]

Hi Deepak,

Have a look at the attached to see if it's what you need.

Regards - Dave
 


Date: Tue, 7 Sep 2010 10:21:26 +0530
Subject: $$Excel-Macros$$ Urgent Help Required
From: deepaktheind...@gmail.com
To: excel-macros@googlegroups.com


Hi Guy's,
 
I've a worksheet containing three columns Serial No, Month and 
New/CarryForward. I want to get count of New & Carry Forward on Monthly basis 
using an excel formula not by pivot table, I've tried to done it using COUNTIF 
but couldn't get success.
 
Please Help
 
Thanks
Deepak Kumar

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

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
 
We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
  

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

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

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


Required Formula(1).xlsx
Description: Binary data

Re: $$Excel-Macros$$ Urgent help Required

[Born to Win]

Dear Andy,

This is working Good i believe in Tag There are many categories are
available separated by comma(,),(/).is it Possible to match All word so that
i can match maximum apart from Checking only one word.


Thanks for your Support,
Chandrabhan Singh



On Mon, Nov 1, 2010 at 1:47 PM, Aindril De  wrote:

> Dear Chandrabhan,
>
> There is no need to do the same with a macro. You can use a simple vlookup
> and then filter to do so.
> Attached is the solution.
> Please let us know, if this is what you wanted.
>
> Regards,
> Andy
>
>
> On Mon, Nov 1, 2010 at 11:44 AM, Born to Win  wrote:
>
>> Hi Experts,
>>
>> Attached Excel File contains 2 Sheets in First Sheet I have some unique
>> Tag In Second Sheet(Base File) i have to Find Tags which is Placed in First
>> sheet.Please if Possible Please help me & send me a macro program so that i
>> can find All Tags from RAW data.I would request you to please look in to
>> this.its Urgent.
>>
>>
>> Thanks,
>> Chandrabhan Singh
>>
>>  --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>>
>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

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

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

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

[ashish koul]

check the attachment see if it helps .

On Sat, Nov 27, 2010 at 6:46 PM, girish kumar
wrote:

> Dear Experts,
>>>
>>
> I need your help to sort this problem
>
> i have attached one file, i have mentioned my problem in file itself.
>
> thanks in advance
>
> regards
>
> Girish
>
>
>
>
>
>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>>
>>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>>
>>
>>
>>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

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

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


Help Required (1).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

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

[girish kumar]

Dear Ashish / Experts

Its wonderfull, its solved what i need.

But i need VBA code for this because i need to send this file to my higher
officials if formulas are there it wont be look good.

and for drop box (Column XFD) u put only those destinations which are in
Master sheet, if i need to add more destination what i have to do.

Thanx in Advance.

Regards

Girish

On Sat, Nov 27, 2010 at 7:14 PM, ashish koul  wrote:

>
> check the attachment see if it helps .
>
> On Sat, Nov 27, 2010 at 6:46 PM, girish kumar  > wrote:
>
>>  Dear Experts,

>>>
>> I need your help to sort this problem
>>
>> i have attached one file, i have mentioned my problem in file itself.
>>
>> thanks in advance
>>
>> regards
>>
>> Girish
>>
>>
>>
>>
>>
>>> --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

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

 <><><><><><><><><><><><><><><><><><><><><><>
 Like our page on facebook , Just follow below link

 http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

>>>
>>>
>>>
>>  --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>>
>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> P Before printing, think about the environment.
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>



-- 
Warm Regards,

*Girish Sherigar*

* (¨`·.·´¨) *
*`·.¸(¨`·.·´¨)* *Keep*
* (¨`·.·´¨)¸.·´ Smiling!*
* `·.¸.·´*

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

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


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

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

[girish kumar]

Hi Ashish,

i want one small info again in provided macro

if i hide the Master sheet macro is not running, is there any way to hide
the Master sheet and run the macro successfully?

thanks in advance

Regards

Girish.

On Tue, Nov 30, 2010 at 7:05 PM, ashish koul  wrote:

> its ok bro
>
>
> On Tue, Nov 30, 2010 at 3:08 PM, girish kumar  > wrote:
>
>> Hi Ashish,
>>
>> i opened that website. but how to follow? or just need to open once?
>>
>>
>> On Mon, Nov 29, 2010 at 8:52 PM, ashish koul wrote:
>>
>>> welcome
>>>
>>> can you follow my blog  http://akoul.blogspot.com/
>>>  thanks in advance
>>>
>>>
>>> On Mon, Nov 29, 2010 at 8:51 PM, girish kumar <
>>> girishkumar832...@gmail.com> wrote:
>>>
 Hi Ashish,

 Thanks for your wonderful efforts!!, its working fine.

 Thanks a lot.

 Regards

 Girish


 On Mon, Nov 29, 2010 at 6:29 PM, ashish koul wrote:

> run crete val macro to add data in validation everytime u add a new
> data to file
>
>
> On Mon, Nov 29, 2010 at 11:52 AM, girish kumar <
> girishkumar832...@gmail.com> wrote:
>
>> Dear Ashish / Experts
>>
>> Its wonderfull, its solved what i need.
>>
>> But i need VBA code for this because i need to send this file to my
>> higher officials if formulas are there it wont be look good.
>>
>> and for drop box (Column XFD) u put only those destinations which are
>> in Master sheet, if i need to add more destination what i have to do.
>>
>> Thanx in Advance.
>>
>> Regards
>>
>> Girish
>>
>> On Sat, Nov 27, 2010 at 7:14 PM, ashish koul 
>> wrote:
>>
>>>
>>> check the attachment see if it helps .
>>>
>>> On Sat, Nov 27, 2010 at 6:46 PM, girish kumar <
>>> girishkumar832...@gmail.com> wrote:
>>>
  Dear Experts,
>>
>
 I need your help to sort this problem

 i have attached one file, i have mentioned my problem in file
 itself.

 thanks in advance

 regards

 Girish





> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @
>> http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to
>> excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>>
>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
>
>
  --

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

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

 <><><><><><><><><><><><><><><><><><><><><><>
 Like our page on facebook , Just follow below link

 http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

>>>
>>>
>>>
>>> --
>>> *Regards*
>>> * *
>>> *Ashish Koul*
>>> *akoul*.*blogspot*.com 
>>> *akoul*.wordpress.com 
>>> My Linkedin Profile
>>>
>>>
>>> P Before printing, think about the environment.
>>>
>>>
>>>  --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @
>>> http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><

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

[girish kumar]

Hi Ashish,

Any updates??

On Mon, Dec 6, 2010 at 3:04 PM, girish kumar wrote:

> Hi Ashish,
>
> i want one small info again in provided macro
>
> if i hide the Master sheet macro is not running, is there any way to hide
> the Master sheet and run the macro successfully?
>
> thanks in advance
>
> Regards
>
> Girish.
>
>
> On Tue, Nov 30, 2010 at 7:05 PM, ashish koul wrote:
>
>> its ok bro
>>
>>
>> On Tue, Nov 30, 2010 at 3:08 PM, girish kumar <
>> girishkumar832...@gmail.com> wrote:
>>
>>> Hi Ashish,
>>>
>>> i opened that website. but how to follow? or just need to open once?
>>>
>>>
>>> On Mon, Nov 29, 2010 at 8:52 PM, ashish koul wrote:
>>>
 welcome

 can you follow my blog  http://akoul.blogspot.com/
  thanks in advance


 On Mon, Nov 29, 2010 at 8:51 PM, girish kumar <
 girishkumar832...@gmail.com> wrote:

> Hi Ashish,
>
> Thanks for your wonderful efforts!!, its working fine.
>
> Thanks a lot.
>
> Regards
>
> Girish
>
>
> On Mon, Nov 29, 2010 at 6:29 PM, ashish koul wrote:
>
>> run crete val macro to add data in validation everytime u add a new
>> data to file
>>
>>
>> On Mon, Nov 29, 2010 at 11:52 AM, girish kumar <
>> girishkumar832...@gmail.com> wrote:
>>
>>> Dear Ashish / Experts
>>>
>>> Its wonderfull, its solved what i need.
>>>
>>> But i need VBA code for this because i need to send this file to my
>>> higher officials if formulas are there it wont be look good.
>>>
>>> and for drop box (Column XFD) u put only those destinations which are
>>> in Master sheet, if i need to add more destination what i have to do.
>>>
>>> Thanx in Advance.
>>>
>>> Regards
>>>
>>> Girish
>>>
>>> On Sat, Nov 27, 2010 at 7:14 PM, ashish koul 
>>> wrote:
>>>

 check the attachment see if it helps .

 On Sat, Nov 27, 2010 at 6:46 PM, girish kumar <
 girishkumar832...@gmail.com> wrote:

>  Dear Experts,
>>>
>>
> I need your help to sort this problem
>
> i have attached one file, i have mentioned my problem in file
> itself.
>
> thanks in advance
>
> regards
>
> Girish
>
>
>
>
>
>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @
>>> http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to
>>> excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>>
>>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>>
>>
>>
>>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @
> http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
>
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>



 --
 *Regards*
 * *
 *Ashish Koul*
 *akoul*.*blogspot*.com 
 *akoul*.wordpress.com 
 My Linkedin Profile


 P Before printing, think about the environment.


  --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @
 http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.e

Re: $$Excel-Macros$$ Urgent help Required

[sujit pagare]

pl stop this

On Tue, Jan 4, 2011 at 2:07 PM, ashish koul  wrote:

> check the attachment see if it helps
>
>
>
> On Tue, Jan 4, 2011 at 11:58 AM, Born to Win  wrote:
>
>> Hi Friends,
>>
>> Please help me to Apply sum & Average Formula at the end of Month however
>> when i am taking more than 30 Arguments
>> i am getting an error.
>>
>>
>> Thanks,
>> Chandrabhan
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>>
>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> P Before printing, think about the environment.
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>



-- 
Sujeet

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

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

Re: $$Excel-Macros$$ Urgent help Required

[Rohan Young]

Dear Ashish Ji,

i hv a question, i am looking your attachment where u r using an array
formula and the average col. many of cells is empty where the no. of calls
having value (1 or 2) is it ok? or the calculating method of mine for
average is correct.

please clear me, or suggest me if my working is worng.

Thanks & Regards

ROHAN
9818247278, 8860567680

On Tue, Jan 4, 2011 at 3:37 PM, Rohan Young  wrote:

> Hi,
>
> Please find the attachment
>
> Thanks & Regards
>
> ROHAN
> 9818247278, 8860567680
>
>
> On Tue, Jan 4, 2011 at 2:10 PM, ashish koul  wrote:
>
>> ignore the previous mail  check this one
>>
>>
>>
>> On Tue, Jan 4, 2011 at 2:07 PM, ashish koul wrote:
>>
>>> check the attachment see if it helps
>>>
>>>
>>>
>>> On Tue, Jan 4, 2011 at 11:58 AM, Born to Win  wrote:
>>>
 Hi Friends,

 Please help me to Apply sum & Average Formula at the end of Month
 however when i am taking more than 30 Arguments
 i am getting an error.


 Thanks,
 Chandrabhan

 --

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

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

 <><><><><><><><><><><><><><><><><><><><><><>
 Like our page on facebook , Just follow below link

 http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

>>>
>>>
>>>
>>> --
>>> *Regards*
>>> * *
>>> *Ashish Koul*
>>> *akoul*.*blogspot*.com 
>>> *akoul*.wordpress.com 
>>> My Linkedin Profile 
>>>
>>>
>>> P Before printing, think about the environment.
>>>
>>>
>>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>> *akoul*.*blogspot*.com 
>> *akoul*.wordpress.com 
>> My Linkedin Profile 
>>
>>
>> P Before printing, think about the environment.
>>
>>
>>  --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>>
>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
>

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

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

Re: $$Excel-Macros$$ Urgent help Required

[Born to Win]

Thanks u So much Experts.
Thanks,
Chandrabhan Singh



On Tue, Jan 4, 2011 at 3:37 PM, Rohan Young  wrote:

> Hi,
>
> Please find the attachment
>
> Thanks & Regards
>
> ROHAN
> 9818247278, 8860567680
>
>
> On Tue, Jan 4, 2011 at 2:10 PM, ashish koul  wrote:
>
>> ignore the previous mail  check this one
>>
>>
>>
>> On Tue, Jan 4, 2011 at 2:07 PM, ashish koul wrote:
>>
>>> check the attachment see if it helps
>>>
>>>
>>>
>>> On Tue, Jan 4, 2011 at 11:58 AM, Born to Win  wrote:
>>>
 Hi Friends,

 Please help me to Apply sum & Average Formula at the end of Month
 however when i am taking more than 30 Arguments
 i am getting an error.


 Thanks,
 Chandrabhan

 --

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

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

 <><><><><><><><><><><><><><><><><><><><><><>
 Like our page on facebook , Just follow below link

 http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

>>>
>>>
>>>
>>> --
>>> *Regards*
>>> * *
>>> *Ashish Koul*
>>> *akoul*.*blogspot*.com 
>>> *akoul*.wordpress.com 
>>> My Linkedin Profile 
>>>
>>>
>>> P Before printing, think about the environment.
>>>
>>>
>>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>> *akoul*.*blogspot*.com 
>> *akoul*.wordpress.com 
>> My Linkedin Profile 
>>
>>
>> P Before printing, think about the environment.
>>
>>
>>  --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>>
>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

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

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

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

[Rajan_Verma]

See if it helps

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Anshul Gupta
Sent: Saturday, July 02, 2011 7:39 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Urgent Help required!!

 

Hi All.
 
As m working in a import house for that i have to sales bills on daily basis
i just want a help that makes me easy to make that
 
If someone tell that how to make 5 random numbers selection between 197.001
to 203.999 which gives the total of 1000.000
 
Please help meurgent guys 
 
Cheers 

-- 

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

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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


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

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

[karunanithi ramaswamy]

Sir,
  Do u have any idea of auto filling magic squre for a particular sum total.  
Iam interested
to know it. Thanks if u could help.
   -R.Karunanithi

--- On Sat, 7/2/11, Rajan_Verma  wrote:

From: Rajan_Verma 
Subject: RE: $$Excel-Macros$$ Urgent Help required!!
To: excel-macros@googlegroups.com
Date: Saturday, July 2, 2011, 8:25 PM




 
 






 



See if it helps 

   



From:
excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Anshul Gupta

Sent: Saturday, July 02, 2011 7:39 PM

To: excel-macros@googlegroups.com

Subject: $$Excel-Macros$$ Urgent Help required!! 



   

Hi All.

 

As m working in a import house for that i have to sales bills on daily basis i
just want a help that makes me easy to make that

 

If someone tell that how to make 5 random numbers selection between 197.001 to
203.999 which gives the total of 1000.000

 

Please help meurgent guys 

 

Cheers  

-- 

--

Some important links for excel users:

1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310

3. Excel tutorials at http://www.excel-macros.blogspot.com

4. Learn VBA Macros at http://www.quickvba.blogspot.com

5. Excel Tips and Tricks at http://exceldailytip.blogspot.com



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

 

<><><><><><><><><><><><><><><><><><><><><><>

Like our page on facebook , Just follow below link

http://www.facebook.com/discussexcel 



 





-- 

--

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$$ Urgent Help required!!!!!!!!!!

[Anshul Gupta]

No dude its not owrking proerly which buttun you give to generate thats is
also not working and the random numbers are not coming in decimels there
coming in proper figure.


Anyone else who can help me out buddy's

please help me out

cheers!!!

On Sat, Jul 2, 2011 at 8:25 PM, Rajan_Verma wrote:

>  *See if it helps*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Anshul Gupta
> *Sent:* Saturday, July 02, 2011 7:39 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Urgent Help required!!
>
> ** **
>
> Hi All.
>
> As m working in a import house for that i have to sales bills on daily
> basis i just want a help that makes me easy to make that
>
> If someone tell that how to make 5 random numbers selection between 197.001
> to 203.999 which gives the total of 1000.000
>
> Please help meurgent guys
>
> Cheers 
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> 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$$ Urgent Help required!!!!!!!!!!

[Rajan_Verma]

See if it help

http://www.mrexcel.com/tip069.shtml

 

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of karunanithi ramaswamy
Sent: Saturday, July 02, 2011 9:29 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Urgent Help required!!

 


Sir,
  Do u have any idea of auto filling magic squre for a particular sum total.
Iam interested
to know it. Thanks if u could help.
   -R.Karunanithi

--- On Sat, 7/2/11, Rajan_Verma  wrote:


From: Rajan_Verma 
Subject: RE: $$Excel-Macros$$ Urgent Help required!!
To: excel-macros@googlegroups.com
Date: Saturday, July 2, 2011, 8:25 PM

See if it helps

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Anshul Gupta
Sent: Saturday, July 02, 2011 7:39 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Urgent Help required!!

 

Hi All.
 
As m working in a import house for that i have to sales bills on daily basis
i just want a help that makes me easy to make that
 
If someone tell that how to make 5 random numbers selection between 197.001
to 203.999 which gives the total of 1000.000
 
Please help meurgent guys 
 
Cheers 

-- 

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

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 

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

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 

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

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

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

Re: $$Excel-Macros$$ Urgent Help required!!!!!!!!!!

[Anshul Gupta]

Hi All

No boss this is also not working see i show you what excatly i want

202.718
198.724
200.178
202.867
195.514
Total 1000.000

this is i want that random unique numbers between 195.001 to 203.999 which
always gives a total of 1000.000 after every total of 5 numbers

Help me guy

cheers!!!
On Sun, Jul 3, 2011 at 12:40 PM, Rajan_Verma wrote:

>  *See if it help*
>
> http://www.mrexcel.com/tip069.shtml
>
> ** **
>
> * *
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *karunanithi ramaswamy
> *Sent:* Saturday, July 02, 2011 9:29 PM
>
> *To:* excel-macros@googlegroups.com
>  *Subject:* RE: $$Excel-Macros$$ Urgent Help required!!
>
>   ** **
>
> Sir,
>   Do u have any idea of auto filling magic squre for a particular sum
> total.  Iam interested
> to know it. Thanks if u could help.
>-R.Karunanithi
>
> --- On *Sat, 7/2/11, Rajan_Verma * wrote:
>
>
> From: Rajan_Verma 
> Subject: RE: $$Excel-Macros$$ Urgent Help required!!
> To: excel-macros@googlegroups.com
> Date: Saturday, July 2, 2011, 8:25 PM
>
> *See if it helps*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Anshul Gupta
> *Sent:* Saturday, July 02, 2011 7:39 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Urgent Help required!!
>
>  
>
> Hi All.
>
> As m working in a import house for that i have to sales bills on daily
> basis i just want a help that makes me easy to make that
>
> If someone tell that how to make 5 random numbers selection between 197.001
> to 203.999 which gives the total of 1000.000
>
> Please help meurgent guys
>
> Cheers 
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> 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 Macro

Re: $$Excel-Macros$$ Urgent Help required!!!!!!!!!!

[Dilip Pandey]

Hi Anshul,

As per the latest scenario provided by you, attached solution may help you.
Let me know if this works :)

Regards,
DILIPandey

On 7/4/11, Anshul Gupta  wrote:
> Hi All
>
> No boss this is also not working see i show you what excatly i want
>
> 202.718
> 198.724
> 200.178
> 202.867
> 195.514
> Total 1000.000
>
> this is i want that random unique numbers between 195.001 to 203.999 which
> always gives a total of 1000.000 after every total of 5 numbers
>
> Help me guy
>
> cheers!!!
> On Sun, Jul 3, 2011 at 12:40 PM, Rajan_Verma
> wrote:
>
>>  *See if it help*
>>
>> http://www.mrexcel.com/tip069.shtml
>>
>> ** **
>>
>> * *
>>
>> * *
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *karunanithi ramaswamy
>> *Sent:* Saturday, July 02, 2011 9:29 PM
>>
>> *To:* excel-macros@googlegroups.com
>>  *Subject:* RE: $$Excel-Macros$$ Urgent Help required!!
>>
>>   ** **
>>
>> Sir,
>>   Do u have any idea of auto filling magic squre for a particular sum
>> total.  Iam interested
>> to know it. Thanks if u could help.
>>-R.Karunanithi
>>
>> --- On *Sat, 7/2/11, Rajan_Verma * wrote:
>>
>>
>> From: Rajan_Verma 
>> Subject: RE: $$Excel-Macros$$ Urgent Help required!!
>> To: excel-macros@googlegroups.com
>> Date: Saturday, July 2, 2011, 8:25 PM
>>
>> *See if it helps*
>>
>> * *
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Anshul Gupta
>> *Sent:* Saturday, July 02, 2011 7:39 PM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ Urgent Help required!!
>>
>>  
>>
>> Hi All.
>>
>> As m working in a import house for that i have to sales bills on daily
>> basis i just want a help that makes me easy to make that
>>
>> If someone tell that how to make 5 random numbers selection between
>> 197.001
>> to 203.999 which gives the total of 1000.000
>>
>> Please help meurgent guys
>>
>> Cheers 
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>> --
>>
>> --
>> 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
>>
>> <>&

Re: $$Excel-Macros$$ Urgent Help required!!!!!!!!!!

[chandrabhushan prasad]

tri this

=round(a1,-3)

On Mon, Jul 4, 2011 at 9:31 PM, Dilip Pandey  wrote:

> Hi Anshul,
>
> As per the latest scenario provided by you, attached solution may help you.
> Let me know if this works :)
>
> Regards,
> DILIPandey
>
> On 7/4/11, Anshul Gupta  wrote:
> > Hi All
> >
> > No boss this is also not working see i show you what excatly i want
> >
> > 202.718
> > 198.724
> > 200.178
> > 202.867
> > 195.514
> > Total 1000.000
> >
> > this is i want that random unique numbers between 195.001 to 203.999
> which
> > always gives a total of 1000.000 after every total of 5 numbers
> >
> > Help me guy
> >
> > cheers!!!
> > On Sun, Jul 3, 2011 at 12:40 PM, Rajan_Verma
> > wrote:
> >
> >>  *See if it help*
> >>
> >> http://www.mrexcel.com/tip069.shtml
> >>
> >> ** **
> >>
> >> * *
> >>
> >> * *
> >>
> >> *From:* excel-macros@googlegroups.com [mailto:
> >> excel-macros@googlegroups.com] *On Behalf Of *karunanithi ramaswamy
> >> *Sent:* Saturday, July 02, 2011 9:29 PM
> >>
> >> *To:* excel-macros@googlegroups.com
> >>  *Subject:* RE: $$Excel-Macros$$ Urgent Help required!!
> >>
> >>   ** **
> >>
> >> Sir,
> >>   Do u have any idea of auto filling magic squre for a particular sum
> >> total.  Iam interested
> >> to know it. Thanks if u could help.
> >>-R.Karunanithi
> >>
> >> --- On *Sat, 7/2/11, Rajan_Verma * wrote:
> >>
> >>
> >> From: Rajan_Verma 
> >> Subject: RE: $$Excel-Macros$$ Urgent Help required!!
> >> To: excel-macros@googlegroups.com
> >> Date: Saturday, July 2, 2011, 8:25 PM
> >>
> >> *See if it helps*
> >>
> >> * *
> >>
> >> *From:* excel-macros@googlegroups.com [mailto:
> >> excel-macros@googlegroups.com] *On Behalf Of *Anshul Gupta
> >> *Sent:* Saturday, July 02, 2011 7:39 PM
> >> *To:* excel-macros@googlegroups.com
> >> *Subject:* $$Excel-Macros$$ Urgent Help required!!
> >>
> >>  
> >>
> >> Hi All.
> >>
> >> As m working in a import house for that i have to sales bills on daily
> >> basis i just want a help that makes me easy to make that
> >>
> >> If someone tell that how to make 5 random numbers selection between
> >> 197.001
> >> to 203.999 which gives the total of 1000.000
> >>
> >> Please help meurgent guys
> >>
> >> Cheers 
> >>
> >> --
> >>
> >>
> --
> >> Some important links for excel users:
> >> 1. Follow us on TWITTER for tips tricks and links :
> >> http://twitter.com/exceldailytip
> >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> >> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >>
> >> To post to this group, send email to excel-macros@googlegroups.com
> >>
> >> <><><><><><><><><><><><><><><><><><><><><><>
> >> Like our page on facebook , Just follow below link
> >> http://www.facebook.com/discussexcel
> >>
> >> --
> >>
> >>
> --
> >> 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.c

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

[Mahesh parab]

Hi Prathap


Assuming u r value in cell A1
'=A1/10^6

HTH
Mahesh

On Thu, Oct 13, 2011 at 8:22 PM, Prathap  wrote:

> Hi,
>
> Is there a way to convert all the cells with numbers in to million format
> with shortcut / formula.
>
> Example: 1232345487 i want as 1232.
>
>  Attached is the sample file
>
> Best Regards,
> PRATHAP D
> M +91 9899-370-328
>
> --
>
> --
> 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$$ Urgent Help required

[somcpardeshi]

Hi

Just divide this by 100 
Try this formula =A1/10^6

Thanks and Regards,

Somnath C Pardeshi
Sent from my BlackBerry® Smartphone on Loop Mobile.

-Original Message-
From: Prathap 
Sender: excel-macros@googlegroups.com
Date: Thu, 13 Oct 2011 20:22:52 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Urgent Help required

Hi,

Is there a way to convert all the cells with numbers in to million format
with shortcut / formula.

Example: 1232345487 i want as 1232.

 Attached is the sample file

Best Regards,
PRATHAP D
M +91 9899-370-328

-- 
--
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$$ Urgent Help required

[dguillett1]

Custom Format 
#,##0,, ;[Red](#,##0,,);- ;  

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Prathap 
Sent: Thursday, October 13, 2011 9:52 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Urgent Help required

Hi,

Is there a way to convert all the cells with numbers in to million format with 
shortcut / formula.

Example: 1232345487 i want as 1232.

Attached is the sample file

Best Regards,
PRATHAP D 
M +91 9899-370-328 

-- 
--
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$$ Urgent Help required

[Prathap]

Thank you all for your assistance.

However i have a sheet (containing 67 columns & 3980 rows) were i need to
change the entire cell  into million. Attached is the sample sheet
Best Regards,
PRATHAP D
M +91 9899-370-328


On 13 October 2011 20:22, Prathap  wrote:

> Hi,
>
> Is there a way to convert all the cells with numbers in to million format
> with shortcut / formula.
>
> Example: 1232345487 i want as 1232.
>
>  Attached is the sample file
>
> Best Regards,
> PRATHAP D
> M +91 9899-370-328
>
> --
>
> --
> 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


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

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

[Paul Schreiner]

You could use a macro, 
or, you could use a formula by:

1. Copy the sheet to another sheet.
2. in Cell D7 use: =IF('P & L'!D7>0,'P & L'!D7 / 100,0)
(If you want round it to even values, use: =IF('P & L'!D7>0,ROUND('P & L'!D7 / 
100,0),0)
3. Copy this cell to all columns and rows
4. Select Copy-> Paste Special -> Values

if you'd prefer the macro, let me know.

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: Prathap 
To: excel-macros@googlegroups.com
Sent: Thu, October 13, 2011 1:31:01 PM
Subject: Re: $$Excel-Macros$$ Urgent Help required


Thank you all for your assistance.

However i have a sheet (containing 67 columns & 3980 rows) were i need to 
change 
the entire cell  into million. Attached is the sample sheet
Best Regards,
PRATHAP D 
M +91 9899-370-328 



On 13 October 2011 20:22, Prathap  wrote:

Hi,
>
>Is there a way to convert all the cells with numbers in to million format with 
>shortcut / formula.
>
>Example: 1232345487 i want as 1232.
>
> Attached is the sample file
>
>Best Regards,
>PRATHAP D 
>M +91 9899-370-328 
>-- 
>--
>
>Some important links for excel users:
>1. Follow us on TWITTER for tips tricks and links : 
>http://twitter.com/exceldailytip
>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>3. Excel tutorials at http://www.excel-macros.blogspot.com/
>4. Learn VBA Macros at http://www.quickvba.blogspot.com/
>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com/
>
>To post to this group, send email to excel-macros@googlegroups.com
> 
><><><><><><><><><><><><><><><><><><><><><><>
>Like our page on facebook , Just follow below link
>http://www.facebook.com/discussexcel
>
-- 
--

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

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

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

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

[somcpardeshi]

Hi

In a cell type 100 copy it( ctrl + C)
Select all cells then paste special ( Alt + E + S + V + I ) value with divide 
operation
This will convert all the numbers in million format.

Thanks and Regards,

Somnath C Pardeshi
+91 966 419 4782
Sent from my BlackBerry® Smartphone on Loop Mobile.

-Original Message-
From: Prathap 
Sender: excel-macros@googlegroups.com
Date: Thu, 13 Oct 2011 23:01:01 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Urgent Help required

Thank you all for your assistance.

However i have a sheet (containing 67 columns & 3980 rows) were i need to
change the entire cell  into million. Attached is the sample sheet
Best Regards,
PRATHAP D
M +91 9899-370-328


On 13 October 2011 20:22, Prathap  wrote:

> Hi,
>
> Is there a way to convert all the cells with numbers in to million format
> with shortcut / formula.
>
> Example: 1232345487 i want as 1232.
>
>  Attached is the sample file
>
> Best Regards,
> PRATHAP D
> M +91 9899-370-328
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

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

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

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

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

[Dilip Pandey]

Hi Prathap,

If this is one time exercise then, write 100 somewhere in and copy
it. Now select the data and apply paste special - > Values -> Divide.
If this is kinda template where figures will come and go, then you can
use custom format.

Regards,
DILIPandey


On 10/13/11, Prathap  wrote:
> Hi,
>
> Is there a way to convert all the cells with numbers in to million format
> with shortcut / formula.
>
> Example: 1232345487 i want as 1232.
>
>  Attached is the sample file
>
> Best Regards,
> PRATHAP D
> M +91 9899-370-328
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>


-- 
Thanks & Regards,

DILIP KUMAR PANDEY, mvp
   MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India

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

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


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

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

[Sam Mathai Chacko]

Here's a VBA formula that does the trick

http://www.ozgrid.com/forum/showthread.php?t=144212

Regards,

Sam Mathai Chacko (GL)

On Fri, Oct 14, 2011 at 11:03 AM, Dilip Pandey  wrote:

> Hi Prathap,
>
> If this is one time exercise then, write 100 somewhere in and copy
> it. Now select the data and apply paste special - > Values -> Divide.
> If this is kinda template where figures will come and go, then you can
> use custom format.
>
> Regards,
> DILIPandey
>
>
> On 10/13/11, Prathap  wrote:
> > Hi,
> >
> > Is there a way to convert all the cells with numbers in to million format
> > with shortcut / formula.
> >
> > Example: 1232345487 i want as 1232.
> >
> >  Attached is the sample file
> >
> > Best Regards,
> > PRATHAP D
> > M +91 9899-370-328
> >
> > --
> >
> --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> > http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> > http://www.facebook.com/discussexcel
> >
>
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY, mvp
>   MBA,B.Com(Hons),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 62, India
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Sam Mathai Chacko

-- 
--
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$$ Urgent help required

[dguillett1]

FIRST. To some of us, ME, “urgent help required” is a NO NO. All requests are 
urgent.
Now, you will need to explain the logic of what you want. If you want to find 
every comma on the sheet, what will you do with numbers, etc? You need to 
specify which columns to search and you need to tell us where you want the 
data? Do you want the file changed or do you want a list on another sheet?, etc.

Don Guillett
SalesAid Software
dguille...@gmail.com

From: nitin arora 
Sent: Wednesday, January 04, 2012 1:20 AM
To: excel-macros 
Subject: $$Excel-Macros$$ Urgent help required

Hi,

Please find attached excel sheet named Errors Bifurcation.

In this sheet there are many columns in which errors have been reported 
seperated by commas. I want that all the errors seperated by commas should 
appear in seperate rows with the data for Target ID and Tranaction ID. For 
example:

In Column AB 3, the data reported is: Revenues Missed, Total Assets Missed, 
Total Common Equity Missed, Net Income Missed.

I want this data to appear as:


TargetID  TransID  FnclErr

30839253 144138763   Revenues Missed

30839253 144138763   Total Assets Missed

30839253 144138763   Total Common Equity Missed

30839253 144138763   Net Income Missed.

It would be great if you can tell me a solution for this.

Many Thanks in advance.

Regards,

Nitin Arora


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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Urgent help required

[nitin arora]

Hi Don,

My apologies for the subject and I promise this wont happen in future. As
far as "Me" is concerned I am relatively new to this concept of groups so i
have no Idea where should I go to change it to my name. Any help on this
front would be highly appreciated.

As far as the request is concerned please find below the logic:

Column C in the sheet is Target ID, Column D is Transaction ID and Column
AB is FnclErr. For row 3 data already reported in the sheet is like (for
these 3 columns only):

 TargetID  TransID  FnclErr
30839253 144138763 Revenues Missed, Total Assets Missed, Total
Common Equity Missed, Net Income

I want this data to appear in the below mentioned format in a new sheet


TargetID  TransID  FnclErr
30839253 144138763   Revenues Missed
30839253 144138763   Total Assets Missed
30839253 144138763   Total Common Equity Missed
30839253 144138763   Net Income Missed.

Please let me know if I am missing something over here

Regards,

Nitin Arora


On Wed, Jan 4, 2012 at 6:51 PM, dguillett1  wrote:

>   FIRST. To some of us, ME, “urgent help required” is a NO NO. All
> requests are urgent.
> Now, you will need to explain the logic of what you want. If you want to
> find every comma on the sheet, what will you do with numbers, etc? You need
> to specify which columns to search and you need to tell us where you want
> the data? Do you want the file changed or do you want a list on another
> sheet?, etc.
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* nitin arora 
> *Sent:* Wednesday, January 04, 2012 1:20 AM
> *To:* excel-macros 
> *Subject:* $$Excel-Macros$$ Urgent help required
>
>
> Hi,
>
> Please find attached excel sheet named Errors Bifurcation.
>
> In this sheet there are many columns in which errors have been reported
> seperated by commas. I want that all the errors seperated by commas should
> appear in seperate rows with the data for Target ID and Tranaction ID. For
> example:
>
> In Column AB 3, the data reported is: Revenues Missed, Total Assets
> Missed, Total Common Equity Missed, Net Income Missed.
>
> I want this data to appear as:
>
>
> TargetID  TransID  FnclErr
>
> 30839253 144138763   Revenues Missed
>
> 30839253 144138763   Total Assets Missed
>
> 30839253 144138763   Total Common Equity Missed
>
> 30839253 144138763   Net Income Missed.
>
> It would be great if you can tell me a solution for this.
>
> Many Thanks in advance.
>
> Regards,
>
> Nitin Arora
> --
> 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
>

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

RE: $$Excel-Macros$$ Urgent help required

[Rajan_Verma]

Hi

Do you want this procedure Only in AB Column..?

 

Regards

Rajan

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of nitin arora
Sent: Jan/Wed/2012 12:51
To: excel-macros
Subject: $$Excel-Macros$$ Urgent help required

 

Hi,

Please find attached excel sheet named Errors Bifurcation.

In this sheet there are many columns in which errors have been reported
seperated by commas. I want that all the errors seperated by commas should
appear in seperate rows with the data for Target ID and Tranaction ID. For
example:

In Column AB 3, the data reported is: Revenues Missed, Total Assets Missed,
Total Common Equity Missed, Net Income Missed.

I want this data to appear as:


TargetID  TransID  FnclErr

30839253 144138763   Revenues Missed

30839253 144138763   Total Assets Missed

30839253 144138763   Total Common Equity Missed

30839253 144138763   Net Income Missed.

It would be great if you can tell me a solution for this.

Many Thanks in advance.

Regards,

Nitin Arora

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

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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Urgent help required

[Paul Schreiner]

What you're asking is very simple using VBA.
The question is:  do you know how to use VBA?

 A quick solution would look like:
Option Explicit
Sub Split_Errs()
    Dim R, nRows, dRow, strArray, inx
    dRow = 1
    nRows = 
Application.WorksheetFunction.CountA(Sheets("Sheet1").Range("A1:A65000"))
    For R = 2 To nRows
    strArray = Split(Sheets("Sheet1").Cells(R, "C").Value, ",")
    For inx = 0 To UBound(strArray)
    dRow = dRow + 1
    Sheets("Sheet2").Cells(dRow, "A").Value = Sheets("Sheet1").Cells(R, 
"A").Value
    Sheets("Sheet2").Cells(dRow, "B").Value = Sheets("Sheet1").Cells(R, 
"B").Value
    Sheets("Sheet2").Cells(dRow, "C").Value = Trim(strArray(inx))
    Next inx
    Next R
End Sub

but you need to put it into a "standard" module (rather than a "sheet" module)

using this macro, I was able to take 10,000 rows of sample data and split it 
into 40,000 rows in about 5 seconds.
(using Excel 2010)

hope this helps.
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: nitin arora 
To: excel-macros@googlegroups.com
Sent: Wed, January 4, 2012 8:52:56 AM
Subject: Re: $$Excel-Macros$$ Urgent help required


Hi Don,

My apologies for the subject and I promise this wont happen in future. As far 
as 
"Me" is concerned I am relatively new to this concept of groups so i have no 
Idea where should I go to change it to my name. Any help on this front would be 
highly appreciated.

As far as the request is concerned please find below the logic:

Column C in the sheet is Target ID, Column D is Transaction ID and Column AB is 
FnclErr. For row 3 data already reported in the sheet is like (for these 3 
columns only): 


 TargetID  TransID  FnclErr
30839253 144138763 Revenues Missed, Total Assets Missed, Total 
Common Equity Missed, Net Income 


I want this data to appear in the below mentioned format in a new sheet


TargetID  TransID  FnclErr
30839253 144138763   Revenues Missed
30839253 144138763   Total Assets Missed
30839253 144138763   Total Common Equity Missed
30839253 144138763   Net Income Missed.

Please let me know if I am missing something over here

Regards,

Nitin Arora

 
On Wed, Jan 4, 2012 at 6:51 PM, dguillett1  wrote:

FIRST. To some of us, ME, “urgent help required” is a NO NO. All requests are 
urgent.
>Now, you will need to explain the logic of what you want. If you want to find 
>every comma on the sheet, what will you do with numbers, etc? You need to 
>specify which columns to search and you need to tell us where you want the 
>data? 
>Do you want the file changed or do you want a list on another sheet?, etc.
>
>Don Guillett
>SalesAid Software
>dguille...@gmail.com
>
>From: nitin arora 
>Sent: Wednesday, January 04, 2012 1:20 AM
>To: excel-macros 
>Subject: $$Excel-Macros$$ Urgent help required
>
>Hi,
>Please find attached excel sheet named Errors Bifurcation.
>In this sheet there are many columns in which errors have been reported 
>seperated by commas. I want that all the errors seperated by commas should 
>appear in seperate rows with the data for Target ID and Tranaction ID. For 
>example:
>In Column AB 3, the data reported is: Revenues Missed, Total Assets Missed, 
>Total Common Equity Missed, Net Income Missed.
>I want this data to appear as:
>
>TargetID  TransID  FnclErr
>30839253 144138763   Revenues Missed
>30839253 144138763   Total Assets Missed
>30839253 144138763   Total Common Equity Missed
>30839253 144138763   Net Income Missed.
>It would be great if you can tell me a solution for this.
>Many Thanks in advance.
>Regards,
>Nitin Arora
>-- 
>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 
>

Re: $$Excel-Macros$$ Urgent help required

[dguillett1]

It appears that Paul has solved it for you.

Don Guillett
SalesAid Software
dguille...@gmail.com

From: nitin arora 
Sent: Wednesday, January 04, 2012 7:52 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Urgent help required

Hi Don,

My apologies for the subject and I promise this wont happen in future. As far 
as "Me" is concerned I am relatively new to this concept of groups so i have no 
Idea where should I go to change it to my name. Any help on this front would be 
highly appreciated.

As far as the request is concerned please find below the logic:

Column C in the sheet is Target ID, Column D is Transaction ID and Column AB is 
FnclErr. For row 3 data already reported in the sheet is like (for these 3 
columns only): 

TargetID  TransID  FnclErr
30839253 144138763 Revenues Missed, Total Assets Missed, Total 
Common Equity Missed, Net Income 

I want this data to appear in the below mentioned format in a new sheet


TargetID  TransID  FnclErr
30839253 144138763   Revenues Missed
30839253 144138763   Total Assets Missed
30839253 144138763   Total Common Equity Missed
30839253 144138763   Net Income Missed.

Please let me know if I am missing something over here

Regards,

Nitin Arora

 
On Wed, Jan 4, 2012 at 6:51 PM, dguillett1  wrote:

  FIRST. To some of us, ME, “urgent help required” is a NO NO. All requests are 
urgent.
  Now, you will need to explain the logic of what you want. If you want to find 
every comma on the sheet, what will you do with numbers, etc? You need to 
specify which columns to search and you need to tell us where you want the 
data? Do you want the file changed or do you want a list on another sheet?, etc.

  Don Guillett
  SalesAid Software
  dguille...@gmail.com

  From: nitin arora 
  Sent: Wednesday, January 04, 2012 1:20 AM
  To: excel-macros 
  Subject: $$Excel-Macros$$ Urgent help required

  Hi,

  Please find attached excel sheet named Errors Bifurcation.

  In this sheet there are many columns in which errors have been reported 
seperated by commas. I want that all the errors seperated by commas should 
appear in seperate rows with the data for Target ID and Tranaction ID. For 
example:

  In Column AB 3, the data reported is: Revenues Missed, Total Assets Missed, 
Total Common Equity Missed, Net Income Missed.

  I want this data to appear as:


  TargetID  TransID  FnclErr

  30839253 144138763   Revenues Missed

  30839253 144138763   Total Assets Missed

  30839253 144138763   Total Common Equity Missed

  30839253 144138763   Net Income Missed.

  It would be great if you can tell me a solution for this.

  Many Thanks in advance.

  Regards,

  Nitin Arora


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


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

Re: $$Excel-Macros$$ Urgent help required

[Kris]

Hi Paul,

Can you do a favour for me ? 

ping me your mail ID at: excelfox at live.in

Kris

-- 
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$$ Urgent Help Required (Counta)

[Ravinder Kumar]

Hi Ashish,

Please confirm that the all data in a single sheet or in different
different sheets.




On Sat, Sep 7, 2013 at 11:13 AM, Ashish Kumar wrote:

> Dear Seniors,
>
>
> I want total count of Sold Items according to the state or months. I'hve
> tried this through Counta formula but this is huge volume of data, so
> please suggest me the easy way.
>
>
> 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.

Re: $$Excel-Macros$$ Urgent Help Required (Counta)

[De Premor]

The good thing is that your sheet name have a same name with what we are 
looking for also the name of month, so we can process it easily, try 
this on B2


=COUNTA(OFFSET(INDIRECT($A2&"!$A1" 
),2,MATCH(B$1,INDIRECT($A2&"!$1:$1"),0)-1,2^16))


On 07-09-2013 12:43, Ashish Kumar wrote:

Dear Seniors,


I want total count of Sold Items according to the state or months. 
I'hve tried this through Counta formula but this is huge volume of 
data, so please suggest me the easy way.



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.

Re: $$Excel-Macros$$ Urgent Help Required (Counta)

[Ashish Kumar]

Dear Senior,

All data in single workbook in different sheets and i want to create a 
summary in output sheet. Data pattern will be same according to the sheet 
which i'hve attached for query reference.


Thanks,
Ashish

On Saturday, September 7, 2013 11:22:03 AM UTC+5:30, Excel Group wrote:
>
> Hi Ashish,
>
> Please confirm that the all data in a single sheet or in different 
> different sheets. 
>
>
>
>
> On Sat, Sep 7, 2013 at 11:13 AM, Ashish Kumar 
> 
> > wrote:
>
>> Dear Seniors,
>>
>>
>> I want total count of Sold Items according to the state or months. I'hve 
>> tried this through Counta formula but this is huge volume of data, so 
>> please suggest me the easy way.
>>
>>
>> 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...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com
>> .
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/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$$ Urgent Help Required (Counta)

[Ashish Kumar]

Dear De Premor & Ravinder Sir,

Thanks for your help and valuable support. Thanks a lot.


Thanks,
Ashish Kumar

On Saturday, September 7, 2013 11:32:20 AM UTC+5:30, De Premor wrote:
>
> The good thing is that your sheet name have a same name with what we are 
> looking for also the name of month, so we can process it easily, try 
> this on B2 
>
> =COUNTA(OFFSET(INDIRECT($A2&"!$A1" 
> ),2,MATCH(B$1,INDIRECT($A2&"!$1:$1"),0)-1,2^16)) 
>
> On 07-09-2013 12:43, Ashish Kumar wrote: 
> > Dear Seniors, 
> > 
> > 
> > I want total count of Sold Items according to the state or months. 
> > I'hve tried this through Counta formula but this is huge volume of 
> > data, so please suggest me the easy way. 
> > 
> > 
> > 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...@googlegroups.com . 
> > To post to this group, send email to 
> > excel-...@googlegroups.com. 
>
> > Visit this group at http://groups.google.com/group/excel-macros. 
> > For more options, visit https://groups.google.com/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$$ Urgent Help Required in a macro

[Dave Bonallack]

Hi Zac,

Can I suggest a simpler approach?

Using the Ctrl key, select the 2 cells you want to swap, then use a shortcut 
key to run this code:

 

Sub swap()
If Selection.Count <> 2 Then Exit Sub
A = ActiveCell.Value
B = ActiveCell.Address
For Each c In Selection
c.Select
Exit For
Next c
D = ActiveCell.Value
ActiveCell.Value = A
Range(B).Value = D
End Sub


It should be quicker than a dialogue box with 3 questions.

 

Regards - Dave.
 


Date: Tue, 20 Apr 2010 14:55:44 +0300
Subject: $$Excel-Macros$$ Urgent Help Required in a macro
From: chaudhry.zahid@gmail.com
To: excel-macros@googlegroups.com



Hi Group,
 
I'm working in a huge excel sheet with thousands of entries. I am currently 
looking for a macro, that when invoked (upon press of a key etc) would open a 
dialogue box having three fields. The first field being Select Row, In which I 
can write a row number Like 3, the second filed would contain "Replace item 
from column", where I can write, for example G, and the third field containing 
an other "Replace item from column" for example AA. In this case the VBA code 
should select cells G3 and AA3. Than when I press enter or a button on the 
excel sheet the contents of cell G3 should go to AA3 and contents of AA3 should 
go to G3. The dialogue should not close after the cell contents have been 
replaced, but should close upon clicking the cross because there would be 
mutiple entries that need correction.
 
An urgent reply and help would be highly appriciated, I have very little time 
to do tjis HUGE task of finding and replacing data in excel.
 
Thanks in advance and Regards,
 
ZAC.

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

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
 
We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
  
_
Need a new place to live? Find it on Domain.com.au
http://clk.atdmt.com/NMN/go/157631292/direct/01/

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

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

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

Re: $$Excel-Macros$$ Urgent Help Required in a macro

[Chaudhry Zahid Ali]

Thanks a bundle Dave. This has expedited my work even more. :-)

(P.S) Can anyone refer me to a good course from where I can learn to write
macros...

On Wed, Apr 21, 2010 at 4:31 AM, Dave Bonallack
wrote:

> Hi Zac,
> Can I suggest a simpler approach?
> Using the Ctrl key, select the 2 cells you want to swap, then use a
> shortcut key to run this code:
>
> Sub swap()
> If Selection.Count <> 2 Then Exit Sub
> A = ActiveCell.Value
> B = ActiveCell.Address
> For Each c In Selection
> c.Select
> Exit For
> Next c
> D = ActiveCell.Value
> ActiveCell.Value = A
> Range(B).Value = D
> End Sub
>
> It should be quicker than a dialogue box with 3 questions.
>
> Regards - Dave.
>
> --
> Date: Tue, 20 Apr 2010 14:55:44 +0300
> Subject: $$Excel-Macros$$ Urgent Help Required in a macro
> From: chaudhry.zahid@gmail.com
> To: excel-macros@googlegroups.com
>
>
>  Hi Group,
>
> I'm working in a huge excel sheet with thousands of entries. I am currently
> looking for a macro, that when invoked (upon press of a key etc) would open
> a dialogue box having three fields. The first field being Select Row, In
> which I can write a row number Like 3, the second filed would contain
> "Replace item from column", where I can write, for example G, and the third
> field containing an other "Replace item from column" for example AA. In this
> case the VBA code should select cells G3 and AA3. Than when I press enter or
> a button on the excel sheet the contents of cell G3 should go to AA3 and
> contents of AA3 should go to G3. The dialogue should not close after the
> cell contents have been replaced, but should close upon clicking the cross
> because there would be mutiple entries that need correction.
>
> An urgent reply and help would be highly appriciated, I have very little
> time to do tjis HUGE task of finding and replacing data in excel.
>
> Thanks in advance and Regards,
>
> ZAC.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
> --
> Find it on Domain.com.au  Need a new place to 
> live?
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

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

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

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

RE: $$Excel-Macros$$ Urgent Help Required in a macro

[Dave Bonallack]

You're welcome.
Regards - Dave.

Date: Wed, 21 Apr 2010 11:45:50 +0300
Subject: Re: $$Excel-Macros$$ Urgent Help Required in a macro
From: chaudhry.zahid@gmail.com
To: excel-macros@googlegroups.com

Thanks a bundle Dave. This has expedited my work even more. :-)
 
(P.S) Can anyone refer me to a good course from where I can learn to write 
macros...


On Wed, Apr 21, 2010 at 4:31 AM, Dave Bonallack  
wrote:


Hi Zac,
Can I suggest a simpler approach?
Using the Ctrl key, select the 2 cells you want to swap, then use a shortcut 
key to run this code:
 
Sub swap()
If Selection.Count <> 2 Then Exit Sub

A = ActiveCell.Value
B = ActiveCell.Address
For Each c In Selection
c.Select
Exit For
Next c
D = ActiveCell.Value
ActiveCell.Value = A
Range(B).Value = D

End Sub

It should be quicker than a dialogue box with 3 questions.
 
Regards - Dave.
 


Date: Tue, 20 Apr 2010 14:55:44 +0300
Subject: $$Excel-Macros$$ Urgent Help Required in a macro
From: chaudhry.zahid@gmail.com
To: excel-macros@googlegroups.com 






Hi Group,
 
I'm working in a huge excel sheet with thousands of entries. I am currently 
looking for a macro, that when invoked (upon press of a key etc) would open a 
dialogue box having three fields. The first field being Select Row, In which I 
can write a row number Like 3, the second filed would contain "Replace item 
from column", where I can write, for example G, and the third field containing 
an other "Replace item from column" for example AA. In this case the VBA code 
should select cells G3 and AA3. Than when I press enter or a button on the 
excel sheet the contents of cell G3 should go to AA3 and contents of AA3 should 
go to G3. The dialogue should not close after the cell contents have been 
replaced, but should close upon clicking the cross because there would be 
mutiple entries that need correction.

 
An urgent reply and help would be highly appriciated, I have very little time 
to do tjis HUGE task of finding and replacing data in excel.
 
Thanks in advance and Regards,
 
ZAC.
-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com

4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com


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

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




Find it on Domain.com.au Need a new place to live?




-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com

4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com


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

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







-- 

--

Some important links for excel users:

1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310

3. Excel tutorials at http://www.excel-macros.blogspot.com

4. Learn VBA Macros at http://www.quickvba.blogspot.com

5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 

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

 

<><><><><><><><><><><><><><><><><><><><><><>

HELP US GROW !!

 

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and

Re: $$Excel-Macros$$ Urgent: Help required in VBA form

[Ahmed Honest]

Hey Pankaj,

The File is password protected, provide password to unlock and get the
required.

Group is waiting



On Tue, Aug 3, 2010 at 7:13 PM, Intelligent But Crazy
wrote:

> Hi group,
>
> My self pankaj,
> currentally I m working on a project, I have created a Excel VBA form
> for quality analysis, but i m facing a problem that when the VBA form
> is open in this Excel so i m unable to activate any onather Excel
> file.
> Pls help me in this only because of this my whole project will be useless.
>
>
> Excel file is attech for refarence.
>
> Thanks
> Pankaj k Pandey
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 
Ahmed Bawazir

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

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

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

Re: $$Excel-Macros$$ Urgent: Help required in VBA form

[Intelligent But Crazy]

My Apologiese

 Pls find the Password details.

  For Workbook: bads...@143
   For VBA Editor  : bads...@143
   For Worksheets   : SecretShot
   For Mastersheet  : SecretShot



Pls help me in this.

Thanks
Pankaj k Pandey

On 8/3/10, Intelligent But Crazy  wrote:
> Hi group,
>
>  My self pankaj,
> currentally I m working on a project, I have created a Excel VBA form
> for quality analysis, but i m facing a problem that when the VBA form
> is open in this Excel so i m unable to activate any onather Excel
> file.
> Pls help me in this only because of this my whole project will be useless.
>
>
> Excel file is attech for refarence.
>
> Thanks
> Pankaj k Pandey
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>


-- 
Pankaj Pandey
Bhopal

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

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

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

Re: $$Excel-Macros$$ Urgent: Help required in VBA form

[Intelligent But Crazy]

Hi Dav,

First of all congrats, I request you to pls help me in
this problem, my whok project n promotion is now only depands on this.

I m waitinig for your reply.


Regards
Pankaj k Pandey


On 8/4/10, Intelligent But Crazy  wrote:
> My Apologiese
>
>  Pls find the Password details.
>
>   For Workbook: bads...@143
>For VBA Editor  : bads...@143
>For Worksheets   : SecretShot
>For Mastersheet  : SecretShot
>
>
>
> Pls help me in this.
>
> Thanks
> Pankaj k Pandey
>
> On 8/3/10, Intelligent But Crazy  wrote:
>> Hi group,
>>
>>  My self pankaj,
>> currentally I m working on a project, I have created a Excel VBA form
>> for quality analysis, but i m facing a problem that when the VBA form
>> is open in this Excel so i m unable to activate any onather Excel
>> file.
>> Pls help me in this only because of this my whole project will be
>> useless.
>>
>>
>> Excel file is attech for refarence.
>>
>> Thanks
>> Pankaj k Pandey
>>
>> --
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 7000 subscribers worldwide and receive many nice notes
>> about
>> the learning and support from the group.Let friends and co-workers know
>> they
>> can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
>
> --
> Pankaj Pandey
> Bhopal
>


-- 
Pankaj Pandey
Bhopal

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

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

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

Re: $$Excel-Macros$$ Urgent: Help required in VBA form

[Kishan Reddy, K]

Try this,

But check it may have adverse effects,

Private Sub CommandButton2_Click()
UserForm1.Show 0
End Sub

Also check for help on SHOW method ( modal/nonmodal forms).

Share with me if you have any problems

Bye,

Kishan Reddy, K
kishanreddy.kethire...@gmail.com


On Aug 5, 6:38 am, Intelligent But Crazy  wrote:
> Hi Dav,
>
>                 First of all congrats, I request you to pls help me in
> this problem, my whok project n promotion is now only depands on this.
>
> I m waitinig for your reply.
>
> Regards
> Pankaj k Pandey
>
> On 8/4/10, Intelligent But Crazy  wrote:
>
>
>
> > My Apologiese
>
> >                  Pls find the Password details.
>
> >       For Workbook        : bads...@143
> >        For VBA Editor      : bads...@143
> >        For Worksheets   : SecretShot
> >        For Mastersheet  : SecretShot
>
> > Pls help me in this.
>
> > Thanks
> > Pankaj k Pandey
>
> > On 8/3/10, Intelligent But Crazy  wrote:
> >> Hi group,
>
> >>              My self pankaj,
> >> currentally I m working on a project, I have created a Excel VBA form
> >> for quality analysis, but i m facing a problem that when the VBA form
> >> is open in this Excel so i m unable to activate any onather Excel
> >> file.
> >> Pls help me in this only because of this my whole project will be
> >> useless.
>
> >> Excel file is attech for refarence.
>
> >> Thanks
> >> Pankaj k Pandey
>
> >> --
> >> --
> >> Some important links for excel users:
> >> 1. Follow us on TWITTER for tips tricks and links :
> >>http://twitter.com/exceldailytip
> >> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> >> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> >> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> >> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> >> To post to this group, send email to excel-macros@googlegroups.com
>
> >> <><><><><><><><><><><><><><><><><><><><><><>
> >> HELP US GROW !!
>
> >> We reach over 7000 subscribers worldwide and receive many nice notes
> >> about
> >> the learning and support from the group.Let friends and co-workers know
> >> they
> >> can subscribe to group at
> >>http://groups.google.com/group/excel-macros/subscribe
>
> > --
> > Pankaj Pandey
> > Bhopal
>
> --
> Pankaj Pandey
> Bhopal

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

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

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

Re: $$Excel-Macros$$ Urgent: Help required in VBA form

[Intelligent But Crazy]

Agreed with your point, but i want that if i required so i can only
see any other Excel file while opening a Form. I dont want to do any
thing on that file just want to see for refrence.

Kindly suggest

Regards
Pankaj k Pandey
On 8/5/10, Intelligent But Crazy  wrote:
> Hi Dav,
>
> First of all congrats, I request you to pls help me in
> this problem, my whok project n promotion is now only depands on this.
>
> I m waitinig for your reply.
>
>
> Regards
> Pankaj k Pandey
>
>
> On 8/4/10, Intelligent But Crazy  wrote:
>> My Apologiese
>>
>>  Pls find the Password details.
>>
>>   For Workbook: bads...@143
>>For VBA Editor  : bads...@143
>>For Worksheets   : SecretShot
>>For Mastersheet  : SecretShot
>>
>>
>>
>> Pls help me in this.
>>
>> Thanks
>> Pankaj k Pandey
>>
>> On 8/3/10, Intelligent But Crazy  wrote:
>>> Hi group,
>>>
>>>  My self pankaj,
>>> currentally I m working on a project, I have created a Excel VBA form
>>> for quality analysis, but i m facing a problem that when the VBA form
>>> is open in this Excel so i m unable to activate any onather Excel
>>> file.
>>> Pls help me in this only because of this my whole project will be
>>> useless.
>>>
>>>
>>> Excel file is attech for refarence.
>>>
>>> Thanks
>>> Pankaj k Pandey
>>>
>>> --
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> HELP US GROW !!
>>>
>>> We reach over 7000 subscribers worldwide and receive many nice notes
>>> about
>>> the learning and support from the group.Let friends and co-workers know
>>> they
>>> can subscribe to group at
>>> http://groups.google.com/group/excel-macros/subscribe
>>>
>>
>>
>> --
>> Pankaj Pandey
>> Bhopal
>>
>
>
> --
> Pankaj Pandey
> Bhopal
>


-- 
Pankaj Pandey
Bhopal

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

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

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

Re: $$Excel-Macros$$ Urgent: Help required in VBA form

[Intelligent But Crazy]

Thanks a lot Krisnan

It is working.
I really appricieat your knowladge, I m glade to get help from you.

Regards
Pankaj k PAndey

On 8/5/10, Kishan Reddy, K  wrote:
> Try this,
>
> But check it may have adverse effects,
>
> Private Sub CommandButton2_Click()
> UserForm1.Show 0
> End Sub
>
> Also check for help on SHOW method ( modal/nonmodal forms).
>
> Share with me if you have any problems
>
> Bye,
>
> Kishan Reddy, K
> kishanreddy.kethire...@gmail.com
>
>
> On Aug 5, 6:38 am, Intelligent But Crazy  wrote:
>> Hi Dav,
>>
>> First of all congrats, I request you to pls help me in
>> this problem, my whok project n promotion is now only depands on this.
>>
>> I m waitinig for your reply.
>>
>> Regards
>> Pankaj k Pandey
>>
>> On 8/4/10, Intelligent But Crazy  wrote:
>>
>>
>>
>> > My Apologiese
>>
>> >  Pls find the Password details.
>>
>> >   For Workbook: bads...@143
>> >For VBA Editor  : bads...@143
>> >For Worksheets   : SecretShot
>> >For Mastersheet  : SecretShot
>>
>> > Pls help me in this.
>>
>> > Thanks
>> > Pankaj k Pandey
>>
>> > On 8/3/10, Intelligent But Crazy  wrote:
>> >> Hi group,
>>
>> >>  My self pankaj,
>> >> currentally I m working on a project, I have created a Excel VBA form
>> >> for quality analysis, but i m facing a problem that when the VBA form
>> >> is open in this Excel so i m unable to activate any onather Excel
>> >> file.
>> >> Pls help me in this only because of this my whole project will be
>> >> useless.
>>
>> >> Excel file is attech for refarence.
>>
>> >> Thanks
>> >> Pankaj k Pandey
>>
>> >> --
>> >> --
>> >> Some important links for excel users:
>> >> 1. Follow us on TWITTER for tips tricks and links :
>> >>http://twitter.com/exceldailytip
>> >> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
>> >> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
>> >> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
>> >> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>>
>> >> To post to this group, send email to excel-macros@googlegroups.com
>>
>> >> <><><><><><><><><><><><><><><><><><><><><><>
>> >> HELP US GROW !!
>>
>> >> We reach over 7000 subscribers worldwide and receive many nice notes
>> >> about
>> >> the learning and support from the group.Let friends and co-workers know
>> >> they
>> >> can subscribe to group at
>> >>http://groups.google.com/group/excel-macros/subscribe
>>
>> > --
>> > Pankaj Pandey
>> > Bhopal
>>
>> --
>> Pankaj Pandey
>> Bhopal
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>


-- 
Pankaj Pandey
Bhopal

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

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

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

Re: $$Excel-Macros$$ Urgent: Help required in VBA form

[madhukar reddy]

Hi Pankaj

What is the password of Excel sheet

Regards
Madhu





From: Intelligent But Crazy 
To: excel-macros@googlegroups.com
Cc: Intelligent But Crazy 
Sent: Tue, 3 August, 2010 9:43:41 PM
Subject: $$Excel-Macros$$ Urgent: Help required in VBA form

Hi group,

 My self pankaj,
currentally I m working on a project, I have created a Excel VBA form
for quality analysis, but i m facing a problem that when the VBA form
is open in this Excel so i m unable to activate any onather Excel
file.
Pls help me in this only because of this my whole project will be useless.


Excel file is attech for refarence.

Thanks
Pankaj k Pandey

-- 
--

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

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

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

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


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

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

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

Re: $$Excel-Macros$$ Urgent help required for Vlookup macro code

[Anil Gawli]

just share your data.
Gawli Anil

On Tue, Jun 5, 2012 at 10:00 AM, Nagendra Modupalli wrote:

> Hi Experts,
>
> I have data with Employee number,based on employee number i need to
> get the date of join.i have many file with DOJ.
>
> What is the VBA vlookup code for looking one file and if not find the
> DOJ filter blanks and asking next file to lookup. Thanks in advance.
>
>
> --
> Thanks&Regards
> Nagendra.M
>
> "Beautiful photos are developed by negatives in a dark room, so if U
> see darkness in Ur life believe that God is making a beautiful future
> for U !!!
>
> --
> 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

Re: $$Excel-Macros$$ Urgent help required for Vlookup macro code

[NOORAIN ANSARI]

Dear Nagendra,

Please use it

Sub USINGVLOOKUP()

Dim X As Range

Set X = Sheets(1).Range("$A$1:$D$9")

Range("E15").Value
=Application.Worksheetfunction.VLookup(Sheets(1).Range("B15").Value, X, 4,
False)



End Sub

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

On Tue, Jun 5, 2012 at 10:00 AM, Nagendra Modupalli wrote:

> Hi Experts,
>
> I have data with Employee number,based on employee number i need to
> get the date of join.i have many file with DOJ.
>
> What is the VBA vlookup code for looking one file and if not find the
> DOJ filter blanks and asking next file to lookup. Thanks in advance.
>
>
> --
> Thanks&Regards
> Nagendra.M
>
> "Beautiful photos are developed by negatives in a dark room, so if U
> see darkness in Ur life believe that God is making a beautiful future
> for U !!!
>
> --
> 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$$ Urgent help required for Vlookup macro code

[dguillett1]

May I ask why your request is more urgent and more important than the other 
requests.??




Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message- 
From: Nagendra Modupalli

Sent: Monday, June 04, 2012 11:30 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Urgent help required for Vlookup macro code

Hi Experts,

I have data with Employee number,based on employee number i need to
get the date of join.i have many file with DOJ.

What is the VBA vlookup code for looking one file and if not find the
DOJ filter blanks and asking next file to lookup. Thanks in advance.


--
Thanks&Regards
Nagendra.M

"Beautiful photos are developed by negatives in a dark room, so if U
see darkness in Ur life believe that God is making a beautiful future
for U !!!

--
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$$ Urgent help required in converting a number into text

[Shaik Waheed]

Hi,



Function English(ByVal N As Currency) As String



Const Thousand = 1000@

Const Million = Thousand * Thousand

Const Billion = Thousand * Million

Const Trillion = Thousand * Billion



If (N = 0@) Then English = "zero": Exit Function



Dim Buf As String: If (N < 0@) Then Buf = "negative " Else Buf = ""

Dim Frac As Currency: Frac = Abs(N - Fix(N))

If (N < 0@ Or Frac <> 0@) Then N = Abs(Fix(N))

Dim AtLeastOne As Integer: AtLeastOne = N >= 1



If (N >= Trillion) Then

Debug.Print N

Buf = Buf & EnglishDigitGroup(Int(N / Trillion)) & " trillion"

N = N - Int(N / Trillion) * Trillion

If (N >= 1@) Then Buf = Buf & " "

End If



If (N >= Billion) Then

Debug.Print N

Buf = Buf & EnglishDigitGroup(Int(N / Billion)) & " billion"

N = N - Int(N / Billion) * Billion

If (N >= 1@) Then Buf = Buf & " "

End If



If (N >= Million) Then

Debug.Print N

Buf = Buf & EnglishDigitGroup(N \ Million) & " million"

N = N Mod Million

If (N >= 1@) Then Buf = Buf & " "

End If



If (N >= Thousand) Then

Debug.Print N

Buf = Buf & EnglishDigitGroup(N \ Thousand) & " thousand"

N = N Mod Thousand

If (N >= 1@) Then Buf = Buf & " "

End If



If (N >= 1@) Then

Debug.Print N

Buf = Buf & EnglishDigitGroup(N)

End If



If (Frac = 0@) Then

Buf = Buf & " exactly"

ElseIf (Int(Frac * 100@) = Frac * 100@) Then

If AtLeastOne Then Buf = Buf & " and "

Buf = Buf & Format$(Frac * 100@, "00") & "/100"

Else

If AtLeastOne Then Buf = Buf & " and "

Buf = Buf & Format$(Frac * 1@, "") & "/1"

End If



English = Buf

End Function







Private Function EnglishDigitGroup(ByVal N As Integer) As String



Const Hundred = " hundred"

Const One = "one"

Const Two = "two"

Const Three = "three"

Const Four = "four"

Const Five = "five"

Const Six = "six"

Const Seven = "seven"

Const Eight = "eight"

Const Nine = "nine"

Dim Buf As String: Buf = ""

Dim Flag As Integer: Flag = False



Select Case (N \ 100)

Case 0: Buf = "": Flag = False

Case 1: Buf = One & Hundred: Flag = True

Case 2: Buf = Two & Hundred: Flag = True

Case 3: Buf = Three & Hundred: Flag = True

Case 4: Buf = Four & Hundred: Flag = True

Case 5: Buf = Five & Hundred: Flag = True

Case 6: Buf = Six & Hundred: Flag = True

Case 7: Buf = Seven & Hundred: Flag = True

Case 8: Buf = Eight & Hundred: Flag = True

Case 9: Buf = Nine & Hundred: Flag = True

End Select



If (Flag <> False) Then N = N Mod 100

If (N > 0) Then

If (Flag <> False) Then Buf = Buf & " "

Else

EnglishDigitGroup = Buf

Exit Function

End If



Select Case (N \ 10)

Case 0, 1: Flag = False

Case 2: Buf = Buf & "twenty": Flag = True

Case 3: Buf = Buf & "thirty": Flag = True

Case 4: Buf = Buf & "forty": Flag = True

Case 5: Buf = Buf & "fifty": Flag = True

Case 6: Buf = Buf & "sixty": Flag = True

Case 7: Buf = Buf & "seventy": Flag = True

Case 8: Buf = Buf & "eighty": Flag = True

Case 9: Buf = Buf & "ninety": Flag = True

End Select



If (Flag <> False) Then N = N Mod 10

If (N > 0) Then

If (Flag <> False) Then Buf = Buf & "-"

Else

EnglishDigitGroup = Buf

Exit Function

End If



Select Case (N)

Case 0:

Case 1: Buf = Buf & One

Case 2: Buf = Buf & Two

Case 3: Buf = Buf & Three

Case 4: Buf = Buf & Four

Case 5: Buf = Buf & Five

Case 6: Buf = Buf & Six

Case 7: Buf = Buf & Seven

Case 8: Buf = Buf & Eight

Case 9: Buf = Buf & Nine

Case 10: Buf = Buf & "ten"

Case 11: Buf = Buf & "eleven"

Case 12: Buf = Buf & "twelve"

Case 13: Buf = Buf & "thirteen"

Case 14: Buf = Buf & "fourteen"

Case 15: Buf = Buf & "fifteen"

Case 16: Buf = Buf & "sixteen"

Case 17: Buf = Buf & "seventeen"

Case 18: Buf = Buf & "eighteen"

Case 19: Buf = Buf & "nineteen"

End Select



EnglishDigitGroup = Buf



End Function


On Mon, Apr 16, 2012 at 11:52 AM, Devendra Sahay <
devendrasahanypt...@gmail.com> wrote:

> Hi...
>
>
>   Please help me on this problem..
>
> --
> P  Before printing, think about the environment.
>
>
> Devendra sahay
>
> --
> 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