$$Excel-Macros$$ Re: 5 Hidden Tricks In Microsoft Excel You Must Know

[Ayush Jain]

Thanks for sharing.

On Wednesday, 18 May 2016 15:42:46 UTC+5:30, Shivani Shukla wrote:
>
> Hello All,
>
> I have found a new article about Microsoft Excel says that *5 Hidden 
> Tricks In Microsoft Excel You Must Know 
> *.
>  
> These are really good and very helpful to professionals, who's working on 
> excel daily like me.
>
> Looking forward for our valuable feedback. Thanks in advance.
>

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

$$Excel-Macros$$ Invitation to the Excel Modeling World Championships 2014

[Ayush Jain]

Dear members,

We’d like to invite members of the discussexcel.com community to the annual 
Excel and Financial Modeling World Championship 2014 Event (*ModelOff, 
www.modeloff.com http://www.modeloff.com*). The Advanced Excel 
educational competition helps celebrate Excel in Financial Services. The 
fun, challenging and innovative competition has a mission to inspire skill 
development with Microsoft Excel, Financial Modeling and Financial Analysis 
which is central to global businesses and communities. The competition 
showcases some of the fastest, hard-working and talented Excel minds from 
100+ countries. Round 1 starts on 25th October 2014 (8 weeks away)

*Summary of Event*

Over 3,000 participants competed in the ModelOff 2013 event. Major Global 
Partners and Sponsors are: Microsoft, Intralinks, SP Capital IQ, Kaplan 
Education, Bloomberg, AMT Training, Corality and Ernst  
Young.  Participants come from diverse companies and jobs – such as 
Analysts, Associates and Managers at Investment Firms and Accounting Firms, 
CFOs, Analytics Professionals, In-House Excel Gurus and Consultants with a 
shared passion for Microsoft Excel and Finance.  Students comprise ~35% of 
all entrants worldwide – most studying Commerce, Accounting, Finance and 
Masters university qualifications. The countries most represented have 
typically been: United States, UK, Poland, Russia, Canada, Australia, India 
and Hong Kong.  Female participation is ~20% of all competitors - hopefully 
higher this year (the reigning champion is Hilary Smart 26yo from London).

 

*How It Works*

The ModelOff competition involves two online qualification rounds (2 hours 
each) conducted simultaneously around the world. The Top 16 performers are 
flown to New York for the Live Finals at the offices of Microsoft and 
Bloomberg in early December 2014.  Questions are mostly case study and 
multiple choice format – with some ranging from a basic understanding of 
discounted cash flow (DCF) analysis, 3-way integrated cash flow models to 
more complex project finance and simulation techniques.  Some basic 
Accounting, Finance and Excel knowledge is likely needed to progress to 
Round 2.

 

*Free Training and Preparation*

All past questions and tests from ModelOff 2012 and 2013 are free and 
available on the ModelOff website. The organizers believe in accessible 
excellence and this can be a great starting point for anyone looking to 
become involved for the first time and improve their Advanced Excel skills 
in Financial Services and Financial Modeling.  We actively encourage all 
participants to visit all our community partners, bloggers, our major 
global sponsors during and following the event for their own learning, 
mentoring and professional development. Competitors in the Top 10% of 
ModelOff 2014 will be eligible for exciting local and international 
opportunities, offers from community partners and fun learning experiences 
(e.g. Trips to Microsoft Excel in Redmond). We're also hosting free 
networking events in major Financial Centres including Hong Kong, London, 
Sydney, New York and Regional Meetups in the coming months for anyone 
interested in networking and mentoring with Excel-users in their local 
cities. Entry to the competition is $20 for students and $30 for 
professionals.


John R Persico is one of the lead organizers of the ModelOff event. John 
can be contacted at j...@modeloff.com.  Get involved at: www.modeloff.com

Thanks 

Regards

Ayush Jain (Owner and moderator @ discussexcel.com)




http://www.modeloff.com

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Re: I appreciate your help :-)

[Ayush Jain]

Mr Rafique , Please note that this is a voluntary forum and no one is bound
to respond your query in 24 hours.

Have some patience or repost your query as a new post so that other members
can look into it.




On Fri, Nov 8, 2013 at 2:46 PM, MRafique Ujjan imrafiqu...@gmail.comwrote:

 Dear Ayush Jain
 I have posted my problem with the subject named  How to retrieve
 multiple or single data from a single column like (A1) to different
 required columns like (D1, D2, D3...) I got quick response from Mr.
 Ravinder Negi  he almost solved my problem, but there was still a problem
 which I mentioned  Mr. Ravinder Negi also asked me to maximum range of
 Employees Allowances, then I go through my data  I gave complete employees
 allowances with their special code.
But sir after passing more then 24 hours I am still waiting for the
 solution. I don't know whether I did a mistake or there is any other
 problem please help me in this regard (ASAP)
Thanking you in aniticipation



 On Thursday, March 7, 2013 9:06:29 PM UTC+5, Ayush Jain wrote:

 Dear members,

 Let's keep this post to recognize the forum members who have helped you
 in solving problem or has shared any knowledge in the forum.
 Let see who recognize first here.

 Thanks.

 Regards
 Ayush Jain

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




-- 
Best regards,
Ayush Jain

-- 
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$$ Today Function

[Ayush Jain]

=TEXT(A1,MMDD)
 OR
=TEXT(Today(),MMDD)



On Mon, Sep 23, 2013 at 11:46 PM, Bill Q ronsmith...@gmail.com wrote:

 Can someone please tell me how to create a formula that will transpose the
 today function to a 8 digit numerical value ? The today function would be
 in cell A1... B1 would return the value.

 Example:

 A1 = 9/23/213
 B1 = 20130923

 Thanks.

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




-- 
Best regards,
Ayush Jain

-- 
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$$ Today Function

[Ayush Jain]

=VALUE(TEXT(TODAY(),MMDD))


