$$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, S&P 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 wrote:

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

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


On Tue, Sep 24, 2013 at 12:10 AM, Bill Q  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  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<https://www.facebook.com/discussexcel>
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros...@**googlegroups.com.
>>> To post to this group, send email to excel-...@googlegroups.com.
>>>
>>> Visit this group at 
>>> http://groups.google.com/**group/excel-macros<http://groups.google.com/group/excel-macros>
>>> .
>>> For more options, visit 
>>> https://groups.google.com/**groups/opt_out<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.
>



-- 
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  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$$ 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
wrote:

> 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 wrote:
>
>>
>> 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 
>> 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/gr

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

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

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 سمية صفار >
>
>> اول موقع سكس شوب عربي 
>> يتميز المتجر  بالمصداقية العالية و الموثوقية الكبيرة 
>> الاسعار المنافسة و الجودة العالية 
>> توفير كل طرق الدفع السهلة و المتاحة 
>> ضم الاف المنتجات الجنسية المتنوعة 
>> شحن الى الدول العربية و تجاوز الجمارك 
>> السرية و الامان 
>> تنوع طرق الشحن و الاستلام 
>> ...
>> كما يتميز الموقع بتقدين خدمة المواعدة الحصرية و المميزة 
>> لينك للموقع
>> www.shopar1.com/mer/
>> لاحتواء الموقع على منتجات البالغين فقد يحجب ببعض البلدان 
>> لذلك و لتجاوز الحظر ارسل رسالة بعنوان ارغب ادخل للموقع 
>> ليتم ارسال لكم برامج بروكسيات و روابط مفتوحة 
>> البريد 
>> mercat...@gmail.com 
>> اطلقوا العنان و تسوقوا من سوق المتعة الاول و الاكثر امان و سرية عربيا 
>> مع حبي
>>
>>  -- 
>> 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.com
>> .
>> To unsubscribe from this group, send email to 
>> excel-macros...@googlegroups.com .
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>  
>>  
>>
>
>

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

FORUM RULES

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

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

RE: $$Excel-Macros$$ Re: 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"  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 wrote:

> 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$$ 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"  wrote:
>
> Submitted.
> Regards,
> Vinay Gupta
>
> On Sun, Nov 18, 2012 at 9:53 PM, Ayush Jain  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.

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

[Ayush Jain]

CSk, start the new topic please

Thanks.
On Nov 25, 2012 10:01 PM, "CSK"  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.

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

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

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

> 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

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 > 
> *Sender: * excel-...@googlegroups.com  
> *Date: *Thu, 8 Nov 2012 11:27:38 +0530
> *To: *>
> *ReplyTo: * excel-...@googlegroups.com  
> *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, >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.com
>> .
>> To unsubscribe from this group, send email to 
>> excel-macros...@googlegroups.com .
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>
>>
>
>
> -- 
> With Regards,
> Noorain Ansari
> http:// 
> <http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com>
> http:// 
> <http://www.excelvbaclinic.blogspot.com>excelvbaclinic.com<http://www.excelvbaclinic.blogspot.com><http://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.com
> .
> To unsubscribe from this group, send email to 
> excel-macros...@googlegroups.com .
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>  
>  
>

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

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles.

$$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.com>noorainansari.com<http://www.noorainansari.com>
> http:// 
> <http://www.excelvbaclinic.blogspot.com>excelvbaclinic.com<http://www.excelvbaclinic.blogspot.com><http://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.

$$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* 
>
> 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  || 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,  wrote:

> Bhanu,  Learn to spell.   Paul,  Right On!
>
>
>  Paul Schreiner  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 
> > 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 
> 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 simpl

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.

$$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$$ 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 wrote:

> 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 wrote:
>>
>>> Amol  Shrivastava From Mumbai...!! 
>>>
>>> On Sat, Sep 29, 2012 at 2:51 PM, Aamir Shahzad wrote:
>>>
>>>> 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 wrote:
>>>>
>>>>> 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"

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

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



-- 
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
here<https://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.


