Re: $$Excel-Macros$$ VBA script to change cell color if text has strikethrough

[David Grugeon]

There are problems with this as the conditional formatting overrides any
locally applied formatting so the macro would need to exclude that cell
from the conditional formatting - not easy and not advisable.  Conditional
formats can get confused enough without any help.

I would suggest you have a column called Status which has either
"Uncompleted" or "Completed" you could usefully limit it to these with a
validation dropdown.  You could include other statuses such as "Working",
"Not Started" if you wanted to.  Lets call this Column Z

Now: in the cell where the conditional formatting is you include, as your
first condition =Z1="Completed" and a format of No fill and Strikethrough.

HTH

David

On 6 June 2012 06:33, Michael Landry  wrote:

> I am working on a spreadsheet that contains several columns with due
> dates.  I have conditional formatting rules that change the cell color as a
> due date gets closer to today's date.
> <15 days = yellow
> <10 days = orange
> <5 days = red
>
> Once an activity has been completed, the user formats the date with
> strikethrough. At this point, I would like to change the cell color back to
> "none" so the user doesn't have red cells showing for activities that have
> already been completed.
> It appears that I will need a vba script to do this, but I have no idea
> how to get started.
>
> Any assistance would be greatly appreciated!
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or 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




-- 
David Grugeon

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

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

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

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

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

5)  Cross-promotion of, or 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$$ Graph

[Smitha S R]

*Hi,

Please help in preparing the graph on the attached data
*
On Tue, Jun 5, 2012 at 6:33 PM, Rajan_Verma wrote:

> Hi Smith
>
> Every Chart needs related data, can you provide the data of *Growth*?
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Smitha S R
> *Sent:* 05 June 2012 3:25
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Graph
>
> ** **
>
> Hi,
>
> Please help me in drawing the graph, as per the attachment.
> Need a graph , month wise where the employee growth, cost wise growth and
> team could be identified .
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or 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

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

Re: $$Excel-Macros$$ Re: extract data from table

[joseph . camill]

Great Noorain and Seraj,

Will revert if incase of any issue.

Sent on my BlackBerry® from Vodafone

-Original Message-
From: Seraj Alam 
Sender: excel-macros@googlegroups.com
Date: Tue, 5 Jun 2012 20:31:55 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: extract data from table

Hi

You can use below formula also...

=IFERROR(INDEX($B$3:$S$3,MATCH(B$19,$B$1:$S$1,0)),"")

On Tue, Jun 5, 2012 at 7:31 PM, NOORAIN ANSARI wrote:

> Dear Joseph,
>
> Please find attached sheet, Hope it will help to you.
>
> for Column Heading
>
> =IFERROR(INDEX($1:$1,0,SMALL(IF(($A$2:$A$11=$A$16)*($A$2:$S$11<>0),COLUMN($B$1:$S$1),""),COLUMN(B1))-1),"")
> For Numbers without 0
> =IFERROR(HLOOKUP(B$15,$B$1:$S$11,MATCH($A16,$A$1:$A$11,0),0),"")
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Wed, Jun 6, 2012 at 1:10 AM, Vish  wrote:
>
>> Hi,
>>
>> Is your table going to be the same? I mean the number of columns and rows
>> going to be same??
>>
>> On Wednesday, June 6, 2012 12:51:31 AM UTC+5:30, Joseph wrote:
>>>
>>> Hi,
>>>
>>> I have a table and need to extract data that is non-zero.
>>>
>>> Attached is the sample file for your reference.
>>>
>>> Thanks,
>>> Joseph
>>>
>>
>> On Wednesday, June 6, 2012 12:51:31 AM UTC+5:30, Joseph wrote:
>>>
>>> Hi,
>>>
>>> I have a table and need to extract data that is non-zero.
>>>
>>> Attached is the sample file for your reference.
>>>
>>> Thanks,
>>> Joseph
>>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
>
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
Thanks & Regards
Seraj Alam
*+91 989 130 1776*

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

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

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

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

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

5)  Cross-promotion of, or 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 competitiv

Re: $$Excel-Macros$$ Re: extract data from table

[Seraj Alam]

Hi

You can use below formula also...

=IFERROR(INDEX($B$3:$S$3,MATCH(B$19,$B$1:$S$1,0)),"")

On Tue, Jun 5, 2012 at 7:31 PM, NOORAIN ANSARI wrote:

> Dear Joseph,
>
> Please find attached sheet, Hope it will help to you.
>
> for Column Heading
>
> =IFERROR(INDEX($1:$1,0,SMALL(IF(($A$2:$A$11=$A$16)*($A$2:$S$11<>0),COLUMN($B$1:$S$1),""),COLUMN(B1))-1),"")
> For Numbers without 0
> =IFERROR(HLOOKUP(B$15,$B$1:$S$11,MATCH($A16,$A$1:$A$11,0),0),"")
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Wed, Jun 6, 2012 at 1:10 AM, Vish  wrote:
>
>> Hi,
>>
>> Is your table going to be the same? I mean the number of columns and rows
>> going to be same??
>>
>> On Wednesday, June 6, 2012 12:51:31 AM UTC+5:30, Joseph wrote:
>>>
>>> Hi,
>>>
>>> I have a table and need to extract data that is non-zero.
>>>
>>> Attached is the sample file for your reference.
>>>
>>> Thanks,
>>> Joseph
>>>
>>
>> On Wednesday, June 6, 2012 12:51:31 AM UTC+5:30, Joseph wrote:
>>>
>>> Hi,
>>>
>>> I have a table and need to extract data that is non-zero.
>>>
>>> Attached is the sample file for your reference.
>>>
>>> Thanks,
>>> Joseph
>>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
>
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
Thanks & Regards
Seraj Alam
*+91 989 130 1776*

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

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

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

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

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

5)  Cross-promotion of, or 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

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

Re: $$Excel-Macros$$ VBA script to change cell color if text has strikethrough

[NOORAIN ANSARI]

Dear Michael,

Please share a sample workbook with Group.

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

On Wed, Jun 6, 2012 at 2:03 AM, Michael Landry wrote:

> I am working on a spreadsheet that contains several columns with due
> dates.  I have conditional formatting rules that change the cell color as a
> due date gets closer to today's date.
> <15 days = yellow
> <10 days = orange
> <5 days = red
>
> Once an activity has been completed, the user formats the date with
> strikethrough. At this point, I would like to change the cell color back to
> "none" so the user doesn't have red cells showing for activities that have
> already been completed.
> It appears that I will need a vba script to do this, but I have no idea
> how to get started.
>
> Any assistance would be greatly appreciated!
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or 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: extract data from table

[NOORAIN ANSARI]

Dear Joseph,

Please find attached sheet, Hope it will help to you.

