Re: $$Excel-Macros$$ Seems Like comments but Not

[Deba Ranjan]

Thanks all.


Thanks & Regards,
*Deba Ranjan P*





On Mon, Jun 18, 2012 at 11:27 PM, NOORAIN ANSARI
wrote:

> Dear Deba Ranjan,
>
> See attachment, we can create it from here.
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Fri, Jun 15, 2012 at 3:59 PM, Deba Ranjan  wrote:
>
>> Dear Experts,
>>
>>  I show in the attached file, If we click in B2 cell to B5 cell, then
>> some comments appears, actually I have notice that it is not a comments,
>> Can you Please suggest what actually is ?
>>
>>
>> Thanks & Regards,
>> *Deba Ranjan P*
>>
>>
>> 
>>
>> --
>> -- FORUM RULES (986+ members already BANNED for violation) 1) Use
>> concise, accurate thread titles. Poor thread titles, like Please Help,
>> Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not
>> get quick attention or may not be answered. 2) Don't post a question in the
>> thread of another member. 3) Don't post questions regarding breaking or
>> bypassing any security measure. 4) Acknowledge the responses you receive,
>> good or bad. 5) Cross-promotion of, or links to, forums competitive to this
>> forum in signatures are prohibited. NOTE : Don't ever post personal or
>> confidential data in a workbook. Forum owners and members are not
>> responsible for any loss.
>> --
>> To post to this group, send email to excel-macros@googlegroups.com To
>> unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
>
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Adding Auto Rows

[Deba Ranjan]

Thanks Rajan ji,  Is working fine.

  Dear Don ji, exactly the same you expect, i mean it should copy and past
in the below row and correspondingly the same for other which is unique.

   Thanks all.


Thanks & Regards,
*Deba Ranjan P*





On Mon, Jun 18, 2012 at 9:02 PM, dguillett1  wrote:

>   As is often the case you do not fully explain. Do you want a BLANK row
> below or copy (and insert) the value and what to do with
>
>Mah 5-10 L Aurangabad Mah 1-5 L Kolhapur
>
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Deba Ranjan 
> *Sent:* Monday, June 18, 2012 9:05 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Adding Auto Rows
>
>
> Dear Experts,
>
>
>
>
> Please find the attached file. There is 39 Unique  name in MARKET NAME, in
> every  market name is double (compulsary double), if the market name is
> single then  we need to add one row for making double .
>
> Eg.  if kolkata is single, so we need to add 1 row below the kolkata, is
> there any macros or Formula to add row.
>
>
>
>
> Thanks & Regards,
> *Deba Ranjan P*
>
>
> 
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

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

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

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

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

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

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

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

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

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

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

[in . vaibhav]

Definitely agreed.
 
-Original Message-
From: Ayush Jain 
Sender: excel-macros@googlegroups.com
Date: Mon, 18 Jun 2012 23:41:44 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: MIS executive

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

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

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

[Sam Mathai Chacko]

I would appreciate if you could take the discussion about job postings off
of the forum. Ayush has stated his decision regarding job postings as of
now. As he mentioned, once this is allowed, people start abusing the
option. That is why it has been banned.

For job seekers, there are numerous job sites out there for Excel or
related jobs. The volunteers here don't come here to see job ads, but to
help others with solutions from their expertise and experience.

As a member, I would only request everybody to keep the faith until Ayush
figures out how this can be addressed. So PLEASE STOP PESTERING.

Sam Mathai Chacko

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

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

[in . vaibhav]

Hi Ayush,

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


-Original Message-
From: Ayush Jain 
Sender: excel-macros@googlegroups.com
Date: Mon, 18 Jun 2012 23:02:07 
To: 
Reply-To: 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
 Yogananda Muthaiah
 Ph : 973 123 7267


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

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

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

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

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

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

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


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

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

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

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.


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

$$Excel-Macros$$ share Dashboard Examples/Templates

[pankaj gmail account]

Dear All,

Please share Dashboard Examples/Templates

I already viewed Chandoo's Site so no reference to that site.

-- 
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$$ Progress Bas for macro status - Help Required

[Rajan_Verma]

I think you should try yourself, we can just give you the way that how you
can accomplish the task , if you feel any confusion in implement the
progress bar code in your module .. let us know 

I will be happy to help you J

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Avinash
Sent: 18 June 2012 10:42
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Progress Bas for macro status - Help Required

 

Thanks Rajan,

 

It works perfect. 

 

but can you do 1 thing for me i have one excel it contains progress bar
macro which also i want to use in my macro i have attached the file please
go through this and please implement same progress bar which my macro file.

 

Regards,

Avinash

On Monday, June 18, 2012 10:19:07 PM UTC+5:30, Rajan_Verma wrote:

See the attached

I have implemented Progress bar in your file.

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Avinash
Sent: 18 June 2012 9:43
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Progress Bas for macro status - Help Required

 

Hi Rajan,

 

Please find attached excel file but before u start working run "Dept_Data"
macro which will create 10 sub sheet which needs to format.

 

Regards,

Avinash

On Monday, June 18, 2012 8:52:28 PM UTC+5:30, Rajan_Verma wrote:

You just need to increase command bar width on every step , 

Send  us your file with code to get desired result

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Avinash
Sent: 18 June 2012 8:50
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Progress Bas for macro status - Help Required

 

Hi Rajan,

 

Thanks for your help but can u please tell me how can i use this progress
bar in to my existing code i mean it is loading directly towards the end but
i want it should run like when my first step gets completed it should say 10
% complete and till 10 step it should say 100% completed.

 

it should not complete before any step finished it should load as per the
step are getting completed.

 

 

Regards,

 

Avinash 

On Monday, June 18, 2012 6:29:01 PM UTC+5:30, Rajan_Verma wrote:

See the attached file

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Avinash
Sent: 18 June 2012 2:35
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Progress Bas for macro status - Help Required

 

Thanks  Manoj for you help.

 

But i want progress bar macro formatting macro i already have i have
mentioned sample macro code not my actual code.

 

Regards,

Avinash 

On Monday, June 18, 2012 11:05:34 AM UTC+5:30, Manoj Kumar wrote:

Dear Avinash.

 

 

Sub gg()

 

For a = 1 To Sheets.Count

Sheets(a).Activate

Range("a1:dd5").Select

 

Selection.Font.Bold = True

 

 

Next

 

End Sub

 

Regard

Manoj

 

On Sun, Jun 17, 2012 at 11:39 PM, Avinash  wrote:

Dear Experts,

 

I have 1 workbook and there are 10 subsheets in that workbook.

i have created 1 macro to format those 10 subsheets.

 

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

and and sheet 2 bold italic text for row 2.

 

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

 

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

 

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

 

My macro style

 

Sub Formatting ()

 

Step1

format sheet 1

 

Step2

format sheet 2

 

Step3

format sheet 3

 

Step4

format sheet 4

 

Step5

format sheet 5

 

Step6

format sheet 6

 

Step7

format sheet 7

 

Step7

format sheet 7

 

Step8

format sheet 8

 

Step9

format sheet 9

 

Step10

format sheet 10

 

 

End Sub

 

 

 

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

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

[yogananda muthaiah]

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

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

[pankaj gmail account]

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

[Avinash]

Thanks Don  ,

But i am not able to understand this that is the reason i am asking for 
help.

Regards,
Avinash