On Tue, Sep 24, 2013 at 12:10 AM, Bill Q ronsmith...@gmail.com wrote:

 Excellent Is there something that can be added to the code so that the
 returned value is in a numeric value ?


 On Monday, 23 September 2013 18:48:32 UTC-4, Ayush Jain wrote:

 =TEXT(A1,MMDD)
  OR
 =TEXT(Today(),MMDD)



 On Mon, Sep 23, 2013 at 11:46 PM, Bill Q ronsm...@gmail.com wrote:

 Can someone please tell me how to create a formula that will transpose
 the today function to a 8 digit numerical value ? The today function
 would be in cell A1... B1 would return the value.

 Example:

 A1 = 9/23/213
 B1 = 20130923

 Thanks.

 --
 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/**discussexcelhttps://www.facebook.com/discussexcel

 FORUM RULES

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

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To 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-macroshttp://groups.google.com/group/excel-macros
 .
 For more options, visit 
 https://groups.google.com/**groups/opt_outhttps://groups.google.com/groups/opt_out
 .




 --
 Best regards,
 Ayush Jain

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




-- 
Best regards,
Ayush Jain

-- 
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$$ If you are interested to build your carrier in BI Developer/MIS/Database Reporting

[Ayush Jain]

Hi Syed

Its not mandatory to solve any query in the forum as we only expect
voluntary contribution from forum members.
Contribution should be driven by passion to help others.

At the same time, we expect the forum members to follow the rules and not
to post any ads or jobs in the forum.
You have posted a job post which is against the rules of this forum and can
be banned for such violation.

Please take care in future. Let me know if you have any concerns.

Regards
Ayush Jain







On Sun, Jun 9, 2013 at 1:19 PM, syed aliya raza hashim
hashim...@gmail.comwrote:

 Hi Satish/Ayush,

 Let me tell you one thing it is not mandatory to solve any query right and
 for your kind information I use to solve many query in earlier days but now
 a days I dont have the time for these kind of stuff due to busy schedule,




 On Sun, Jun 9, 2013 at 7:17 AM, Satish Raghav satishragha...@gmail.comwrote:


 Hi Ayush,

 Pls ban this user, this group is not a advertising platform,
 I have attached this group from long period but this user has not solved
 any query of Excel and VBA.


 Now a days this type of some peoples are miss guiding to users by using
 this group.
 Kindly strictly ban this type of users.


 Thanks,
 Satish R.


 -- Forwarded message --
 From: syed aliya raza hashim hashim...@gmail.com
 Date: Sun, Jun 9, 2013 at 12:05 AM
 Subject: $$Excel-Macros$$ If you are interested to build your carrier in
 BI Developer/MIS/Database Reporting
 To: excel-macros@googlegroups.com


 Hi If you want to build your carrier in BI developer /MIS Reporting/SQL
 server coding basic and advance (dynamic Query) and VBA ,EXCEL then Please
 Call 9953256629
 Currently I  am running a batch ...I am Working In United Health Group as
 an Sr.Database Reporting


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

 FORUM RULES

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

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




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

 FORUM RULES

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

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






 --
 syed aliya




-- 
Best regards,
Ayush Jain

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

$$Excel-Macros$$ Most helpful member award stopped.

[Ayush Jain]

Dear members,

Thanks for your active participation and taking this group to new heights.

This is to inform you that we are stopping the 'Most helpful Member' award 
for the below reasons :
1) The award is based on only quantity of the posts and not the quality of 
the posts. It is not possible for us to check each message and keep a track 
of quality delivered.
2) We should recognize the people who explains the reason behind the 
problem and not just give the solution. 
3) I have observed that people post unnecessary question or solution or 
answer and do anything just to increase the post count.

Our target is to maintain the quality in the forum and not increase the 
quantity of posts.

Recognition is very important and hence I am starting a new thread* 'I 
appreciate' *where you can recognize the people who have helped you and you 
want to recognize the efforts. Its open for every member of the forum. I 
hope you like the idea. I welcome your suggestions and please write to me 
if you have any queries,

Thanks again

Keep posting.

Regards
Ayush Jain
Group Manager

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

FORUM RULES

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

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

$$Excel-Macros$$ I appreciate your help :-)

[Ayush Jain]

Dear members, 

Let's keep this post to recognize the forum members who have helped you in 
solving problem or has shared any knowledge in the forum.
Let see who recognize first here.

Thanks.

Regards
Ayush Jain

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ بضائع جنسية +18

[Ayush Jain]

Banned. Thanks for reporting

On Saturday, 5 January 2013 10:49:57 UTC+5:30, §»VIPER«§ wrote:

 Ayush,

 Nowadays lots of spam in group. Moderators should be cautious  

 2013/1/4 سمية صفار trainlo...@gmail.com javascript:

 اول موقع سكس شوب عربي 
 يتميز المتجر  بالمصداقية العالية و الموثوقية الكبيرة 
 الاسعار المنافسة و الجودة العالية 
 توفير كل طرق الدفع السهلة و المتاحة 
 ضم الاف المنتجات الجنسية المتنوعة 
 شحن الى الدول العربية و تجاوز الجمارك 
 السرية و الامان 
 تنوع طرق الشحن و الاستلام 
 ...
 كما يتميز الموقع بتقدين خدمة المواعدة الحصرية و المميزة 
 لينك للموقع
 www.shopar1.com/mer/
 لاحتواء الموقع على منتجات البالغين فقد يحجب ببعض البلدان 
 لذلك و لتجاوز الحظر ارسل رسالة بعنوان ارغب ادخل للموقع 
 ليتم ارسال لكم برامج بروكسيات و روابط مفتوحة 
 البريد 
 mercat...@gmail.com javascript:
 اطلقوا العنان و تسوقوا من سوق المتعة الاول و الاكثر امان و سرية عربيا 
 مع حبي

  -- 
 Join official Facebook page of this forum @ 
 https://www.facebook.com/discussexcel
  
 FORUM RULES
  
 1) Use concise, accurate thread titles. Poor thread titles, like Please 
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security 
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.
  
 NOTE : Don't ever post confidential data in a workbook. Forum owners and 
 members are not responsible for any loss.
 --- 
 You received this message because you are subscribed to the Google Groups 
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-...@googlegroups.comjavascript:
 .
 To unsubscribe from this group, send email to 
 excel-macros...@googlegroups.com javascript:.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
  
  




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

FORUM RULES

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

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

RE: $$Excel-Macros$$ Re: Dynamic calendar quiz : There is a prize for the winner.

[Ayush Jain]

Congratulations to all winners

Thanks for the participation.

-Ayush
 On Dec 14, 2012 8:26 PM, Rajan_Verma rajanverma1...@gmail.com wrote:

 *Vinay’s  worksheet is password protected, I think formula should be
 visible to all *

 * *

 * *

 *Regards*

 *Rajan verma*

 *+91 7838100659 [IM-Gtalk]*

 * *

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *Paul Schreiner
 *Sent:* 14 December 2012 8:20
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ Re: Dynamic calendar quiz : There is a prize
 for the winner.

 ** **

 I asked Ayush how best to make these available.

 I know he's been busy, so hasn't been able to respond.

  

 Some Google Groups do not allow file attachments and have a Files
 section for sharing files.

 But this group ALLOWS attachments, and doesn't have a Files section.

  

 But I'm hesitant to email out a 1Mb zip file to all members!

 (This could cause problems with some email applications)

  

 For now, here are the calendars provided by the winners.

  

 Once I hear from Ayush regarding his recommended method for sharing the
 others, I'll do so.

  

 Once again, Congratulations!

  

 Paul

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

 FORUM RULES

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

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

  

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

 FORUM RULES

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

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




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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Join this Group

[Ayush Jain]

Hi Paul

Thanks for your response.
www.discussexcel.com is a website link to access this group. This was
created by me so that people don't need to remember the full link of Google
groups.

Regards
Ayush Jain

On Wed, Nov 28, 2012 at 6:07 PM, Paul Schreiner schreiner_p...@att.netwrote:

 c




-- 
Best regards,
Ayush Jain

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

FORUM RULES

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

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

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

[Ayush Jain]

CSk, start the new topic please

Thanks.
On Nov 25, 2012 10:01 PM, CSK charandeeps...@gmail.com wrote:


 hi sir
  my query is i have extract last five yrs data of two stocks and one index
 on one sheet and prepare line chart and insert four combo boxes

 1) stock 1
 2) stock 2
 3) Index
 4)time combo box  which incudes if you drag  , less than one year .less
 than than 6 months,2 year,3 year so on  and so forth..
 5) one button  to chgange the chart accordingly

 my objective is if i select from time combo box less than six
 monthsand press that button it will show me less than six month
 chart of the above 3,nd so on so forth


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

 Hey all new and current posters,

 Welcome to excel group,one of the largest online community of excel Fans!

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

 Thanks for your time
 Ayush Jain
 Group Manager
 Microsoft MVP

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

 FORUM RULES

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

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




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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Dynamic calendar quiz : There is a prize for the winner.

[Ayush Jain]

Thanks Vinay

Dear Group, only 6 days left for the quiz, give it a try and you will learn
something new

Looking forward to your active participation

Thanks

Best regards
Ayush Jain
Group manager

On Nov 26, 2012 7:52 AM, VINAY GUPTA vinaygupta...@gmail.com wrote:

 Submitted.
 Regards,
 Vinay Gupta

 On Sun, Nov 18, 2012 at 9:53 PM, Ayush Jain jainayus...@gmail.com wrote:

 Dear members,

 Let's get set for the new year 2013

 Here is inviting you to participate in a quiz to make calendar for the
new year in excel.

 There are some rules to be followed :
 1) No macros to be used and should be formula based, only xlsx file to
be submitted.
 2) The calendar should be dynamic for any year, if you change the year ,
the calendar should update automatically.
 3) The calendar should be in one sheet only
 4) The leap year should be considered.
 5) Last date to submit the calendar is 2nd December 2012
 6) Make sure you create calendar yourself and do not download from
anywhere
 7) Send your calendar to my email id - jainayush85[at]gmail.com. If you
post in the forum, there are chances people take reference from your
calendar.
 8) Once you send the calendar, you can reply to this post for the
confirmation.

 The following will add points to your calendar :
 1) Highlight current date
 2) Highlight bank/public holidays
 3) Calendar formatting and user friendliness

 There is a prize for the best calendar and recognition for the runner up.
 Sponsors for the prize are invited, you can contact me if you want to be
sponsor.

 Looking forward to your active participation in the quiz. Let me know if
you have any queries.

 Many thanks for your contribution to this group. Keep it up

 Regards
 Ayush Jain
 Group Manager

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

 FORUM RULES

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

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




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

 FORUM RULES

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

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



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

FORUM RULES

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

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

$$Excel-Macros$$ Dynamic calendar quiz : There is a prize for the winner.

[Ayush Jain]

Dear members,

Let's get set for the new year 2013

Here is inviting you to participate in a quiz to make calendar for the new 
year in excel. 

There are some rules to be followed :
1) No macros to be used and should be formula based, only xlsx file to be 
submitted.
2) The calendar should be dynamic for any year, if you change the year , 
the calendar should update automatically.
3) The calendar should be in one sheet only
4) The leap year should be considered.
5) Last date to submit the calendar is 2nd December 2012
6) Make sure you create calendar yourself and do not download from anywhere
7) Send your calendar to my email id - jainayush85[at]gmail.com. If you 
post in the forum, there are chances people take reference from your 
calendar. 
8) Once you send the calendar, you can reply to this post for the 
confirmation.

The following will add points to your calendar :
1) Highlight current date
2) Highlight bank/public holidays
3) Calendar formatting and user friendliness

There is a prize for the best calendar and recognition for the runner up.
Sponsors for the prize are invited, you can contact me if you want to be 
sponsor.

Looking forward to your active participation in the quiz. Let me know if 
you have any queries.

Many thanks for your contribution to this group. Keep it up

Regards
Ayush Jain
Group Manager

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

FORUM RULES

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

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

$$Excel-Macros$$ Re: VBA Macros quiz #1

[Ayush Jain]

Visit this link

https://groups.google.com/forum/?fromgroups=#!topic/excel-macros/lwyDr7R6LJk

Regards
Ayush Jain

On Saturday, 17 November 2012 06:43:43 UTC+5:30, Orlando José Mézquita 
Fabián wrote:

 Hi Ayush,

 Where can I see the winners of quizzes?

 On Saturday, November 10, 2012 8:13:08 AM UTC-4, Ayush Jain wrote:

 Hello everyone,

 Here is another quiz for you to test VBA basics. There are 10 multiple 
 choice questions in the quiz and should not take more than 5 minutes to 
 complete the quiz.
 VBA quiz http://goo.gl/PnSfr

 So what you are waiting for , go ahead and take the quiz.
 Click here to participate in quiz. http://goo.gl/PnSfr

 I will share the winners of excel quiz and VBA quiz on 13th November in 
 this forum only. Stay tuned.

 Regards
 Ayush Jain
 Group Manager





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

FORUM RULES

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

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

$$Excel-Macros$$ VBA Macros quiz #1

[Ayush Jain]

Hello everyone,

Here is another quiz for you to test VBA basics. There are 10 multiple 
choice questions in the quiz and should not take more than 5 minutes to 
complete the quiz.
VBA quiz http://goo.gl/PnSfr

So what you are waiting for , go ahead and take the quiz.
Click here to participate in quiz. http://goo.gl/PnSfr

I will share the winners of excel quiz and VBA quiz on 13th November in 
this forum only. Stay tuned.

Regards
Ayush Jain
Group Manager



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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ Conditional formatting

[Ayush Jain]

Hi Shiv

You can use conditional formatting to color the cells(or any other
formatting) based on the value of the cell. I have implemented the same in
the enclosed file.
Let us know if you need any further assistance on this.

Regards
Ayush Jain


On Fri, Nov 9, 2012 at 9:55 PM, Shiva Prasad shivaprasad1...@gmail.comwrote:

 Dear Champs,

 i have on excel one sheet  when i mentioned values of percentages change
 the color of that cells.

 please help me the formula r any macro also.

 plz find the attchement of example of trail sheet.

 plz need .

 --





 Regards,
 Shivaprasad K.

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

 FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

 6) Jobs posting is not allowed.

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

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






-- 
Best regards,
Ayush Jain

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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




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

$$Excel-Macros$$ discussexcel formula quiz 1

[Ayush Jain]

Dear group,

I have created a small formula quiz to test your formula knowledge. This 
quiz has 10 questions related to excel formulas only.
Formula quiz http://goo.gl/DE4V3

Based on your participation and engagement, I will try to launch more such 
activities in the forum
Click here to participate http://goo.gl/DE4V3

Only 50 people can participate, so hurry and participate.

Many Thanks.

Regards,
Ayush Jain
Group Manager

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

$$Excel-Macros$$ Re: Magical Diwali Template (Excel Version)

[Ayush Jain]

Dear Noorain

Please share, what is magical in this template
thanks

-Ayush Jain

On Thursday, 8 November 2012 17:12:23 UTC+5:30, NOORAIN ANSARI wrote:

 Dear Group,

 Please find attached template and double click on it.


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




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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ Required tutorials to learn Basics of DashBoards.

[Ayush Jain]

Hi Sandeep,

You can visit www.dashboardspy.com or chandoo.org for learning the 
dashboards 

Noorain, I am not sure how the document that you shared will be helpful in 
learning dashboards. That attachment is specifically designed to guide 
Digital Dashboard function in IMMEX that may be some proprietary feature 
of some company. It does not at all teaches how to develop dashboard or 
give presentation in excel.

Regards,
Ayush Jain
Group Manager

On Thursday, 8 November 2012 16:40:45 UTC+5:30, sandeep chhajer wrote:

 Thank you sir.

 Sandeep Chhajer.
 Sent on my BlackBerry® from Vodafone
 --
 *From: * NOORAIN ANSARI noorain...@gmail.com javascript: 
 *Sender: * excel-...@googlegroups.com javascript: 
 *Date: *Thu, 8 Nov 2012 11:27:38 +0530
 *To: *excel-...@googlegroups.com javascript:
 *ReplyTo: * excel-...@googlegroups.com javascript: 
 *Subject: *Re: $$Excel-Macros$$ Required tutorials to learn Basics of 
 DashBoards.

 Dear Sandeep,

 Please find attached Dashboard tutorial pdf.
 Hope it will help to you.


 On Thu, Nov 8, 2012 at 10:23 AM, chhajer...@gmail.com javascript:wrote:

 Dear Excel Gurus,
 Recently I have came to know about excel dashboard and its potential 
 while presenting reports. Can any one send me some tutorials for the 
 beginners like me.
 Thanking you in advance.

 Sandeep Chhajer.
 Sent on my BlackBerry® from Vodafone

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

 FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

 6) Jobs posting is not allowed.

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

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





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


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


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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

NOTE  : Don't ever post personal

$$Excel-Macros$$ Re: Urgent Client Positions ::: .Net Lead / .Net Developer -- Work Location : St. John’s, Newfoundland, Canada

[Ayush Jain]

This member is banned

-Ayush Jain



On Wednesday, 7 November 2012 20:49:35 UTC+5:30, sandeep reddy wrote:

 *Hi,*

 *This is Sandeep Representing SancroSoft USA Inc.*

 We have an urgent requirement as follows:

 Please respond with resumes in MS-Word Format with the following details 
 to *sand...@sancrosoftusa.com* javascript:

 Full Name :
 Location :
 Contact Number :
 Email :
 Availability :
 Visa Status :

  *Position 1:**
 .Net Lead*
 Work Location : St. John’s, Newfoundland, Canada.
 Position Type : Long-Term

 We need resource from Canada only

 *Project Leader*
 Strong experience in architecting, designing  developing .NET, Web 
 Services, VSTS (6+ years in .NET, 2+ years in Web Services on a .NET 
 platform)
 Experience in Silverlight  Expressions blend  and WPF is a strongly 
 desired skill
 Experience in SQL / Queries / Stored Procedures on a SQL Server platform
 Must have led a team of 10-15 people on a .NET project, preferably in US, 
 Canada, Australia or UK
 Strong planning  tracking skills
 Excellent communications skills



 --

 *Position 2:**
 Sr.Net Developer*
 Work Location : St. John’s, Newfoundland, Canada.
 Position Type : Long-Term

 We need resource from Canada only


 Strong experience in designing  developing .NET applications (ASP.NET, 
 C#) (4+ years)
 Experience using Microsoft Visual Studio Team System 2010 with Team 
 Foundation server
 Can lead  direct 1-2 developers

   

 *Thanks  Regards*

  

 *Sandeep *

 *[image: Description: Description: Description: Description: Description: 
 Description: Description: cid:image001.jpg@01CD14F0.B169F430] [image: 
 Description: Description: Description: Description: Description: 
 Description: Description: cid:image002.jpg@01CD14F0.B169F430] *

 * **The power of focus*

  

 *SancroSoft USA INC*

 4944 Sunrise Blvd, Suite B-4 || Fair Oaks, CA 95628

 Phone : 916-671-5575 || Fax: 916-200-0305

 E-Mail : sand...@sancrosoftusa.com javascript: || www.sancrosoftusa.com

 We place professionals in contract, contract-to-hire and full-time 
 employment positions across all IT and Engineering disciplines, nationwide

  

 The information contained in this email message is intended only for the 
 personal and confidential use of the recipient(s) named above. The message 
 may be privileged and confidential and protected from disclosure. If the 
 reader of this message is not the intended recipient or an agent 
 responsible for delivering it to the intended recipient, you are hereby 
 notified that you have received this document in error and that any review, 
 dissemination, distribution, copying of this message is strictly 
 prohibited. If you have received this communication in error, please notify 
 us immediately by email and delete the original message.
  
  


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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

$$Excel-Macros$$ Follow forum rules and maintain discipline !!!

[Ayush Jain]

Group,

Kindly request you all to follow rules that you see in signtures and I
hope there will be no such heated arguments in future.

You need not to respond to people who violate the forum rules, just forward
me the email to ban the person. I will take decision to give warning or ban
the person as appropriate.

It is very important for us to maintain the discipline in the forum. Let me
know if you have any queries or feedback.

Thanks and warm regards
Ayush Jain
Group Manager





On Tue, Nov 6, 2012 at 8:07 PM, bwo...@cox.net wrote:

 Bhanu,  Learn to spell.   Paul,  Right On!


  Paul Schreiner schreiner_p...@att.net wrote:
  Sorry you feel that way.
 
  But from someone who has had many, many hours of effort expended
  only to have someone else take the coding and present it as his
  own, and not only get a PROMOTION because of the hours he saved,
  but had someone else terminated because they asked me for help...
 
  I tend to be more suspicious of people who try to get past
  the passwords to get access to someone else's code.
 
  and as for your assertion that you know the rules of the forum...
 
  if you do, then why did you INTENTIONALLY violate them?
 
  sorry if you took it the wrong way...
 
  *I* was trying in a friendly way (unsuccessfully, I guess)
  to explain WHY the rule exists.
  and I tried to humorously (poorly, I guess) to suggest that since
  WE aren't supposed to help break security, there are companies
  out there that DO.
 
  and really... take a look at your request from my perspective (and
 others):
 
  You sent out something that looks like class work (which, you said it is)
  and you're asking to break the security on it
 
  What would you do if one of your students sent this out for the same
 reason?
 
  -
  I guess I was feeling spunky yesterday, and should have done what I
 normally
  do
  and delete any emails that ignore rule #1:
 
  1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help,
  Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
 not get
  quick attention or may not be answered.
 
  sorry to have wasted your time and mine.
  But perhaps we've both learned something.
 
  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: bhanu prakash bhanu...@gmail.com
  To: excel-macros@googlegroups.com
  Sent: Tue, November 6, 2012 6:18:11 AM
  Subject: Re: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect **
 Urgent
  Help Required**
 
 
  Paul,
 
  I know the Rules of the forum...I had using this forum fro almost from
 long
  time..appreciate your efforts in writing lengthy mail on this..
 
  That exam itself designed by me..and I am not taking any exam ( Wrong
  prediction) ..think positively ...this will nt have any loss for any one
 
 
  Finally you suggested plenty of names for password...its better you use
 it
  urself and dont suggest to anyone, which is not necessary here..none of
 them buy
  ur suggestions here...
 
  Hope had clarified your doubts in your mind..finally the gud news is
 that I am
  capable of writing a VBA code to extract the source code in the file and
 I am
  able to open file and do modification in the current test..
 
  Had posted this file in this forum to get speedy  positive
 response.never
  thought ppl like dont know solution to issue and diverting the things in
  different way( negative minded persons--- I will really petty on your
  wife)...now your long philosophy is just waste of time of many..
 
 
  Reagdrs,Bhanu
 
 
  On Mon, Nov 5, 2012 at 8:33 PM, Paul Schreiner schreiner_p...@att.net
 wrote:
 
  Notice Forum Rule #3?
  
  
  3) Don't post questions regarding breaking or bypassing any security
 measure.
  
  
  WE don't have any way of knowing if you own the code or are simply
 trying break
  into the code to determine some type of proprietary information
 (hacking)
  If you are attempting to perform some illegal activity (obtain
 proprietary
  information, etc.)
  then we would them become accomplices in your activity.
  
  From the looks of your file, it looks like someone's classwork, in
 which you are
  attempting
  to find the correct answers, instead of doing the work... (if so, tsk
 tsk).
  
  If this is truly urgent, then there ARE companies out there (try
 Googling)
  that,
  for a fee, will attempt to circumvent the security of your file.
  
  These companies have their own procedures in place to protect them from
  the legal aspects of the service they provide. (hence the need for the
 fee)
  
  We, however, have no such protection.
  
  If, indeed, this is YOUR file, and need to get at the VBA in order to
 grade the
  exams,
  
  then I would suggest trying

$$Excel-Macros$$ Want to get your question answered quickly?

[Ayush Jain]

Dear members,

If you keep below points in mind while asking your query, The chances to 
get answered is just high :

   1. *Ensure your question is not too vague.* Don't assume anyone is 
   familiar with your problem. While you can upload small attachments, 
   describe your problem in the body of the post. We are fortunate to have 
   several Excel gurus, but few mind-readers.
   2. *On the other hand, skip irrelevant details.* Be descriptive and 
   concise. Short, direct, and to-the-point questions with apt thread titles 
   are almost always answered promptly.
   3. *Keep the scope reasonably narrow.* Questions like, How do I set up 
   an accounting system in Excel? might be a long time waiting.
   4. *Explain what you've already tried.* (Calculation is set to 
   automatic, but formulas still don't compute) so helpers don't waste your 
   time or theirs.
   5. *Post a WORKBOOK.* Nobody wants to type data from a picture or paste 
   text from your post into a spreadsheet as a prelude to helping. To attache 
   a file, You can email them as attachments to your group's email address 
   excel-macros@googlegroups.com OR Simply Attach a file during posting 
   in New Google Groups.
   6. If your question has not been answered within a day, consider adding 
   another post with any additional information you believe is relevant. 
   7. Use {} from the post menu to *high**light the syntax*

Many Thanks

Keep Posting,

-Ayush Jain(Group Manager)






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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ Want to get your question answered quickly?

[Ayush Jain]

Somnath, Can you please create your own post for your query.

This is violation of forum rules and you will be banned on repeating this 
action.

-Ayush

On Saturday, 3 November 2012 20:28:26 UTC+5:30, Somnath Khadilkar wrote:

 Dear SIrs, 
I have an XL file with few sheets [ DATANov01] 
 One of the sheets contain general info named -common info 
  . 
One sheet named DATA has 5col. 
   I need to generate as many files from this single file as many are 
   -unique values of the col. B[Circle]. 

The new files so generated must have names which are generatd with 
 the uniq values 
 obtained [ eg MUMBAINov01, BENGALNov01 etc. ] 

 The split files DATA must have all the col of DATA sheets A thru E except 
 B 
 The split files must have ALL rows containing the uniq col in the sheet 
 say MUMBAI has only MUMBAI realated rows [ w/o colm B, now redundant.] 

 All other sheets  of the file must stay unchanged. 

 Cheers 


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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ Create HTML sample html file using EXCEL Macro

[Ayush Jain]

Hey Vignesh

This can simply be achieved by saving the excel file as html file by VBA
code.

Here is the code reference.
Activeworkbook.Sheets(1).range(A1).value = This is my First HTML PAGE
USING EXCEL MACRO
Activeworkbook.saveas C:\Scripts\Test.htm, xlHTML

Hope it helps.

Let us know if you need more assistance. Thanks.

Regards
Ayush Jain
Group Manager

On Mon, Oct 15, 2012 at 10:48 PM, Vignesh S R srvigneshs...@gmail.comwrote:

 hi,

 Anybody can help how to create the Excel macro for creation of HTML page.
 Sample html file like  This is my First HTML PAGE USING EXCEL MACRO

 --
 Vignesh .S.R

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

 FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

 6) Jobs posting is not allowed.

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

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






-- 
Best regards,
Ayush Jain

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

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

[Ayush Jain]

Aamir, Amol, Johnson  Vabs.

Welcome to this group, I wish you great journey and lots of learning in 
this group.
Keep posting !

Thanks.

On Tuesday, 2 October 2012 10:17:17 UTC+5:30, Vabz wrote:

 Hey hii..

 My self Vaibhav Joshi and online people call me vabz/vabs..

 I am extremely lover of system  automation..
 MS Excel is one of my area of meditation  love to help people because i 
 love to feel that smile  relief on the face when problem is solved...
 It gives me smile on my face when i see Macro running on my colleagues 
 made by me which makes them go home early..

 By profession I am commerce graduate In my early days of Work when I have 
 been introduced to Excel, i tried learning excel function through F1(MS 
 Office Help) option..

 All my knowledge in to MS Excel is through online communities  group help.

 One of my early day wish was to be MVP and definitely with the help of 
 this group i will be able to achieve it..

 See you then ...n keep Excelling  Rocking...

 Cheerz..

 Rgds//Vabs

 On Saturday, September 29, 2012 5:02:43 PM UTC+5:30, johnson wrote:

 Hellow Guys
  
 I am Johnson, Chartered Accountant working currently as a Finance 
 Controller of a SChneider Group company. 
 I am thankful to individual memberrs of this group as they helped me a 
 lot in learning various advanced tricks of Excel which will help me in my 
 day to day job.
 Thank you guys once again.
 You are smart!!!  
 thanks
 Johnson

 On Sat, Sep 29, 2012 at 3:06 PM, Amol Shrivastava shri...@gmail.comwrote:

 Amol  Shrivastava From Mumbai...!! 

 On Sat, Sep 29, 2012 at 2:51 PM, Aamir Shahzad aamirsh...@gmail.comwrote:

 Hi Group, this is Aamir Shahzad from Karachi Pakistan, currently 
 working as MIS Officer in a Bank. Love Excel  learning. 

 Aamir Shahzad
  
 On Sat, Sep 29, 2012 at 11:43 AM, Ayush Jain jaina...@gmail.comwrote:

 Good to know you all from this post, please keep this thread alive by 
 introducing yourself.

 cheers. 


 On Friday, 28 September 2012 06:45:07 UTC+5:30, reshma shri wrote: 

 Hi 

 I am Reshma, new to this group.

 i was looking to find a macro or a tool to list wav file name and 
 duration in a excel, thats when i found about this group and instantly 
 joined.

 I would like to know if that's possible at all.

 if u have a tool for that, kindly lemme know.

 that would be of gr8 help coz i am doing it manually now.

 Regards
 Reshma

 -- 
 Join official facebook page of this forum @ 
 https://www.facebook.com/discussexcel
  
 FORUM RULES (1120+ members already BANNED for violation)
  
 1) Use concise, accurate thread titles. Poor thread titles, like 
 Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 
 Advice will not get quick attention or may not be answered.
  
 2) Don't post a question in the thread of another member.
  
 3) Don't post questions regarding breaking or bypassing any security 
 measure.
  
 4) Acknowledge the responses you receive, good or bad.
  
 5) Cross-promotion of, or links to, forums competitive to this forum 
 in signatures are prohibited. 
  
 6) Jobs posting is not allowed.
  
 7) Sharing copyrighted ebooks/pirated ebooks/their links is not 
 allowed.
  
 NOTE : Don't ever post personal or confidential data in a workbook. 
 Forum owners and members are not responsible for any loss.
 --- 
 You received this message because you are subscribed to the Google 
 Groups MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-...@googlegroups.com.
 To unsubscribe from this group, send email to 
 excel-macros...@googlegroups.com.
  
  




 -- 
  
 Regards,
 Aamir Shahzad
  
 -- 
 Join official facebook page of this forum @ 
 https://www.facebook.com/discussexcel
  
 FORUM RULES (1120+ members already BANNED for violation)
  
 1) Use concise, accurate thread titles. Poor thread titles, like Please 
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
 will not get quick attention or may not be answered.
  
 2) Don't post a question in the thread of another member.
  
 3) Don't post questions regarding breaking or bypassing any security 
 measure.
  
 4) Acknowledge the responses you receive, good or bad.
  
 5) Cross-promotion of, or links to, forums competitive to this forum in 
 signatures are prohibited. 
  
 6) Jobs posting is not allowed.
  
 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
  
 NOTE : Don't ever post personal or confidential data in a workbook. 
 Forum owners and members are not responsible for any loss.
 --- 
 You received this message because you are subscribed to the Google 
 Groups MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-...@googlegroups.com.
 To unsubscribe from this group, send email to 
 excel-macros...@googlegroups.com.
  
  




 -- 
 Thanks  Regards, 

 Amol Shrivastava
 +91 99671 18180



  -- 
 Join official facebook page of this forum @ 
 https://www.facebook.com/discussexcel
  
 FORUM RULES (1120+ members

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

[Ayush Jain]

Good to know you all from this post, please keep this thread alive by 
introducing yourself.

cheers.

On Friday, 28 September 2012 06:45:07 UTC+5:30, reshma shri wrote:

 Hi

 I am Reshma, new to this group.

 i was looking to find a macro or a tool to list wav file name and duration 
 in a excel, thats when i found about this group and instantly joined.

 I would like to know if that's possible at all.

 if u have a tool for that, kindly lemme know.

 that would be of gr8 help coz i am doing it manually now.

 Regards
 Reshma


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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ Small Query

[Ayush Jain]

.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.

  

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

 FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

 6) Jobs posting is not allowed.

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

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






-- 
Best regards,
Ayush Jain

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

$$Excel-Macros$$ Moderators of discussexcel forum

[Ayush Jain]

Hi Ashish, Don, Noorain and Rajan,
**
Many thanks for your great contribution in the forum.

Since there is increase in spam and job posts in the forum, I would like to
recognise you all as Moderators of the Forum with some exclusive rights
to manage members and topics.
I have selected you all on the basis of your past contribution and
confident you will use this power responsibly.
You will be assigned a Moderator badge as [image: Inline image 1] as part
of recognition. The badge should appear with your name in the forum.

I hope this step will control spamming in the forum. Let me know if you
have any queries.

For any feedback, please feel free to post
herehttps://docs.google.com/spreadsheet/viewform?formkey=dHpYdmtTeWZBcEhDWDhmandNWDlpYXc6MQ
.
Thanks

Best regards,
Ayush Jain
Group Manager
Microsoft MVP

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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


Moderator.jpg

Re: $$Excel-Macros$$ DB2 DBA // Atlanta, GA // 1 to 2 years

[Ayush Jain]

banned
 
-Ayush

On Saturday, 18 August 2012 00:49:25 UTC+5:30, Seraj wrote:

 Dear group member follow the group rule #6.job podting is not allowed 
 in this forum.
 Sent from BlackBerry® on Airtel
 --
 *From: *Job Postings requirements...@gmail.com javascript: 
 *Sender: *excel-...@googlegroups.com javascript: 
 *Date: *Fri, 17 Aug 2012 12:40:53 -0400
 *To: *requirements...@gmail.com javascript:
 *ReplyTo: *excel-...@googlegroups.com javascript: 
 *Subject: *$$Excel-Macros$$ DB2 DBA // Atlanta, GA // 1 to 2 years

  *Please send the resumes with contact details to **
 res...@gallopresources.com javascript:*


 **


 **

 *
 *

 **

 *Job Title: DB2 DBA*

 *Location:  Atlanta, GA*

 *Duration: 1 to 2 years*

 * *

 *Needs a background in DB2 in a linux environment.*

 The ideal candidate will blend an interest in administration with a keen 
 understanding of good DB development practices.

 He or she will have several years of experience as a DBA with DB2 on 
 Linux. 

 Demonstrable experience with:

 Linux DB2 administration

 Logical and physical DB modeling. Must be capable of converting a logical 
 model into a physical model

 Writing and maintaining DB2 Stored Procedures

 Creating and maintaining indexes

 Creating and maintaining triggers

 DB performance analysis and tuning, including memory footprint, I/O, 
 processor

 Linux administrator tools

 Database modeling tools, ER Studio preferred

 Java programming and JDBC s

 Excellent written and verbal communication skills across multiple 
 disciplines: architecture, development, operations, product, project 
 management. 

 Self-starting

 Ability to independently research problems and come up with solutions

  



  
 Regards,


 *Gallop Resources, Inc*

 1220 N Market Street, Suite 806,
 Wilmington, Delaware, 1980

  www.gallopresources.com


 -- 
 Join official facebook page of this forum @ 
 https://www.facebook.com/discussexcel
  
 FORUM RULES (1120+ members already BANNED for violation)
  
 1) Use concise, accurate thread titles. Poor thread titles, like Please 
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
 will not get quick attention or may not be answered.
  
 2) Don't post a question in the thread of another member.
  
 3) Don't post questions regarding breaking or bypassing any security 
 measure.
  
 4) Acknowledge the responses you receive, good or bad.
  
 5) Cross-promotion of, or links to, forums competitive to this forum in 
 signatures are prohibited. 
  
 6) Jobs posting is not allowed.
  
 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
  
 NOTE : Don't ever post personal or confidential data in a workbook. Forum 
 owners and members are not responsible for any loss.
 --- 
 You received this message because you are subscribed to the Google Groups 
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-...@googlegroups.comjavascript:
 .
 To unsubscribe from this group, send email to 
 excel-macros...@googlegroups.com javascript:.
  
  


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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ 4 Hot Positions(Unix Admin,J boss Consultant,IT Infra Architect,Solution Archite

[Ayush Jain]

Karan Bhatia is banned.
 
-Ayush Jain

On Thursday, 16 August 2012 01:17:31 UTC+5:30, finu wrote:

  Please ban this user

  
  
 *From:* excel-...@googlegroups.com javascript: [mailto:
 excel-...@googlegroups.com javascript:] *On Behalf Of *Ashish Pradhan
 *Sent:* 15 August 2012 20:24
 *To:* excel-...@googlegroups.com javascript:
 *Subject:* Re: $$Excel-Macros$$ 4 Hot Positions(Unix Admin,J boss 
 Consultant,IT Infra Architect,Solution Archite

  
  

 Dear Ayush

 Please ban this gentleman. 

 Thanks

  

 Ashish Pradhan

 On 15-08-2012 21:50, Karan Bhatia wrote:

  
 Please respond to   ka...@hmgamerica.com javascript:  
   
 *Position: *Unix Administrator*
 Location: *Houston, TX*
 Duration: *6 months extendable contract*
 Job Description / Responsibility*

 Should have around 6-8 years of UNIX/LINUX experience with 6+ years of 
 demonstrated experience and proficiency in managing and maintaining UNIX 
 environment, will be responsible for Installing, configuring and 
 maintaining Sun (Solaris10) /Linux (Red Hat). 

 Installation, configuration and managing HA environment using 
 VERITAS/REDHAT clustering, Volume manager and Sun logical volume manager.

 -   Storage disk management.

 -   Creating/resizing file systems/volumes under Sun/VERITAS volume 
 manager.

 -   Installing/Maintaining Solaris Jumpstart and Kick start 
 environment.

 -   Updating OS patches using Satellite server.

 -   Patch and Package administration.

 -   Printer Administration.

 -   Writing shell scripts to accomplish day to day system 
 administration task.

 -   Configuring and supporting domain on Sun systems.

 -   Troubleshooting Hardware and Operating system related issue.

 -   Capacity planning and fine tune system for optimal performance.

 -   Understanding of SAN and NAS storage.

 -   Installation, configuration of NetBackup client.

 -   Administration of NIS or LDAP environment.

 -   Configuring UNIX Security baseline.

 -   Troubleshooting Hardware and Operating system related issues.

 -   Experience in System Fault Tolerance Design, Business continuity 
 and Disaster recovery.

 -NIS administration

 -Zones administration

 Experience on following will be added advantage

 -Samba

 -PGP

 -DNS

 -Sendmail

 -LDAP

 -Monitoring Tools (like BMC Patrol, HP open view, IBM Tivoli)

 -ITIL awareness


 ‘’’’

 *Position:  JBoss consultant
 Location: Cary, NC
 Duration: 6 months extendable contract

 *

 *Job Description:*

 JBoss installation, configuration and maintenance with Ver.5.x
 Apache installation, configuration and maintenance with Ver.2.x
 Tomcat installation, configuration and maintenance with Ver.6.x
 Knowledge on SVN repository
 Knowledge on RHE Linux and troubleshooting issues on Linux
 Knowledge on troubleshooting JBoss, Apache and Tomcat with Primary 
 Database as Oracle.


 ‘’

 *Position:  IT Infra Architect
 Location: Wilmington, DE
 Duration: 6 months contract*

 *Job Description*

 The candidates should have architecture experience in the following 
 foundation technologies. 

 Strong knowledge in underlying technologies such as 

 Good understanding of Storage /Backup Architecture and Design – Expert 
 level

 Storage: HP, Hitachi, NetApp – Expert level

 Storage understanding of Data Archival technologies

 Fabric – Brocade/Cisco – Expert Level

 Backup: HP-DP, De-duplication,  Disk based Backup  – Expert level

 Good understand of application level backups

 Virtualization :VMware – Knowledge 

 O/S: Solaris, AIX, HP-UX (One of the OS flavors) - Knowledge

 Fundamentals of Networking: (Routing/Switching/Converged Networking/WAN 
 Optimization)

 Awareness about well know applications – Exchange, Database, Web services, 
 Middleware

 Understand the technical scope of the project and document the requirement 
 by creating or validating the SOW.

 Ability to take the both functional and non-functional requirements from 
 the respective teams to freeze the SOW.

 Review the SOW ensuring the scope and the prerequisite is complete by 
 validating the dependencies on other projects, IT infrastructure resources 
 required, cross technologies needs are met.

 The architect should ensure that the proposed design is aligned with 
 industry best practices and the solution is well optimized.

 Create, Review and validate the design by engaging with the respective 
 stakeholders, PM’s etc.

 The candidate should be in a position to build Technology standards, IT 
 Strategy, Roadmap

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

[Ayush Jain]

Dear members,

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

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

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

Regards,
Ayush Jain
Group Manager
Microsoft MVP

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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Forcasting for acquring New Project

[Ayush Jain]

Mr Kumar Kishore

May I ask you start new topic instead of posting in other people threads.

Regards
Ayush Jain

On Sat, Jul 28, 2012 at 6:36 PM, kumar Kishore kishore...@gmail.com wrote:

 hai friends,

 can you do favour

 please find enclosed PDF file

 please convert to word document file.


 Thank in advance.

 Regards,

 kishore

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






-- 
Best regards,
Ayush Jain

-- 
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$$ Update graph range by referencing a cell?

[Ayush Jain]

Mr Kishore

You are violating the forum rules and you will be banned.

This query has no relation to excel or VBA and you are posting queries in
other topics.

Regards
Ayush Jain

On Sat, Jul 28, 2012 at 7:23 PM, kumar Kishore kishore...@gmail.com wrote:

 hai friends,

 how to remove the Password of PDF file

 Regards,

 kishore

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






-- 
Best regards,
Ayush Jain

-- 
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 need for java/flex developer

[Ayush Jain]

Banned

On Thursday, 19 July 2012 08:30:36 UTC+5:30, NOORAIN ANSARI wrote:

 Dear Ayush,

 Please ban it..

 On Thu, Jul 19, 2012 at 3:27 AM, uma sindhu umagethi...@gmail.com wrote:

 Hi,

  

 Hope you are doing good!!!

  

 We have an Urgent need Java/Flex developer with  one of our client. 
 Please go through the job description and let me know your interest. If you 
 are interested please send me your updated resume along with the below 
 details**

  

 *Job Title   :* Java developer/ Flex Developer (Technical Lead / 
 Lead Developer)

 *Duration**:* 6-12months+ 

 *Location   :* Atlanta, GA 

 *Interview Type   :* phone+  Skype 

 *Primary Skills**:* Adobe AIR 3.x, Flex 4.x, Java/J2EE, Action Script

 * *

 *Other Information :* 
 •CSS, SQL (Oracle / SQL Server),SOAP 
 •Experience with Adobe LCES / LCDS (LiveCycle Enterprise Services / 
 LiveCycle Data Services)
 •Experience with HTML, CSS and JavaScript libraries.
 •Leadership skills


 Thanks and regards
 uma charugundla
 uma_charugun...@aesinc.uss.com
 630-242-8896X307

 http://www.linkedin.com/pub/uma-charugundla/4a/344/608



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

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




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





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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ ****** FIVE YEARS COMPLETION******THANK YOU******

[Ayush Jain]

Thanks Dilip and everyone for your great contribution to this forum.
The forum is really doing well and we will achieve more and more milestones.

Together we can and we will make a difference.

Cheers,
Ayush Jain
On Wed, Jul 4, 2012 at 5:11 PM, Indrajit $nai talk2indra...@gmail.comwrote:

 Congrats Asish. :)



 On Tue, Jul 3, 2012 at 8:27 PM, Bé Trần Văn betnmtdongna...@gmail.comwrote:

   Show group already have 03 users received decode of the
 Microsoft, real absolute. I am tham community this because it very useful to
 add comments expression cho me also like all all user.
   Sorry, I was busy at the work group, wish all the members of this
 forum to achieve important event, I hope that in future other members can
 achieve as Ashish koul and Pandey Dilip, hope you two continue to
 contribute to better forum.

 2012/7/3 Dilip Pandey dilipan...@gmail.com

 Congratulations Ayush . . . . !!

 This is a wonderful group with full of energy and learning.  Thanks to
 all the members for achieving this milestone.  :)

  Thanks  Regards,

 DILIP KUMAR PANDEY, mvp
 MBA,B.Com(Hons),BCA
 Mobile: +91 9810929744
 dilipan...@gmail.com
 dilipan...@yahoo.com
 New Delhi -62, India
  On Mar 22, 2012 4:25 AM, Ayush Jain jainayus...@gmail.com wrote:

  Dear members,**

  

 I am proud to announce that the forum has completed 5 years today. This
 is really great milestone of the forum. 

 My sincere thanks to each one of you who keep this forum alive by
 asking questions and helping others by providing solutions.

  

 Over the last five years, I have seen decent growth in the number of
 posts and quality of solutions provided by the experts here. I have learned
 many things from this forum and experts. 

 In my view, Learning never stops and the discussion forum is the best
 place to learn and share the skills.

  

 I hardly get time to resolve the excel queries after office hours but I
 try my best to moderate the forum closely. I visit the forum 2-3 times
 daily to approve the messages and to check everything is ok. Please let me
 know the improvements and changes you want to see in the forum. I would be
 happy to hear your feedback.

  

 Some key achievements of this forum in numbers:

 1) In last 1.5 years, we have seen three people receiving the Microsoft
 MVP award from this forum. This is itself a big achievement for forum and I
 hope to see more deserving people get this award in future.

  

 2) This is spam free forum and we hardly get spam messages. In last 5
 years, 1000 members are banned for sending spam messages

  

 3) We are 8400+ members with diversity in expertise, experience and
 location.

  

 4) Over 7600+ topics discussed in five years

  

 Once again many thanks and congratulations to all of you. Keep posting
 and together we will achieve more milestones.

 Regards,
 Ayush Jain
 Microsoft MVP
 Forum Owner
 jainayus...@gmail.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

 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

Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!--Add

[Ayush Jain]

Pankaj,
 
Please let me know which advertisements you are referring to.
 
Thanks,
 

On Tuesday, 3 July 2012 11:25:02 UTC+5:30, panky wrote:

 Dear Moderator,
  
 Please also Ban these kinds of Promotional/Advertisements in this forum.
  
 They are not related to Excel Help.
  
 Please advice
  
  
 Thanks and Regads,
 Pankaj Michael

 On Sun, Jul 1, 2012 at 9:54 PM, Ayush Jain jainayus...@gmail.com wrote:

 Dear members,
  
 I am extremely happy to inform you that two members of the group are 
 awarded Microsoft Most Valuable Professional Award.
 My heartiest congratulations to *Ashish koul* and *Dilip Pandey* and  
 thanks for their big support to this forum.
  
 Keep posting !

 Best regards,
 Ayush Jain
 Group Manager
 Microsoft MVP


  

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

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




 -- 
 Pankaj Kumar


-- 
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$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!

[Ayush Jain]

Don,

You are valuable to this forum and a star performer.
We really admire you and appreciate your great contribution to this forum.

Regards
Ayush Jain

On Sun, Jul 1, 2012 at 10:34 PM, dguillett1 dguille...@gmail.com wrote:

   And, Don Guillett was not re selected.

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

  *From:* Ayush Jain jainayus...@gmail.com
 *Sent:* Sunday, July 01, 2012 11:24 AM
  *To:* excel-macros excel-macros@googlegroups.com
 *Cc:* Dilip Pandey dilipan...@gmail.com ; ashish koulkoul.ash...@gmail.com
 *Subject:* $$Excel-Macros$$ MVP AwardCongratulations Ashish Koul and
 Dilip Pandey !!

   Dear members,

 I am extremely happy to inform you that two members of the group are
 awarded Microsoft Most Valuable Professional Award.
 My heartiest congratulations to *Ashish koul* and *Dilip Pandey* and
 thanks for their big support to this forum.

 Keep posting !

 Best regards,
 Ayush Jain
 Group Manager
 Microsoft MVP



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

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

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

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

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

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

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


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

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

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

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

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

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

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

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

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


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

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




-- 
Best regards,
Ayush Jain

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

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

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

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

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

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

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

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

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

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

[Ayush Jain]

Thanks everyone and welcome to this group !!
 
Keep introducing yourself and keep this thread alive.
 
Regards
Ayush Jain

On Thursday, 21 June 2012 21:41:19 UTC+5:30, Rajan_Verma wrote:

  Dubey G

 Welcome on the group J

  

 * *

 *Regards*

 *Rajan verma*

 *+91 7838100659 [IM-Gtalk]*

  

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *Prince Dubey
 *Sent:* 21 June 2012 9:40
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ Re: Introduce Yourself !!

  

 Hi All,
  
 I am Prince dubey, working as Sr. Associate in WNS Gurgaon.I am  very keen 
 to learn Excel and VBA so i spend my most of the time on internet searching 
 solutions of my technical stuffs.I love to listen music,watching cricket 
 and surfing on net.

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

 Thanks for your time
 Ayush Jain
  
 Group Manager
  
 Microsoft MVP

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


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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Re: MIS executive

[Ayush Jain]

Hello All,

Thank you for sharing your views.

When I allowed the job posting earlier, people started posting all kind of
jobs. For me it is very difficult to moderate each job posts, and ban
people just because of job posting.
I will definitely think of channelising the job posts or add a link where
you can post the jobs.

For now, Job posting is NOT allowed in forum. Let me know if you still have
any queries.

Thanks and best regards
Ayush Jain
Group Manager
Microsoft MVP


On Mon, Jun 18, 2012 at 10:21 PM, yogananda muthaiah 
yogananda.mutha...@gmail.com wrote:

 Hi,

 Thank you everyone who has given a feedback to Ayush and he may come take
 this as +ve feedback.

 Please do call me if someone who is really looking for MIS profile and
 ready for face to face interview.



 On Mon, Jun 18, 2012 at 9:49 PM, pankaj gmail account 
 pankaji...@gmail.com wrote:

 Hi To All,

 I also agree that we should also think about Job Posting in this forum.
 If a Needy gets Job with our help that's the best result of the forum.

 OK I also agree that this is not a Job Forum but instead of joining other
 Job forums we should think some alternative like we can use some Mandatory
 Subject Line etc JOB:- Posting :-- Job Details-


 Dear Moderator Please think Excel do not pay much and now a days we are
 facing lots of competition with other BI tools and i think excel should be
 promoted more by sharing knowledge/jobs.


 Thanks and Regards,
 Pankaj




 On Mon, Jun 18, 2012 at 4:08 PM, Mangesh Vimay 
 mangesh.da...@gmail.comwrote:

 Hi Friends,

 I am agree with Yogananda because many people are spending their time
 here to learn excel concepts with the intention to get the job and hence if
 someone is providing such nice opportunities then I think it is good.
 Moreover, only related job posting should be there (with excel, access
 only).

 Thanks.



 On Sun, Jun 17, 2012 at 8:04 AM, Prince Ever Increasing Abundance King
 of Exceeding Overflowing Prosperity goldasd...@hotmail.com wrote:

  I have no intent of doing a job posting.  Asking for others.
  Where should job postings be done.  I am in British Colulmbia Canada.
 What should I do if I want to change to change my email receiving
 address for this group?

 Thank you.
 David

  --
 Date: Sat, 16 Jun 2012 08:14:00 -0700
 From: jainayus...@gmail.com
 To: excel-macros@googlegroups.com
 Subject: $$Excel-Macros$$ Re: MIS executive


 Hi Yogananda,

 Please note that Job posting is allowed in this forum. Please do not
 post any jobs going forward.

 Thanks.


 On Saturday, 16 June 2012 16:41:50 UTC+5:30, (%Allmydreams%) wrote:

 Hi,

 We have a opening for MIS - Executive in Bangalore location.  Do call
 my below number on next coming monday.  Its Urgent requirement



 Regards
 Yogananda Muthaiah
 Ph : 973 123 7267


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




 --
 With regards,

 MaNgEsH

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

Re: $$Excel-Macros$$ Re: MIS executive

[Ayush Jain]

Vaibhav,

Allowing job posts is not only moderation but an invitation to spammers,
recruiters and employers for job posting.
I really do not want that to happen in this forum.

Banning job posts is not my sole decision but decided after the feedback of
many members in this forum.

Let's keep the scope of this forum limited to excel related queries only,

Regards
Ayush Jain

On Mon, Jun 18, 2012 at 11:25 PM, in.vaib...@gmail.com wrote:

 **
 Hi Ayush,

 Why can't we have separate team of moderator like other sites.

 --
 *From: *Ayush Jain jainayus...@gmail.com
 *Sender: *excel-macros@googlegroups.com
 *Date: *Mon, 18 Jun 2012 23:02:07 +0530
 *To: *excel-macros@googlegroups.com
 *ReplyTo: *excel-macros@googlegroups.com
 *Subject: *Re: $$Excel-Macros$$ Re: MIS executive

 Hello All,

 Thank you for sharing your views.

 When I allowed the job posting earlier, people started posting all kind of
 jobs. For me it is very difficult to moderate each job posts, and ban
 people just because of job posting.
 I will definitely think of channelising the job posts or add a link where
 you can post the jobs.

 For now, Job posting is NOT allowed in forum. Let me know if you still
 have any queries.

 Thanks and best regards
 Ayush Jain
 Group Manager
 Microsoft MVP


 On Mon, Jun 18, 2012 at 10:21 PM, yogananda muthaiah 
 yogananda.mutha...@gmail.com wrote:

 Hi,

 Thank you everyone who has given a feedback to Ayush and he may come take
 this as +ve feedback.

 Please do call me if someone who is really looking for MIS profile and
 ready for face to face interview.



 On Mon, Jun 18, 2012 at 9:49 PM, pankaj gmail account 
 pankaji...@gmail.com wrote:

 Hi To All,

 I also agree that we should also think about Job Posting in this forum.
 If a Needy gets Job with our help that's the best result of the forum.

 OK I also agree that this is not a Job Forum but instead of joining
 other Job forums we should think some alternative like we can use some
 Mandatory Subject Line etc JOB:- Posting :-- Job Details-


 Dear Moderator Please think Excel do not pay much and now a days we are
 facing lots of competition with other BI tools and i think excel should be
 promoted more by sharing knowledge/jobs.


 Thanks and Regards,
 Pankaj




 On Mon, Jun 18, 2012 at 4:08 PM, Mangesh Vimay 
 mangesh.da...@gmail.comwrote:

 Hi Friends,

 I am agree with Yogananda because many people are spending their time
 here to learn excel concepts with the intention to get the job and hence if
 someone is providing such nice opportunities then I think it is good.
 Moreover, only related job posting should be there (with excel, access
 only).

 Thanks.



 On Sun, Jun 17, 2012 at 8:04 AM, Prince Ever Increasing Abundance King
 of Exceeding Overflowing Prosperity goldasd...@hotmail.com wrote:

  I have no intent of doing a job posting.  Asking for others.
  Where should job postings be done.  I am in British Colulmbia Canada.
 What should I do if I want to change to change my email receiving
 address for this group?

 Thank you.
 David

  --
 Date: Sat, 16 Jun 2012 08:14:00 -0700
 From: jainayus...@gmail.com
 To: excel-macros@googlegroups.com
 Subject: $$Excel-Macros$$ Re: MIS executive


 Hi Yogananda,

 Please note that Job posting is allowed in this forum. Please do not
 post any jobs going forward.

 Thanks.


 On Saturday, 16 June 2012 16:41:50 UTC+5:30, (%Allmydreams%) wrote:

 Hi,

 We have a opening for MIS - Executive in Bangalore location.  Do call
 my below number on next coming monday.  Its Urgent requirement



 Regards
 Yogananda Muthaiah
 Ph : 973 123 7267


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

$$Excel-Macros$$ Re: SR LINUX SYS ADMIN/ATLANTA, GA/6 months contract

[Ayush Jain]

Jacob John is banned.
 
-Ayush Jain

On Thursday, 14 June 2012 22:53:13 UTC+5:30, Jacob john wrote:

 Hello Consultant,
 Please let me know if you are interested in this requirement. If yes, 
 kindly send us your 

 resume along with contact information. 
 If you are not looking for new projects, please feel free to pass on this 
 email to your friends 

 or relatives who might be interested.

 Title:SR LINUX SYS ADMIN
 Location:ATLANTA, GA
 Length: 6 months contract


 Minimum 7 years Linux (RHEL) experience; this includes familiarity and 
 experience with the 

 following;
 Boot from SAN
 Building a Linux server from ISO, configuring and deploying on physical 
 hardware and in a 

 Virtual VMWare environment
 multipathing
 Bonding 
 NFS / DNS / NTP
 Support and Troubleshooting of applications / network on RHEL systems
 experience with supporting and configuring RHEL for use as an Oracle RAC 
 server
 experience with Veritas Storage Foundation HA (VCS, VxFS) on linux
 LVM
 Must have basic scripting in ksh or perl


 Would like to also have experience with Solaris (minimum 5 - 10 years) 
 working with Solaris 

 Zones and LDOM's

 LINUX (RHEL) – REQUIRED – 7 YEARS
 VMware – REQUIRED – 7 YEARS
 UNIX/LINUX ENVIRONMENT – REQUIRED – 7 YEARS
 PERL – CREATE FROM SCRATCH – REQUIRED – 7 YEARS
 SOLARIS ZONES AND LDOM’S – REQUIRED – 5 YEARS

  


 Thank you

 Jacob John
 Panzer Solutions LLC
 45 Stuart Ave,k
 Norwalk,CT 06850 USA
 jacob.j...@panzersolutions.com
 Direct: 203-652-1454 Ext 119
 Fax: (203) 971-8354
 URL: www.panzersolutions.com


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

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

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

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

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

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

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

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

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

$$Excel-Macros$$ Re: MIS executive

[Ayush Jain]

Hi Yogananda,
 
Please note that Job posting is allowed in this forum. Please do not post 
any jobs going forward.
 
Thanks.
 

On Saturday, 16 June 2012 16:41:50 UTC+5:30, (%Allmydreams%) wrote:

 Hi, 

 We have a opening for MIS - Executive in Bangalore location.  Do call my 
 below number on next coming monday.  Its Urgent requirement



 Regards
 Yogananda Muthaiah
 Ph : 973 123 7267



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

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

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

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

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

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

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

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

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

$$Excel-Macros$$ Re: MIS executive

[Ayush Jain]

Hi Yogananda,
 
Please note that Job posting is *NOT* allowed in this forum. Hence, do not 
post any jobs going forward.
 
Thanks.
 

On Saturday, 16 June 2012 16:41:50 UTC+5:30, (%Allmydreams%) wrote: 

 Hi, 

 We have a opening for MIS - Executive in Bangalore location.  Do call my 
 below number on next coming monday.  Its Urgent requirement



 Regards
 Yogananda Muthaiah
 Ph : 973 123 7267



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

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

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

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

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

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

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

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

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

$$Excel-Macros$$ Re: Need for ATG - Java J2EE Developer

[Ayush Jain]

Dev Karan is banned.
 
Regards
Ayush Jain

On Thursday, 14 June 2012 02:48:03 UTC+5:30, Dev Karan wrote:

 Dear Friend,

 We need your help for following open position:

 *Mail Resumes to: d...@tecknowledgie.com*
 *
 *
 *ATG - Java J2EE Developer*
 * *
 *Duration : 3 - 6 month contract to hire*
 *Location : San Francisco CA*

 Required:
 • Minimum of two years experience working on J2EE based applications
 • Minimum two years working knowledge of ATG platform 
 • Ability to write and tune applications 
 • Ability to work with business users, product managers, QA, release, and 
 UI and platform engineering teams to develop great e-commerce application
 • Functional Competencies:
 o * Systems Modeling and Design Skills
 o * Hands-on experience in Java programming
 o * Sound knowledge of J2EE or Java EE
 o * XML, XSD, XSL/XSLT and HTML
 o * HTTP, FTP
 o * OOP
 o * Data Modeling, SQL and Oracle Database
 o * Personalization and Localization concepts


 Please send your latest resume with contact details and best rates.

 **

 *Thanks,*

 *DK*

 *Tecknowledgie Group, Inc.*

 **

 *Yahoo IM: dk_devk*




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

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

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

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

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

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

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

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

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

$$Excel-Macros$$ Forum feature : Highlight code syntax

[Ayush Jain]

Dear members,
 
I would like to share one of the cool feature of new google groups. 
This is called *'Highlight code syntax'* where you can highlight the code 
in different color to normal content. This feature will distinguish your 
code from your explanation of problem or solution.
It appears as right most option when you post using google groups. 
https://lh5.googleusercontent.com/-MXyhghaaziM/T9l1OYPeoVI/AWo/LKudJuFrQ5Q/s1600/highlight_code.JPG
An example is given at the end.
 
Please use this feature in your postings going forward.
 
Thank you.
 
Regards
Ayush Jain
Group Manager
www.discussexcel.com
 
 
 
 Sub Macro()
Msgbox This is to highlight code syntax
 End Sub   

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

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

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

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

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

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

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

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

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

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

[Ayush Jain]

Dear all,

Good to know you all and feels proud to be part of this forum.

Let me introduce myself.

I am Ayush Jain from Delhi, India. Presently working as senior analyst in
Ernst  Young and my work includes bulding Excel  Access based models for
clients for analysis, reporting, planning etc.

I started this forum 5 years back with the aim to provide quality solutions
for excel and vba queries  I am quite happy to see what we are today.
This is one of the largest forum which is spam free and always buzzing with
activity.

I have received Microsoft MVP award in 2010  2011 for my voluntry
contribution to various communities in excel. For more details:-Please
visit my MVP profile http://mvp.microsoft.com/profiles/Ayush

I really appreciate the forum members for their active paticipation and
voluntry help to others. If you have any
feedbackhttp://www.surveymonkey.com/s/3WM3FYH, click
here http://www.surveymonkey.com/s/3WM3FYH.
Keep introducing yourself!!

Many Thanks.
-Ayush Jain
Group Manager / Microsoft MVP

On Sun, Jun 10, 2012 at 2:23 PM, David Grugeon da...@grugeon.com.au wrote:

 Hi all 'Excel'lent people

 This is David Grugeon from Brisbane Australia.

 I work as an accountant/consultant for local governments - mainly one in
 Thargomindah which is 1000 Km west of Brisbane and one in Thursday Island
 which is 2000 Km North.

 I use excel all the time for work and am currently working on the Budget
 for Bulloo Shire Council (Thargomindah) with about ten interlinked
 workbooks with many sheets each.  I use VBA a lot where it saves me time.
  I think I have quite good Excel skills developed by helping others on
 groups like this one.  If you try to answer the questions you learn a lot
 which you can use in the future.

 If oyu are interested Bulloo Shire council has an area of about 83000 sq
 Km (about half the size of England) and a population of about 600.
  Thursday island is the administrative centre for four islands (Thursday,
 Horn, Prince of Wales, and Goods Islands) in the Torres Strait between
 Australia and Papua New Guinea.

 I am 69 in a few days and lived in England until I was 47.

 I hope I am able to help you guys and I am sure I will learn a lot as well.

 Best regards
 David Grugeon


 On 10 June 2012 16:47, vatspoojav...@gmail.com wrote:

 **
 Hi Excel Buddies!

 My name is Pooja Sharma, I'm from New Delhi. Working as Lead into
 Financial Closing and Reporting with a Gurgaon based MNC.
 Apart from my work, I like to travel, enjoy most forms of music, playing
 Table Tennis, Gardening.
 Excel plays major supportive role in accounting and reporting.
 I am really feel good to be a part of this forum.

 Regards,
 Pooja Sharma
 Sent from BlackBerry® on Airtel
 --
 *From: *amar.gur...@gmail.com
 *Sender: *excel-macros@googlegroups.com
 *Date: *Sun, 10 Jun 2012 06:38:09 +
  *To: *excel-macros@googlegroups.com
 *ReplyTo: *excel-macros@googlegroups.com
 *Subject: *Re: $$Excel-Macros$$ Introduce Yourself !!

 Hi Everyone,

 I am Amar, an insurance professional working in non-life insurance. I
 love interacting with people, working in excel and food with different
 specialities.

 I am from Mumbai.

 Regards,
 Amar
 Sent on my BlackBerry® from Vodafone
 --
 *From: *Rajesh Janardanan rajesh...@gmail.com
 *Sender: *excel-macros@googlegroups.com
 *Date: *Sun, 10 Jun 2012 10:31:29 +0400
 *To: *excel-macros@googlegroups.com
 *ReplyTo: *excel-macros@googlegroups.com
 *Subject: *Re: $$Excel-Macros$$ Introduce Yourself !!

 Hello All,

 I am Rajesh Janardhanan , a Chartered Accountant working in the oil field
 service industry, aged 34. I live in UAE.
 interest includes travelling , movies etc and Excel and presentations are
 a necessity for business for me and this forum has helped me many time's in
 last many year's.

 Thanks to all.

 Best regards
 Rajesh


 On Sun, Jun 10, 2012 at 10:27 AM, joseph.cam...@gmail.com wrote:

 **
 Hi everyone,

 My name is Joseph. I live in Mumbai, age 34 years. I work as a
 Presentation Specialist. I work only on PowerPoint, Excel and Word.

 Thanks and regards,
 Joseph
 Sent on my BlackBerry® from Vodafone
 --
 *From: *resp...@gmail.com
 *Sender: *excel-macros@googlegroups.com
 *Date: *Fri, 8 Jun 2012 19:34:15 +
 *To: *excel-macros@googlegroups.com
 *ReplyTo: *excel-macros@googlegroups.com
 *Subject: *Re: $$Excel-Macros$$ Introduce Yourself !!

 Hilary from Ghana. A stockbroker. Interest is excel and football.
 Sent from my BlackBerry® smartphone from Airtel Ghana
 --
 *From: *Ayush Jain jainayus...@gmail.com
 *Sender: *excel-macros@googlegroups.com
 *Date: *Fri, 8 Jun 2012 12:21:59 -0700 (PDT)
 *To: *excel-macros@googlegroups.com
 *ReplyTo: *excel-macros@googlegroups.com
 *Subject: *$$Excel-Macros$$ Introduce Yourself !!

 Hey all new and current posters,

 Welcome to excel group,one of the largest online community of excel Fans!

 I hope you enjoy

Re: $$Excel-Macros$$ Please Tell Me

[Ayush Jain]

Nazia Menaz is banned.
 
-Ayush
 
On Sunday, 10 June 2012 17:32:13 UTC+5:30, Ashish wrote:

  
 What has this link to do with Excel??

 Thanks

 Ashish Pradhan

 On 10-06-2012 17:31, Nazia Menaz wrote:

 Please Add Your Id This Link

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

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





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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ RE: FW: hi there...

[Ayush Jain]

Thanks guys for your support.
 
I have banned that user.
 
Regards
Ayush Jain

On Friday, 8 June 2012 21:50:25 UTC+5:30, sandeep chhajer wrote:

 Hi Ayush, Noorain and all mentor,

 You all are the best mind in the field of Information Technology. So 
 please do needful to stop this type of cross advertising and 
 abuses.(Happened on today morning by Viktorija Zukauskiene ). We have an 
 esteemed group so I am urging every true member of this group please try to 
 find out a way by which we can stop any such future incidents.

 Sent on my BlackBerry® from Vodafone
 --
 *From: *OfficeVba Trainer officevbatrai...@yahoo.com 
 *Sender: *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
  
 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$$ MACRO

[Ayush Jain]

Hello everyone,
 
I hope the book which is being shared in this thread is free ebook and not 
the paid one. 
I am strongly against sharing pirated copies without the consent of author. 
 
Let me know if you have any queries.
 
Thanks.
 
Regards
Ayush Jain
Group Manager  Microsoft MVP
 

On Thursday, 31 May 2012 19:59:26 UTC+5:30, Bullet wrote:

 Dear Noorian,

 Can you please send me those ebooks to my mail id: talk2indra...@gmail.com

 Thanks in advance.


 On Thu, May 31, 2012 at 4:44 PM, Prakash Paul jprakashp...@gmail.comwrote:

 Dear Noorian,

 Please send the 2007 file to jprakashp...@gmail.com.

 Thanks in advance

 Regards
 Paul 


 -- 
 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 Client Position ::: Java Developer - Work Location: Palo Alto, CA

[Ayush Jain]

Sai Girish is banned
 
Regards
Ayush Jain
On Thursday, 24 May 2012 22:42:55 UTC+5:30, hilary lomotey wrote:

 Why do you keep sending this ad over and over again. 
 Sent from my BlackBerry® smartphone from Airtel Ghana
 --
 *From: *sai girish saigiris...@gmail.com 
 *Sender: *excel-macros@googlegroups.com 
 *Date: *Thu, 24 May 2012 22:42:19 +0530
 *ReplyTo: *excel-macros@googlegroups.com 
 *Subject: *$$Excel-Macros$$ Urgent Client Position ::: Java Developer - 
 Work Location: Palo Alto, CA

 *Hi,*

 *This is Thomas Fedrick, - Recruitment and Resources from SancroSoft USA 
 Inc.*

 We have an urgent requirement as follows:

 Please reply to this email with the latest copy of your resume in MS-Word 
 Format with the following details to 
 *tho...@sancrosoftusa.com*tho...@sancrosoftusa.com 

 Full Name :
 Location :
 Contact Number :
 Email :
 Availability :
 Rate / Hour :
 Visa Status :

 *Requirement Details** :--**
 *
 *Java Developer*
 Work Location: Palo Alto, CA
 Duration: 6 months Contract (possible extension)
 Rate : Market

 We need to look for a person who is more well-rounded, with both backend 
 (J2EE experience) and GUI experience.  

 - JAVA, J2EE, Web services, JPA/Hibernate, Spring (higher priority)

 Also the candidates need to have experience in big scale development/high 
 volume/scalability projects, and with experience with small scale 
 development... It is a big plus if the candidate has big scale development 
 experience.

 We would like someone who is primarily stronger on the Java back-end side 

  

  

 *Thanks  Regards*

 *Thomas Fedrick**
 **Recruiting Specialist IT Services*

 *[image: Description: Description: Description: Description: Description: 
 Description: cid:image001.jpg@01CD14F0.B169F430] [image: Description: 
 Description: Description: Description: Description: Description: 
 cid:image002.jpg@01CD14F0.B169F430] *

 * **The power of focus*

 *SancroSoft USA INC*

 *4944 Sunrise Blvd, Suite B-4 || Fair Oaks, CA 95628
 Phone : 916-671-5559*  ||* 916-671-5584 *||* Fax: 916-200-0305*
 *E-Mail :* *tho...@sancrosoftusa.com* tho...@sancrosoftusa.com || *
 www.sancrosoftusa.com* http://www.sancrosoftusa.com/
 *
 We place professionals in contract, contract-to-hire and full-time 
 employment positions *

 *across all IT and Engineering disciplines, **nationwide*
   
 Stay Connected:
  
 [image: Description: Description: Description: Description: Description: 
 Description: 
 cid:image003.png@01CD14F0.B169F430]http://www.linkedin.com/in/Thomasfedrick
  
 [image: Description: Description: Description: Description: Description: 
 Description: 
 cid:image004.png@01CD14F0.B169F430]http://www.facebook.com/people/Thomas-Fedrick/10156958548
  
 [image: Description: Description: Description: Description: Description: 
 Description: 
 cid:image005.png@01CD14F0.B169F430]https://twitter.com/#%21/thomasfedrick99

 For More Job Openings , Please Visit my blog   [image: Description: 
 Description: Description: Description: Description: Description: 
 http://t0.gstatic.com/images?q=tbn:ANd9GcTtrxGMSDzmqNcd78ZgJEjlJHrdvfl3wZ7N2W02bC6UwOEQJQUO]http://thomassancrosoftusa.blogspot.in/

 The information contained in this email message is intended only for the 
 personal and confidential use of the recipient(s) named above. The message 
 may be privileged and confidential and protected from disclosure. If the 
 reader of this message is not the intended recipient or an agent 
 responsible for delivering it to the intended recipient, you are hereby 
 notified that you have received this document in error and that any review, 
 dissemination, distribution, copying of this message is strictly 
 prohibited. If you have received this communication in error, please notify 
 us immediately by email and delete the original message.

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

Re: $$Excel-Macros$$ NEW RULE : No more job postings in this forum.

[Ayush Jain]

Thanks everyone for your support.

Initially, I allowed to post excel related jobs but that allowance was
misused by spammers.
It is very difficult to differentiate excel jobs with other technical jobs
for moderators.
Hence, I have decided not to allow any job opening posts in this forum.

Thanks for your understanding.

Regards
Ayush Jain
Group Manager
Microsoft MVP

On Mon, May 21, 2012 at 9:37 PM, Mangesh Dayne mangesh.da...@gmail.comwrote:

 Hi All,
 Welcome decision.
 In addition, it is also good that job posting should be related to excel,
 vba only.
 Our objective is to make universal platform for EXCEL/VBA LOVERS.


 with regards,

 Mangesh


 On Mon, May 21, 2012 at 7:10 PM, prernacha...@ymail.com wrote:

 **
 Hi Ayush sir,

 Can you plz exlude me from this forum.
 Sent on my BlackBerry® from Vodafone
  --
 *From: *Ayush Jain jainayus...@gmail.com
 *Sender: *excel-macros@googlegroups.com
 *Date: *Sun, 20 May 2012 07:54:03 -0700 (PDT)
 *To: *excel-macros@googlegroups.com
 *ReplyTo: *excel-macros@googlegroups.com
 *Subject: *$$Excel-Macros$$ NEW RULE : No more job postings in this
 forum.

 Hello everyone,

 There is sudden increase in job posts and more than half of all job posts
 are irrelevent  not related to excel.
 I have decided not to allow any jobs whether related to excel or not. *This
 is not employment forum and intended to help on excel queries only.*

 Anyone found posting jobs will be banned without any warning.

 Let me know if you have any questions.

 Regards
 Ayush Jain
 Group Manager and Microsoft MVP

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

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

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

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

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

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

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


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

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




-- 
Best regards,
Ayush Jain

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

$$Excel-Macros$$ NEW RULE : No more job postings in this forum.

[Ayush Jain]

Hello everyone,
 
There is sudden increase in job posts and more than half of all job posts 
are irrelevent  not related to excel.
I have decided not to allow any jobs whether related to excel or not. *This 
is not employment forum and intended to help on excel queries only.*
 
Anyone found posting jobs will be banned without any warning.
 
Let me know if you have any questions.
 
Regards
Ayush Jain
Group Manager and Microsoft MVP

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Happy Birth Day Ayush.

[Ayush Jain]

Thank you everyone.
 
Regards
Ayush Jain
 

On Friday, 27 April 2012 05:35:18 UTC+5:30, Sam Mathai Chacko wrote:

 Happy Birthday Ayush. Have a great new year.

 REgards,
 Sam Mathai CHacko

 On Fri, Apr 27, 2012 at 3:24 AM, Michael Brumby mikebru...@yahoo.comwrote:

   *Happy birthday...!!*

  Best Regards. 
 Mr Michael Brumby
 Diese Email und samtliche beigefugten Anhange sind vertraulich zu 
 behandeln und sind vor Veroffentlichung geschutzt. Informieren Sie den 
 Absender bitte umgehend und loschen Sie diese Nachricht mit allen 
 beigefugten Anhangen, falls Sie nicht der vorgesehene Empfanger sind. Der 
 Inhalt dieser Email darf nicht an oder von dritten weitergeleitet, 
 veroffentlicht, verwendet, oder kopiert werden, oder durch jegliches Medium 
 gespeichert werden. 


 --- On *Thu, 26/4/12, Aruna jayaram aruna2...@gmail.com* wrote:


 From: Aruna jayaram aruna2...@gmail.com
 Subject: Re: $$Excel-Macros$$ Happy Birth Day Ayush.
 To: excel-macros@googlegroups.com
 Date: Thursday, 26 April, 2012, 6:49 


  many happy returns for the day ayush
 On Apr 26, 2012 11:13 AM, bhupendra singh raghav 
 raghav.bhupen...@gmail.comhttp://uk.mc1612.mail.yahoo.com/mc/compose?to=raghav.bhupen...@gmail.com
  
 wrote:

 Hi Ayush, 
  
  
  
 Many many happy returns of the day.

  

  

   

 Regards 

 Raghav 
 -- 
 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.comhttp://uk.mc1612.mail.yahoo.com/mc/compose?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




 -- 
 Sam Mathai Chacko


-- 
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$$ HOT LIST OF INFOTARGETS

[Ayush Jain]

BANNED

On Wednesday, 18 April 2012 02:35:12 UTC+1, Asa R. wrote:

  Must be sending to all contacts.  I believe it's some kind of 
 solicitation--obviously misdirected--but based on info so far (3 of these 
 emails in 2 days, hasn't responded to list questions about the messages), I 
 think resumeske...@gmail.com should be banned without further ado.

  
  
 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *Maries
 *Sent:* Tuesday, April 17, 2012 1:52 PM
 *To:* excel-macros@googlegroups.com
 *Subject:* Re: $$Excel-Macros$$ HOT LIST OF INFOTARGETS

  
  
 **
  
 On Tue, Apr 17, 2012 at 11:00 PM, kevin pietersen resumeske...@gmail.com 
 wrote:

 infotargets.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$$ new

[Ayush Jain]

banned from the forum. if you see any such email, Please report 
@jainayus...@gmail.com
 
Thanks

On Thursday, 5 April 2012 09:13:46 UTC+1, Asa R. wrote:

  Is that what that was? It went right over my head! :)

  
  
 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI
 *Sent:* Thursday, April 05, 2012 1:09 AM
 *To:* excel-macros@googlegroups.com
 *Subject:* Re: $$Excel-Macros$$ new

  

 Dear Gemd,

 Please read below mentioned forum rules.

 5) Cross-promotion of, or links to, forums competitive to this forum in 
 signatures are prohibited. 
  
 2012/4/5 جمال دغيدى gemd2...@gmail.com
  
 *Dear valued customers*

 *Please send all new value of your involvement*

 *Greetings*

  

  
  
 *Gamal deghady*

 *Egypt*

 *تقبلوا تحياتى *

 *جمال دغيدى*

  

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

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




 -- 
  
 Thanks  regards,
  
 Noorain Ansari
  
 *http://noorainansari.com/*
  
 *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
  
  

  

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

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


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

$$Excel-Macros$$ Re: कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया.****** FIVE YEARS COMPLETION******THANK YOU******

[Ayush Jain]

You always rock Noorain. This is really a great skill.
 
Thanks for writing poem and your great contribution to forum
 
-Ayush Jain

On Thursday, 22 March 2012 18:42:08 UTC, NOORAIN ANSARI wrote:

  जहाँ Excel के दीवानों की,  है बहूत घनी आबादी.
 जहाँ Question,Answer करने की,है खूब आज़ादी.
 जहाँ के पोस्ट को follow कर-कर के,कितनो का Career खुशहाल हो  गया.
 दोस्तों उस अपने Excel-Macro ग्रुप का उम्र,  अब 5 साल हो गया.
 चाहे सुबह हो या शाम, चाहे दिन हो या रात.
 हर समय होती है यहाँ पोस्टिंग की बरसात.
ये उपवन सजा है दोस्तों, कई Talented फूलों से.
  यहाँ शीत युद्ध चलती है अक्सर Excel के फर्मुलों से.
 Logic की खेती होती है यहाँ solutions के खलिहानों में.
 यहाँ मदद की होड़ मची रहती है EXCEL के दिवानो में..
जिसने पा लिया साथ इस ग्रुप का, समझो निहाल हो गया. 
दोस्तों अपने Excel-Macro ग्रुप का उम्र अब 5 साल हो गया.
 *Haseeb,SAM,DON,Ashish* जैसी हस्ती यहाँ पे बसती है.
 Man of BT *Krishna* के solution को दुनिया तरसती है.
   *ASA,Rajan,Dilip,Maries* सब के सब कोहिनूर है.
   *Venkat,Sunny,Abhishekh* भी कम नहीं मशहूर है. 
 और भी यहाँ बहूत सारी शख्सियत है निराली.
 *Ayush* बाबू करते है इस बगीया  की रखवाली.
ये  forum  अब मिशाल नहीं रहा, बल्कि बेमिशाल हो गया.   
 
दोस्तों अपने Excel-Macro ग्रुप का उम्र अब 5 साल हो गया.


 -- 
 Thanks  regards,
 Noorain Ansari
  *http://noorainansari.com/* http://excelmacroworld.blogspot.com/
 *http://excelmacroworld.​blogspot.com/*http://excelmacroworld.blogspot.com/
  



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

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

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

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

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

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

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

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

Fwd: spam Re: $$Excel-Macros$$

[Ayush Jain]

Hi Joginder,

Requesting a password recovery software is against forum rules. Please do
not post such request again.

Regards
-- Forwarded message --
From: xlstime xlst...@gmail.com
Date: Tue, Mar 6, 2012 at 3:59 PM
Subject: spam Re: $$Excel-Macros$$
To: Ayush Jain jainayus...@gmail.com


please take action.

On Tue, Mar 6, 2012 at 8:51 PM, Jai jaihumtu...@gmail.com wrote:

 Dear expert please give me the  Excel VBA passward recover setup this
 is really needed for me

 Thanks in Advance.

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




-- 
.




-- 
Best regards,
Ayush Jain

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

$$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

[Ayush Jain]

 Hello Everyone,

Noorain Ansari has been selected as 'Most Helpful Member' for the month of
Jan'12
He has posted 175 posts in Jan'12 and helped many people through his
expertise. He has been consistent contributor to this excel forum but has
acheived this recognition for first time.

*About Noorain Ansari :*
[image: noorain.jpg]

Noorain is a great poet and keep sharing his thoughts on different topics
throgh cool poems. Professionally, he is a Excel aficionado and presently
working as senior business analyst in One97 Communication Ltd. He is a MS
excel - vba expert and keep sharing his thoughts with this forum. You can
follow his blogs for Excel knowledge and cool poems :
www.excel-macro.blogspot.com  www.noorain-ansari.blogspot.com

*Noorain, Many thanks for all your great support to group. Keep it up*

*Thanks to Rajan Verma, Sam, Don Guillett, Kris, Bheema, Venkat, Chandru ,
Priyanka, Lokesh and other folks for helping excel enthusiasts voluntarily
!! Keep it up !!
**
*Keep posting.

Regards
Ayush Jain
Group Manager
Microsoft MVP

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Dec'2011

[Ayush Jain]

Sam, Welcome back to the group. We missed you.

Noorain, I liked the poetic wishes. Keep it up.

Thanks everyone for being the part of this group.

Regards
Ayush Jain




On Wed, Jan 4, 2012 at 11:20 PM, Aamir Shahzad aamirshahza...@gmail.comwrote:

 Congratulates Rajan. Wellcome back SAM.


 On Wed, Jan 4, 2012 at 7:37 PM, Rajan_Verma rajanverma1...@gmail.comwrote:

  Thank you all.



 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *SWADHEEN JAIN
 *Sent:* Jan/Wed/2012 02:27
 *To:* excel-macros@googlegroups.com
 *Subject:* Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member-
 Dec'2011



 Thank you Rajan ji for your devotion and time for the group.



 God bless you.



 Swadheen Jain

 On Wed, Jan 4, 2012 at 12:59 PM, Maries talk2mar...@gmail.com wrote:

 *Congrats Rajan!*



 On Wed, Jan 4, 2012 at 10:37 AM, Asa Rossoff a...@lovetour.info wrote:

 Congratulations, Rajan!   You bring a lot to the group -- you're very
 generous with your time and expertise.



 Much respect.



 Asa



 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *Ayush Jain
 *Sent:* Tuesday, January 03, 2012 10:21 AM
 *To:* excel-macros
 *Subject:* $$Excel-Macros$$ Rajan verma : Most Helpful Member- Dec'2011



 Hello Everyone,



 Wish you a very happy new year !!


 Rajan Verma has been selected as 'Most Helpful Member' for the month of
 December'2011
 He has posted 105 posts in December2011 and helped many people through
 his expertise. He has been consistent contributor to this excel forum and
 has acheived this recognition third time.



 He is back after long time but we all want him to continue his voluntary
 contribution in 2012 as well.


 Thanks to Don, Noorain, and other folks for helping excel enthusiasts
 voluntarily !! Keep it up !!

 Keep posting.

 Regards
 Ayush Jain
 Group Manager
 Microsoft MVP

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

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

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

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

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

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

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


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

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

$$Excel-Macros$$ Rajan verma : Most Helpful Member- Dec'2011

[Ayush Jain]

Hello Everyone,

Wish you a very happy new year !!

Rajan Verma has been selected as 'Most Helpful Member' for the month of
December'2011
He has posted 105 posts in December2011 and helped many people through his
expertise. He has been consistent contributor to this excel forum and has
acheived this recognition third time.

He is back after long time but we all want him to continue his voluntary
contribution in 2012 as well.

Thanks to Don, Noorain, and other folks for helping excel enthusiasts
voluntarily !! Keep it up !!

Keep posting.

Regards
Ayush Jain
Group Manager
Microsoft MVP

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

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

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

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

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

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

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

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

$$Excel-Macros$$ Take Excel quiz and share your score

[Ayush Jain]

Dear members,

Hope you are doing well !!
I came across an excel quiz and want you to take the same. It is mix of
excel and macros.

http://excelexperts.com/excel-experts-quiz

Do share your score :)
All the best.

http://excelexperts.com/excel-experts-quiz

Best regards,
Ayush Jain

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

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

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

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

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

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

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

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

$$Excel-Macros$$ JOB (Excel/Access VBA, 2-3 yrs experience, Ernst Young)

[Ayush Jain]

Hi,

We urgently need some Excel and Access VBA developers with upto 2-3 yrs of
experience and good communication skills.
Please send me resumes of your friends, colleagues and yours @
jainayus...@gmail.com

Thanks.
Best regards,
Ayush Jain
Microsoft MVP
Group Manager

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Excel learning Institute

[Ayush Jain]

Please make sure that you are sharing only free material in the forum and
not the paid one.
As per rules, you will be banned on violation.

Thanks !

Keep Posting !

Regards
Ayush Jain
On Sat, Nov 26, 2011 at 1:35 AM, kJo contactkkjo...@gmail.com wrote:

 What address or contact number pls?

 Any where in Borivli ?

 On Nov 24, 2:07 pm, krishnanm2...@gmail.com wrote:
  Andheri east
 
  Sent on my BlackBerry® from Vodafone
 
 
 
 
 
 
 
  -Original Message-
  From: mangesh bavalekar bavalek...@gmail.com
 
  Sender:excel-macros@googlegroups.com
  Date: Thu, 24 Nov 2011 14:16:44To: excel-macros@googlegroups.com
 Reply-To:excel-macros@googlegroups.com
  Subject: Re: $$Excel-Macros$$ Excel learning Institute
 
   where I can learn advance excel.im mumbai ?
 
   Mangesh V. B.
 
  --
  FORUM RULES (934+ members already BANNED for violation)
 
  1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 
  2) Don't post a question in the thread of another member.
 
  3) Don't post questions regarding breaking or bypassing any security
 measure.
 
  4) Acknowledge the responses you receive, good or bad.
 
  5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.
 
  NOTE  : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.
 
 
 --To
 post to this group, send email toexcel-mac...@googlegroups.com

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

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

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

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

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

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

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


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




-- 
Best regards,
Ayush Jain

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$

[Ayush Jain]

=if((a2+b2)/2=0,,(a2+b2)/2)

I hope it helps.

Thanks.

On Tue, Nov 29, 2011 at 10:57 PM, Ayoub Kakande akaka...@gmail.com wrote:

 i have a simple formula like =(a2+b2)/2 it returns zero for empty
 cells yet I want it to leave empty cells blank please help

 --
 *If u wanna dream dream BIG
 *You`ve got to do your own growing, no matter how tall your grandfather was


 Kayoub K
 0772656158 / 0703516660
 PMTCT Data Manager
 Mujhu Research Collaboration
 Mulago Hosp

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

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

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

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

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

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

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


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




-- 
Best regards,
Ayush Jain

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

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

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

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

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

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

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

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

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

[Ayush Jain]

Thanks Sam , Paul and Don,

I totally agree with you guys but it is not possible to moderate each
message.
As an immediate action, I have modified the message footer to add forum
rules. Now every message will carry below text at bottom.

I hope this helps. Let me know if it is helpful or any other action
required.

Thanks again,
Ayush Jain

-
FORUM RULES (925+ 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


On Thu, Oct 27, 2011 at 8:44 PM, Sam Mathai Chacko samde...@gmail.comwrote:

 Seconding Don and Paul on that. Another point that comes to the table is
 the lack of proper Subject Titles that clearly and concisely describes the
 problem/objective. I know that this is hinted in the forum rules, but do we
 not need to moderate this?

 Regards,

 Sam


 On Thu, Oct 27, 2011 at 7:39 PM, Paul Schreiner schreiner_p...@att.netwrote:

   I agree with Don.
 The first thing I do is delete all requests that do not describe the
 problem in the subject line.

 Posting Tips:

 Subjects like Urgent Help Needed convey no valueable information.
 the problem isn't urgent for ME, and if the poster didn't need help,
 he/she wouldn't be posting.

 Next, I consider myself an expert in many facets of Excel and VBA, but
 I have very little experience in Pivot Tables.
 Therefore, I skip questions outside of my areas of expertise and let
 someone who knows what
 they're talking about answer those questions.

 So, Subjects that sound interesting, challenging, or within my areas of
 expertise, I'll open and look at.
 If the author didn't feel like wasting his time writing a descriptive
 subject line, I don't feel
 obligated to waste my time trying to figure out what he needs help with.

 I receive HUNDREDS of emails every day...
 I get to choose which ones to open...

 just my opinion...


 *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:* dguillett1 dguille...@gmail.com
 *To:* excel-macros@googlegroups.com
 *Sent:* Thu, October 27, 2011 9:56:09 AM
 *Subject:* Re: $$Excel-Macros$$ Urgent help needed


 Anil, Please do NOT use urgent in your request as most who would help may
 even put that request last on their list or ignore the request.
 Try this code, assuming Master Sheet does NOT exist.
 ===
 Option Explicit
 Sub ConsodilateSheetsSAS()
 Dim dlr As Long
 Dim i As Long

 Application.ScreenUpdating = False
 Sheets.Add before:=Sheets(1)

 With ActiveSheet
   .Name = Master Sheet
 For i = 2 To Sheets.Count
   dlr = .Cells(Rows.Count, 1).End(xlUp).Row + 1
   Sheets(i).UsedRange.Copy .Cells(dlr, 1)
 .Cells(dlr, h) = Sheets(i).Name
 .Cells(dlr, H).Interior.Color = vbCyan
 Next i
 .Columns.AutoFit
 .Rows(1).Delete
 End With
 Application.ScreenUpdating = True
 End Sub
 
 Don Guillett
 SalesAid Software
 dguille...@gmail.com

  *From:* Anil Bhange anil.bha...@tatacommunications.com
 *Sent:* Thursday, October 27, 2011 5:24 AM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ Urgent help needed


 Hi Expert,



 I have found one code which can consolidate the excel worksheets into one
 worksheet, but I wanted my worksheet name should also appear after
 consolidation in column.



 I am unable to make changes in this code, please help me urgently,



 Sub CopyFromWorksheets()

 Dim wrk As Workbook 'Workbook object - Always good to work with object
 variables

 Dim sht As Worksheet 'Object for handling worksheets in loop

 Dim trg As Worksheet 'Master Worksheet

 Dim rng As Range 'Range object

 Dim colCount As Integer 'Column count in tables in the worksheets



 Set wrk = ActiveWorkbook 'Working in active workbook



 For Each sht In wrk.Worksheets

Re: $$Excel-Macros$$ Re: Restrict cell format not values

[Ayush Jain]

Hi Sam,

Thank you so much. It worked well for me.

Cheers.

Regards
Ayush Jain

On Fri, Oct 21, 2011 at 4:47 PM, GoldenLance samde...@gmail.com wrote:

 Here's a link too

 http://excelhints.com/2008/10/21/protect-cell-formats/

 Regards,

 Sam

 On Oct 21, 3:06 pm, GoldenLance samde...@gmail.com wrote:
  Please protect the sheet, and use 'Allow Users To Edit Ranges' option.
  Your format will remain, and users will not be able to edit, but you
  will be able to add data.
 
  Regards,
 
  Sam Mathai Chacko (GL)
 
  On Oct 21, 10:45 am, Ayush Jain jainayus...@gmail.com wrote:
 
 
 
   Hello members,
 
   Thanks for your great participation in the group.
 
   I have a query too. I want to restrict the cell format , so that user
 should
   not be able to change the format but enter the values.
   If the currency format is dollar or percent, the should be able to
 enter
   values only and should not be allow to change the format.
 
   It would be great if we could do it without VBA ,but advise all ideas
 that
   you can think of.
 
   Many thanks in advance
 
   Best regards,
   Ayush Jain
   Group Manager.- Hide quoted text -
 
  - Show quoted text -

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/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




-- 
Best regards,
Ayush Jain

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


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

$$Excel-Macros$$ Do not support any request of breaking passwords

[Ayush Jain]

Noorain, Imaraan, Anish, Sam, Jayandra and rest of the group,

Please do not post or support any query on breaking password of excel vba
file.
This is against the rules of this group.

This is not acceptable and may lead to ban from the group. Take Care.

Thanks.

Regards
Ayush Jain



On Thu, Oct 20, 2011 at 7:58 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:

 Dear Imran,

 Please use attached sheet.

  Thanks  regards,
 Noorain Ansari
  *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
 *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/

  On Thu, Oct 20, 2011 at 6:20 AM, Imran Ansari immi007...@gmail.comwrote:

 Hi Anish,

 Can you tell me as to how can i get the same

 Also please tell me the name of the software that your are using and the
 amount in rupees to spend for same

 Do you have a VBA password cracker i did ask this question to all but
 unfortunately no one has replied

 Please reply

 Regards,

 Imran


  On Tue, Oct 18, 2011 at 5:06 PM, Anish Shrivastava 
 anish@gmail.comwrote:

  Hi,

 I have a password recovery application (Licensed version) but it works
 only till office 2003.

 I tried unlocking your file but no success since it's xlsx (2007).

 If anyone needs any assistance in breaking passwords till xls or any
 office application till 2003 ver, I can be a help.

 Thanks,
 Anish

  On Mon, Oct 17, 2011 at 9:35 PM, Sam Mathai Chacko 
 samde...@gmail.comwrote:

 That will only open the sheet / workbook password Noorain :)


  On Mon, Oct 17, 2011 at 9:29 PM, NOORAIN ANSARI 
 noorain.ans...@gmail.com wrote:

  Dear Jay,

 Please try through below link.
 http://www.straxx.com/excel/password.html

 --
   On Mon, Oct 17, 2011 at 7:40 PM, jayendra gaurav 
 jayendra.gau...@gmail.com wrote:


 Pls help me in this.


 -- Forwarded message --
 From: jayendra gaurav jayendra.gau...@gmail.com
 Date: Fri, Oct 14, 2011 at 1:19 PM
 Subject: $$Excel-Macros$$ Un lock the file.
 To: excel-macros@googlegroups.com



 Dear Team,


 I forgot the password of this file .kindly unlock the same


 Its very urgent.

 Regards

 J.Gaurav

 --

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



 --
 J.Gaurav
 Operation Manager
 Mahindra logistics
 General Motor
 Hallol Baroda
 Cell - 9327348097

 --

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

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

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





 --

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

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

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




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


 --

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

$$Excel-Macros$$ Restrict cell format not values

[Ayush Jain]

Hello members,

Thanks for your great participation in the group.

I have a query too. I want to restrict the cell format , so that user should
not be able to change the format but enter the values.
If the currency format is dollar or percent, the should be able to enter
values only and should not be allow to change the format.

It would be great if we could do it without VBA ,but advise all ideas that
you can think of.

Many thanks in advance

Best regards,
Ayush Jain
Group Manager.

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


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

$$Excel-Macros$$ Thanks everyone.

[Ayush Jain]

Dear members,

I am proud to share that I have been re-awarded the Micrososft MVP award in
2011.  My deep thanks to each group member for all your support and
contribution to this group.
I keep saying that this forum is a great community and emerging as one of
the largest forum in the world, because of the 'helping hand' we all give
one another.

Thanks again  keep posting !

Regards,
Ayush Jain
Group Manager

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


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

Re: $$Excel-Macros$$ Most Helpful Member Sep'11 - Noorain Ansari

[Ayush Jain]

Hello everyone,

I have recognised the achievement on discussexcel.com as well.

Here is the 
linkhttp://www.discussexcel.com/google-group/most-helpful-member/most-helpful-member-of-the-month/noorainansari-sept11

Regards
Ayush Jain

On Sun, Oct 2, 2011 at 12:43 AM, Ayush Jain jainayus...@gmail.com wrote:

 Hello Everyone,

 Noorain Ansari has been selected as 'Most Helpful Member' for the month of
 Sept'11
 He has posted 140 posts in sept 2011 and helped many people through his
 expertise. He has been consistent contributor to this excel forum but has
 acheived this recognition for first time.

 *About Noorain Ansari :*
 [image: noorain.jpg]

 Noorain is a great poet and keep sharing his thoughts on different topics
 throgh cool poems. Professionally, he is a Excel aficionado and presently
 working as senior business analyst in One97 Communication Ltd. He is a MS
 excel - vba expert and keep sharing his thoughts with this forum. You can
 follow his blogs for Excel knowledge and cool poems :
 www.excel-macro.blogspot.com  www.noorain-ansari.blogspot.com

 *Noorain, Many thanks for all your great support to group. Keep it up*

 *Thanks to Don Guillett, Bheema, Venkat, GoldenLance, Ashish Koul, XLS S ,
 Paul and other folks for helping excel enthusiasts voluntarily !! Keep it up
 !!

 *Keep posting.

 Regards
 Ayush Jain
 Group Manager

 --

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

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

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




-- 
Best regards,
Ayush Jain

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


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

$$Excel-Macros$$ Excel chart challenge

[Ayush Jain]

Dear group,

Recently in one of the project, I encountered an issue where we need to sort
the 2-D Bar chart from high to low without sorting the data table
The data table could not be sorted because it is linked with some dynamic
formulas.

Enclosed is the sample data and chart for you, where I jumbled the forum top
posters data in data table.
So the CHALLENGE for you is that you need to sort bars in chart from high to
low without sorting data.

Let's see who has the solution.
Keep posting !

Best regards,
Ayush Jain
Group Manager

P.S. Can we use some dynamic formulas in chart series range, I dont know, I
am just thinking. :)

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


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

Re: $$Excel-Macros$$ Excel chart challenge

[Ayush Jain]

Thanks Ashish , It does work well. However I used the rank function to sort
the data in different range.
Sam, All the solutions are most welcome.

I am looking at the solutions where we can sort chart without using the
additional range. Sometimes the complex sheets with large number of charts
dont allow to add seperate range to sheets.

All ideas matters :) :)


Regards
Ayush Jain

On Sat, Sep 17, 2011 at 6:18 PM, Sam Mathai Chacko samde...@gmail.comwrote:

 Ashish, nice improvisation.

 Ayush, has that solution from solved your question? or are you looking for
 any other solution

 Sam


 On Sat, Sep 17, 2011 at 5:47 PM, ashish koul koul.ash...@gmail.comwrote:

 check the attachement


 On Sat, Sep 17, 2011 at 5:33 PM, Ayush Jain jainayus...@gmail.comwrote:

 Dear group,

 Recently in one of the project, I encountered an issue where we need to
 sort the 2-D Bar chart from high to low without sorting the data table
 The data table could not be sorted because it is linked with some dynamic
 formulas.

 Enclosed is the sample data and chart for you, where I jumbled the
 forum top posters data in data table.
 So the CHALLENGE for you is that you need to sort bars in chart from high
 to low without sorting data.

 Let's see who has the solution.
 Keep posting !

 Best regards,
 Ayush Jain
 Group Manager

 P.S. Can we use some dynamic formulas in chart series range, I dont know,
 I am just thinking. :)

 --

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

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

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




 --
 *Regards*
 * *
 *Ashish Koul*
 *http://www.excelvbamacros.com/*


 P Before printing, think about the environment.


 --

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

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

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




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




-- 
Best regards,
Ayush Jain

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


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

$$Excel-Macros$$ Rajan Verma : Most Helpful Member - August'11

[Ayush Jain]

Hello Everyone,
Rajan Verma has been selected as 'Most Helpful Member' for the month of
August'11
He has posted 152 posts in August 2011 and helped many people through his
expertise. He has been consistent contributor to this excel forum and has
acheived this recognition for second time consecutively.

Thanks to Noorain, Venkat, Sunny(XLS S), Don Guillett, and other folks for
helping excel enthusiasts voluntarily !! Keep it up !!

Keep posting.

Regards
Ayush Jain
Group Manager
Microsoft MVP

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


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

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

[Ayush Jain]

Venkat,

If the tool is free ware, Please feel free to share with entire group. I can
see individuals asking to send the tool to their personal email ids.
If the tool is paid, just provide the website name from where people can buy
it.

As per forum rules, we restrict the distribution of copyright material or
paid material for free.
Many thanks for your great contribution to group. Let me know if u have any
queries.

Thanks.

Regards
Ayush Jain
Group Manager
2011/8/20 Venkat CV 

 You are welcome

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

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

 Thank you very much.




 --
 *
 *
 *
 *


 --

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

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

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




-- 
Best regards,
Ayush Jain

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


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

$$Excel-Macros$$ Re: If excel is your friend, Then what feature will you gift to excel :)

[Ayush]

Please post the same in the link mentioned above.

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

$$Excel-Macros$$ Rajan Verma : Most Helpful Member - July'11

[Ayush Jain]

   Hello Everyone,

 Rajan Verma has been selected as 'Most Helpful Member' for the month of
 July'11
 He has posted 170 posts in July 2011 and helped many people through his
 expertise. He has been consistent contributor to this excel forum and but
 achived this recognition for the first time.

He has also created a record of highest number of posts by any
individual in a month.



Thanks to Ashish, Dilip, Venkat, Sunny(XLS S), Noorain, and other folks
 for helping excel enthusiasts !! keep it up !!


  We as a group made a record of 1350+ posts in a month. Thanks
everyone...Thats really awesome. :)


Keep posting.


  Regards
 Ayush Jain
 Group Manager



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


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

Re: $$Excel-Macros$$ Poem - जोर से बोलो दम लगा के जय, Excel -Macro परिवार.

[Ayush Jain]

Thanks Noorain !

Excellent poem everytime :)

2011/7/30 Jattin Agarwal jatti...@gmail.com

 kamal hai , asey hi poem likhtey raho , aur hamey kush karte raho

 2011/7/30 NOORAIN ANSARI noorain.ans...@gmail.com:
   Dear Experts,
 
  I have written a poem on our group to complete 8000 Members in
 EXCEL-MACRO
  faimly.
  read and Enjoy...
 
  जहा रोज सैकड़ों Questions की होती है बौछार.
  फिर लगते है अति-उत्तम Answers की कतार.
  जहा Excel-Experts की है बहूत बड़ी भरमार.
  सदस्य संख्या जिसकी हो चुकी  है 8 हज़ार.
वो है यारों अपना Excel-Macro परिवार.
  होती है बरसात यहाँ Excel के फोर्मुलों की.
  स्वाद सभी लेते है Logic के रसगुल्लों की.
  Question चाहे हो टेढ़ा, चाहे हो आसान.
  यहाँ हर समस्या Excel की बनती है समाधान.
  Excel -Experts की Army जहा बैठी है तैयार.
  ताक़ में है कब आये कोई query रूपी शिकार.
 वो है यारों अपना Excel-Macro परिवार.
  धन्यवाद का Button जब करते है हम PUSH जी.
  सबसे पहले याद आते है अपने ग्रुप मैनेजर आयुष जी.
  Technique है जिनका सीधा-साधा,पर logic है बहूत deep जी.
  उस Excel -Expert का नाम है Pandey Mr  dilip जी.
  जब चली है बात एक्सपर्ट की तो उन्हें भी देदे WISH .
  Group का दुलारा,सबके आँखों का तारा,Koul Mr आशीष.
   DAVE,PAUL,DANIEL,STD(V) इस  ग्रुप के  कोहिनूर है.
  MAHESH,HASEEB,VENKAT के different Logic सदा से मशहूर है.
  और जो एक्सपर्ट हर Query के answer खातिर रहते है बेकाबू.
  वो है अपने छैल-छबीले पुने वाले हंसमुख राजन बाबु.
  सुमधुर लगती है अगर इस ग्रुप की मुरली की तान.
  तो उसमे हर सदस्य का है यारों बहुमूल्य योगदान.
  ग्रुप के सारे सदस्यों की महिमा यु बनी रहे आपार.
  दुआ है दिन-दुनी रात चौगुनी हो इसका बिस्तार.
  जोर से बोलो दम लगा के जय Excel -Macro परिवार.
 
 
 
  --
  Thanks  regards,
  Noorain Ansari
  http://noorain-ansari.blogspot.com/
 
  --
 
 --
  Some important links for excel users:
  1. Follow us on TWITTER for tips tricks and links :
  http://twitter.com/exceldailytip
  2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
  3. Excel tutorials at http://www.excel-macros.blogspot.com
  4. Learn VBA Macros at http://www.quickvba.blogspot.com
  5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
  To post to this group, send email to excel-macros@googlegroups.com
 
  
  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




-- 
Best regards,
Ayush Jain

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


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

Re: $$Excel-Macros$$ Re: Poem - जोर से बोलो दम लगा के जय, Excel -Macro परिवार.

[Ayush Jain]

Hello Daniel,

I tried to use google translate to convert the same into english. Few lines
converted very well but the meaning may have changed in few lines.
Noorain, Can you please fix the lines where the intended meaning is changed.
Thanks.

 Where is the daily barrage of hundreds Questions.
 Then start over - the line of Best Answers.
 Where the very large glut of Excel-Experts.
 It's the 8 thousand members.
 Is that your Excel-Macro family of boys.
 Is the rain of Excel formulas here.
 Taste of Logic Rsgullon of all charges.
 Question is whether sloping, easy to get it.
 Here is the solution to every problem created in Excel.
 Excel-Experts to prepare the Army is sitting where.
 A query came when running the game at recess.
 Is that your Excel-Macro family of boys.
 Thanks to the Button when we live PUSH.
 First of all I miss your Group Manager AYUSH law.
 Technique's that simple - but very deep in-law's logic.
 Is the name of the Excel-Expert Pandey Mr dilip law.
 Is left to the experts, they also Dede WISH.
 Group's pet, the apple of everyone's eyes, Koul Mr Ashish.
 DAVE, PAUL, DANIEL, STD (V) is the Kohinoor Group.
 MAHESH, HASEEB, VENKAT always known the different Logic.
 And the expert's answer for every Query wild living.
 That's my Cutie - The Jolly Rajan Babu Cbile Res.
 This group seems saccharine tone of Murali.
 So it is each member contributes valuable guys.
 Group Apar all members continue to glorify war.
 Dua's Day - that the ground gained by leaps and bounds.
 Come on speak up Excel-Macro family of the Glory.
 Regards
Ayush Jain
Group Manager

2011/7/30 daniel dcolarde...@gmail.com

 Hello, Noorain,

 I am really sad not to understand the meaning of your poem (is it
 Hindi ? I failed to learn it a few years ago) I shall really enjoy to
 get a translation from it. If you have time enough to do it.

 Regards.

 Daniel

 On 30 juil, 04:20, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
  Dear Experts,
 
  I have written a poem on our group to complete 8000 Members in
 EXCEL-MACRO
  faimly.
  read and Enjoy...
 
  जहा रोज सैकड़ों Questions की होती है बौछार.
  फिर लगते है अति-उत्तम Answers की कतार.
  जहा Excel-Experts की है बहूत बड़ी भरमार.
  सदस्य संख्या जिसकी हो चुकी  है 8 हज़ार.
वो है यारों अपना Excel-Macro परिवार.
  होती है बरसात यहाँ Excel के फोर्मुलों की.
  स्वाद सभी लेते है Logic के रसगुल्लों की.
  Question चाहे हो टेढ़ा, चाहे हो आसान.
  यहाँ हर समस्या Excel की बनती है समाधान.
  Excel -Experts की Army जहा बैठी है तैयार.
  ताक़ में है कब आये कोई query रूपी शिकार.
 वो है यारों अपना Excel-Macro परिवार.
  धन्यवाद का Button जब करते है हम PUSH जी.
  सबसे पहले याद आते है अपने ग्रुप मैनेजर आयुष जी.
  Technique है जिनका सीधा-साधा,पर logic है बहूत deep जी.
  उस Excel -Expert का नाम है Pandey Mr  dilip जी.
  जब चली है बात एक्सपर्ट की तो उन्हें भी देदे WISH .
  Group का दुलारा,सबके आँखों का तारा,Koul Mr आशीष.
   DAVE,PAUL,DANIEL,STD(V) इस  ग्रुप के  कोहिनूर है.
  MAHESH,HASEEB,VENKAT के different Logic सदा से मशहूर है.
  और जो एक्सपर्ट हर Query के answer खातिर रहते है बेकाबू.
  वो है अपने छैल-छबीले पुने वाले हंसमुख राजन बाबु.
  सुमधुर लगती है अगर इस ग्रुप की मुरली की तान.
  तो उसमे हर सदस्य का है यारों बहुमूल्य योगदान.
  ग्रुप के सारे सदस्यों की महिमा यु बनी रहे आपार.
  दुआ है दिन-दुनी रात चौगुनी हो इसका बिस्तार.
  जोर से बोलो दम लगा के जय Excel -Macro परिवार.
 
  --
  Thanks  regards,
  Noorain Ansari
  *http://noorain-ansari.blogspot.com/*
 http://noorain-ansari.blogspot.com/

 --

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

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

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




-- 
Best regards,
Ayush Jain

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


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

$$Excel-Macros$$ Re: minimum numeric positive value

[Ayush]

Hi Sunder,
 
If you have the data in the range of G18 to G23 , then you can use below 
formula.
 
{=MIN(IF(G18:G230,G18:G23,MAX(G18:G23)))}
This is array formula, So you need to press SHIFT+CTRL+ENTER after writing 
it.
 
I hope it helps. Feel free to let me know if any further help is required.
 
Regards
Ayush Jain
Group manager
 

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


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

$$Excel-Macros$$ Two major milestones : 8000 members and 1000+ posts

[Ayush]

Dear members,
 
I am glad to share that this forum has achieved two major milestones this 
month. The number of members have reached 8000 and 1000 posts in a month 
which is highest in forum history.
The credit goes to each forum member who is passionate about excel. 
 
My sincere thanks to active MVPs, query solvers and all excel enthusiasts.
 
*Feel free to invite your friends, colleagues , boss, relatives, your ex, 
your present and everyone who is in love with excel :) :)*
** 
You can provide me the email ids of the people you want to invite in the 
forum. Send me the list at  jainayus...@gmail.com
 
Keep the spirit up 
 
Warm regards
Ayush Jain
Group Manager.

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


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

$$Excel-Macros$$ Forum rules : Please adhere else you will be BANNED

[Ayush Jain]

Hello everyone,

Please adhere to below rules of the forum. You will be banned without
warning on non compliance.
Till date 806 members are banned in group, This is the reason the group is
spam free.

   *Please read and adhere to these simple rules!*
*
1. Use concise, accurate thread titles. *Your post title should describe
your problem, not your anticipated solution. Use terms appropriate to a
Google search. Poor thread titles, like Please Help, Urgent, Need Help,
Formula Problem, Code Problem, and Need Advice will not get quick attention
or may not be answered.

*2. Don't post a question in the thread of another member* -- start your
own. If you feel it's particularly relevant, provide a link to the other
thread.

*3. Don't Private Message* or email questions to moderators or other
members. The point of having a public forum is to share solutions to common
(and sometimes uncommon) problems with all members.

*4. Common courtesy is the order of the day*. Avoid coarse language (meaning
any words you didn't hear in Sunday school), provide feedback to suggested
solutions, and take the time to thank those who took their time to help you.
If you solve a problem yourself before anyone else has responded, please
take a moment to describe your solution -- chances are some other member
will benefit.

*5. Don't post questions regarding breaking or bypassing any security
measure.* Such posts will be deleted, and repeat offenders will be banned.
This includes posting of links to sites that offer software, code or
services to do this or posting of code to remove passwords.

*6. Acknowledge the responses you receive, good or bad.*

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

*8. Any post which is not related to excel, macros, vba, access or any other
office technology, It will be considered as spam on the discretion of
moderators.*

*General suggestions:*

   1. *Don't put your email address in a post unless you're dying for more
   spam in your inbox.
   *
   2. *Don't ever post personal or confidential data in a workbook. The
   moderators will not consider any request to delete such posts.*


Feel free to let me know if you have any doubts or if you want to add more
rules to keep this forum clean.

The rules are also available @ this
linkhttp://www.discussexcel.com/google-group/forum-rules


Best regards,
Ayush Jain
Group Manager, MVP

-- 
--
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$$ Forum rules : Please adhere else you will be BANNED

[Ayush Jain]

There is no feature in google groups to send an email to new users.

The link is available on the top of the page for new users.

Regards
Ayush Jain

On Sat, Jul 23, 2011 at 8:23 PM, XLS S xlst...@gmail.com wrote:

 Dear Ayush,

 Thanks for sharing rule's, Is it possible that read all the rules and
 regulation before join from? specially for new member

 Because i am also new member...





 On Sat, Jul 23, 2011 at 4:50 PM, Ayush Jain jainayus...@gmail.com wrote:

 Hello everyone,

 Please adhere to below rules of the forum. You will be banned without
 warning on non compliance.
 Till date 806 members are banned in group, This is the reason the group is
 spam free.

*Please read and adhere to these simple rules!*
 *
 1. Use concise, accurate thread titles. *Your post title should describe
 your problem, not your anticipated solution. Use terms appropriate to a
 Google search. Poor thread titles, like Please Help, Urgent, Need Help,
 Formula Problem, Code Problem, and Need Advice will not get quick
 attention or may not be answered.

 *2. Don't post a question in the thread of another member* -- start your
 own. If you feel it's particularly relevant, provide a link to the other
 thread.

 *3. Don't Private Message* or email questions to moderators or other
 members. The point of having a public forum is to share solutions to common
 (and sometimes uncommon) problems with all members.

 *4. Common courtesy is the order of the day*. Avoid coarse language
 (meaning any words you didn't hear in Sunday school), provide feedback to
 suggested solutions, and take the time to thank those who took their time to
 help you. If you solve a problem yourself before anyone else has responded,
 please take a moment to describe your solution -- chances are some other
 member will benefit.

 *5. Don't post questions regarding breaking or bypassing any security
 measure.* Such posts will be deleted, and repeat offenders will be
 banned. This includes posting of links to sites that offer software, code or
 services to do this or posting of code to remove passwords.

 *6. Acknowledge the responses you receive, good or bad.*

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

 *8. Any post which is not related to excel, macros, vba, access or any
 other office technology, It will be considered as spam on the discretion of
 moderators.*

 *General suggestions:*

1. *Don't put your email address in a post unless you're dying for
more spam in your inbox.
*
2. *Don't ever post personal or confidential data in a workbook. The
moderators will not consider any request to delete such posts.*


 Feel free to let me know if you have any doubts or if you want to add more
 rules to keep this forum clean.

 The rules are also available @ this 
 linkhttp://www.discussexcel.com/google-group/forum-rules


 Best regards,
 Ayush Jain
 Group Manager, MVP

 --

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




-- 
Best regards,
Ayush Jain

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


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

$$Excel-Macros$$ Group Survey : Your feedback is important

[Ayush Jain]

Dear members,

Thanks for all your contribution to group. I am very happy to see the
great participation in the group.

For me its very important to know what you feel about the group, So that I
can take any action or initiative on the basis of your feedback.
This is an anonymous survey, so feel free to share your views and the
activities you would like to see in this group. Your valuable feedback is
highly appreciated.

To participate in survey, Please follow the below link
http://www.surveymonkey.com/s/L8BTDNQ

Thanks again and Keep Posting. :)

Best regards,
Ayush Jain
Group Manager

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


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

$$Excel-Macros$$ Submit your innovative MS Excel thoughts, ideas, suggestions

[Ayush]

Dear members,

As you already know that I am collecting ideas and new features that you 
would like to see in upcoming version of MS Excel. 
The only intent here is to make excel awesome for the users and give 
feedback to Microsoft on their product. These ideas will be reviewed by 
Microsoft Excel product team.

Submit your idea here now. http://goo.gl/mod/psLh You can vote the ideas 
submitted by others. There is no limit to submit ideas or features. 

In total, 92 ideas submitted on which 313 votes are casted. 
Let see who submit the maximum ideassee you there.. 

ALL IDEAS MATTERS :) http://goo.gl/mod/psLh

Best Regards, 
Ayush Jain 
Group Manager.

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


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

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

[Ayush Jain]

  Hello Everyone,

 Ashish Koul has been selected as 'Most Helpful Member' for the month of
 June'11
 He has posted 53 posts in June 2011 and helped many people through his
 expertise. He has been consistent contributor to this excel forum and
 achieved this recognition from last seven months consecutively.This is
 really awesome. He is awarded Microsoft MVP 2011 award for his voluntary
 contribution.


   Thanks to Rajan, Venkat and other folks for helping excel enthusiasts !!
keep it up !!

   Let see who becomes next MVP..

   Keep posting.


  Regards
 Ayush Jain
 Group Manager


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


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

$$Excel-Macros$$ and the Microsoft MVP award goes to Ashish Koul :)

[Ayush]

Dear Group,
I am extremely happy to share a good news with you. One of our dearest group 
member 'Ashish Koul' is awarded Microsoft MVP award on 1st July for his 
exceptional MS Excel skills and voluntary contribution. 
He is well deserving for the award and I am very happy and proud of his 
recognition. The guy has been top poster in the group from last 7-8 months.
 Let see who becomes the next MVP from the group. The group has now three 
active MVPs. 
 
Dear Ashish, 
Many Many congratulations for the award.I am very proud of you to be part of 
this group. 
Keep your valuable contribution to the group. I wish your long association 
with this group.
Cheers !!
Best Regards,
Ayush Jain
Group Manager

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


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

$$Excel-Macros$$ Re: Dynamic Lookup Secrets is LIVE!

[Ayush]

Dear Group,
 
Only 2 days left. 

On Tuesday, 21 June 2011 23:35:38 UTC+5:30, Ayush wrote:

 Dear members,
  
 Hope you are doing great ! 
  
 This is very exciting news !

 John Franco has just opened enrollment for his premium online private 
 coaching program Dynamic Lookup Secrets

 It is packed with amazing content that you will LOVE. I have personally 
 reveiwed the material and it is fantastic and you WILL be helped.
 Click HERE to get started http://www.1shoppingcart.com/app/?Clk=4338507

 After seeing how great this material is, I honestly don't think you can 
 afford to NOT at least try it out.
 The value is so much more than the asking price and you should invest in 
 yourself and take action now

 Invest in your career NOW http://www.1shoppingcart.com/app/?Clk=4338507
  
 The product just went live, and he expects there to be lots of traffic 
 today, so head on over to the page below and reserve your spot. 
 Let me know if you have any queries. The program is open till 24th June
  
 Countdown starts..

 Thanks for your time,
 Ayush Jain


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


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

$$Excel-Macros$$ Dynamic Lookup Secrets is LIVE!

[Ayush Jain]

Dear members,

Hope you are doing great !

This is very exciting news !

John Franco has just opened enrollment for his premium online private
coaching program Dynamic Lookup Secrets

It is packed with amazing content that you will LOVE. I have personally
reveiwed the material and it is fantastic and you WILL be helped.
Click HERE to get started http://www.1shoppingcart.com/app/?Clk=4338507

After seeing how great this material is, I honestly don't think you can
afford to NOT at least try it out.
The value is so much more than the asking price and you should invest in
yourself and take action now

Invest in your career NOW http://www.1shoppingcart.com/app/?Clk=4338507

The product just went live, and he expects there to be lots of traffic
today, so head on over to the page below and reserve your spot.
Let me know if you have any queries. The program is open till 24th June

Countdown starts..

Thanks for your time,
Ayush Jain

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


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

$$Excel-Macros$$ Join discussexcel @ Facebook and twitter

[Ayush]

Dear members, 
 
I know most of you have accounts on facebook and twitter. Then why not 
follow discussexcel on Facebook  Twitter for Excel Tips and Tricks.
 
Join us now on Facebook http://www.facebook.com/discussexcel and 
Twitterhttp://twitter.com/discussexcel
 
You can also share tips and tricks on these channels.
 
Keep Posting ! 
 
Regards
Ayush Jain
Group Manager
 

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


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

$$Excel-Macros$$ Re: Time running out on FREE Index/Match, Vlookup downloads

[Ayush]

TWO DAYS LEFT :)

On Friday, 17 June 2011 21:41:39 UTC+5:30, Ayush wrote:

 Dear members, 
  
 I saw that you didn't go and check out FREE Index/Match and Vlookup Syntax 
 Memory Cards http://www.1shoppingcart.com/app/?Clk=4338508 that was 
 released last week.
  
 You should really go download them because they have gotten 100% positive 
 feedback AND *Monday is the LAST day* you will be able to have access to 
 them.
  
 Get your FREE lookup downloads 
 herehttp://www.1shoppingcart.com/app/?Clk=4338508
  
 There are ALSO 3 free videos that you should really watch as well. They 
 show you the logic of these confusing lookup formulas and show you some 
 simple ways to operate them with success.
  
 Get the free content HERE http://www.1shoppingcart.com/app/?Clk=4338508
  
 You should probably note as well that on Tuesday, June 21st John will be 
 releasing his brand new Lookup training course and DISCUSSEXCEL group 
 members will get special discount to buy the same. Keep watching this space. 
 :)
  
 So go to the page and check out all of the content!
  
 Best Regards,
 Ayush Jain
 Group Manager


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


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

$$Excel-Macros$$ Time running out on FREE Index/Match, Vlookup downloads

[Ayush]

Dear members, 
 
I saw that you didn't go and check out FREE Index/Match and Vlookup Syntax 
Memory Cards http://www.1shoppingcart.com/app/?Clk=4338508 that was 
released last week.
 
You should really go download them because they have gotten 100% positive 
feedback AND *Monday is the LAST day* you will be able to have access to 
them.
 
Get your FREE lookup downloads 
herehttp://www.1shoppingcart.com/app/?Clk=4338508
 
There are ALSO 3 free videos that you should really watch as well. They show 
you the logic of these confusing lookup formulas and show you some simple 
ways to operate them with success.
 
Get the free content HERE http://www.1shoppingcart.com/app/?Clk=4338508
 
You should probably note as well that on Tuesday, June 21st John will be 
releasing his brand new Lookup training course and DISCUSSEXCEL group 
members will get special discount to buy the same. Keep watching this space. 
:)
 
So go to the page and check out all of the content!
 
Best Regards,
Ayush Jain
Group Manager

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


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

$$Excel-Macros$$ Excel Blog of the month - akoul.blogspot.com

[Ayush]

Dear group,
 
As the part of discussexcel http://www.discussexcel.com/ initiative, we 
declare Excel bog of the month each month. This is done to appreciate 
indvidual Excel bloggers and encourage excel blogging. 
 
akoul.blogspot.com has been selected as blog of the month for May 2011. This 
is a great excel blog which is very active in sharing tips, tricks, 
functions  VBA macros.. 
The blog is managed by Ashish Koul who is 'Most Helpful Member' of the month 
from last six months.
 
I have published the more info about the bloghttp://www.akoul.blogspot.com/ 
on 
discussexcel.com. Please do visit the blog atleast once.
 
Dear Ashish, Congratulations
We are proud to have you in the group. Keep it up.
 
Best regards,
Ayush Jain
Group Manager

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


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

$$Excel-Macros$$ Index, Match, Vlookup Memory Cards [Free downloads]

[Ayush]

Well, he's done it again. My good friend John Franco just uploaded these free 
lookup syntax mastery 
downloadshttp://www.1shoppingcart.com/app/?Clk=4338508for you.
To be honest, these are AWESOME. These will ensure that you understand and 
REMEMBER the syntax for Index, Match, and Vlookup.

I really think you should download these because they are great tangible 
resources that you can use TODAY at your office. 
Watch the video and get the 
downloadshttp://www.1shoppingcart.com/app/?Clk=4338508NOW

He also provides a POWERFUL analogy in his video that makes it easy to see 
the logic of these formulas.
You can get all the goodies http://www.1shoppingcart.com/app/?Clk=4338508HERE

Warm regards,
Ayush Jain
Group Manager

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


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

Re: $$Excel-Macros$$ Posting jobs in group

[Ayush]

Dilip, 
 
Ok, I will approve the external link if it is opening form for that specific 
job only. 
I hope that is fine.
 
Dear Group, 
Start posting jobs :)
 
Regards
Ayush Jain
Group Manager

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


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

$$Excel-Macros$$ Group Survey : Your feedback is important

[Ayush]

Dear members,

Thanks for great participation in the group. 

For me its very important to know what you feel about the group, so that I 
can take any action or initiative on the basis of your feedback.
This is an anonymous survey , so feel free to share your views and the 
activities you would like to see in this group. Your valuable feedback is 
highly appreciated.

To participate in survey, Please follow the below link
http://www.surveymonkey.com/s/L8BTDNQ

Thanks again and Keep Posting. :)

Best regards,
Ayush Jain
Group Manager
 
P.S. I send this feedback email every month. If you have already 
participated , You may ignore this email.  If you want to give feedback or 
suggestion again, You are most welcome.

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

$$Excel-Macros$$ Have idea or suggestion for MS Excel ? Submit and win awesome prize

[Ayush Jain]

 Dear Group members,

An awesome opportunity to win prize and be closer to Microsoft Excel.

What you need to do ? Just submit the idea or feature that you would like to
implement in upcoming version of excel.
http://www.google.com/moderator/#16/e=455db

The best five ideas with maximum votes will get the $10 cash prize(*If 1000
ideas are submitted in total*). Not only you can submit the idea but you can
also vote other ideas and suggestion.
This initiative was started in January and we have collected over 68 ideas
and 258 votes

I encourage you to participate yourself and let your friends and colleagues
participate in this venture. I really expect at least one idea from each one
of you. This is going to be global series and you will have the chance to
learn the upcoming possibilities in excel.

You can vote on submissions and suggest your own Idea at
http://www.google.com/moderator/#16/e=455db

Thanks  Best Regards,
Ayush Jain
Group Manager

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


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

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

[Ayush]

 Hello Everyone,

Ashish Koul has been selected as 'Most Helpful Member' for the month of 
April'11
He has posted 57 posts in April 2011 and helped many people through his 
expertise. He has been consistent contributor to this excel forum and 
achieved this recognition from last five months consecutively.This is really 
awesome.
 
ASHISH, Many Many thanks for the incredible support to group.
 
*I have published the same on discussexcel.com homepage.*

Regards
Ayush Jain
Group Manager

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


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

$$Excel-Macros$$ Excel blog of the month : Chandoo.org

[Ayush Jain]

Dear group,

As the part of discussexcel.com initiative, we declare Excel bog of the
month each month. This is done to appreciate indvidual Excel bloggers and
encourage excel blogging.

*Chandoo.org* has been selected as blog of the month for *April 2011*. This
is a great excel blog which is very active in sharing tips, tricks  data
analysis techniques regularly.
The blog is managed by *Purna Duggirala* who is Microsoft MVP since 2009.
I have published the more info on discussexcel.com. Please do visit by
clicking this 
*link*http://www.discussexcel.com/blog-of-the-month/blog-of-the-month-2011/chandooorgbypurnaduggirala-apr11
for
more information.

*Another great news : We are 7800 strong now...Just 200 away from 8000
milestone...Invite your friends and colleagues to be part of this great
group. Thanks*

Best regards,
Ayush Jain
Group Manager

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


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

Re: $$Excel-Macros$$ Group Survey : Your feedback is important

[Ayush]

Hi Sanjoo, 
 
Thanks for feedback. I also wanted to categorise the group into sub groups 
but we do not have such facility available in Google groups.
Google Groups have been working to add new features in future but I am not 
sure what all will come.
 
We need to live with this limitation. :)
 
Rest of the group, Please participate in survey if you have not done yet. 
Thanks
Regards
Ayush Jain

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


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