for Column Heading
=IFERROR(INDEX($1:$1,0,SMALL(IF(($A$2:$A$11=$A$16)*($A$2:$S$11<>0),COLUMN($B$1:$S$1),""),COLUMN(B1))-1),"")
For Numbers without 0
=IFERROR(HLOOKUP(B$15,$B$1:$S$11,MATCH($A16,$A$1:$A$11,0),0),"")


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

On Wed, Jun 6, 2012 at 1:10 AM, Vish  wrote:

> Hi,
>
> Is your table going to be the same? I mean the number of columns and rows
> going to be same??
>
> On Wednesday, June 6, 2012 12:51:31 AM UTC+5:30, Joseph wrote:
>>
>> Hi,
>>
>> I have a table and need to extract data that is non-zero.
>>
>> Attached is the sample file for your reference.
>>
>> Thanks,
>> Joseph
>>
>
> On Wednesday, June 6, 2012 12:51:31 AM UTC+5:30, Joseph wrote:
>>
>> Hi,
>>
>> I have a table and need to extract data that is non-zero.
>>
>> Attached is the sample file for your reference.
>>
>> Thanks,
>> Joseph
>>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or 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

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

Re: $$Excel-Macros$$ Re: extract data from table

[bpascal123]

Hi Joseph,
Do you want this done with formula or Vba script?
Pascal

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

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

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

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

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

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

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

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

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

$$Excel-Macros$$ VBA script to change cell color if text has strikethrough

[Michael Landry]

I am working on a spreadsheet that contains several columns with due dates. 
 I have conditional formatting rules that change the cell color as a due 
date gets closer to today's date.
<15 days = yellow
<10 days = orange
<5 days = red

Once an activity has been completed, the user formats the date with 
strikethrough. At this point, I would like to change the cell color back to 
"none" so the user doesn't have red cells showing for activities that have 
already been completed.
It appears that I will need a vba script to do this, but I have no idea how 
to get started.

Any assistance would be greatly appreciated!

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

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

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

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

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

5)  Cross-promotion of, or 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: extract data from table

[joseph camill]

Can you also give me an option if my number of rows change.

On Wed, Jun 6, 2012 at 1:18 AM, joseph camill wrote:

> yes, the number of rows and columns will be the same, but the values in it
> may change.
>
>
> On Wed, Jun 6, 2012 at 1:10 AM, Vish  wrote:
>
>> Hi,
>>
>> Is your table going to be the same? I mean the number of columns and rows
>> going to be same??
>>
>> On Wednesday, June 6, 2012 12:51:31 AM UTC+5:30, Joseph wrote:
>>>
>>> Hi,
>>>
>>> I have a table and need to extract data that is non-zero.
>>>
>>> Attached is the sample file for your reference.
>>>
>>> Thanks,
>>> Joseph
>>>
>>
>> On Wednesday, June 6, 2012 12:51:31 AM UTC+5:30, Joseph wrote:
>>>
>>> Hi,
>>>
>>> I have a table and need to extract data that is non-zero.
>>>
>>> Attached is the sample file for your reference.
>>>
>>> Thanks,
>>> Joseph
>>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or 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: extract data from table

[joseph camill]

yes, the number of rows and columns will be the same, but the values in it
may change.

On Wed, Jun 6, 2012 at 1:10 AM, Vish  wrote:

> Hi,
>
> Is your table going to be the same? I mean the number of columns and rows
> going to be same??
>
> On Wednesday, June 6, 2012 12:51:31 AM UTC+5:30, Joseph wrote:
>>
>> Hi,
>>
>> I have a table and need to extract data that is non-zero.
>>
>> Attached is the sample file for your reference.
>>
>> Thanks,
>> Joseph
>>
>
> On Wednesday, June 6, 2012 12:51:31 AM UTC+5:30, Joseph wrote:
>>
>> Hi,
>>
>> I have a table and need to extract data that is non-zero.
>>
>> Attached is the sample file for your reference.
>>
>> Thanks,
>> Joseph
>>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

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

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

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

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

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

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

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

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

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

$$Excel-Macros$$ Re: extract data from table

[Vish]

Hi,

Is your table going to be the same? I mean the number of columns and rows 
going to be same??

On Wednesday, June 6, 2012 12:51:31 AM UTC+5:30, Joseph wrote:
>
> Hi,
>
> I have a table and need to extract data that is non-zero.
>
> Attached is the sample file for your reference.
>
> Thanks,
> Joseph
>

On Wednesday, June 6, 2012 12:51:31 AM UTC+5:30, Joseph wrote:
>
> Hi,
>
> I have a table and need to extract data that is non-zero.
>
> Attached is the sample file for your reference.
>
> Thanks,
> Joseph
>

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

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

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

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

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

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

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

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

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

$$Excel-Macros$$ Re: Need a Email Macro based on the Cell time

[bpascal123]

Hi Puttu,

Please provide more details about your task such as the email client you 
want to use. I would suppose Outlook but you don't tell. How column F is 
completed? Do you manually changed the dates? What are the dates related to.

You should provide more details, it's too vague to me and maybe to others, 
I don't know

Pascal

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

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

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

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

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

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

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

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

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

$$Excel-Macros$$ extract data from table

[joseph camill]

Hi,

I have a table and need to extract data that is non-zero.

Attached is the sample file for your reference.

Thanks,
Joseph

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

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

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

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

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

5)  Cross-promotion of, or 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

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

Re: $$Excel-Macros$$ Lookup Item No. from Stock.xls in Order.xls

[prkhan56]

Thanks Asa, Noorain and Vijayjith for your help. Works great.

On Monday, June 4, 2012 5:59:40 PM UTC+4, vijayajith VA wrote:

> Hi ,,
> Then removie ..YES ..just give " " 
>
> Thanks
>
> =IF(NOT(ISERROR(VLOOKUP(A7,'C:\Documents and Settings\user\My 
> Documents\Downloads\New Folder\[Stock.xls]Sheet1'!$C$5:$C$914,1,0))),"NO"," 
> ")
>
> On Sun, Jun 3, 2012 at 10:11 PM, prkhan56  wrote:
>
>> Thanks.
>> But it is showing "Yes" for Blanks also.
>> I wish to show Blank for Blanks.
>>
>> On Saturday, June 2, 2012 12:12:39 PM UTC+4, vijayajith VA wrote:
>>
>>> Hi Rashid
>>> As you requested.. Please find ...attached file...Thanks
>>>
>>>
>>> On Sat, Jun 2, 2012 at 1:14 PM, Rashid Khan  wrote:
>>>
 Hello All

 I am enclosing two files viz Stock.xls and Order.xls

 I wish to have a formula in Order.xls in the ‘IS PRESENT’ column on all 
 the 3 Sheets (PF,MU,PR) to lookup for Item No. from Stock.xls (6 digits 
 from left only) and say “Yes” if present or “No” if not present.

 TIA

 Rashid
  
 -- 
 FORUM RULES (986+ members already BANNED for violation)
  
 1) Use concise, accurate thread titles. Poor thread titles, like Please 
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
 will not get quick attention or may not be answered.
  
 2) Don't post a question in the thread of another member.
  
 3) Don't post questions regarding breaking or bypassing any security 
 measure.
  
 4) Acknowledge the responses you receive, good or bad.
  
 5) Cross-promotion of, or 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+unsubscribe@**
 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$$ Excel VBA Book?