On Monday, June 18, 2012 8:57:26 PM UTC+5:30, Don Guillett wrote:
>
>   http://oreilly.com/pub/h/2607  
>  
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>   
>  *From:* Avinash  
> *Sent:* Monday, June 18, 2012 10:20 AM
> *To:* excel-macros@googlegroups.com 
> *Subject:* Re: $$Excel-Macros$$ Progress Bas for macro status - Help 
> Required
>  
> Hi Rajan, 
>  
> Thanks for your help but can u please tell me how can i use this progress 
> bar in to my existing code i mean it is loading directly towards the end 
> but i want it should run like when my* first step gets completed* it 
> should say *10 % complete* and till *10 step* it should say *100% 
> completed*. 
>  
> *it should not complete before any step finished* it should load as per 
> the step are getting completed.
>  
>  
> Regards,
>  
> Avinash 
>
> On Monday, June 18, 2012 6:29:01 PM UTC+5:30, Rajan_Verma wrote: 
>>
>>  See the attached file
>>
>>  
>>
>> ** 
>>
>> *Regards*
>>
>> *Rajan verma*
>>
>> *+91 7838100659 [IM-Gtalk]*
>>
>>  
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Avinash
>> *Sent:* 18 June 2012 2:35
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ Progress Bas for macro status - Help 
>> Required
>>
>>  
>>
>> Thanks  Manoj for you help.
>>  
>>  
>>  
>> But i want progress bar macro formatting macro i already have i have 
>> mentioned sample macro code not my actual code.
>>  
>>  
>>  
>> Regards,
>>  
>> Avinash 
>>
>> On Monday, June 18, 2012 11:05:34 AM UTC+5:30, Manoj Kumar wrote:
>>  
>> Dear Avinash.
>>  
>>  
>>  
>>  
>>  
>> Sub gg()
>>  
>>  
>>  
>> For a = 1 To Sheets.Count
>>  
>> Sheets(a).Activate
>>  
>> Range("a1:dd5").Select
>>  
>>  
>>  
>> Selection.Font.Bold = True
>>  
>>  
>>  
>>  
>>  
>> Next
>>  
>>  
>>  
>> End Sub
>>  
>>  
>>  
>> Regard
>>  
>> Manoj
>>
>>  
>>  
>> On Sun, Jun 17, 2012 at 11:39 PM, Avinash  
>> wrote:
>>  
>> Dear Experts,
>>  
>>  
>>  
>> I have 1 workbook and there are 10 subsheets in that workbook.
>>  
>> i have created 1 macro to format those 10 subsheets.
>>  
>>  
>>  
>> every sheet does have different formatting e.g. sheet 1 bold text for row 
>> 1
>>  
>> and and sheet 2 bold italic text for row 2.
>>  
>>  
>>  
>> so now i want macro to show the progress bar (progress bar should be VBA 
>> USERFORM ) in % which shows me how much formatting is completed like after 
>> sheet 1 formatting progress bar should show 10% completed after sheet 2 it 
>> should show 20%
>>  
>>  
>>  
>> and after all formatting done it should say 100% with how much time taken 
>> for formatting all thease sheets.
>>  
>>  
>>  
>> Please help me in this as i want to incorporate the same type of macro in 
>> other projects.
>>  
>>  
>>  
>> My macro style
>>  
>>  
>>  
>> Sub Formatting ()
>>  
>>  
>>  
>> Step1
>>  
>> format sheet 1
>>  
>>  
>>  
>> Step2
>>  
>> format sheet 2
>>  
>>  
>>  
>> Step3
>>  
>> format sheet 3
>>  
>>  
>>  
>> Step4
>>  
>> format sheet 4
>>  
>>  
>>  
>> Step5
>>  
>> format sheet 5
>>  
>>  
>>  
>> Step6
>>  
>> format sheet 6
>>  
>>  
>>  
>> Step7
>>  
>> format sheet 7
>>  
>>  
>>  
>> Step7
>>  
>> format sheet 7
>>  
>>  
>>  
>> Step8
>>  
>> format sheet 8
>>  
>>  
>>  
>> Step9
>>  
>> format sheet 9
>>  
>>  
>>  
>> Step10
>>  
>> format sheet 10
>>  
>>  
>>  
>>  
>>  
>> End Sub
>>  
>>  
>>  
>>  
>>  
>>  
>>
>> -- 
>> FORUM RULES (986+ members already BANNED for violation)
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>>  
>> 2) Don't post a question in the thread of another member.
>>  
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>>  
>> 4) Acknowledge the responses you receive, good or bad.
>>  
>> 5) Cross-promotion of, or links to, forums competitive to this forum in 
>> signatures are prohibited. 
>>  
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum 
>> owners and members are not responsible for any loss.
>>  
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>  
>> To unsubscribe, send a blank email to 
>> excel-macros+unsubscr...@googlegroups.com
>>
>>  
>>
>> -- 
>> FORUM RULES (986+ members already BANNED for violation)
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>>  
>> 2) Don't post a question in the thread of another member.
>>  
>> 3) Don't post questions rega

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

[Avinash]

Thanks Don  ,

But i am not able to understand this that is the reason i am asking for 
help.

Regards,
Avinash

On Monday, June 18, 2012 8:57:26 PM UTC+5:30, Don Guillett wrote:
>
>   http://oreilly.com/pub/h/2607  
>  
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>   
>  *From:* Avinash  
> *Sent:* Monday, June 18, 2012 10:20 AM
> *To:* excel-macros@googlegroups.com 
> *Subject:* Re: $$Excel-Macros$$ Progress Bas for macro status - Help 
> Required
>  
> Hi Rajan, 
>  
> Thanks for your help but can u please tell me how can i use this progress 
> bar in to my existing code i mean it is loading directly towards the end 
> but i want it should run like when my* first step gets completed* it 
> should say *10 % complete* and till *10 step* it should say *100% 
> completed*. 
>  
> *it should not complete before any step finished* it should load as per 
> the step are getting completed.
>  
>  
> Regards,
>  
> Avinash 
>
> On Monday, June 18, 2012 6:29:01 PM UTC+5:30, Rajan_Verma wrote: 
>>
>>  See the attached file
>>
>>  
>>
>> ** 
>>
>> *Regards*
>>
>> *Rajan verma*
>>
>> *+91 7838100659 [IM-Gtalk]*
>>
>>  
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Avinash
>> *Sent:* 18 June 2012 2:35
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ Progress Bas for macro status - Help 
>> Required
>>
>>  
>>
>> Thanks  Manoj for you help.
>>  
>>  
>>  
>> But i want progress bar macro formatting macro i already have i have 
>> mentioned sample macro code not my actual code.
>>  
>>  
>>  
>> Regards,
>>  
>> Avinash 
>>
>> On Monday, June 18, 2012 11:05:34 AM UTC+5:30, Manoj Kumar wrote:
>>  
>> Dear Avinash.
>>  
>>  
>>  
>>  
>>  
>> Sub gg()
>>  
>>  
>>  
>> For a = 1 To Sheets.Count
>>  
>> Sheets(a).Activate
>>  
>> Range("a1:dd5").Select
>>  
>>  
>>  
>> Selection.Font.Bold = True
>>  
>>  
>>  
>>  
>>  
>> Next
>>  
>>  
>>  
>> End Sub
>>  
>>  
>>  
>> Regard
>>  
>> Manoj
>>
>>  
>>  
>> On Sun, Jun 17, 2012 at 11:39 PM, Avinash  
>> wrote:
>>  
>> Dear Experts,
>>  
>>  
>>  
>> I have 1 workbook and there are 10 subsheets in that workbook.
>>  
>> i have created 1 macro to format those 10 subsheets.
>>  
>>  
>>  
>> every sheet does have different formatting e.g. sheet 1 bold text for row 
>> 1
>>  
>> and and sheet 2 bold italic text for row 2.
>>  
>>  
>>  
>> so now i want macro to show the progress bar (progress bar should be VBA 
>> USERFORM ) in % which shows me how much formatting is completed like after 
>> sheet 1 formatting progress bar should show 10% completed after sheet 2 it 
>> should show 20%
>>  
>>  
>>  
>> and after all formatting done it should say 100% with how much time taken 
>> for formatting all thease sheets.
>>  
>>  
>>  
>> Please help me in this as i want to incorporate the same type of macro in 
>> other projects.
>>  
>>  
>>  
>> My macro style
>>  
>>  
>>  
>> Sub Formatting ()
>>  
>>  
>>  
>> Step1
>>  
>> format sheet 1
>>  
>>  
>>  
>> Step2
>>  
>> format sheet 2
>>  
>>  
>>  
>> Step3
>>  
>> format sheet 3
>>  
>>  
>>  
>> Step4
>>  
>> format sheet 4
>>  
>>  
>>  
>> Step5
>>  
>> format sheet 5
>>  
>>  
>>  
>> Step6
>>  
>> format sheet 6
>>  
>>  
>>  
>> Step7
>>  
>> format sheet 7
>>  
>>  
>>  
>> Step7
>>  
>> format sheet 7
>>  
>>  
>>  
>> Step8
>>  
>> format sheet 8
>>  
>>  
>>  
>> Step9
>>  
>> format sheet 9
>>  
>>  
>>  
>> Step10
>>  
>> format sheet 10
>>  
>>  
>>  
>>  
>>  
>> End Sub
>>  
>>  
>>  
>>  
>>  
>>  
>>
>> -- 
>> FORUM RULES (986+ members already BANNED for violation)
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>>  
>> 2) Don't post a question in the thread of another member.
>>  
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>>  
>> 4) Acknowledge the responses you receive, good or bad.
>>  
>> 5) Cross-promotion of, or links to, forums competitive to this forum in 
>> signatures are prohibited. 
>>  
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum 
>> owners and members are not responsible for any loss.
>>  
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>  
>> To unsubscribe, send a blank email to 
>> excel-macros+unsubscr...@googlegroups.com
>>
>>  
>>
>> -- 
>> FORUM RULES (986+ members already BANNED for violation)
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>>  
>> 2) Don't post a question in the thread of another member.
>>  
>> 3) Don't post questions rega