<>

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 > 
> *Sender: *excel-...@googlegroups.com  
> *Date: *Fri, 17 Aug 2012 12:40:53 -0400
> *To: *>
> *ReplyTo: *excel-...@googlegroups.com  
> *Subject: *$$Excel-Macros$$ DB2 DBA // Atlanta, GA // 1 to 2 years
>
>  *Please send the resumes with contact details to **
> res...@gallopresources.com *
>
>
> **
>
>
> **
>
> *
> *
>
> **
>
> *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.com
> .
> To unsubscribe from this group, send email to 
> excel-macros...@googlegroups.com .
>  
>  
>

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ 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  [mailto:
> excel-...@googlegroups.com ] *On Behalf Of *Ashish Pradhan
> *Sent:* 15 August 2012 20:24
> *To:* excel-...@googlegroups.com 
> *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   
>   
> *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-functio

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

$$Excel-Macros$$ Have an idea to improve excel ? Submit here.

[Ayush Jain]

Dear members,

Last year,I started an initiative to collect ideas for improvements in
excel. The initiative received the great response of 190 ideas and 1348
votes.

If you still have ideas and new features that you would like to see in
future version of MS Excel, you can submit the same
here<http://www.google.com/moderator/#16/e=455db>
The only intent here is to make excel awesome for the users and give
feedback to Microsoft on their product.

Submit your idea here <http://www.google.com/moderator/#16/e=455db>

If you dont have idea, you can
vote<http://www.google.com/moderator/#16/e=455db>the ideas of others
and support them. The ideas will be reviewed by
Microsoft product team and they may incorporate if they like it.

Thanks all for supporting this initiative.
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

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  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$$ 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  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$$ 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  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$$ 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  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$$ ****** 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 wrote:

> Congrats Asish. :)
>
>
>
> On Tue, Jul 3, 2012 at 8:27 PM, Bé Trần Văn wrote:
>
>>   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 
>>
>>> 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"  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 competit

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

>   And, Don Guillett was not re selected.
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Ayush Jain 
> *Sent:* Sunday, July 01, 2012 11:24 AM
>  *To:* excel-macros 
> *Cc:* Dilip Pandey  ; ashish koul
> *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]

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,  wrote:

> **
> Hi Ayush,
>
> Why can't we have separate team of moderator like other sites.
>
> ------
> *From: *Ayush Jain 
> *Sender: *excel-macros@googlegroups.com
> *Date: *Mon, 18 Jun 2012 23:02:07 +0530
> *To: *
> *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 
>>> wrote:
>>>
>>>> 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  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
>>>>&g

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

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

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

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$$ 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
feedback<http://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  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,  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: *
>> *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 
>> *Sender: *excel-macros@googlegroups.com
>> *Date: *Sun, 10 Jun 2012 10:31:29 +0400
>> *To: *
>> *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,  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: *
>

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  
> *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 wrote:
>
>> 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  
> *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* 
>
> 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*  || *
> 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 
> own

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

> 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,  wrote:
>
>> **
>> Hi Ayush sir,
>>
>> Can you plz exlude me from this forum.
>> Sent on my BlackBerry® from Vodafone
>>  --
>> *From: *Ayush Jain 
>> *Sender: *excel-macros@googlegroups.com
>> *Date: *Sun, 20 May 2012 07:54:03 -0700 (PDT)
>> *To: *
>> *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-