[charlyRoot]

PERFECT!! Thank you very much! I knew there was something out there I 
haven't found yet.

On Tuesday, June 5, 2012 10:57:07 AM UTC-4, Sandeep Kumar Baranwal wrote:
>
> Refer
>  functionx.com/vbaexcel
>
> this will help
>
> Sandeep
>
>
> On Tue, Jun 5, 2012 at 7:12 AM, charlyRoot  wrote:
>
>> I don't know VBA other than manipulating recorded macros. What is the 
>> quickest way to learn from foundation up? Book? Some pay site? It takes to 
>> long to go through youtubes.
>>
>> I would like a info dense book that does not assume prior prior VBA 
>> knowledge but also assumes I know what a keyboard is.
>>
>>
>>
>>
>
>
> -- 
> *Sandeep Kumar Baranwal*
> Credit Risk Methodology & Wholesale Basel
> Gurgaon
> Mob:-08588802543
>
>
>  
On Tuesday, June 5, 2012 10:57:07 AM UTC-4, Sandeep Kumar Baranwal wrote:
>
> Refer
>  functionx.com/vbaexcel
>
> this will help
>
> Sandeep
>
>
> On Tue, Jun 5, 2012 at 7:12 AM, charlyRoot  wrote:
>
>> I don't know VBA other than manipulating recorded macros. What is the 
>> quickest way to learn from foundation up? Book? Some pay site? It takes to 
>> long to go through youtubes.
>>
>> I would like a info dense book that does not assume prior prior VBA 
>> knowledge but also assumes I know what a keyboard is.
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5)  Cross-promotion of, or 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 
>>
>> To unsubscribe, send a blank email to 
>>
>
>
>
> -- 
> *Sandeep Kumar Baranwal*
> Credit Risk Methodology & Wholesale Basel
> Gurgaon
> Mob:-08588802543
>
>
>  

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

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

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

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

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

5)  Cross-promotion of, or 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$$ How to disable all macros initially when i open the workbook

[dguillett1]

You probably have your macro in the ThisWorkbook workbook open  or a sheet 
module activate. Move the body of the macro to a regular Sub linked to your 
command button or a shape.

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

From: Mangesh Dayne 
Sent: Tuesday, June 05, 2012 9:52 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ How to disable all macros initially when i open the 
workbook

Hi Friends, 

I am working with the file containing macros.
I want all macros should be disable when i opened the file and should be enable 
when i click on command button in file.
My intention is to stop executing the macro just after opening the file. It 
should be run only when i click on command button.
Please help.


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

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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Excel VBA Book?

[Sandeep Kumar Baranwal]

Refer
 functionx.com/vbaexcel

this will help

Sandeep


On Tue, Jun 5, 2012 at 7:12 AM, charlyRoot  wrote:

> I don't know VBA other than manipulating recorded macros. What is the
> quickest way to learn from foundation up? Book? Some pay site? It takes to
> long to go through youtubes.
>
> I would like a info dense book that does not assume prior prior VBA
> knowledge but also assumes I know what a keyboard is.
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or 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




-- 
*Sandeep Kumar Baranwal*
Credit Risk Methodology & Wholesale Basel
Gurgaon
Mob:-08588802543

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

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

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

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

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

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

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

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

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

$$Excel-Macros$$ How to disable all macros initially when i open the workbook

[Mangesh Dayne]

Hi Friends,

I am working with the file containing macros.
I want all macros should be disable when i opened the file and should be
enable when i click on command button in file.
My intention is to stop executing the macro just after opening the file. It
should be run only when i click on command button.
Please help.


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$$ Graph with radio button

[pawel lupinski]

thanks Raj, I've just noticed, it's still too complicated to me but with the 
time maybe.

Thanks

Pawel




 From: Rajan_Verma 
To: excel-macros@googlegroups.com 
Sent: Tuesday, June 5, 2012 1:49 PM
Subject: RE: $$Excel-Macros$$ Graph with radio button
 

 
Hi,
 
There are three Simple VBA Procedure to accomplish this task. I have created 3 
name ranges in your sheet Team1,Team2 and Team3 then on Every Option Button 
Click Event I am assigning the Current Region of Corresponding Range to the 
Chart Source.
 
 
Sub OptionButton1_Click()
    Sheet1.ChartObjects("Chart 1").Chart.SetSourceData 
Sheet1.Range("team1").CurrentRegion
End Sub
 
 
Sub Sheet1_OptionButton2_Click()
    Sheet1.ChartObjects("Chart 1").Chart.SetSourceData 
Sheet1.Range("team2").CurrentRegion
End Sub
Sub OptionButton3_Click()
    Sheet1.ChartObjects("Chart 1").Chart.SetSourceData 
Sheet1.Range("team3").CurrentRegion
End Sub
 
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
 
From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of pawel lupinski
Sent: 05 June 2012 3:37
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Graph with radio button
 
Hi Rajan,
 
is there any chance, that you can explain me how you've done it?
 
Regards,
 
Pawel
 



From:Rajan_Verma 
To: excel-macros@googlegroups.com 
Sent: Monday, June 4, 2012 2:11 PM
Subject: RE: $$Excel-Macros$$ Graph with radio button
 
HTH
 
 
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
 
From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Anil Gawli
Sent: 04 June 2012 2:58
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Graph with radio button
 
See the attached data
Regards,
Gawli Anil


 
On Mon, Jun 4, 2012 at 2:38 PM, santosh subudhi 
 wrote:
Hi Maries,
 
Thankyou for your early response.
 
I want to show only the list of people who are available.
 
I mean when I will select "team 1" then the graph should show only the data for 
the three people and no zero's .
 
Hope I am clear with query.
 
Regards
Santosh
santoshkumar.subu...@gmail.com
 
From: talk2mar...@gmail.com
Date: Mon, 4 Jun 2012 02:01:14 -0700
Subject: Re: $$Excel-Macros$$ Graph with radio button
To: excel-macros@googlegroups.com 
 
Hi,

PFA...
On Mon, Jun 4, 2012 at 1:39 AM, santosh 
subudhi  wrote:
Hi Group, 
 
I want to create a graph which will show the work performance of different 
teams as and when they are selected.
 
Attached is the sample sheet for your easy reference.
-- 
Regards
Santosh 
santoshkumar.subu...@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



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

 
-- 
Regards
Santosh 
santoshkumar.subu...@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 sec

Re: $$Excel-Macros$$ Multiple excel sheets in merge in single excel sheet

[dguillett1]

You can use the vba DIR to open each file in the current folder and then copy 
the used range.offset(1) to the next available row in the consolidate file. If 
necessary, you can specify the files within an array

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