Re: $$Excel-Macros$$ Adding Auto Rows

[dguillett1]

As is often the case you do not fully explain. Do you want a BLANK row below or 
copy (and insert) the value and what to do with

  Mah 5-10 L Aurangabad 
  Mah 1-5 L Kolhapur 



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

From: Deba Ranjan 
Sent: Monday, June 18, 2012 9:05 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Adding Auto Rows

Dear Experts,






Please find the attached file. There is 39 Unique  name in MARKET NAME, in  
every  market name is double (compulsary double), if the market name is single 
then  we need to add one row for making double .

Eg.  if kolkata is single, so we need to add 1 row below the kolkata, is there 
any macros or Formula to add row.




  

Thanks & Regards,
Deba Ranjan P





-- 
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$$ Progress Bas for macro status - Help Required

[dguillett1]

http://oreilly.com/pub/h/2607 

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

From: Avinash 
Sent: Monday, June 18, 2012 10:20 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Progress Bas for macro status - Help Required

Hi Rajan, 

Thanks for your help but can u please tell me how can i use this progress bar 
in to my existing code i mean it is loading directly towards the end but i want 
it should run like when my first step gets completed it should say 10 % 
complete and till 10 step it should say 100% completed. 

it should not complete before any step finished it should load as per the step 
are getting completed.


Regards,

Avinash 

On Monday, June 18, 2012 6:29:01 PM UTC+5:30, Rajan_Verma wrote: 
  See the attached file





  Regards

  Rajan verma

  +91 7838100659 [IM-Gtalk]



  From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Avinash
  Sent: 18 June 2012 2:35
  To: excel-macros@googlegroups.com
  Subject: Re: $$Excel-Macros$$ Progress Bas for macro status - Help Required



  Thanks  Manoj for you help.



  But i want progress bar macro formatting macro i already have i have 
mentioned sample macro code not my actual code.



  Regards,

  Avinash 

  On Monday, June 18, 2012 11:05:34 AM UTC+5:30, Manoj Kumar wrote:

  Dear Avinash.





  Sub gg()



  For a = 1 To Sheets.Count

  Sheets(a).Activate

  Range("a1:dd5").Select



  Selection.Font.Bold = True





  Next



  End Sub



  Regard

  Manoj



  On Sun, Jun 17, 2012 at 11:39 PM, Avinash  wrote:

  Dear Experts,



  I have 1 workbook and there are 10 subsheets in that workbook.

  i have created 1 macro to format those 10 subsheets.



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

  and and sheet 2 bold italic text for row 2.



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



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



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



  My macro style



  Sub Formatting ()



  Step1

  format sheet 1



  Step2

  format sheet 2



  Step3

  format sheet 3



  Step4

  format sheet 4



  Step5

  format sheet 5



  Step6

  format sheet 6



  Step7

  format sheet 7



  Step7

  format sheet 7



  Step8

  format sheet 8



  Step9

  format sheet 9



  Step10

  format sheet 10





  End Sub







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



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

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

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

[Rajan_Verma]

You just need to increase command bar width on every step , 

Send  us your file with code to get desired result

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Avinash
Sent: 18 June 2012 8:50
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Progress Bas for macro status - Help Required

 

Hi Rajan,

 

Thanks for your help but can u please tell me how can i use this progress
bar in to my existing code i mean it is loading directly towards the end but
i want it should run like when my first step gets completed it should say 10
% complete and till 10 step it should say 100% completed.

 

it should not complete before any step finished it should load as per the
step are getting completed.

 

 

Regards,

 

Avinash 

On Monday, June 18, 2012 6:29:01 PM UTC+5:30, Rajan_Verma wrote:

See the attached file

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Avinash
Sent: 18 June 2012 2:35
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Progress Bas for macro status - Help Required

 

Thanks  Manoj for you help.

 

But i want progress bar macro formatting macro i already have i have
mentioned sample macro code not my actual code.

 

Regards,

Avinash 

On Monday, June 18, 2012 11:05:34 AM UTC+5:30, Manoj Kumar wrote:

Dear Avinash.

 

 

Sub gg()

 

For a = 1 To Sheets.Count

Sheets(a).Activate

Range("a1:dd5").Select

 

Selection.Font.Bold = True

 

 

Next

 

End Sub

 

Regard

Manoj

 

On Sun, Jun 17, 2012 at 11:39 PM, Avinash  wrote:

Dear Experts,

 

I have 1 workbook and there are 10 subsheets in that workbook.

i have created 1 macro to format those 10 subsheets.

 

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

and and sheet 2 bold italic text for row 2.

 

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

 

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

 

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

 

My macro style

 

Sub Formatting ()

 

Step1

format sheet 1

 

Step2

format sheet 2

 

Step3

format sheet 3

 

Step4

format sheet 4

 

Step5

format sheet 5

 

Step6

format sheet 6

 

Step7

format sheet 7

 

Step7

format sheet 7

 

Step8

format sheet 8

 

Step9

format sheet 9

 

Step10

format sheet 10

 

 

End Sub

 

 

 

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

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

 

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

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

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

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

[Avinash]

Hi Rajan,

Thanks for your help but can u please tell me how can i use this progress 
bar in to my existing code i mean it is loading directly towards the end 
but i want it should run like when my* first step gets completed* it should 
say *10 % complete* and till *10 step* it should say *100% completed*.

*it should not complete before any step finished* it should load as per the 
step are getting completed.


Regards,

Avinash 