$$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 wrote:
>
>>   *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 * wrote:
>>
>>
>> From: Aruna jayaram 
>> 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.com<http://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.com<http://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 pos

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  
> 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 جمال دغيدى 
>  
> *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/*
>  
>  
>
>  
>
> -- 
> 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 
Date: Tue, Mar 6, 2012 at 3:59 PM
Subject: spam Re: $$Excel-Macros$$
To: Ayush Jain 


please take action.

On Tue, Mar 6, 2012 at 8:51 PM, Jai  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
<>

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

> Congratulates Rajan. Wellcome back SAM.
>
>
> On Wed, Jan 4, 2012 at 7:37 PM, Rajan_Verma wrote:
>
>>  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  wrote:
>>
>> *Congrats Rajan!*
>>
>>
>>
>> On Wed, Jan 4, 2012 at 10:37 AM, Asa Rossoff  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.

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

[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  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$$ 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  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 
> >
> > Sender:excel-macros@googlegroups.com
> > Date: Thu, 24 Nov 2011 14:16:44To: 
> 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

$$Excel-Macros$$ VBA Job @ Ernst and Young , Gurgaon

[Ayush Jain]

Dear members,

E&Y(Gurgaon) looking out for VBA professionals with 1-2 years of experience.

Refer your friends and send me resume @ jainayus...@gmail.com.

Please do not post any resume in forum and send it to me only.

Thanks.

-- 
Best regards,
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

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

> 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 wrote:
>
>>   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 
>> *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 
>> *Sent:* Thursday, October 27, 2011 5:24 AM
>> *To:* excel-macros@googlegroups.com
>> *Subjec

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

> Here's a link too
>
> http://excelhints.com/2008/10/21/protect-cell-formats/
>
> Regards,
>
> Sam
>
> On Oct 21, 3:06 pm, GoldenLance  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  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$$ 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$$ 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 wrote:

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

$$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 
link<http://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  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
<>

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

> 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 wrote:
>
>> check the attachement
>>
>>
>> On Sat, Sep 17, 2011 at 5:33 PM, Ayush Jain wrote:
>>
>>> 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$$ 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

$$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 wrote:
>
>> 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$$ 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$$ 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 

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

Re: $$Excel-Macros$$ Poem - जोर से बोलो दम लगा के जय, Excel -Macro परिवार.

[Ayush Jain]

Thanks Noorain !

Excellent poem everytime :)

2011/7/30 Jattin Agarwal 

> kamal hai , asey hi poem likhtey raho , aur hamey kush karte raho
>
> 2011/7/30 NOORAIN ANSARI :
>  > 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$$ 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  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  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 
>> link<http://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
>

$$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
link<http://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

$$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$$ 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$$ 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$$ Ashish Koul : Most Helpful Member - May'11

[Ayush Jain]

 Hello Everyone,

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

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

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

Regards
Ayush Jain
Group Manager

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

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

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

$$Excel-Macros$$ Re: Countif Problem

[Ayush Jain]

Hi prasad,

Good day to you!

Attached is the solution. Please have a look and let me know if any
further assistance is required.

Regards
Ayush Jain
Group Manager

On Sun, Apr 3, 2011 at 1:39 PM, Suryaprasad wrote:

> Hi Team / Ayush,
>
> Need a formula about a countif criteria
>
> See the attachment and please do the need full
>
> Regards
> prasad
>



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


Example.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Ashish Koul : Most Helpful Member - March 2011

[Ayush Jain]

Hello Everyone,

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

ASHISH, Many Many thanks for the incredible support to group.

This is a record achievement by anyone since we launched the recognition.
Let see who will break Ashish's record. :)

*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$$ discussexcel.com Launched today

[Ayush Jain]

Dear Excel Group Members,

I am very glad to share that* discussexcel.com <http://www.discussexcel.com>
*website is launched today. The website development was initiated three
months back and here is what I achieved. As promised with you, The site is
launched on on the *4th Anniversary* of the group.

[image: discussexcel_Logo.jpg] <http://www.discussexcel.com>

The website is launched with some cool sections like "*Excel Interview Q&A*"
and "*Excel Blog of the month*". I am also planning to add a new
section *"Excel
Expert Interview"* soon. I hope you like them.

I have selected the simplest tagline "*Excel Simplified*" as suggested by
Balbir Kumar.

The website content development is still in progress, & I will keep sharing
Excel tips and tricks through this portal over the time. Feel free to submit
any content you want to be appear on website. *I really want to see this
website as largest Excel Knowledge base.*
*
Finally , Thanks to all excel enthusiasts for keeping me motivated all the
time.
This is my personal achievement and I duly appreciate your support for the
same.*

Please go through this portal and provide your valuable
feedback/suggestions/comments/inputs on the form located at 'Contact
us<http://www.discussexcel.com/contact-me>'
Page.

Best regards,
Ayush Jain
Excel Group Owner & Manager
Microsoft Excel 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
<>

$$Excel-Macros$$ Re: कविता : महिमा SUMPRODUCT की

[Ayush Jain]

Noorain, You are always awesome and this poem is phenomenal.

Regards
Ayush Jain

2011/3/11 NOORAIN ANSARI 

> Dear Experts,
>
> I have tried to describe importance of sumproduct function in my poem
> with example.
> Please read and see attached worksheet.
>
> SUMPRODUCT है एक..लेकिन इसके  रूप है अनेक.
> अगर बिश्वास नहीं है भाई तो जरा एक नज़र तो देख.
>  नहीं चाहिए हमको बहूत सारे Functions  का सहारा.
>  उनके जगह पे काफी है बस एक sumproduct  हमारा.
>चाहे DATA  हो आसान,चाहे हो critical.
>चाहे हो Horizental ,चाहे हो Vertical.
>चाहे EXCEL हो 2003,  चाहे हो 2007.
>इसके लिए issue नहीं  है कोई भी हालात.
>कौन नहीं रखेगा excel के ऐसे  धांसू
> function को याद.
>  जो बिना CTRL+SHIFT+Enter का ही देता है
> Array Function का स्वाद.
>हर जगह इसका Performance  हैं शानदार.
>Best Function के अवार्ड का ये है हकदार.
>महिमा sumproduct का भईया अपरम्पार है.
>तभी तो हर किसी के दिल में इसके लिए प्यार है.
>
>   Name ID Marks Check Duplicate Entry Helping Col  A 111 123
> =SUMPRODUCT(--($A$2:A5=A5)) 1  B 222 232  =SUMPRODUCT(--($A$2:A6=A6)) 1  A
> 111 453  =SUMPRODUCT(--($A$2:A7=A7)) 2  D 444 231
> =SUMPRODUCT(--($A$2:A8=A8)) 1  A 999 124  =SUMPRODUCT(--($A$2:A9=A9)) 3  B
> 555 234  =SUMPRODUCT(--($A$2:A10=A10)) 2  C 333 321
> =SUMPRODUCT(--($A$2:A11=A11)) 1  B 222 256  =SUMPRODUCT(--($A$2:A12=A12))
> 3  D 444 231  =SUMPRODUCT(--($A$2:A13=A13)) 2 Formula Criteria Syntex
> Example Output  Countif A  =SUMPRODUCT(--(A2:A10=B13)) 3  Countifs A,111
> =SUMPRODUCT((A2:A10=B14)*(B2:B10=111)) 2  Sum=SUMPRODUCT(C2:C10) 2205 
> Sumif
> A  =SUMPRODUCT((A2:A10=B16)*(C2:C10)) 700  Sumifs A,111
> =SUMPRODUCT((A2:A10="A")*(B2:B10=111)*(C2:C10)) 576  Averageif A
> =SUMPRODUCT((A2:A10="A")*(C2:C10))/SUMPRODUCT(--(A2:A10="A")) 233.333 
> Averageifs
> A,111
> =SUMPRODUCT((A2:A10="A")*(B2:B10=111)*(C2:C10))/SUMPRODUCT((A2:A10="A")*(B2:B10=111))
> 288  Conditional MAX Max of A  =SUMPRODUCT(MAX((A2:A10="A")*(C2:C10))) 453 
> Max Value A & B
> A,B  =SUMPRODUCT(MAX(($A$2:$A$10={"A","B"})*($C$2:$C$10))) 453 Conditional 
> Large 2nd
> Max of A  =SUMPRODUCT(LARGE((A2:A10="A")*(C2:C10),2)) 124  Sum of A & B A,
> B  =SUMPRODUCT((A2:A10={"A","B"})*(C2:C10)) 1422  Count of A&B A,B
> =SUMPRODUCT(--(A2:A10={"A","B"})) 6  All Marks of A A
> =SUMPRODUCT(($A$2:$A$10="A")*($D$2:$D$10=ROW(A1))*($C$2:$C$10)) 123
> =SUMPRODUCT(($A$2:$A$10="A")*($D$2:$D$10=ROW(A2))*($C$2:$C$10)) 453
> =SUMPRODUCT(($A$2:$A$10="A")*($D$2:$D$10=ROW(A3))*($C$2:$C$10)) 124  Total
> Unique Data=SUMPRODUCT(1/COUNTIF(A2:A10,A2:A10)) Press
> ctrl+shift+enter 4
>
> If i missed any thing please add...
> --
> Thanks & regards,
> Noorain Ansari
>
>


-- 
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$$ 22 days left - Launch of discussexcel.com

[Ayush Jain]

Thank you group for all awesome ideas. Though, I was looking for Tagline
only, you have provided the awesome website names too.
This proves that our group is not only blessed with Excel Experts but also
with Creative Artists. I feel proud of it.

The website name is going to be discussexcel.com only.

I have finalized two ideas
1) Excel Simplified or XL-S - By Balbirkumar/Aindrail De
2) Excelerated Learning - By Dave Bonallack

You need to help me in choosing the best of them.

Regards
Ayush Jain
Group Manager

On Tue, Mar 1, 2011 at 12:56 PM, Ashish Pahuja wrote:

> ExcelINsideUs
>
>
> regards,
>
>
> On Tue, Mar 1, 2011 at 12:48 PM, NOORAIN ANSARI 
> wrote:
>
>> Hey Ayush..
>>
>> As per my Idea :
>>
>> 1. Exlsolution.com
>> 2. EXL-WORLD.com
>> 3. EXL-Garden.com
>> 4. EXL-Station.Com
>>
>> Thanks & regards,
>> Noorain Ansari
>> On Tue, Feb 22, 2011 at 11:29 PM, Ayush Jain wrote:
>>
>>> Dear members,
>>>
>>> I am too excited to share that discussexcel.com website development is
>>> in good progress and we are ready to launch the website on 4th Anniversary
>>> of our Google group. i.e. 16th -17th March.
>>>
>>> In the meantime, Can you advise a good tagline, punchline for website.
>>>
>>> My thoughts are :
>>> 1) building excel-lence
>>> 2) Excellence in Excel
>>> 3) Let's discuss and learn excel
>>>
>>> what do you think, Let me know
>>>
>>> Keep watching this space for more
>>>
>>> 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
>>>
>>
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>>
>>  --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> 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$$ 22 days left - Launch of discussexcel.com

[Ayush Jain]

Thanks Dave & Aindril for awesome ideas

i will share the final one soon :)

Regards

On Mon, Feb 28, 2011 at 4:09 PM, Aindril De  wrote:

> Hi Ayush,
>
> How about   XLS
> (Excel Simplified in Short)
>
> Andy
>
>
> On Mon, Feb 28, 2011 at 12:42 PM, Dave Bonallack <
> davebonall...@hotmail.com> wrote:
>
>>  Hi Ayush,
>> Perhaps you could play with the word 'Accelerate'
>> Some suggestions would be:
>>
>> Excelerated Learning
>> Excelerated Solutions
>> Excelerating.com
>> Exlceleration.com
>> Excelerate.com
>>
>> Regards - Dave.
>>
>>
>> --
>> From: jainayus...@gmail.com
>> Date: Mon, 28 Feb 2011 11:07:31 +0530
>>
>> Subject: Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com
>> To: excel-macros@googlegroups.com
>>
>> Thanks Akash, This is pity cool and short...
>> I liked it.
>>
>> On Mon, Feb 28, 2011 at 10:42 AM, Akash $urkatha wrote:
>>
>>   Hey Ayush,
>>
>> What About 'SIMPLEXCEL'???
>>
>> Regards,
>>
>> Aakash.
>>
>> --- On *Mon, 2/28/11, Ayush Jain * wrote:
>>
>>
>> From: Ayush Jain 
>> Subject: Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com
>> To: excel-macros@googlegroups.com
>> Cc: "Dilip Pandey" 
>> Date: Monday, February 28, 2011, 10:12 AM
>>
>>   Thank You Dilip...Awesome Tag Lines.
>>
>> I have shortlisted two taglines from all :
>> 1) Excel Simplified
>> 2) Helping the world to Excel in their professional life
>>
>> Group, Its not finalized, so you can submit more.
>>
>> Regards
>> Ayush Jain
>>
>>
>> On Sun, Feb 27, 2011 at 11:13 PM, Dilip Pandey 
>> http://mc/compose?to=dilipan...@gmail.com>
>> > wrote:
>>
>> Hi Ayush,
>>
>> Few Taglines from my side:-
>>
>> Helping the world to Excel in their professional life
>>
>> Excelling in Excel
>>
>> Excel becomes Easy here..!!
>>
>> Best Regards,
>> DILIPandey
>>
>> On 2/22/11, Ayush Jain 
>> http://mc/compose?to=jainayus...@gmail.com>>
>> wrote:
>> > Dear members,
>> >
>> > I am too excited to share that discussexcel.com website development is
>> in
>> > good progress and we are ready to launch the website on 4th Anniversary
>> of
>> > our Google group. i.e. 16th -17th March.
>> >
>> > In the meantime, Can you advise a good tagline, punchline for website.
>> >
>> > My thoughts are :
>> > 1) building excel-lence
>> > 2) Excellence in Excel
>> > 3) Let's discuss and learn excel
>> >
>> > what do you think, Let me know
>> >
>> > Keep watching this space for more
>> >
>> > 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<http://mc/compose?to=excel-macros@googlegroups.com>
>> >
>> > <><><><><><><><><><><><><><><><><><><><><><>
>> > Like our page on facebook , Just follow below link
>> > http://www.facebook.com/discussexcel
>> >
>>
>>
>> --
>> Thanks & Regards,
>>
>> DILIP KUMAR PANDEY, mvp
>>   MBA,B.Com(Hons),BCA
>> Mobile: +91 9810929744
>> dilipan...@gmail.com <http://mc/compose?to=dilipan...@gmail.com>
>> dilipan...@yahoo.com <http://mc/compose?to=dilipan...@yahoo.com>
>> New Delhi - 62, India
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.link

Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com

[Ayush Jain]

Thanks Akash, This is pity cool and short...
I liked it.

On Mon, Feb 28, 2011 at 10:42 AM, Akash $urkatha wrote:

> Hey Ayush,
>
> What About 'SIMPLEXCEL'???
>
> Regards,
>
> Aakash.
>
> --- On *Mon, 2/28/11, Ayush Jain * wrote:
>
>
> From: Ayush Jain 
> Subject: Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com
> To: excel-macros@googlegroups.com
> Cc: "Dilip Pandey" 
> Date: Monday, February 28, 2011, 10:12 AM
>
> Thank You Dilip...Awesome Tag Lines.
>
> I have shortlisted two taglines from all :
> 1) Excel Simplified
> 2) Helping the world to Excel in their professional life
>
> Group, Its not finalized, so you can submit more.
>
> Regards
> Ayush Jain
>
>
> On Sun, Feb 27, 2011 at 11:13 PM, Dilip Pandey 
> http://mc/compose?to=dilipan...@gmail.com>
> > wrote:
>
> Hi Ayush,
>
> Few Taglines from my side:-
>
> Helping the world to Excel in their professional life
>
> Excelling in Excel
>
> Excel becomes Easy here..!!
>
> Best Regards,
> DILIPandey
>
> On 2/22/11, Ayush Jain 
> http://mc/compose?to=jainayus...@gmail.com>>
> wrote:
> > Dear members,
> >
> > I am too excited to share that discussexcel.com website development is
> in
> > good progress and we are ready to launch the website on 4th Anniversary
> of
> > our Google group. i.e. 16th -17th March.
> >
> > In the meantime, Can you advise a good tagline, punchline for website.
> >
> > My thoughts are :
> > 1) building excel-lence
> > 2) Excellence in Excel
> > 3) Let's discuss and learn excel
> >
> > what do you think, Let me know
> >
> > Keep watching this space for more
> >
> > 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<http://mc/compose?to=excel-macros@googlegroups.com>
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> > http://www.facebook.com/discussexcel
> >
>
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY, mvp
>   MBA,B.Com(Hons),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com <http://mc/compose?to=dilipan...@gmail.com>
> dilipan...@yahoo.com <http://mc/compose?to=dilipan...@yahoo.com>
> New Delhi - 62, India
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to 
> excel-macros@googlegroups.com<http://mc/compose?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
>
>
>


-- 
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$$ 22 days left - Launch of discussexcel.com

[Ayush Jain]

Thank You Dilip...Awesome Tag Lines.

I have shortlisted two taglines from all :
1) Excel Simplified
2) Helping the world to Excel in their professional life

Group, Its not finalized, so you can submit more.

Regards
Ayush Jain


On Sun, Feb 27, 2011 at 11:13 PM, Dilip Pandey  wrote:

> Hi Ayush,
>
> Few Taglines from my side:-
>
> Helping the world to Excel in their professional life
>
> Excelling in Excel
>
> Excel becomes Easy here..!!
>
> Best Regards,
> DILIPandey
>
> On 2/22/11, Ayush Jain  wrote:
> > Dear members,
> >
> > I am too excited to share that discussexcel.com website development is
> in
> > good progress and we are ready to launch the website on 4th Anniversary
> of
> > our Google group. i.e. 16th -17th March.
> >
> > In the meantime, Can you advise a good tagline, punchline for website.
> >
> > My thoughts are :
> > 1) building excel-lence
> > 2) Excellence in Excel
> > 3) Let's discuss and learn excel
> >
> > what do you think, Let me know
> >
> > Keep watching this space for more
> >
> > 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
> >
>
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY, mvp
>   MBA,B.Com(Hons),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 62, India
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
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$$ 22 days left - Launch of discussexcel.com

[Ayush Jain]

Dear members,

I am too excited to share that discussexcel.com website development is in
good progress and we are ready to launch the website on 4th Anniversary of
our Google group. i.e. 16th -17th March.

In the meantime, Can you advise a good tagline, punchline for website.

My thoughts are :
1) building excel-lence
2) Excellence in Excel
3) Let's discuss and learn excel

what do you think, Let me know

Keep watching this space for more

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$$ Re: Requesting help to generate progress reports in Excel ...

[Ayush Jain]

Greg, You are most welcome

cheers

On Fri, Jan 21, 2011 at 9:05 PM, Greg Mouning  wrote:

> Hi Ayush,
>
> That's perfect! Exactly what I want.
>
> Thanks,
> Greg
>
> On Thu, Jan 20, 2011 at 9:55 PM, Ayush Jain  wrote:
>
>> Hi Greg,
>>
>> See attached updated one.
>> I hope it helps.
>>
>>
>> Thanks.
>>
>> Best Regards,
>> Ayush Jain
>>
>> On Thu, Jan 20, 2011 at 11:07 PM, Greg Mouning wrote:
>>
>>> Hi Ayush,
>>>
>>> Awesome job! The pie chart displays the contents I requested.
>>>
>>> However, I question the win/loss percentage. It should total 100% and
>>> currently it totals 155%... I believe the total loss percentage = 55% is
>>> accurate as we had a losing session. That would mean the total win
>>> percentage should calculate to 45%. This would means the win percentage for
>>> each player should be smaller as well.
>>>
>>> Can you verify this?
>>>
>>> Regards,
>>> Greg
>>>
>>> On Thu, Jan 20, 2011 at 12:03 PM, Ayush Jain wrote:
>>>
>>>> Hi Greg,
>>>>
>>>> I have modified the Pie chart as required by you.
>>>> Please see attached file and let me know for any further assistance
>>>> required.
>>>>
>>>> Best Regards,
>>>> Ayush Jain
>>>> Group Manager and Microsoft MVP
>>>>
>>>>
>>>>
>>>>>>> On Wed, Jan 12, 2011 at 12:02 PM, ayush jain 
>>>>>>> wrote:
>>>>>>>
>>>>>>>> Hi Greg,
>>>>>>>> Due to some office work, i have not responded you on this...I hope
>>>>>>>> to get back to you by this weekend on this...
>>>>>>>>
>>>>>>>>
>>>>>>>> BR,
>>>>>>>> Ayush Jain
>>>>>>>>
>>>>>>>>
>>>>>>>> On Wed, Jan 12, 2011 at 7:09 AM, Greg Mouning 
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> Dear Ayush,
>>>>>>>>>
>>>>>>>>> Thank you the graphs you generated look awesome! I love the bar
>>>>>>>>> chart particularly as it demonstrates our team progress over 16 weeks.
>>>>>>>>>
>>>>>>>>> As for the pie chart, I am not sure that it represents what I am
>>>>>>>>> looking to report. I guess first, I want a pie chart that shows 9 
>>>>>>>>> slices.
>>>>>>>>> Because there are 16 weeks of data and I can only play 5 out of 8 
>>>>>>>>> players
>>>>>>>>> each week; the total number of weeks (16) multiplied by (5) matches 
>>>>>>>>> equal 80
>>>>>>>>> total matches. I think it needs to use all 80 games and create a 
>>>>>>>>> percentage
>>>>>>>>> of each persons wins which demonstrates their individual 
>>>>>>>>> contribution. This
>>>>>>>>> percentage, should should make up 8 slices of the pie, one for each 
>>>>>>>>> player.
>>>>>>>>> Finally, there needs to be (1) remaining slice to represent the 
>>>>>>>>> remainder of
>>>>>>>>> the pie which is the total matches loss.
>>>>>>>>>
>>>>>>>>> If there is a way to add the win/loss records of individual
>>>>>>>>> players, that would be perfect. For example, in my case I played 11 
>>>>>>>>> matches,
>>>>>>>>> so it needs to display the following data inside of my slice of the 
>>>>>>>>> pie:
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> G Mouning
>>>>>>>>> 8%
>>>>>>>>> (3-8)
>>>>>>>>>
>>>>>>>>> I don't know if this explanation is any more helpful but I thought
>>>>>>>>> I should try to explain what I want differently. Thanks again for your
>>>>>>>>> additional assistance.
>>>>>>>>>
>>>>>>>>> Best regards,
>>>>>>>>> 

Re: $$Excel-Macros$$ Your feedback is important ! Just need your 5 minutes.

[Ayush Jain]

Dear group,

Thanks to those few guys who submitted their feedback.

I am expecting more feedback from you. Please feel free to submit the
anonymous survey.
I will share the results soon.

Click here to submit the survey http://www.surveymonkey.com/s/
L8BTDNQ <http://www.surveymonkey.com/s/L8BTDNQ>

Best Regards,
Ayush Jain

On Mon, Jan 17, 2011 at 8:15 PM, Ayush  wrote:

> Dear members,
>
> Thanks for all your contribution to group. The group recently achieved a
> milestone of 7500 members. I am very happy to see that this group is always
> buzzing with activities.
>
> 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& 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
>



-- 
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$$ Empty Mail

[ayush jain]

Hi Hanumant,

I have also faced this while approving messages.
I think its a bug of Google groups and not any issue at your end.

I hope it helps.

Best Regards,
Ayush Jain
Group Manager.

On Mon, Jan 17, 2011 at 1:28 AM, hanumant shinde
wrote:

> Hi Friends,
>
> some time few mails which are sent to our group doesnt have any content. On
> my machine i dont see any content or body.this happens with even my mails
> which i send to our group.
> I just want to know this is my machine problem or my registration problem
> or you too guys face this.
>
> @Ayush
> Could you please look into this.
>
>
>  --
>
> --
> 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