From: Kishore 
Sent: Friday, June 01, 2012 2:45 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Multiple excel sheets in merge in single excel sheet


Hi Excel Gurus,

I have three different excel sheets with data & top of the first at rows names 
are described, all though three excel sheets headings at rows are little vary , 
I would like to merge all these 3 excel sheets in single workbook excel sheet.

Please help& do the needful.

File attached.

Regards,


Kishore K. 

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or 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$$ Creating a Chart with bubble on it

[Shishir Ranjan]

Hi Rajan,

See below and attached. The first three are DOR (days of receivables) in
days and second three are the amounts associated with these accounts.




  DOR in DaysInventory in m$ AccountWIPAR TotalWIPAR TotalABC5645101
6.517.524DEF 68351036.313.2 19.5GHI344579 3.44.57.9JKL 5525802.20.93.1 MNO80
251051.3 1.62.9PQR3215 473.80.34.1 STU3425592.43.2 5.6VWX346599 1.23.44.6YZ
25 25503.65.69.2 TOTAL   30.750.2 80.9

On Tue, Jun 5, 2012 at 7:56 AM, Rajan_Verma wrote:

> Can you please provide sample data also?
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Shishir Ranjan
> *Sent:* 05 June 2012 11:30
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Creating a Chart with bubble on it
>
> ** **
>
> Hi David and Joseph and everyone,
>
> ** **
>
> Here is a pic hope this helps in explaining what I am looking for. I have
> omitted the names but this is for few accounts, the data table is on the
> right.
>
> ** **
>
> Please let me know if you have any more questions and also how to create
> such report or any other suggestion on explaining this data through a
> chart.. looking for some innovative meaningful chart.
>
> ** **
>
> Regards
>
> Shishir
>
> ** **
>
> On Mon, Jun 4, 2012 at 10:55 PM,  wrote:
>
> Also remember, a bubble chart has third variant, that specifies the bubble
> size.
>
> Thanks,
> Joseph
>
> Sent on my BlackBerry® from Vodafone
> --
>
> *From: *David Grugeon  
>
> *Sender: *excel-macros@googlegroups.com 
>
> *Date: *Tue, 5 Jun 2012 10:46:32 +1000
>
> *To: *
>
> *ReplyTo: *excel-macros@googlegroups.com 
>
> *Subject: *Re: $$Excel-Macros$$ Creating a Chart with bubble on it
>
> ** **
>
> Could you post a picture of the chart you are talking about?
>
> On 5 June 2012 08:01, SR  wrote:
>
>
> I have seen a report in my company which shows on two axis - the two
> parameters of an account and a line connects to these and there is a bubble
> placed on the line to indicate the volume,
>
> ** **
>
> OK to simplify - it is basically an AR related report - on one axis - it
> shows - how many days old past due - on the other axis - it shows - how
> many days it takes to bill (billing delays in days) and then a line
> connects these two and points and on this line, a bubble shows how much
> inventory (volume of AR past due + amount to be invoiced i.e. total
> inventory).
>
> ** **
>
> I can provide more information but I need to create such report for a
> dashboard ... 
>
> ** **
>
> All help shall be highly appreciated...
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or 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
>
>
>
> 
>
> ** **
>
> --
> David Grugeon
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or 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

RE: $$Excel-Macros$$ Graph

[Rajan_Verma]

Hi Smith

Every Chart needs related data, can you provide the data of Growth?

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Smitha S R
Sent: 05 June 2012 3:25
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Graph

 

Hi,

Please help me in drawing the graph, as per the attachment.
Need a graph , month wise where the employee growth, cost wise growth and
team could be identified .

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or 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$$ unhide all sheet

[Rajan_Verma]

You need to hide your workbook , because you cannot hide all worksheets in
your workbook

 

ALT +W H to Hide

ALT + W H U to Unhide

 

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shaik Waheed
Sent: 05 June 2012 1:51
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ unhide all sheet

 

Hi,

 

You can use the following code, i had been using this..

 

Sub unhide_sheets()
 Dim ws As Worksheet
 For Each ws In ActiveWorkbook.Worksheets
 ws.Visible = True
 Next ws
 End Sub

On Tue, Jun 5, 2012 at 1:33 PM, jayendra gaurav 
wrote:

Dear Team, 

 

I required your support to unhide  20 sheets in single go.

 

kindly support me .


 

-- 
J.Gaurav
Call-7838594954

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or 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$$ Creating a Chart with bubble on it

[Rajan_Verma]

Can you please provide sample data also?

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shishir Ranjan
Sent: 05 June 2012 11:30
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Creating a Chart with bubble on it

 

Hi David and Joseph and everyone,

 

Here is a pic hope this helps in explaining what I am looking for. I have
omitted the names but this is for few accounts, the data table is on the
right.

 

Please let me know if you have any more questions and also how to create
such report or any other suggestion on explaining this data through a
chart.. looking for some innovative meaningful chart.

 

Regards

Shishir

 

On Mon, Jun 4, 2012 at 10:55 PM,  wrote:

Also remember, a bubble chart has third variant, that specifies the bubble
size.

Thanks,
Joseph

Sent on my BlackBerryR from Vodafone

  _  

From: David Grugeon  

Sender: excel-macros@googlegroups.com 

Date: Tue, 5 Jun 2012 10:46:32 +1000

To: 

ReplyTo: excel-macros@googlegroups.com 

Subject: Re: $$Excel-Macros$$ Creating a Chart with bubble on it

 

Could you post a picture of the chart you are talking about?

On 5 June 2012 08:01, SR  wrote:


I have seen a report in my company which shows on two axis - the two
parameters of an account and a line connects to these and there is a bubble
placed on the line to indicate the volume,

 

OK to simplify - it is basically an AR related report - on one axis - it
shows - how many days old past due - on the other axis - it shows - how many
days it takes to bill (billing delays in days) and then a line connects
these two and points and on this line, a bubble shows how much inventory
(volume of AR past due + amount to be invoiced i.e. total inventory).

 

I can provide more information but I need to create such report for a
dashboard ... 

 

All help shall be highly appreciated...

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





 

-- 
David Grugeon

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





 

-- 
~Cheers
Shishir

-- 
FO

Re: $$Excel-Macros$$ Need VBA to select and reassign moving XY chart data

[dguillett1]

This can probably be greatly simplified. Provide your excel version and the 
file.

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

From: thatguy 
Sent: Monday, June 04, 2012 9:59 PM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Need VBA to select and reassign moving XY chart data

I have data that I am importing regularly and the number of lines of the data 
is highly variable. I have written code that first inserts a column of data I 
need for my Y axis, then the second part of my code should select the my X and 
Y range and change the graph accordingly then thirdly modify the limits of the 
major axis to the nearest largest multiple of 10 of the data. My sections 2 and 
three are not working properly. If you can help with any part I would be very 
grateful. 

Here is my code: 
Sub Tip_Elevation()
'
' Tip_Elevation Macro
' Insert Tip Elevation Depth (Ft)
'
' Keyboard Shortcut: Ctrl+Shift+I

'Insert column needed for Y Axis 
Cells.find(What:="Test").Activate
Selection.Offset(0, -1).Select
ActiveCell.FormulaR1C1 = "TIP"
Down
ActiveCell.FormulaR1C1 = "Elevation"
Down
ActiveCell.FormulaR1C1 = "Depth"
Down
ActiveCell.FormulaR1C1 = "(ft)"
Down
ActiveCell.FormulaR1C1 = "'-"
Down
ActiveCell.FormulaR1C1 = "=-RC[1]"
Down
Selection.Offset(0, 1).Activate
5
If ActiveCell > 0 Then GoTo 10
GoTo 15
10
Selection.Offset(0, -1).Select
ActiveCell.FormulaR1C1 = "=-RC[1]"
Down
Selection.Offset(0, 1).Activate
GoTo 5
15
' modify_graph Macro
'
'Determine the number of rows are in data
n = 0 'number of rows in graph data
Cells.find(What:="Test").Activate 'Find Column with Test
Selection.Offset(5, 0).Select 'Select fist number of column

20 
If ActiveCell > 0 Then GoTo 25 'If number exists go to 15
GoTo 30 'End counter

25 
n = n + 1 'Add counter
Down
GoTo 20 'Continue counter

30 'Determine Y Vaule Range 
Dim RngYVal As Range
'Cells.FindNext(After:=ActiveCell).Activate
'Cells.FindNext(After:=ActiveCell).Activate
'Cells.find(What:="Tip").Activate
Cells.find(What:="TIP", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _
True, SearchFormat:=False).Activate
Selection.Offset(5, 0).Select
Set RngYVal = Range(ActiveCell, ActiveCell.Offset(n, 0))

40 'Determine X Value Range 
Dim RngXVal As Range
Cells.find(What:="TIP", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _
True, SearchFormat:=False).Activate
Selection.Offset(5, 6).Select
Set RngXVal = Range(ActiveCell, ActiveCell.Offset(n, 0))

50 'Set graph Data 
Sheets("Curve").Select
ActiveChart.SeriesCollection(1).XValues = RngXVal
ActiveChart.SeriesCollection(1).Values = RngYVal

60 'Modify Axis Limits 
61 'Find Max Depth - factor of 10
Dim Depth As Integer
ActiveSheet.Previous.Select 'Selects the Previous Sheet
Cells.find(What:="TIP", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _
True, SearchFormat:=False).Activate
Selection.Offset(n + 5, 0).Select
Depth = ActiveCell
Depth = Application.RoundUp(lngRHDataRows / 10, 0)
Depth = Depth * 10
ActiveCell.Offset(1, 0) = Depth
62 'Find Max Load - factor of 10
Dim Load As Integer
Selection.Offset(-1, 6).Select
Load = ActiveCell
Load = Application.RoundUp(lngRHDataRows / 10, 0)
Load = Depth * 10
ActiveCell.Offset(1, 0) = Load
65 'Change Graph Axis limits
Sheets("Curve").Select
ActiveSheet.ChartObjects("Chart 7").Activate
ActiveChart.Axes(xlValue).Select
ActiveChart.PlotArea.Select
ActiveChart.Axes(xlValue).Select
ActiveChart.Axes(xlValue).MinimumScale = Depth
ActiveChart.Axes(xlCategory).Select
ActiveChart.Axes(xlCategory).MaximumScale = Load
End Sub


Thank you for all and any help! 
-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or 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 

RE: $$Excel-Macros$$ Graph with radio button

[Rajan_Verma]

 

Hi,

 

There are three Simple VBA Procedure to accomplish this task. I have created
3 name ranges in your sheet Team1,Team2 and Team3 then on Every Option
Button Click Event I am assigning the Current Region of Corresponding Range
to the Chart Source.

 

 

Sub OptionButton1_Click()

Sheet1.ChartObjects("Chart 1").Chart.SetSourceData
Sheet1.Range("team1").CurrentRegion

End Sub

 

 

Sub Sheet1_OptionButton2_Click()

Sheet1.ChartObjects("Chart 1").Chart.SetSourceData
Sheet1.Range("team2").CurrentRegion

End Sub

Sub OptionButton3_Click()

Sheet1.ChartObjects("Chart 1").Chart.SetSourceData
Sheet1.Range("team3").CurrentRegion

End Sub

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of pawel lupinski
Sent: 05 June 2012 3:37
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Graph with radio button

 

Hi Rajan,

 

is there any chance, that you can explain me how you've done it?

 

Regards,

 

Pawel

 

  _  

From: Rajan_Verma 
To: excel-macros@googlegroups.com 
Sent: Monday, June 4, 2012 2:11 PM
Subject: RE: $$Excel-Macros$$ Graph with radio button

 

HTH

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Anil Gawli
Sent: 04 June 2012 2:58
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Graph with radio button

 

See the attached data

Regards,

Gawli Anil



 

On Mon, Jun 4, 2012 at 2:38 PM, santosh subudhi
 wrote:

Hi Maries,

 

Thankyou for your early response.

 

I want to show only the list of people who are available.

 

I mean when I will select "team 1" then the graph should show only the data
for the three people and no zero's .

 

Hope I am clear with query.

 

Regards

Santosh

santoshkumar.subu...@gmail.com

 

From: talk2mar...@gmail.com
Date: Mon, 4 Jun 2012 02:01:14 -0700
Subject: Re: $$Excel-Macros$$ Graph with radio button
To: excel-macros@googlegroups.com 

 

Hi,

PFA...

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

Hi Group, 

 

I want to create a graph which will show the work performance of different
teams as and when they are selected.

 

Attached is the sample sheet for your easy reference.

-- 

Regards
Santosh 
  santoshkumar.subu...@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




-- 

 

  MARIES

  Excel Inspiration

 

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

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


 

-- 
Regards
Santosh 
santoshkumar.subu...@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 

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

[dguillett1]

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




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

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

Hi Experts,

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

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


--
Thanks&Regards
Nagendra.M

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

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

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


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

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


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

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


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


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

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


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

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

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

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

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

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


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

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

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

Re: $$Excel-Macros$$ Graph

[Smitha S R]

Please help on the graph preparation

On Tue, Jun 5, 2012 at 3:25 PM, Smitha S R  wrote:

> Hi,
>
> Please help me in drawing the graph, as per the attachment.
> Need a graph , month wise where the employee growth, cost wise growth and
> team could be identified .
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or 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$$ delete my id from mailing list

[Maries]

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




On Tue, Jun 5, 2012 at 4:04 AM, Ajay Tripathi wrote:

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




-- 
*
*
*  MARIES*
Excel Inspiration 

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

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

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

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

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

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

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

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

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

$$Excel-Macros$$ delete my id from mailing list