On Monday, June 18, 2012 6:29:01 PM UTC+5:30, Rajan_Verma wrote:
>
> See the attached file
>
>  
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Avinash
> *Sent:* 18 June 2012 2:35
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Progress Bas for macro status - Help 
> Required
>
>  
>
> Thanks  Manoj for you help.
>
>  
>
> But i want progress bar macro formatting macro i already have i 
> have mentioned sample macro code not my actual code.
>
>  
>
> Regards,
>
> Avinash 
>
> On Monday, June 18, 2012 11:05:34 AM UTC+5:30, Manoj Kumar wrote:
>
> Dear Avinash.
>
>  
>
>  
>
> Sub gg()
>
>  
>
> For a = 1 To Sheets.Count
>
> Sheets(a).Activate
>
> Range("a1:dd5").Select
>
>  
>
> Selection.Font.Bold = True
>
>  
>
>  
>
> Next
>
>  
>
> End Sub
>
>  
>
> Regard
>
> Manoj
>
>  
>
> On Sun, Jun 17, 2012 at 11:39 PM, Avinash  
> wrote:
>
> Dear Experts,
>
>  
>
> I have 1 workbook and there are 10 subsheets in that workbook.
>
> i have created 1 macro to format those 10 subsheets.
>
>  
>
> every sheet does have different formatting e.g. sheet 1 bold text for row 1
>
> and and sheet 2 bold italic text for row 2.
>
>  
>
> so now i want macro to show the progress bar (progress bar should be VBA 
> USERFORM ) in % which shows me how much formatting is completed like after 
> sheet 1 formatting progress bar should show 10% completed after sheet 2 it 
> should show 20%
>
>  
>
> and after all formatting done it should say 100% with how much time taken 
> for formatting all thease sheets.
>
>  
>
> Please help me in this as i want to incorporate the same type of macro in 
> other projects.
>
>  
>
> My macro style
>
>  
>
> Sub Formatting ()
>
>  
>
> Step1
>
> format sheet 1
>
>  
>
> Step2
>
> format sheet 2
>
>  
>
> Step3
>
> format sheet 3
>
>  
>
> Step4
>
> format sheet 4
>
>  
>
> Step5
>
> format sheet 5
>
>  
>
> Step6
>
> format sheet 6
>
>  
>
> Step7
>
> format sheet 7
>
>  
>
> Step7
>
> format sheet 7
>
>  
>
> Step8
>
> format sheet 8
>
>  
>
> Step9
>
> format sheet 9
>
>  
>
> Step10
>
> format sheet 10
>
>  
>
>  
>
> End Sub
>
>  
>
>  
>
>  
>
> -- 
> FORUM RULES (986+ members already BANNED for violation)
>  
> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
> will not get quick attention or may not be answered.
>  
> 2) Don't post a question in the thread of another member.
>  
> 3) Don't post questions regarding breaking or bypassing any security 
> measure.
>  
> 4) Acknowledge the responses you receive, good or bad.
>  
> 5) Cross-promotion of, or links to, forums competitive to this forum in 
> signatures are prohibited. 
>  
> NOTE : Don't ever post personal or confidential data in a workbook. Forum 
> owners and members are not responsible for any loss.
>  
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>  
> To unsubscribe, send a blank email to 
> excel-macros+unsubscr...@googlegroups.com
>
>  
>
> -- 
> FORUM RULES (986+ members already BANNED for violation)
>  
> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
> will not get quick attention or may not be answered.
>  
> 2) Don't post a question in the thread of another member.
>  
> 3) Don't post questions regarding breaking or bypassing any security 
> measure.
>  
> 4) Acknowledge the responses you receive, good or bad.
>  
> 5) Cross-promotion of, or links to, forums competitive to this forum in 
> signatures are prohibited. 
>  
> NOTE : Don't ever post personal or confidential data in a workbook. Forum 
> owners and members are not responsible for any loss.
>  
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>  
> To unsubscribe, send a blank email to 
> excel-macros+unsubscr...@googlegroups.com
>

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

RE: $$Excel-Macros$$ Adding Auto Rows

[Rajan_Verma]

Try this:

 

 

Sub AddOneMore()



Dim rngRange As Range

Dim rngCell  As Range



Set rngRange = Range("A1")



For Each rngCell In rngRange.CurrentRegion.Columns(1).Cells

If rngCell.Value = "" Then Exit For

If WorksheetFunction.CountIf(rngRange.CurrentRegion.Columns(1),
rngCell.Value) < 2 Then

rngRange.Offset(rngRange.End(xlDown).Row).Value = rngCell.Value

End If

Next rngCell

rngRange.CurrentRegion.Sort key1:=rngRange.Offset(1)

End Sub

 

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Deba Ranjan
Sent: 18 June 2012 7:35
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Adding Auto Rows

 

Dear Experts,

 

 

Please find the attached file. There is 39 Unique  name in MARKET NAME, in
every  market name is double (compulsary double), if the market name is
single then  we need to add one row for making double .

Eg.  if kolkata is single, so we need to add 1 row below the kolkata, is
there any macros or Formula to add row.




  

Thanks & Regards,
Deba Ranjan P

 

 

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

[Chandra Shekar]

Hello Rajan,

Thanks its working fine.

Regards,

Chandra Shekar B

On Mon, Jun 18, 2012 at 3:08 PM, Rajan_Verma wrote:

>  ** **
>
> ** **
>
> =INT(B2-A2) in C2
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar
> *Sent:* 18 June 2012 6:18
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Date
>
>  ** **
>
> Hello Rajan,
>
>  
>
> Thanks for your reply.For example If date in Cell C2 18/06/2012 14:44:04
> and in Cell D2 19/06/2012 14:42:04 then formula should show 0 because as
> per time one day is not completed.
>
>  
>
> I hope this is clear. 
>
>  
>
> Thanks,
>
>  
>
> Chandra Shekar B
>
> On Mon, Jun 18, 2012 at 9:31 AM, ankur  wrote:***
> *
>
> hi chandra
>
> Sorry for late reply
>
> Please find the attached file for the solution,as i suggested you earlier
>
> Regards:
> CMA Ankur Pandey 
>
>
>
>
>
>
> 
>
> On Fri, Jun 15, 2012 at 8:36 PM, Rajan_Verma 
> wrote:
>
> Hi,
>
>  
>
> I think I am not getting you .
>
> Can you please explain how you want to get day on behalf of Hours??
>
>  
>
> Because the days is also calculating in the last formula based on give
> Dates and Times.
>
>  
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar
> *Sent:* 15 June 2012 8:25
>
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Date
>
>  
>
> Hello Rajan,
>
>  
>
> Thanks for the formula. Could you please provide days as well which is in
> Column C based on Hours.
>
>  
>
> Thanks in advance.
>
>  
>
> Regards,
>
>  
>
> Chandra Shekar B
>
> On Fri, Jun 15, 2012 at 4:22 PM, Rajan_Verma 
> wrote:
>
>  
>
>  
>
> HI 
>
>  
>
> Try this 
>
>  
>
> *=DAY(B2-A2) & " Day " & HOUR(B2-A2) & " Hour " & MINUTE(B2-A2) & "
> Minute " & SECOND(B2-A2) & " Second"*
>
>  
>
>  
>
>  
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar
> *Sent:* 15 June 2012 6:06
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Date
>
>  
>
> Hello,
>
>  
>
> Any help regarding this.
>
>  
>
> Thanks in advance.
>
>  
>
> Regards,
>
>  
>
> Chandra Shekar B
>
> -- Forwarded message --
> From: *Chandra Shekar* 
> Date: Tue, Jun 12, 2012 at 3:45 PM
> Subject: $$Excel-Macros$$ Date
> To: excel-macros@googlegroups.com
>
> Hello,
>
>  
>
> Can you please help me with attached excel.
>
>  
>
> Thanks in advance.
>
>  
>
> Regards,
>
>  
>
> Chandra Shekar B
>
> --
> 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
> ex

$$Excel-Macros$$ Adding Auto Rows

[Deba Ranjan]

Dear Experts,



Please find the attached file. There is 39 Unique  name in MARKET NAME, in
every  market name is double (compulsary double), if the market name is
single then  we need to add one row for making double .

Eg.  if kolkata is single, so we need to add 1 row below the kolkata, is
there any macros or Formula to add row.




Thanks & Regards,
*Deba Ranjan P*




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

Adding Auto Rows.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Attendance tracker 2012

[Suyog]

Hi Santosh,

Nicely solved.
I checked IF condition but I've not understood how you set criteria for 
different names. Ex .Selecting  Halfday Leave will result HL in status 
column.
How to set that. Can explain please.

Regards,
Suyog

On Monday, 18 June 2012 14:07:48 UTC+5:30, santosh wrote:
>
> Hi Lokesh,
>
> The Problem with "Leave with loss of Pay"for Sachin G.A on 1st july (row # 
> 19) is solved.
>
> Regards
> Santosh Kumar Subudhi
>
>
> --
> Date: Mon, 18 Jun 2012 13:47:37 +0530
> Subject: Re: $$Excel-Macros$$ Attendance tracker 2012
> From: lokeshsmg2...@gmail.com
> To: excel-macros@googlegroups.com
>
> Santhosh for 1st june she get comp off and your formula is correct, and 
> 2nd june she had worked but half day that is also correct.
>
> The problem is "Leave with loss of pay" for "Sachin G.A" he had no leaves 
> and no production. so i need "LOP" for this perticular person.
>
> Regards
> Lokesh
>
> On Mon, Jun 18, 2012 at 1:39 PM, santosh subudhi <
> santoshkumar.subu...@gmail.com> wrote:
>
> Hi Lokesh,
>
> As per you mail and conditions I have applied and checked for the 1st 10 
> rows (from akshata to kamalkar for 1st july) and they are working fine 
> marked in blue.
>
> If the amount is zero without any comments it is "L" row 2 for Anusha
>
> Please check and let me know.
>
> Regards
> Santosh Kumar Subudhi
>
> --
> Date: Mon, 18 Jun 2012 13:21:09 +0530
>
> Subject: Re: $$Excel-Macros$$ Attendance tracker 2012
> From: lokeshsmg2...@gmail.com
> To: excel-macros@googlegroups.com
>
> Hi Santhosh,
>
> Yes you are right, but when the amt is "0" with an comment "comp Off, 
> Halfday Leave, Loss of pay, Move to other project, Unplanned leave", that 
> time i need *this condition "See if the amt is "0" with comment It should 
> be "COMP","LOP","J","UL","M",*
>
> And *See if amt is "0" without any comment it should be "L".
>
> *
> Please try once and do the needful santosh.
>
> Regards
> Lokesh.M*
> *
>
>
> On Mon, Jun 18, 2012 at 1:15 PM, santosh subudhi <
> santoshkumar.subu...@gmail.com> wrote:
>
> Hi Lokesh,
>
> As per you comments these are the below conditions that come up
>
> 1  If total amount colum is more than "0" it should be treated a "P"
> 2 If total amount colum is "0" without any comment, it should be treated 
> as "L"
> 3 If total amount colum is "0" with the comment Unplanned Leave , it 
> should be treated as "UL""
> 4 If total amount colum is "0" with the comment Comp Off, it should be 
> treated as "COM"
> 5 If total amount colum is "0" with the comment Half Day Leave, it should 
> be treated as "HL"
> 6 If total amount colum is "0" with the comment Loss of pay, it should be 
> treated as "LOP"
> 7 If total amount colum is "0" with the comment Move to other project, it 
> should be treated as "M"
> 8 If total amount colum is "0" with the comment Resignation, it should be 
> treated as "R"
> 9 If total amount colum is "0" with the comment Joining, it should be 
> treated as "J"
>
> I have also created the tracker based on the above conditions which I have 
> already sent you in my previous mail.
>
> Regards
> Santosh Kumar Subudhi
>
>
> --
> Date: Mon, 18 Jun 2012 11:51:05 +0530
>
> Subject: Re: $$Excel-Macros$$ Attendance tracker 2012
> From: lokeshsmg2...@gmail.com
> To: excel-macros@googlegroups.com
>
> Hi Santosh,
>
>
> Thanks for resolving the query. See the below few conditions i needed. And 
> if you have any doubt send me an email.
>
> *See if amt is "0" without any comment it should be "L".**See if the amt 
> is "0" with comment It should be "COMP","LOP","J","UL","M",* 
> based on comments i need the results in status colum.
>
> Regards
> Lokesh.M
>
> On Sun, Jun 17, 2012 at 8:59 PM, santosh subudhi <
> santoshkumar.subu...@gmail.com> wrote:
>
> Hi Lokesh,
>
> Hope you are fine!!!
>
> I have some confusion with the conditions that you stated
> 1) As per condition one if the amount is more than zero it has to be 
> "P",however for Christina on 01-07-2012 you stated as half day same with 
> anusha with date 02-07-2012
>
> 2) In conditions you mentioned as "loss of Pay",however in comments you 
> have used "leave with loss of pay".
>
> Still I have tried to solve you problems as per the conditions mentioned 
> on second sheet of the workbook.
>
> Comments:
> 1)You have add a status colum as i have added on 01july  and 02july for 
> every date and paste the formula on the 1st sheet.
> 2)Secondly you need to enter the Vlookup formula for each date in second 
> sheet and just change the "coloum index number"accordingly.
> 3)Name ranges have been used here( to view them CTRL+F3)
>
> -- 
> Regards
> Santosh 
> santoshkumar.subu...@gmail.com
>
>
> --
> Date: Sun, 17 Jun 2012 18:39:19 +0530
> Subject: Re: $$Excel-Macros$$ Attendance tracker 2012
> From: lokeshsmg2...@gmail.com
> To: excel-macros@googlegroups.com
>
>
> Hi All,
>
> Please resolve this query whether using f

RE: $$Excel-Macros$$ Date

[Rajan_Verma]

 

 

=INT(B2-A2) in C2

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Chandra Shekar
Sent: 18 June 2012 6:18
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Date

 

Hello Rajan,

 

Thanks for your reply.For example If date in Cell C2 18/06/2012 14:44:04 and
in Cell D2 19/06/2012 14:42:04 then formula should show 0 because as per
time one day is not completed.

 

I hope this is clear. 

 

Thanks,

 

Chandra Shekar B

On Mon, Jun 18, 2012 at 9:31 AM, ankur  wrote:

hi chandra

Sorry for late reply

Please find the attached file for the solution,as i suggested you earlier

Regards:
CMA Ankur Pandey 



 




On Fri, Jun 15, 2012 at 8:36 PM, Rajan_Verma 
wrote:

Hi,

 

I think I am not getting you .

Can you please explain how you want to get day on behalf of Hours??

 

Because the days is also calculating in the last formula based on give Dates
and Times.

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Chandra Shekar
Sent: 15 June 2012 8:25


To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Date

 

Hello Rajan,

 

Thanks for the formula. Could you please provide days as well which is in
Column C based on Hours.

 

Thanks in advance.

 

Regards,

 

Chandra Shekar B

On Fri, Jun 15, 2012 at 4:22 PM, Rajan_Verma 
wrote:

 

 

HI 

 

Try this 

 

=DAY(B2-A2) & " Day " & HOUR(B2-A2) & " Hour " & MINUTE(B2-A2) & " Minute "
& SECOND(B2-A2) & " Second"

 

 

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Chandra Shekar
Sent: 15 June 2012 6:06
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Date

 

Hello,

 

Any help regarding this.

 

Thanks in advance.

 

Regards,

 

Chandra Shekar B

-- Forwarded message --
From: Chandra Shekar 
Date: Tue, Jun 12, 2012 at 3:45 PM
Subject: $$Excel-Macros$$ Date
To: excel-macros@googlegroups.com

Hello,

 

Can you please help me with attached excel.

 

Thanks in advance.

 

Regards,

 

Chandra Shekar B

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

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

 

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

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

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

--
To post to this gr

Re: $$Excel-Macros$$ Need help!!! MACRO

[dguillett1]

OOPS

Put a space between select and case
selectcase
select case



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

Sent: Monday, June 18, 2012 4:10 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need help!!! MACRO

Hi All,

I need help with macros. Attached (Macro for Footer) is the existing file 
with macros for labeling an excel sheet, It asks for Yes or no for label the 
sheet as Confidential or Internal Use Only.


I need your help to include 1 more category Restricted. I tried to do some 
changes to the vb coding (Macros 2), but couldn’t do it correctly.



Best Regards

Jones Pulikotil
Sent on my BlackBerry® from Vodafone

--
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$$ Need help!!! MACRO

[dguillett1]

Try

Sub FooterSAS()
selectcase InputBox("Enter 1=Confidental, 2=For Internal Use Only 3=Other")
Case Is = 1: x = "Confidental"
Case Is = 2: x = "For Internal Use Only"
Case Is = 3: x = "Restricted"
Case Else
End Select
For Each wk In Application.Workbooks
   For Each sh In wk.Worksheets
   'wk.Sheets(i).Select
   sh.PageSetup.CenterFooter = x
   Next
Next
MsgBox strResponse & " footer has been successfully added."
End Sub



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

Sent: Monday, June 18, 2012 4:10 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need help!!! MACRO

Hi All,

I need help with macros. Attached (Macro for Footer) is the existing file 
with macros for labeling an excel sheet, It asks for Yes or no for label the 
sheet as Confidential or Internal Use Only.


I need your help to include 1 more category Restricted. I tried to do some 
changes to the vb coding (Macros 2), but couldn’t do it correctly.



Best Regards

Jones Pulikotil
Sent on my BlackBerry® from Vodafone

--
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$$ Progress Bas for macro status - Help Required

[Rajan_Verma]

See the attached file

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Avinash
Sent: 18 June 2012 2:35
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Progress Bas for macro status - Help Required

 

Thanks  Manoj for you help.

 

But i want progress bar macro formatting macro i already have i have
mentioned sample macro code not my actual code.

 

Regards,

Avinash 

On Monday, June 18, 2012 11:05:34 AM UTC+5:30, Manoj Kumar wrote:

Dear Avinash.

 

 

Sub gg()

 

For a = 1 To Sheets.Count