[Ajay Tripathi]

Hi

Please delete my name from mailing list for the time being.

Thanx

Ajay Tripathi

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

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

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

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

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

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

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

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

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

$$Excel-Macros$$ Graph

[Smitha S R]

Hi,

Please help me in drawing the graph, as per the attachment.
Need a graph , month wise where the employee growth, cost wise growth and
team could be identified .

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

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

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

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

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

5)  Cross-promotion of, or 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

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

RE: $$Excel-Macros$$ Text Cleaning

[Asa Rossoff]

Hi Sonal,

Sure --

String * length

indicates a "fixed-length string" of length number of characters in length.

 

I used it because the variable will always hold exactly one character, but
the usual "variable length string" (declared as just String) would have
worked too.

 

Asa

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of SG
Sent: Tuesday, June 05, 2012 2:34 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Text Cleaning

 

Hi Asa,

 

your code really works exact for me.Thanks for the help but can u please
explain why you have done this "Character As String * 1".
On Monday, June 4, 2012 9:14:07 PM UTC+5:30, Asa R. wrote:

I re-read your query and I see you only wanted alphabet characters.  I had
this include numbers as well. for just alphabetical characters A-Z and a-z,
here is the correction:

Function CleanText(Text As String) As String

Dim NewText As String, Character As String * 1, Position As Long

For Position = 1 To Len(Text)

Character = Mid(Text, Position, 1)

If Character Like "[A-z]" Then

NewText = NewText & Character

End If

Next Position

CleanText = NewText

End Function

 

By the way, welcome to the group!

 

Asa

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Asa Rossoff
Sent: Monday, June 04, 2012 8:38 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Text Cleaning

 

Hi Sonal,

Another function for you:

Function CleanText(Text As String) As String

Dim NewText As String, Character As String * 1, Position As Long

For Position = 1 To Len(Text)

Character = Mid(Text, Position, 1)

If Character Like "[A-z]" Or Character Like "#" Then

NewText = NewText & Character

End If

Next Position

CleanText = NewText

End Function

 

You can use this as a UDF in a worksheet formula or call it from other
macros.

 

Asa

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of sonal gupta
Sent: Monday, June 04, 2012 8:15 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Text Cleaning

 

Hi,

 

This is my first post in this group.I have learnt many things from this
group.I'm finding difficulty in cleaning the range in which each cell has
string like " rahul;6e3-".I need a macro which will clean the special
characters,spaces & numbers & leave the alphabets only.

 

Thanks in advance.

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

--
To post to this group, send email to excel-macros@googlegroups.com
 
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 confid

Re: $$Excel-Macros$$ Text Cleaning

[SG]

Rajan...Thanks for the help but still your code is returning numbers .
On Monday, June 4, 2012 9:11:22 PM UTC+5:30, Rajan_Verma wrote: 
>
>  Ah , *Cod* is just a integer type *variable* , that will hold the *ACSII 
> Code* or each character in string,
>
>  
>
>  
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *sonal
> *Sent:* 04 June 2012 9:04
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Text Cleaning
>
>  
>
> again thanks but i know how to run a macro what i was asking is 
> the explanation for "COD" that ypu have used  in your code.
> On Monday, June 4, 2012 8:59:23 PM UTC+5:30, Rajan_Verma wrote: 
>  
> Ok..
>
>  
>
> Press ALT+F11
>
> ALT + I M
>
> Paste this code there
>
>  
>
> Use Function Worksheet Like :
>
> = RemoveSpecialCharacters(YourString)
>
>  
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *sonal gupta
> *Sent:* 04 June 2012 8:58
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Text Cleaning
>
>  
>  
> Thanks rajan, but i'm new to macros..can you please explain the use of 
> "COD" in this.
>  
>  
>  
>
> On Monday, June 4, 2012 8:51:52 PM UTC+5:30, Rajan_Verma wrote:
>
>  Try this :
>
>  
>
> Public Function RemoveSpecialCharacters(Shname As String) As String
>
> Dim Cod As Integer
>
> Dim ShN As String
>
> For i = 1 To Len(Shname)
>
> Cod = Asc(Mid(Shname, i, 1))
>
> If (Cod > 47 And Cod < 58) Or (Cod > 64 And Cod < 
> 91) Or (Cod > 96 And Cod < 123) Then
>
> ShN = ShN & Mid(Shname, i, 1)
>
> End If
>
> Next
>
> RemoveSpecialCharacters = ShN
>
> End Function
>
>  
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *sonal gupta
> *Sent:* 04 June 2012 8:45
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Text Cleaning
>
>  
>  
> Hi,
>  
>  
>  
> This is my first post in this group.I have learnt many things from this 
> group.I'm finding difficulty in cleaning the range in which each cell has 
> string like " rahul;6e3-".I need a macro which will clean the special 
> characters,spaces & numbers & leave the alphabets only.
>  
>  
>  
> Thanks in advance.
>
> -- 
> FORUM RULES (986+ members already BANNED for violation)
>  
> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
> will not get quick attention or may not be answered.
>  
> 2) Don't post a question in the thread of another member.
>  
> 3) Don't post questions regarding breaking or bypassing any security 
> measure.
>  
> 4) Acknowledge the responses you receive, good or bad.
>  
> 5) Cross-promotion of, or links to, forums competitive to this forum in 
> signatures are prohibited. 
>  
> NOTE : Don't ever post personal or confidential data in a workbook. Forum 
> owners and members are not responsible for any loss.
>  
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>  
> 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 securit

Re: $$Excel-Macros$$ Text Cleaning

[SG]

Hi david.
that "e" was bymistake.I want to clean special characters & spaces & it's 
done by Asa's code.
 
thanks for your concern.
On Tuesday, June 5, 2012 6:11:41 AM UTC+5:30, David Grugeon wrote:

> Hi Sonal 
>
> I hope you realise that if you apply any of the suggested solutions to 
> your string " rahul;6e3-" you will get "rahule" not "rahul".  I hope this 
> is what you want.  If not we might need to see a greater selection of 
> strings to see if there is a pattern (like - always cut them off at the 
> first non-letter).
>
> Regards
> David Grugeon
>
> On 5 June 2012 01:28, sonal gupta  wrote:
>
>> Thanks ashish.I'll try it. 
>>
>> On Monday, June 4, 2012 8:51:06 PM UTC+5:30, ashish wrote: 
>>>
>>> Sub text_clean()
>>> Application.DisplayAlerts = False
>>> Application.Calculation = xlCalculationManual
>>> Dim cell As Range
>>> Dim str As String, text1 As String
>>> For Each cell In Selection
>>> str = ""
>>> text1 = ""
>>> str = cell.Text
>>> For i = 1 To Len(str)
>>> If (Asc(Mid(str, i, 1)) > 64 And Asc(Mid(str, i, 1)) < 90) Or 
>>> (Asc(Mid(str, i, 1)) > 96 And Asc(Mid(str, i, 1)) < 123) Then
>>> text1 = text1 & Mid(str, i, 1)
>>> End If
>>> Next i
>>> cell.Value = text1
>>> Next
>>> Application.DisplayAlerts = True
>>> Application.Calculation = xlCalculationAutomatic
>>> End Sub
>>>
>>>
>>>
>>> On Mon, Jun 4, 2012 at 8:44 PM, sonal gupta  wrote:
>>>
 Hi,
  
 This is my first post in this group.I have learnt many things from this 
 group.I'm finding difficulty in cleaning the range in which each cell has 
 string like " rahul;6e3-".I need a macro which will clean the special 
 characters,spaces & numbers & leave the alphabets only.
  
 Thanks in advance.

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

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

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

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

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

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

5)  Cross-promotion of, or 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, 

Re: $$Excel-Macros$$ Text Cleaning

[SG]

Hi Asa,
 
your code really works exact for me.Thanks for the help but can u please 
explain why you have done this "Character As String * 1".
On Monday, June 4, 2012 9:14:07 PM UTC+5:30, Asa R. wrote:

>  I re-read your query and I see you only wanted alphabet characters.  I 
> had this include numbers as well… for just alphabetical characters A-Z and 
> a-z, here is the correction:
>
> Function CleanText(Text As String) As String
>
> Dim NewText As String, Character As String * 1, Position As Long
>
> For Position = 1 To Len(Text)
>
> Character = Mid(Text, Position, 1)
>
> If Character Like "[A-z]" Then
>
> NewText = NewText & Character
>
> End If
>
> Next Position
>
> CleanText = NewText
>
> End Function
>
>  
>
> By the way, welcome to the group!
>
>  
>
> Asa
>
>  
>  
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Asa Rossoff
> *Sent:* Monday, June 04, 2012 8:38 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* RE: $$Excel-Macros$$ Text Cleaning
>
>  
>
> Hi Sonal,
>
> Another function for you:
>
> Function CleanText(Text As String) As String
>
> Dim NewText As String, Character As String * 1, Position As Long
>
> For Position = 1 To Len(Text)
>
> Character = Mid(Text, Position, 1)
>
> If Character Like "[A-z]" Or Character Like "#" Then
>
> NewText = NewText & Character
>
> End If
>
> Next Position
>
> CleanText = NewText
>
> End Function
>
>  
>
> You can use this as a UDF in a worksheet formula or call it from other 
> macros.
>
>  
>
> Asa
>
>  
>  
> *From:* excel-macros@googlegroups.com [
> mailto:excel-macros@googlegroups.com ] *On 
> Behalf Of *sonal gupta
> *Sent:* Monday, June 04, 2012 8:15 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Text Cleaning
>
>  
>  
> Hi,
>  
>  
>  
> This is my first post in this group.I have learnt many things from this 
> group.I'm finding difficulty in cleaning the range in which each cell has 
> string like " rahul;6e3-".I need a macro which will clean the special 
> characters,spaces & numbers & leave the alphabets only.
>  
>  
>  
> Thanks in advance.
>
> -- 
> FORUM RULES (986+ members already BANNED for violation)
>  
> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
> will not get quick attention or may not be answered.
>  
> 2) Don't post a question in the thread of another member.
>  
> 3) Don't post questions regarding breaking or bypassing any security 
> measure.
>  
> 4) Acknowledge the responses you receive, good or bad.
>  
> 5) Cross-promotion of, or links to, forums competitive to this forum in 
> signatures are prohibited. 
>  
> NOTE : Don't ever post personal or confidential data in a workbook. Forum 
> owners and members are not responsible for any loss.
>  
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>  
> 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.

--

Re: $$Excel-Macros$$ Need a Email Macro based on the Cell time

[Darwin Chan]

http://www.teachexcel.com/excel-help/excel-how-to.php?i=447580#3


2012/6/5 Darwin Chan 

> Dear,
>
> I am not an expert, but see if the below page can give you some idea.
>
> Darwin
>
> 2012/6/5 Puttu * 
>
>> Experts,
>>
>> Can you have look on my requirements and provide the solution.
>>
>> On Mon, Jun 4, 2012 at 12:19 AM, Puttu *  wrote:
>>
>>> Hi Excel Experts,
>>>
>>> Need a help on the macro for automated email reminders. below is the
>>> requirements. Attached is sheet for your reference
>>>
>>>
>>>  Need a macro based on the given date and time in 1st, 2nd & Final
>>> reminder columns to all the email ID  Subject mail should be content of
>>> cell text in the column B  This Task list shouldn't be limited to only
>>> for row 6 it should be never ending (B:B)  If Any Case column F status
>>> changed to Completed, after the 1st or 2 or Final Reminder, then there
>>> would be no more reminder mails
>>> Please help me on this. Appreciated all you support
>>>
>>> --
>>> Putta
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or 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
>>
>>
>>
>>
>> --
>> Putta
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
>
>
> --
> Best Regards,
> Darwin Chan
> darwin.chankaw...@gmail.com
> kw42c...@yahoo.com.hk
>
>


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

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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Need a Email Macro based on the Cell time

[Darwin Chan]

Dear,

I am not an expert, but see if the below page can give you some idea.

Darwin

2012/6/5 Puttu * 

> Experts,
>
> Can you have look on my requirements and provide the solution.
>
> On Mon, Jun 4, 2012 at 12:19 AM, Puttu *  wrote:
>
>> Hi Excel Experts,
>>
>> Need a help on the macro for automated email reminders. below is the
>> requirements. Attached is sheet for your reference
>>
>>
>>  Need a macro based on the given date and time in 1st, 2nd & Final
>> reminder columns to all the email ID  Subject mail should be content of
>> cell text in the column B  This Task list shouldn't be limited to only
>> for row 6 it should be never ending (B:B)  If Any Case column F status
>> changed to Completed, after the 1st or 2 or Final Reminder, then there
>> would be no more reminder mails
>> Please help me on this. Appreciated all you support
>>
>> --
>> Putta
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or 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
>
>
>
>
> --
> Putta
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



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

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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ unhide all sheet

[Shaik Waheed]

Hi,

You can use the following code, i had been using this..

Sub unhide_sheets()
 Dim ws As Worksheet
 For Each ws In ActiveWorkbook.Worksheets
 ws.Visible = True
 Next ws
 End Sub

On Tue, Jun 5, 2012 at 1:33 PM, jayendra gaurav
wrote:

> Dear Team,
>
> I required your support to unhide  20 sheets in single go.
>
> kindly support me .
>
> --
> J.Gaurav
> Call-7838594954
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or 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$$ Records found but unable to get proper result.

[Sourabh Salgotra]

many many thanks ashish sir for helping me. i am also done it with the
following formula

=IFERROR(INDEX(Table1[SUBCODE],SMALL(IF(COURSES!$A$2:$A$804=LIST!$E$1,ROW(INDIRECT("1:803")),""),ROW()-34)),"")


but sir your method is simpler than me now i am following your method.




On Mon, Jun 4, 2012 at 8:59 PM, ashish koul  wrote:

>
> see if it helps
>
>
> On Mon, Jun 4, 2012 at 8:48 PM, Sourabh Salgotra wrote:
>
>> Dear Sir,
>>
>>i have little knowledge about vba. that's why i am asking sol
>> with index/match.
>>
>> and plz tell me abt offset function also.
>>
>>
>>
>> On Sun, Jun 3, 2012 at 11:42 PM, pawel lupinski wrote:
>>
>>> Don,
>>>
>>> love it (great reply)  :)
>>>
>>> Pawel
>>>
>>>   --
>>> *From:* dguillett1 
>>> *To:* excel-macros@googlegroups.com
>>> *Sent:* Sunday, June 3, 2012 6:55 PM
>>>
>>> *Subject:* Re: $$Excel-Macros$$ Records found but unable to get proper
>>> result.
>>>
>>>   I like my solution.
>>>
>>> Don Guillett
>>> Microsoft MVP Excel
>>> SalesAid Software
>>> dguille...@gmail.com
>>>
>>>  *From:* Sourabh Salgotra 
>>> *Sent:* Sunday, June 03, 2012 12:53 PM
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* Re: $$Excel-Macros$$ Records found but unable to get proper
>>> result.
>>>
>>> thanks for help.
>>>
>>> plz provide index/atch solution also
>>>
>>> On Sun, Jun 3, 2012 at 6:35 PM, dguillett1  wrote:
>>>
>>>   How about a nice macro? Change your formatting and use in macro
>>> enabled workbook
>>>
>>> Sub filtercopy()
>>> With Sheets("COURSES").UsedRange
>>>   .AutoFilter Field:=1 'criteria IF needed
>>>   .AutoFilter Field:=2
>>>   .AutoFilter Field:=3, Criteria1:=Sheets("form").Range("n1")
>>>   .Offset(1, 3).Resize(, 2).SpecialCells(xlVisible). _
>>>Copy Sheets("form").Range("d35")
>>> End With
>>> End Sub
>>>
>>>
>>>
>>> Don Guillett
>>> Microsoft MVP Excel
>>> SalesAid Software
>>> dguille...@gmail.com
>>>
>>>  *From:* Sourabh Salgotra 
>>> *Sent:* Sunday, June 03, 2012 5:08 AM
>>> *To:* excel-macros@googlegroups.com
>>> *Cc:* Don Guillett  ; rajanverma1...@gmail.com ;
>>> noorain.ans...@gmail.com
>>> *Subject:* $$Excel-Macros$$ Records found but unable to get proper
>>> result.
>>>
>>>
>>> Dear sir,
>>>i am using index/match formula. in my problem i am getting
>>> the 1st occurrence result only.
>>> Sr. No. Subject Code Subject/Paper code 1 BF 1 MATHEMATICS I
>>> 2 #NUM! #NUM! 3 #NUM! #NUM! 4 #NUM! #NUM! 5
>>> #NUM! #NUM! 6 #NUM! #NUM! 7 #NUM! #NUM! 8 #NUM!
>>> #NUM! 9 #NUM! #NUM!
>>>
>>>
>>> i want the output like this.
>>>
>>>Sr. No. Subject Code Subject/Paper code 1 BF 1 MATHEMATICS 2 BF
>>> 2 CHEMISTRY 3 BF 3 ENGLISH I 4 BF 4 ELECTRICAL
>>> TECHNOLOGY 5 BF 5 MECHANICS 6 BF 6 INTRODUCTION TO
>>> MANUFACTURING PROCESS 7 BF 2P CHEMISTRY PRACTICAL 8 BF
>>> 4P ELECTICAL TECHNOLOGY PRACTICAL 9 BF 7 INDIAN CONSTITUTION
>>> AND ETHICS
>>> 
>>>
>>> sample sheet attached
>>>
>>> Thanks & Regards
>>> Sourabh
>>> Contact Numbers: +91-94630-49202
>>>
>>>
>>

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

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

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

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

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

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

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

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

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

$$Excel-Macros$$ unhide all sheet

[jayendra gaurav]

Dear Team,

I required your support to unhide  20 sheets in single go.

kindly support me .

-- 
J.Gaurav
Call-7838594954

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

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

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

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

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

5)  Cross-promotion of, or 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 a Email Macro based on the Cell time

[Puttu *]

Experts,

Can you have look on my requirements and provide the solution.

On Mon, Jun 4, 2012 at 12:19 AM, Puttu *  wrote:

> Hi Excel Experts,
>
> Need a help on the macro for automated email reminders. below is the
> requirements. Attached is sheet for your reference
>
>
>  Need a macro based on the given date and time in 1st, 2nd & Final
> reminder columns to all the email ID  Subject mail should be content of
> cell text in the column B  This Task list shouldn't be limited to only
> for row 6 it should be never ending (B:B)  If Any Case column F status
> changed to Completed, after the 1st or 2 or Final Reminder, then there
> would be no more reminder mails
> Please help me on this. Appreciated all you support
>
> --
> Putta
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or 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




-- 
Putta

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

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

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

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

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

5)  Cross-promotion of, or 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$$ Rajan Verma - Most helpful Member(May'12)

[Indrajit $nai]

Congrats Rajan. :D

On Mon, Jun 4, 2012 at 6:06 PM, Rajan_Verma wrote:

> Thank you all J
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *resp...@gmail.com
> *Sent:* 04 June 2012 12:18
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(May'12)*
> ***
>
> ** **
>
> Congratulation Raj. Proud of you. Lunch for you tommorrow. 
>
> Sent from my BlackBerry® smartphone from Airtel Ghana
> --
>
> *From: *Ayush Jain  
>
> *Sender: *excel-macros@googlegroups.com 
>
> *Date: *Sun, 3 Jun 2012 23:12:31 +0530
>
> *To: *excel-macros
>
> *ReplyTo: *excel-macros@googlegroups.com 
>
> *Subject: *$$Excel-Macros$$ Rajan Verma - Most helpful Member(May'12)
>
> ** **
>
> Hello Everyone,
>
> Rajan Verma has been selected as 'Most Helpful Member' for the month of
> May'2012
> He has posted 147 posts in May 2012 and helped many people through his
> expertise.  
>
>  
>
> I truly appreciate his consistency and commitment to group. He is really
> doing great job God bless you :)
>
>
> Thanks to Noorain, Don, Asa, Maries, and other folks for helping excel
> enthusiasts voluntarily !! Keep it up !!
>
> Trust me, It requires big heart to help others voluntarily and thanks to
> everyone who is supporting this forum. 
>
>
> Keep posting.
>
> Regards
> Ayush Jain
> Group Manager
> Microsoft MVP 
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com 
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

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

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

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

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

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

5)  Cross-promotion of, or