Sheets(a).Activate

Range("a1:dd5").Select

 

Selection.Font.Bold = True

 

 

Next

 

End Sub

 

Regard

Manoj

 

On Sun, Jun 17, 2012 at 11:39 PM, Avinash  wrote:

Dear Experts,

 

I have 1 workbook and there are 10 subsheets in that workbook.

i have created 1 macro to format those 10 subsheets.

 

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

and and sheet 2 bold italic text for row 2.

 

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

 

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

 

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

 

My macro style

 

Sub Formatting ()

 

Step1

format sheet 1

 

Step2

format sheet 2

 

Step3

format sheet 3

 

Step4

format sheet 4

 

Step5

format sheet 5

 

Step6

format sheet 6

 

Step7

format sheet 7

 

Step7

format sheet 7

 

Step8

format sheet 8

 

Step9

format sheet 9

 

Step10

format sheet 10

 

 

End Sub

 

 

 

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

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

 

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

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

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

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

Re: $$Excel-Macros$$ Date

[Chandra Shekar]

Hello Rajan,

Thanks for your reply.For example If date in Cell C2 18/06/2012 14:44:04
and in Cell D2 19/06/2012 14:42:04 then formula should show 0 because as
per time one day is not completed.

I hope this is clear.

Thanks,

Chandra Shekar B

On Mon, Jun 18, 2012 at 9:31 AM, ankur  wrote:

> hi chandra
>
> Sorry for late reply
>
> Please find the attached file for the solution,as i suggested you earlier
>
> Regards:
> CMA Ankur Pandey
>
>
>
>
>
>
> On Fri, Jun 15, 2012 at 8:36 PM, Rajan_Verma wrote:
>
>>  Hi,
>>
>> ** **
>>
>> I think I am not getting you .
>>
>> Can you please explain how you want to get day on behalf of Hours??
>>
>> ** **
>>
>> Because the days is also calculating in the last formula based on give
>> Dates and Times.
>>
>> ** **
>>
>> * *
>>
>> *Regards*
>>
>> *Rajan verma*
>>
>> *+91 7838100659 [IM-Gtalk]*
>>
>> ** **
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar
>> *Sent:* 15 June 2012 8:25
>>
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ Date
>>
>>  ** **
>>
>> Hello Rajan,
>>
>>  
>>
>> Thanks for the formula. Could you please provide days as well which is in
>> Column C based on Hours.
>>
>>  
>>
>> Thanks in advance.
>>
>>  
>>
>> Regards,
>>
>>  
>>
>> Chandra Shekar B
>>
>> On Fri, Jun 15, 2012 at 4:22 PM, Rajan_Verma 
>> wrote:
>>
>>  
>>
>>  
>>
>> HI 
>>
>>  
>>
>> Try this 
>>
>>  
>>
>> *=DAY(B2-A2) & " Day " & HOUR(B2-A2) & " Hour " & MINUTE(B2-A2) & "
>> Minute " & SECOND(B2-A2) & " Second"*
>>
>>  
>>
>>  
>>
>>  
>>
>> * *
>>
>> *Regards*
>>
>> *Rajan verma*
>>
>> *+91 7838100659 [IM-Gtalk]*
>>
>>  
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar
>> *Sent:* 15 June 2012 6:06
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ Date
>>
>>  
>>
>> Hello,
>>
>>  
>>
>> Any help regarding this.
>>
>>  
>>
>> Thanks in advance.
>>
>>  
>>
>> Regards,
>>
>>  
>>
>> Chandra Shekar B
>>
>> -- Forwarded message --
>> From: *Chandra Shekar* 
>> Date: Tue, Jun 12, 2012 at 3:45 PM
>> Subject: $$Excel-Macros$$ Date
>> To: excel-macros@googlegroups.com
>>
>> Hello,
>>
>>  
>>
>> Can you please help me with attached excel.
>>
>>  
>>
>> Thanks in advance.
>>
>>  
>>
>> Regards,
>>
>>  
>>
>> Chandra Shekar B
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>>  
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking o

Re: $$Excel-Macros$$ delete blank columns

[vishal angre]

press F5 > click special button > select blanks button

selected cell delete




On Fri, Jun 15, 2012 at 11:56 AM, Excel Vba wrote:

> Hi  Smitha,
>
> PFA Workbook. I hope this will help u.
>
> Regards,
> Hemant.
>
>
>
> ---
>
>
>  On Fri, Jun 15, 2012 at 11:11 AM, Smitha S R wrote:
>
>> How to delete all blank columns arising between various rows and columns?
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
With Regards,
*Vishal K. Angre*
E-mail :  visha...@gmail.com
 vishal.k.an...@gmail.com

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

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

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

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

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

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

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

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

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

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

[Mangesh Vimay]

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



-- 
With regards,

MaNgEsH

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

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

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

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

4) 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$$ Seems Like comments but Not

[ankur]

yes, datavalidation-input message

Regards:
CMA Ankur Pandey





On Fri, Jun 15, 2012 at 4:13 PM, Anil Gawli  wrote:

> Yes that is created by data validation
> Ahmed is Right.
> Regards,
> Gawli Anil
>
> On Fri, Jun 15, 2012 at 4:03 PM, Ahmed Honest wrote:
>
>>  Dear Deba,
>>
>> That's INput message defined using Data Validation. For your information
>> click in the cell where the message is coming up go to Data tab and
>> select Data Validation and in Data Validation Check for Input message. Hope
>> you shbould understand.
>>
>> Moreover, it's one of the way to guide the end user what is to be entered
>> or how the data is to be entered in a speicific sheet.
>>
>> Hope this above explanation help.
>>
>> Thanks,
>>
>>
>>
>> On Fri, Jun 15, 2012 at 1:29 PM, Deba Ranjan  wrote:
>>
>>> Dear Experts,
>>>
>>>  I show in the attached file, If we click in B2 cell to B5 cell,
>>> then some comments appears, actually I have notice that it is not a
>>> comments, Can you Please suggest what actually is ?
>>>
>>>
>>> Thanks & Regards,
>>> *Deba Ranjan P*
>>>
>>>
>>> 
>>>
>>> --
>>> -- 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
>>
>>
>>
>>
>> --
>>  Ahmed Bawazir
>> *احمد باوزير*
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
>
>
> --
> Thanks & Regards,
> Gawli Anil Narayan
> Software Developer,
> Abacus Software Services Pvt Ltd
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

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

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

[Avinash]

Thanks  Manoj for you help.

But i want progress bar macro formatting macro i already have i 
have mentioned sample macro code not my actual code.

Regards,
Avinash 

On Monday, June 18, 2012 11:05:34 AM UTC+5:30, Manoj Kumar wrote:
>
> Dear Avinash.
>
>
> Sub gg()
>
> For a = 1 To Sheets.Count
> Sheets(a).Activate
> Range("a1:dd5").Select
>
> Selection.Font.Bold = True
>
>
> Next
>
> End Sub
>
> Regard
> Manoj
>
>
> On Sun, Jun 17, 2012 at 11:39 PM, Avinash wrote:
>
>> Dear Experts,
>>
>> I have 1 workbook and there are 10 subsheets in that workbook.
>> i have created 1 macro to format those 10 subsheets.
>>
>> every sheet does have different formatting e.g. sheet 1 bold text for row 
>> 1
>> and and sheet 2 bold italic text for row 2.
>>
>> so now i want macro to show the progress bar (progress bar should be VBA 
>> USERFORM ) in % which shows me how much formatting is completed like after 
>> sheet 1 formatting progress bar should show 10% completed after sheet 2 it 
>> should show 20%
>>
>> and after all formatting done it should say 100% with how much time taken 
>> for formatting all thease sheets.
>>
>> Please help me in this as i want to incorporate the same type of macro in 
>> other projects.
>>
>> My macro style
>>
>> Sub Formatting ()
>>
>> Step1
>> format sheet 1
>>
>> Step2
>> format sheet 2
>>
>> Step3
>> format sheet 3
>>
>> Step4
>> format sheet 4
>>
>> Step5
>> format sheet 5
>>
>> Step6
>> format sheet 6
>>
>> Step7
>> format sheet 7
>>
>> Step7
>> format sheet 7
>>
>> Step8
>> format sheet 8
>>
>> Step9
>> format sheet 9
>>
>> Step10
>> format sheet 10
>>
>>
>> End Sub
>>
>>
>>
>>  -- 
>> FORUM RULES (986+ members already BANNED for violation)
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>>  
>> 2) Don't post a question in the thread of another member.
>>  
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>>  
>> 4) Acknowledge the responses you receive, good or bad.
>>  
>> 5) Cross-promotion of, or links to, forums competitive to this forum in 
>> signatures are prohibited. 
>>  
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum 
>> owners and members are not responsible for any loss.
>>  
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>  
>> To unsubscribe, send a blank email to 
>> excel-macros+unsubscr...@googlegroups.com
>
>
>

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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Attendance tracker 2012

[Lokesh Loki]

Santhosh for 1st june she get comp off and your formula is correct, and 2nd
june she had worked but half day that is also correct.

The problem is "Leave with loss of pay" for "Sachin G.A" he had no leaves
and no production. so i need "LOP" for this perticular person.

Regards
Lokesh

On Mon, Jun 18, 2012 at 1:39 PM, santosh subudhi <
santoshkumar.subu...@gmail.com> wrote:

> Hi Lokesh,
>
> As per you mail and conditions I have applied and checked for the 1st 10
> rows (from akshata to kamalkar for 1st july) and they are working fine
> marked in blue.
>
> If the amount is zero without any comments it is "L" row 2 for Anusha
>
> Please check and let me know.
>
> Regards
> Santosh Kumar Subudhi
>
> --
> Date: Mon, 18 Jun 2012 13:21:09 +0530
>
> Subject: Re: $$Excel-Macros$$ Attendance tracker 2012
> From: lokeshsmg2...@gmail.com
> To: excel-macros@googlegroups.com
>
> Hi Santhosh,
>
> Yes you are right, but when the amt is "0" with an comment "comp Off,
> Halfday Leave, Loss of pay, Move to other project, Unplanned leave", that
> time i need *this condition "See if the amt is "0" with comment It should
> be "COMP","LOP","J","UL","M",*
>
> And *See if amt is "0" without any comment it should be "L".
>
> *
> Please try once and do the needful santosh.
>
> Regards
> Lokesh.M*
> *
>
>
> On Mon, Jun 18, 2012 at 1:15 PM, santosh subudhi <
> santoshkumar.subu...@gmail.com> wrote:
>
> Hi Lokesh,
>
> As per you comments these are the below conditions that come up
>
> 1  If total amount colum is more than "0" it should be treated a "P"
> 2 If total amount colum is "0" without any comment, it should be treated
> as "L"
> 3 If total amount colum is "0" with the comment Unplanned Leave , it
> should be treated as "UL""
> 4 If total amount colum is "0" with the comment Comp Off, it should be
> treated as "COM"
> 5 If total amount colum is "0" with the comment Half Day Leave, it should
> be treated as "HL"
> 6 If total amount colum is "0" with the comment Loss of pay, it should be
> treated as "LOP"
> 7 If total amount colum is "0" with the comment Move to other project, it
> should be treated as "M"
> 8 If total amount colum is "0" with the comment Resignation, it should be
> treated as "R"
> 9 If total amount colum is "0" with the comment Joining, it should be
> treated as "J"
>
> I have also created the tracker based on the above conditions which I have
> already sent you in my previous mail.
>
> Regards
> Santosh Kumar Subudhi
>
>
> --
> Date: Mon, 18 Jun 2012 11:51:05 +0530
>
> Subject: Re: $$Excel-Macros$$ Attendance tracker 2012
> From: lokeshsmg2...@gmail.com
> To: excel-macros@googlegroups.com
>
> Hi Santosh,
>
>
> Thanks for resolving the query. See the below few conditions i needed. And
> if you have any doubt send me an email.
>
> *See if amt is "0" without any comment it should be "L".* *See if the amt
> is "0" with comment It should be "COMP","LOP","J","UL","M",*
> based on comments i need the results in status colum.
>
> Regards
> Lokesh.M
>
> On Sun, Jun 17, 2012 at 8:59 PM, santosh subudhi <
> santoshkumar.subu...@gmail.com> wrote:
>
> Hi Lokesh,
>
> Hope you are fine!!!
>
> I have some confusion with the conditions that you stated
> 1) As per condition one if the amount is more than zero it has to be
> "P",however for Christina on 01-07-2012 you stated as half day same with
> anusha with date 02-07-2012
>
> 2) In conditions you mentioned as "loss of Pay",however in comments you
> have used "leave with loss of pay".
>
> Still I have tried to solve you problems as per the conditions mentioned
> on second sheet of the workbook.
>
> Comments:
> 1)You have add a status colum as i have added on 01july  and 02july for
> every date and paste the formula on the 1st sheet.
> 2)Secondly you need to enter the Vlookup formula for each date in second
> sheet and just change the "coloum index number"accordingly.
> 3)Name ranges have been used here( to view them CTRL+F3)
>
> --
> Regards
> Santosh
> santoshkumar.subu...@gmail.com
>
>
> --
> Date: Sun, 17 Jun 2012 18:39:19 +0530
> Subject: Re: $$Excel-Macros$$ Attendance tracker 2012
> From: lokeshsmg2...@gmail.com
> To: excel-macros@googlegroups.com
>
>
> Hi All,
>
> Please resolve this query whether using formula or an macro. I am waiting
> for your reply do the needful.
>
> Regards
> Lokesh.M
>
> On Sat, Jun 16, 2012 at 6:34 PM, Lokesh Loki 
>  wrote:
>
> Hi Experts,
>
> Till now i did not get any updates from the below request. Please do the
> needful brothers.
>
> Regards
> Lokesh.M
>
>
> -- Forwarded message --
> From: *Lokesh Loki* 
> Date: Fri, Jun 15, 2012 at 5:51 PM
> Subject: $$Excel-Macros$$ Attendance tracker 2012
> To: excel-macros@googlegroups.com
>
>
> Hi Experts,
>
> I need a help from you, i have attached excel file with the following
> conditional formats and i need a below result on the *sheet 2* based on *date
> wise* and total amount.
>
> Find the 

Re: $$Excel-Macros$$ Attendance tracker 2012

[Lokesh Loki]

Hi Santhosh,

Yes you are right, but when the amt is "0" with an comment "comp Off,
Halfday Leave, Loss of pay, Move to other project, Unplanned leave", that
time i need *this condition "See if the amt is "0" with comment It should
be "COMP","LOP","J","UL","M",*

And *See if amt is "0" without any comment it should be "L".

*Please try once and do the needful santosh.

Regards
Lokesh.M*
*


On Mon, Jun 18, 2012 at 1:15 PM, santosh subudhi <
santoshkumar.subu...@gmail.com> wrote:

> Hi Lokesh,
>
> As per you comments these are the below conditions that come up
>
> 1  If total amount colum is more than "0" it should be treated a "P"
> 2 If total amount colum is "0" without any comment, it should be treated
> as "L"
> 3 If total amount colum is "0" with the comment Unplanned Leave , it
> should be treated as "UL""
> 4 If total amount colum is "0" with the comment Comp Off, it should be
> treated as "COM"
> 5 If total amount colum is "0" with the comment Half Day Leave, it should
> be treated as "HL"
> 6 If total amount colum is "0" with the comment Loss of pay, it should be
> treated as "LOP"
> 7 If total amount colum is "0" with the comment Move to other project, it
> should be treated as "M"
> 8 If total amount colum is "0" with the comment Resignation, it should be
> treated as "R"
> 9 If total amount colum is "0" with the comment Joining, it should be
> treated as "J"
>
> I have also created the tracker based on the above conditions which I have
> already sent you in my previous mail.
>
> Regards
> Santosh Kumar Subudhi
>
>
> --
> Date: Mon, 18 Jun 2012 11:51:05 +0530
>
> Subject: Re: $$Excel-Macros$$ Attendance tracker 2012
> From: lokeshsmg2...@gmail.com
> To: excel-macros@googlegroups.com
>
> Hi Santosh,
>
>
> Thanks for resolving the query. See the below few conditions i needed. And
> if you have any doubt send me an email.
>
> *See if amt is "0" without any comment it should be "L".**See if the amt
> is "0" with comment It should be "COMP","LOP","J","UL","M",*
> based on comments i need the results in status colum.
>
> Regards
> Lokesh.M
>
> On Sun, Jun 17, 2012 at 8:59 PM, santosh subudhi <
> santoshkumar.subu...@gmail.com> wrote:
>
> Hi Lokesh,
>
> Hope you are fine!!!
>
> I have some confusion with the conditions that you stated
> 1) As per condition one if the amount is more than zero it has to be
> "P",however for Christina on 01-07-2012 you stated as half day same with
> anusha with date 02-07-2012
>
> 2) In conditions you mentioned as "loss of Pay",however in comments you
> have used "leave with loss of pay".
>
> Still I have tried to solve you problems as per the conditions mentioned
> on second sheet of the workbook.
>
> Comments:
> 1)You have add a status colum as i have added on 01july  and 02july for
> every date and paste the formula on the 1st sheet.
> 2)Secondly you need to enter the Vlookup formula for each date in second
> sheet and just change the "coloum index number"accordingly.
> 3)Name ranges have been used here( to view them CTRL+F3)
>
> --
> Regards
> Santosh
> santoshkumar.subu...@gmail.com
>
>
> --
> Date: Sun, 17 Jun 2012 18:39:19 +0530
> Subject: Re: $$Excel-Macros$$ Attendance tracker 2012
> From: lokeshsmg2...@gmail.com
> To: excel-macros@googlegroups.com
>
>
> Hi All,
>
> Please resolve this query whether using formula or an macro. I am waiting
> for your reply do the needful.
>
> Regards
> Lokesh.M
>
> On Sat, Jun 16, 2012 at 6:34 PM, Lokesh Loki 
>  wrote:
>
> Hi Experts,
>
> Till now i did not get any updates from the below request. Please do the
> needful brothers.
>
> Regards
> Lokesh.M
>
>
> -- Forwarded message --
> From: *Lokesh Loki* 
> Date: Fri, Jun 15, 2012 at 5:51 PM
> Subject: $$Excel-Macros$$ Attendance tracker 2012
> To: excel-macros@googlegroups.com
>
>
> Hi Experts,
>
> I need a help from you, i have attached excel file with the following
> conditional formats and i need a below result on the *sheet 2* based on *date
> wise* and total amount.
>
> Find the below results. and do the needful.
>
> Present  P Planned Leave LUnplanned Leave ULComp OffCO Half Day LeaveHLMove 
> to Other Project
> MResignation RJoiningJ Leave with loss of payLOP
> Let me know if you have any clarification.
>
> Regards
> Lokesh.M
>
> --
> 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

RE: $$Excel-Macros$$ Attendance tracker 2012

[santosh subudhi]

Hi Lokesh,

As per you comments these are the below conditions that come up

1  If total amount colum is more than "0" it should be treated a "P"
2 If total amount colum is "0" without any comment, it should be treated as
"L"
3 If total amount colum is "0" with the comment Unplanned Leave , it should
be treated as "UL""
4 If total amount colum is "0" with the comment Comp Off, it should be
treated as "COM"
5 If total amount colum is "0" with the comment Half Day Leave, it should
be treated as "HL"
6 If total amount colum is "0" with the comment Loss of pay, it should be
treated as "LOP"
7 If total amount colum is "0" with the comment Move to other project, it
should be treated as "M"
8 If total amount colum is "0" with the comment Resignation, it should be
treated as "R"
9 If total amount colum is "0" with the comment Joining, it should be
treated as "J"

I have also created the tracker based on the above conditions which I have
already sent you in my previous mail.

Regards
Santosh Kumar Subudhi


--
Date: Mon, 18 Jun 2012 11:51:05 +0530
Subject: Re: $$Excel-Macros$$ Attendance tracker 2012
From: lokeshsmg2...@gmail.com
To: excel-macros@googlegroups.com

Hi Santosh,


Thanks for resolving the query. See the below few conditions i needed. And
if you have any doubt send me an email.

*See if amt is "0" without any comment it should be "L".**See if the amt is
"0" with comment It should be "COMP","LOP","J","UL","M",*
based on comments i need the results in status colum.

Regards
Lokesh.M

On Sun, Jun 17, 2012 at 8:59 PM, santosh subudhi <
santoshkumar.subu...@gmail.com> wrote:

Hi Lokesh,

Hope you are fine!!!

I have some confusion with the conditions that you stated
1) As per condition one if the amount is more than zero it has to be
"P",however for Christina on 01-07-2012 you stated as half day same with
anusha with date 02-07-2012

2) In conditions you mentioned as "loss of Pay",however in comments you
have used "leave with loss of pay".

Still I have tried to solve you problems as per the conditions mentioned on
second sheet of the workbook.

Comments:
1)You have add a status colum as i have added on 01july  and 02july for
every date and paste the formula on the 1st sheet.
2)Secondly you need to enter the Vlookup formula for each date in second
sheet and just change the "coloum index number"accordingly.
3)Name ranges have been used here( to view them CTRL+F3)

-- 
Regards
Santosh
santoshkumar.subu...@gmail.com


--
Date: Sun, 17 Jun 2012 18:39:19 +0530
Subject: Re: $$Excel-Macros$$ Attendance tracker 2012
From: lokeshsmg2...@gmail.com
To: excel-macros@googlegroups.com


Hi All,

Please resolve this query whether using formula or an macro. I am waiting
for your reply do the needful.

Regards
Lokesh.M

On Sat, Jun 16, 2012 at 6:34 PM, Lokesh Loki 
 wrote:

Hi Experts,

Till now i did not get any updates from the below request. Please do the
needful brothers.

Regards
Lokesh.M


-- Forwarded message --
From: *Lokesh Loki* 
Date: Fri, Jun 15, 2012 at 5:51 PM
Subject: $$Excel-Macros$$ Attendance tracker 2012
To: excel-macros@googlegroups.com


Hi Experts,

I need a help from you, i have attached excel file with the following
conditional formats and i need a below result on the *sheet 2* based on *date
wise* and total amount.

Find the below results. and do the needful.

Present  PPlanned Leave LUnplanned LeaveULComp OffCOHalf Day LeaveHLMove to
Other ProjectMResignationRJoiningJLeave with loss of payLOP
Let me know if you have any clarification.

Regards
Lokesh.M

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

Re: $$Excel-Macros$$ Date

[ankur]

hi chandra

Sorry for late reply

Please find the attached file for the solution,as i suggested you earlier

Regards:
CMA Ankur Pandey





On Fri, Jun 15, 2012 at 8:36 PM, Rajan_Verma wrote:

> Hi,
>
> ** **
>
> I think I am not getting you .
>
> Can you please explain how you want to get day on behalf of Hours??
>
> ** **
>
> Because the days is also calculating in the last formula based on give
> Dates and Times.
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar
> *Sent:* 15 June 2012 8:25
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Date
>
> ** **
>
> Hello Rajan,
>
>  
>
> Thanks for the formula. Could you please provide days as well which is in
> Column C based on Hours.
>
>  
>
> Thanks in advance.
>
>  
>
> Regards,
>
>  
>
> Chandra Shekar B
>
> On Fri, Jun 15, 2012 at 4:22 PM, Rajan_Verma 
> wrote:
>
>  
>
>  
>
> HI 
>
>  
>
> Try this 
>
>  
>
> *=DAY(B2-A2) & " Day " & HOUR(B2-A2) & " Hour " & MINUTE(B2-A2) & "
> Minute " & SECOND(B2-A2) & " Second"*
>
>  
>
>  
>
>  
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar
> *Sent:* 15 June 2012 6:06
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Date
>
>  
>
> Hello,
>
>  
>
> Any help regarding this.
>
>  
>
> Thanks in advance.
>
>  
>
> Regards,
>
>  
>
> Chandra Shekar B
>
> -- Forwarded message --
> From: *Chandra Shekar* 
> Date: Tue, Jun 12, 2012 at 3:45 PM
> Subject: $$Excel-Macros$$ Date
> To: excel-macros@googlegroups.com
>
> Hello,
>
>  
>
> Can you please help me with attached excel.
>
>  
>
> Thanks in advance.
>
>  
>
> Regards,
>
>  
>
> Chandra Shekar B
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>  
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsu