FW: $$Excel-Macros$$ need formula Highlight

[Manjunath Narayanappa]

Dear Prince,

I'm keen to learn this.  please teach me.

Thanks
Manjunath

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Manjunath Narayanappa
Sent: 18 January 2013 08:09
To: 'excel-macros@googlegroups.com'
Cc: 'Prince'
Subject: $$Excel-Macros$$ need formula Highlight

Dear Prince,

Thank you very much. Can you please teach me how to execute on 2007 excel
 Await your assistance

Regards
Manjunath

From: Prince [mailto:prince141...@gmail.com]
Sent: 17 January 2013 16:32
To: excel-macros@googlegroups.com
Cc: Manjunath Narayanappa
Subject: Re: FW: $$Excel-Macros$$ need formula Highlight

Hi Manjunath,

PFA,

Regards
Prince

On Thursday, January 17, 2013 6:41:46 PM UTC+5:30, Manjunath Narayanappa wrote:
Dear all,

Please can I get macro for below requests

Regards
Manjunath


From: excel-...@googlegroups.com [mailto:excel-...@googlegroups.com] On Behalf 
Of Manjunath Narayanappa
Sent: 17 January 2013 08:47
To: 'excel-...@googlegroups.com'
Subject: $$Excel-Macros$$ need formula Highlight

Dear Expert,

Good afternoon  have a nice day :)

I have a data in the attached spreadsheet, automatically data in B column 
should get highlighted when there is a duplicate or repeated entry.

Please help me on this.

Thanks
Manjunath



PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL



For Aon's standard conditions associated with this e-mail please visit 
http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp

Aon UK Limited

Registered Office: 8 Devonshire Square, London EC2M 4PL

Registered in London No. 210725 . VAT Registration No. 480 8401 48



Aon UK Limited is authorised and regulated by the Financial Services Authority 
in respect of insurance mediation activities only.
--
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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

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





PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL



For Aon's standard conditions associated with this e-mail please visit 
http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp

Aon UK Limited

Registered Office: 8 Devonshire Square, London EC2M 4PL

Registered in London No. 210725 . VAT Registration No. 480 8401 48



Aon UK Limited is authorised and regulated by the Financial Services Authority 
in respect of insurance mediation activities only.



PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL



For Aon's standard conditions associated with this e-mail please visit 
http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp

Aon UK Limited

Registered Office: 8 Devonshire Square, London EC2M 4PL

Registered in London No. 210725 . VAT Registration No. 480 8401 48



Aon UK Limited is authorised and regulated by the Financial Services Authority 
in respect of insurance mediation activities only.
--
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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

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





PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL



For Aon's standard conditions associat

Re: FW: $$Excel-Macros$$ need formula Highlight

[Prince]

Hi Manjunath,

Please see this if this can help you.

http://www.free-training-tutorial.com/conditional-formatting.html

Regards
Prince

Manjunath 

On Tuesday, January 22, 2013 4:54:11 PM UTC+5:30, Manjunath Narayanappa 
wrote:
>
>  Thank you very much. I was not knowing abt conditional formatting.
>
> Is there any link to learn more abt Conditional formatting
>
>  
>
> Regarda
>
> Manjunath
>
>  
>  
> *From:* excel-...@googlegroups.com  [mailto:
> excel-...@googlegroups.com ] *On Behalf Of *Kuldeep Singh
> *Sent:* 22 January 2013 10:05
> *To:* excel-...@googlegroups.com 
> *Subject:* Re: FW: $$Excel-Macros$$ need formula Highlight
>  
>  
>  
>  
>  
> 1st Conditional Formatting:
>  
>  
>  
> [image: Inline image 1]
>  
> 2nd Conditional Formatting Rules Manager:
>  
>  
>  
> [image: Inline image 2]
>  
>  
>   
> Regards,
> Kuldeep Singh
>  
> Info Edge India Limited (naukri.com)
>  
> Phone.: +91-120-4763789, Extn.: 789,9716615535
> naukri...@gmail.com  || www.naukri.com
> *Please* *Consider the environment. Please don't print this e-mail unless 
> you really need to.*
>  
>  
>   
> On Tue, Jan 22, 2013 at 3:02 PM, Manjunath Narayanappa <
> manjunath@aon.co.uk > wrote:
>  
> Dear Prince,
>
>  
>
> I'm keen to learn this.  please teach me.
>
>  
>
> Thanks
>
> Manjunath
>
>  
>  
> *From:* excel-...@googlegroups.com  [mailto:
> excel-...@googlegroups.com ] *On Behalf Of *Manjunath 
> Narayanappa
> *Sent:* 18 January 2013 08:09
> *To:* 'excel-...@googlegroups.com '
> *Cc:* 'Prince'
>  
>
> *Subject:* $$Excel-Macros$$ need formula Highlight
>
>  
>  
> Dear Prince,
>
>  
>
> Thank you very much. Can you please teach me how to execute on 2007 excel
>
>  Await your assistance
>
>  
>
> Regards
>
> Manjunath
>
>  
>  
> *From:* Prince [mailto:prince...@gmail.com ] 
> *Sent:* 17 January 2013 16:32
> *To:* excel-...@googlegroups.com 
> *Cc:* Manjunath Narayanappa
> *Subject:* Re: FW: $$Excel-Macros$$ need formula Highlight
>  
>  
>
> Hi Manjunath,
>  
>  
>  
> PFA,
>  
>  
>  
> Regards
>  
> Prince
>
> On Thursday, January 17, 2013 6:41:46 PM UTC+5:30, Manjunath Narayanappa 
> wrote:
>  
> Dear all,
>
>  
>
> Please can I get macro for below requests
>
>  
>
> Regards
>
> Manjunath
>
>  
>
>  
>  
> *From:* excel-...@googlegroups.com [mailto:excel-...@googlegroups.com] *On 
> Behalf Of *Manjunath Narayanappa
> *Sent:* 17 January 2013 08:47
> *To:* 'excel-...@googlegroups.com'
> *Subject:* $$Excel-Macros$$ need formula Highlight
>  
>  
>  
> Dear Expert,
>
>  
>
> Good afternoon  have a nice day :)
>
>  
>
> I have a data in the attached spreadsheet, automatically data in B column 
> should get highlighted when there is a duplicate or repeated entry.
>
>  
>
> Please help me on this.
>
>  
>
> Thanks
>
> Manjunath
>  
>  
>  --
>  
>
> PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL
>
>
>
> For Aon’s standard conditions associated with this e-mail please visit 
> http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp
>
> Aon UK Limited
>
> Registered Office: 8 Devonshire Square, London EC2M 4PL
>
> Registered in London No. 210725 . VAT Registration No. 480 8401 48
>
>
>
> Aon UK Limited is authorised and regulated by the Financial Services 
> Authority in respect of insurance mediation activities only.
>
> -- 
> Join official Facebook page of this forum @ 
> https://www.facebook.com/discussexcel
>  
> FORUM RULES
>  
> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security 
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>  
> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
> members are not responsible for any loss.
> --- 
> You received this message because you are subscribed to the Google Groups 
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-...@googlegroups.com.
> To unsubscribe from this group, send email to 
> excel-macros...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>  
>  
>  
>  
>  --
>  
>
> PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL
>
>
>
> For Aon’s standard conditions associated with this e-mail please visit 
> http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp
>
> Aon UK Limited
>
> Registered Office: 8 Devonshire Square, London EC2M 4PL
>
> Registered in London No. 210725 . VAT Registration No. 480 8401 48
>
>
>
> Aon UK Limited is authorised and regulated by the Financial Services 
> Authority in respect of insurance mediation activities only.
>   
>  
>  --
>  

Re: FW: $$Excel-Macros$$ need formula Highlight

[Kuldeep Singh]

Hi Manjunath,

See below pdf. I hope it will help you.

*http://ide20.com/upload/ModuleAE/Lesson01.pdf*
*http://ide20.com/upload/ModuleAE/Lesson02.pdf*
*http://ide20.com/upload/ModuleAE/Lesson03.pdf*
*http://ide20.com/upload/ModuleAE/Lesson04.pdf*

http://lis.dickinson.edu/technology/training/Tutorials/2010/excel/excel_cond_format.pdf
http://wbc.fit.edu/courses/longcourses/home/Microsoft%20Excel/Conditional%20Formatting.pdf
http://pd.clcillinois.edu/manuals/clctech/Excel/Excel_2010_Unit_3_PG.pdf
http://chandoo.org/wp/tag/conditional-formatting/

Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.: +91-120-4763789, Extn.: 789,9716615535
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*
*
*
On Tue, Jan 22, 2013 at 4:59 PM, Prince  wrote:

> Hi Manjunath,
>
> Please see this if this can help you.
>
> http://www.free-training-tutorial.com/conditional-formatting.html
>
> Regards
> Prince
>
> Manjunath
>
>
> On Tuesday, January 22, 2013 4:54:11 PM UTC+5:30, Manjunath Narayanappa
> wrote:
>
>>  Thank you very much. I was not knowing abt conditional formatting.
>>
>> Is there any link to learn more abt Conditional formatting
>>
>>
>>
>> Regarda
>>
>> Manjunath
>>
>>
>>
>> *From:* excel-...@googlegroups.com [mailto:excel-...@**googlegroups.com]
>> *On Behalf Of *Kuldeep Singh
>>
>> *Sent:* 22 January 2013 10:05
>> *To:* excel-...@googlegroups.com
>>
>> *Subject:* Re: FW: $$Excel-Macros$$ need formula Highlight
>>
>>
>>
>>
>>
>> 1st Conditional Formatting:
>>
>>
>>
>> [image: Inline image 1]
>>
>> 2nd Conditional Formatting Rules Manager:
>>
>>
>>
>> [image: Inline image 2]
>>
>>
>>
>> Regards,
>> Kuldeep Singh
>>
>> Info Edge India Limited (naukri.com)
>>
>> Phone.: +91-120-4763789, Extn.: 789,9716615535
>> naukri...@gmail.com || www**.naukri.com 
>>
>> *Please* *Consider the environment. Please don't print this e-mail
>> unless you really need to.*
>>
>>
>>
>> On Tue, Jan 22, 2013 at 3:02 PM, Manjunath Narayanappa <
>> manjunath@aon.co.**uk> wrote:
>>
>> Dear Prince,
>>
>>
>>
>> I'm keen to learn this.  please teach me.
>>
>>
>>
>> Thanks
>>
>> Manjunath
>>
>>
>>
>> *From:* excel-...@googlegroups.com [mailto:excel-...@**googlegroups.com]
>> *On Behalf Of *Manjunath Narayanappa
>>
>> *Sent:* 18 January 2013 08:09
>> *To:* 'excel-...@googlegroups.com**'
>> *Cc:* 'Prince'
>>
>>
>> *Subject:* $$Excel-Macros$$ need formula Highlight
>>
>>
>>
>> Dear Prince,
>>
>>
>>
>> Thank you very much. Can you please teach me how to execute on 2007 excel
>>
>>  Await your assistance
>>
>>
>>
>> Regards
>>
>> Manjunath
>>
>>
>>
>> *From:* Prince [mailto:prince...@gmail.com**]
>> *Sent:* 17 January 2013 16:32
>> *To:* excel-...@googlegroups.com
>>
>> *Cc:* Manjunath Narayanappa
>> *Subject:* Re: FW: $$Excel-Macros$$ need formula Highlight
>>
>>
>>
>> Hi Manjunath,
>>
>>
>>
>> PFA,
>>
>>
>>
>> Regards
>>
>> Prince
>>
>> On Thursday, January 17, 2013 6:41:46 PM UTC+5:30, Manjunath Narayanappa
>> wrote:
>>
>> Dear all,
>>
>>
>>
>> Please can I get macro for below requests
>>
>>
>>
>> Regards
>>
>> Manjunath
>>
>>
>>
>>
>>
>> *From:* excel-...@googlegroups.com [mailto:excel-...@**googlegroups.com]
>> *On Behalf Of *Manjunath Narayanappa
>> *Sent:* 17 January 2013 08:47
>> *To:* 'excel-...@googlegroups.com'
>> *Subject:* $$Excel-Macros$$ need formula Highlight
>>
>>
>>
>> Dear Expert,
>>
>>
>>
>> Good afternoon  have a nice day :)
>>
>>
>>
>> I have a data in the attached spreadsheet, automatically data in B column
>> should get highlighted when there is a duplicate or repeated entry.
>>
>>
>>
>> Please help me on this.
>>
>>
>>
>> Thanks
>>
>> Manjunath
>>
>>
>>  --
>>
>>
>> PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL
>>
>>
>>
>> For Aon’s standard conditions associated with this e-mail please visit
>> http://www.aon.com/uk/en/**email-footer/aon-uk-limited.**jsp
>>
>> Aon UK Limited
>>
>> Registered Office: 8 Devonshire Square, London EC2M 4PL
>>
>> Registered in London No. 210725 . VAT Registration No. 480 8401 48
>>
>>
>>
>> Aon UK Limited is authorised and regulated by the Financial Services
>> Authority in respect of insurance mediation activities only.
>>
>> --
>> Join official Facebook page of this forum @ https://www.facebook.com/**
>> discussexcel 
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not al

Re: $$Excel-Macros$$ Re: VBA Solution Requried

[amar takale]

Dear Shekhar,
This solution is beyond my expectation. Great work Boss. Thanks a lot.

One more solution for in my sheet there are data validation if I
select sector & click GO button then show only that sector company not
other sector company bcos then I concentrate only that specific
sector.If possible guide me.

Regards
Amar


On Tue, Jan 22, 2013 at 5:07 PM, Shekhar  wrote:
> Hi Amar,
>
> Please find attached spreadsheet that has more flexible sorting method.
> Please let me know for further info.
>
>
> thanks and regards,
> Shekhar
>
>
> On Monday, 21 January 2013 19:00:58 UTC+5:30, amar takale wrote:
>>
>> Hi All Experts,
>> All of you request of my solution,Can we sort data
>> Alphabetically,sector wise,price wise.IF I have 100 companies then I
>> want to create VBA Code Button on that data.when I click sector then
>> show all that sector companies as it other.I know it is very time
>> consuming work for VBA coding but if anyone suggest me this VBA code
>> button I am very much thankful.
>> Thank you all for your help. I greatly appreciated it.
>> Regards
>> Amar
>
> --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Re: VBA Solution Requried

[amar takale]

Hi Shekhar,
Can you explain me how to do it.I try it separate file with same
data.I insert same 6 arrow but which macro to asign it.It is two
code.How arrow move up & down.I insert only UP arrow
Pls explain me it is very useful to routine work
Appreciate the help
Amar

On Tue, Jan 22, 2013 at 5:27 PM, amar takale  wrote:
> Dear Shekhar,
> This solution is beyond my expectation. Great work Boss. Thanks a lot.
>
> One more solution for in my sheet there are data validation if I
> select sector & click GO button then show only that sector company not
> other sector company bcos then I concentrate only that specific
> sector.If possible guide me.
>
> Regards
> Amar
>
>
> On Tue, Jan 22, 2013 at 5:07 PM, Shekhar  wrote:
>> Hi Amar,
>>
>> Please find attached spreadsheet that has more flexible sorting method.
>> Please let me know for further info.
>>
>>
>> thanks and regards,
>> Shekhar
>>
>>
>> On Monday, 21 January 2013 19:00:58 UTC+5:30, amar takale wrote:
>>>
>>> Hi All Experts,
>>> All of you request of my solution,Can we sort data
>>> Alphabetically,sector wise,price wise.IF I have 100 companies then I
>>> want to create VBA Code Button on that data.when I click sector then
>>> show all that sector companies as it other.I know it is very time
>>> consuming work for VBA coding but if anyone suggest me this VBA code
>>> button I am very much thankful.
>>> Thank you all for your help. I greatly appreciated it.
>>> Regards
>>> Amar
>>
>> --
>> Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
>> not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Fwd: Excel Spellcheck Help.

[saravanan R]

Hi Frnds,

Any Idea for the given below Reuqest?


*Thanks & Regards,*

*Saravanan R*

*BDI India Private Limited*

“Shreeshyla”, Doddakallasandra,

Kanakapura Road, Bangalore 560 062 INDIA

Ph: 91-80-22560418/19

Fax: 91-80-22560420

Cell: +919449716334

sarava...@bdi-india.com

* *

[image: BDI 75 yr]

*www.bdiworldwide.com*

On Mon, Jan 21, 2013 at 2:44 PM, saravanan R  wrote:

>  Hi Excites,
>
> ** **
>
> ** **
>
> I need your help on using the Spell check in the Excel File.
>
> I have around 4 line items, where I want to use the spell check for
> the complete Column. If I go through the Spell Check Process (Press F7), *
> ***
>
> there are some words which are don’t correct require no changes(Ignore
> all) but some words require changes. 
>
> In this case I want to mark out those word in the adjacent(Separate)
> column.
>
> **
>
> ** **
>
> *Thanks & Regards,*
>
> *Saravanan R*
>
> *BDI India Private Limited*
>
> “Shreeshyla”, Doddakallasandra,
>
> Kanakapura Road, Bangalore 560 062 INDIA
>
> Ph: 91-80-22560418/19
>
> Fax: 91-80-22560420
>
> Cell: +919449716334
>
> sarava...@bdi-india.com
>
> *  *
>
> [image: BDI 75 yr]
>
>  *www.bdiworldwide.com***
>
> ** **
>
>  --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>

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

FORUM RULES

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

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


<>

Re: $$Excel-Macros$$ Re: VBA Solution Requried

[Shekhar Pujari]

In that sheet there are 12 arrows. 6 represents up arrow and 6 are down. As
of now, there are 6 hidden arrow as to suit your sort criteria.

thanks and regards,
Shekhar
On Tue, Jan 22, 2013 at 5:40 PM, amar takale  wrote:

> Hi Shekhar,
> Can you explain me how to do it.I try it separate file with same
> data.I insert same 6 arrow but which macro to asign it.It is two
> code.How arrow move up & down.I insert only UP arrow
> Pls explain me it is very useful to routine work
> Appreciate the help
> Amar
>
> On Tue, Jan 22, 2013 at 5:27 PM, amar takale  wrote:
> > Dear Shekhar,
> > This solution is beyond my expectation. Great work Boss. Thanks a lot.
> >
> > One more solution for in my sheet there are data validation if I
> > select sector & click GO button then show only that sector company not
> > other sector company bcos then I concentrate only that specific
> > sector.If possible guide me.
> >
> > Regards
> > Amar
> >
> >
> > On Tue, Jan 22, 2013 at 5:07 PM, Shekhar 
> wrote:
> >> Hi Amar,
> >>
> >> Please find attached spreadsheet that has more flexible sorting method.
> >> Please let me know for further info.
> >>
> >>
> >> thanks and regards,
> >> Shekhar
> >>
> >>
> >> On Monday, 21 January 2013 19:00:58 UTC+5:30, amar takale wrote:
> >>>
> >>> Hi All Experts,
> >>> All of you request of my solution,Can we sort data
> >>> Alphabetically,sector wise,price wise.IF I have 100 companies then I
> >>> want to create VBA Code Button on that data.when I click sector then
> >>> show all that sector companies as it other.I know it is very time
> >>> consuming work for VBA coding but if anyone suggest me this VBA code
> >>> button I am very much thankful.
> >>> Thank you all for your help. I greatly appreciated it.
> >>> Regards
> >>> Amar
> >>
> >> --
> >> Join official Facebook page of this forum @
> >> https://www.facebook.com/discussexcel
> >>
> >> FORUM RULES
> >>
> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will
> >> not get quick attention or may not be answered.
> >> 2) Don't post a question in the thread of another member.
> >> 3) Don't post questions regarding breaking or bypassing any security
> >> measure.
> >> 4) Acknowledge the responses you receive, good or bad.
> >> 5) Jobs posting is not allowed.
> >> 6) Sharing copyrighted material and their links is not allowed.
> >>
> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> >> members are not responsible for any loss.
> >> ---
> >> You received this message because you are subscribed to the Google
> Groups
> >> "MS EXCEL AND VBA MACROS" group.
> >> To post to this group, send email to excel-macros@googlegroups.com.
> >> To unsubscribe from this group, send email to
> >> excel-macros+unsubscr...@googlegroups.com.
> >> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> >>
> >>
>
> --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE  : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>


-- 

thanks and regards,
-Shekhar

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

FORUM RULES

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

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

$$Excel-Macros$$ Formaula to calculate Turnaround time excluding non working hours

[Amit Desai (MERU)]

Dear All,

I need a small formula to calculate Turnaround time excluding non working hours 
(in this example - working hours is 09:30 AM to 18:30 PM).

Cab No.

In Time

Out Time

TAT

DL1RY1234

22-01-2013 10:00

23-01-2013 15:30

16:30:00

Need this with Formula



Please help.

Best Regards,
Amit Desai



Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.

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

FORUM RULES

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

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

$$Excel-Macros$$ Consolidate data from 31 sheets to one master sheet

[Rajesh thrissur]

Hi Experts,

Is there any method to consolidate data from many worksheets to one
master worksheet, here I  attached a simple work book it have only 5
data sheets and 1 master sheet. being data is very less I solve it
with just adding data from reference cells but when data is more this
method is not practical. If there is any special method pls advise me.

with Regards

Rajesh Kainikkara

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

FORUM RULES

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

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




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

Re: $$Excel-Macros$$ Consolidate data from 31 sheets to one master sheet

[Paul Schreiner]

Because no two people have the same file format or requirements, there really 
isn't a single solution to fit all needs.

HOWEVER:

IF all of the data sheets are in the same format and
IF all of the data sheets have all entries

Basically, if the value for "Cola" "Op STK" is always in cell C2
or even more basic:

each of your 31 sheets is made from the same "template"
so that all ITEMS are listed in the same row on all sheets..

Then, here's what I did in Excel 2010.
(I THINK it works in earlier versions)

First, make sure your "Consolidated" sheet is either the first or the last 
sheet 
of your workbook.

In your "Consolidated" sheet, select cell C7 (Cola, Op Stk)
type =sum(
then select the first sheet (01)
hold down the shift key and select the last sheet (05 in the sample)
(Be sure to NOT include the Consolidated sheet)
 
This will input:
=sum('01:05'!
in the cell
Your first sheet should be displayed (01)
click in the "Cola, Op STK" cell (C2)

then type a closing parenthesis.

You should end up with:
=SUM('01:05'!C2)

This will sum all of contents of cell C2 in each of your sheets.
copy/drag this formula across the columns, then down the rows
and you should have your consolidation sheet.

let me know how it works.


Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-





From: Rajesh thrissur 
To: excel-macros 
Sent: Tue, January 22, 2013 7:36:40 AM
Subject: $$Excel-Macros$$ Consolidate data from 31 sheets to one master sheet

Hi Experts,

Is there any method to consolidate data from many worksheets to one
master worksheet, here I  attached a simple work book it have only 5
data sheets and 1 master sheet. being data is very less I solve it
with just adding data from reference cells but when data is more this
method is not practical. If there is any special method pls advise me.

with Regards

Rajesh Kainikkara

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

FORUM RULES

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

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

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Consolidate data from 31 sheets to one master sheet

[kasper]

Hi Paul

Thanks for the idea you gave. Is there any way to add date criteria also 
there eg: 01/01/13 to 05/01/13 or 01/01/13 to 10/01/13.


With regards and thanks

Rajesh kainikkara

On Tuesday, January 22, 2013 6:28:14 PM UTC+5:30, Paul Schreiner wrote:
>
> Because no two people have the same file format or requirements, there 
> really isn't a single solution to fit all needs.
>  
> HOWEVER:
>  
> IF all of the data sheets are in the same format and
> IF all of the data sheets have all entries
> Basically, if the value for "Cola" "Op STK" is always in cell C2
> or even more basic:
>  
> each of your 31 sheets is made from the same "template"
> so that all ITEMS are listed in the same row on all sheets..
>  
> Then, here's what I did in Excel 2010.
> (I THINK it works in earlier versions)
>  
> First, make sure your "Consolidated" sheet is either the first or the last 
> sheet of your workbook.
>  
> In your "Consolidated" sheet, select cell C7 (Cola, Op Stk)
> type =sum(
> then select the first sheet (01)
> hold down the shift key and select the last sheet (05 in the sample)
> (Be sure to NOT include the Consolidated sheet)
>  
> This will input:
> =sum('01:05'!
> in the cell
> Your first sheet should be displayed (01)
> click in the "Cola, Op STK" cell (C2)
>  
> then type a closing parenthesis.
>  
> You should end up with:
> =SUM('01:05'!C2)
>  
> This will sum all of contents of cell C2 in each of your sheets.
> copy/drag this formula across the columns, then down the rows
> and you should have your consolidation sheet.
>  
> let me know how it works.
>  
>  
>
> *Paul*
>
> -
> *“Do all the good you can,
> By all the means you can,
> In all the ways you can,
> In all the places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> *-
>
>
>  --
> *From:* Rajesh thrissur >
> *To:* excel-macros >
> *Sent:* Tue, January 22, 2013 7:36:40 AM
> *Subject:* $$Excel-Macros$$ Consolidate data from 31 sheets to one master 
> sheet
>
> Hi Experts,
>
> Is there any method to consolidate data from many worksheets to one
> master worksheet, here I  attached a simple work book it have only 5
> data sheets and 1 master sheet. being data is very less I solve it
> with just adding data from reference cells but when data is more this
> method is not practical. If there is any special method pls advise me.
>
> with Regards
>
> Rajesh Kainikkara
>
> -- 
> Join official Facebook page of this forum @ 
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security 
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
> members are not responsible for any loss.
> --- 
> You received this message because you are subscribed to the Google Groups 
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-...@googlegroups.com
> .
> To unsubscribe from this group, send email to excel-macros+
> unsub...@googlegroups.com .
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Re: VBA Solution Requried

[amar takale]

Hi shekhar,
Thanks for explain.I got all hidden arrow by changing in VBA code
False.but yet I confused that Now I saw 12 arrow but which code assign
that all arrow.Pls tell me
Amar

On Tue, Jan 22, 2013 at 5:52 PM, Shekhar Pujari
 wrote:
> In that sheet there are 12 arrows. 6 represents up arrow and 6 are down. As
> of now, there are 6 hidden arrow as to suit your sort criteria.
>
> thanks and regards,
> Shekhar
> On Tue, Jan 22, 2013 at 5:40 PM, amar takale  wrote:
>>
>> Hi Shekhar,
>> Can you explain me how to do it.I try it separate file with same
>> data.I insert same 6 arrow but which macro to asign it.It is two
>> code.How arrow move up & down.I insert only UP arrow
>> Pls explain me it is very useful to routine work
>> Appreciate the help
>> Amar
>>
>> On Tue, Jan 22, 2013 at 5:27 PM, amar takale  wrote:
>> > Dear Shekhar,
>> > This solution is beyond my expectation. Great work Boss. Thanks a lot.
>> >
>> > One more solution for in my sheet there are data validation if I
>> > select sector & click GO button then show only that sector company not
>> > other sector company bcos then I concentrate only that specific
>> > sector.If possible guide me.
>> >
>> > Regards
>> > Amar
>> >
>> >
>> > On Tue, Jan 22, 2013 at 5:07 PM, Shekhar 
>> > wrote:
>> >> Hi Amar,
>> >>
>> >> Please find attached spreadsheet that has more flexible sorting method.
>> >> Please let me know for further info.
>> >>
>> >>
>> >> thanks and regards,
>> >> Shekhar
>> >>
>> >>
>> >> On Monday, 21 January 2013 19:00:58 UTC+5:30, amar takale wrote:
>> >>>
>> >>> Hi All Experts,
>> >>> All of you request of my solution,Can we sort data
>> >>> Alphabetically,sector wise,price wise.IF I have 100 companies then I
>> >>> want to create VBA Code Button on that data.when I click sector then
>> >>> show all that sector companies as it other.I know it is very time
>> >>> consuming work for VBA coding but if anyone suggest me this VBA code
>> >>> button I am very much thankful.
>> >>> Thank you all for your help. I greatly appreciated it.
>> >>> Regards
>> >>> Amar
>> >>
>> >> --
>> >> Join official Facebook page of this forum @
>> >> https://www.facebook.com/discussexcel
>> >>
>> >> FORUM RULES
>> >>
>> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> >> will
>> >> not get quick attention or may not be answered.
>> >> 2) Don't post a question in the thread of another member.
>> >> 3) Don't post questions regarding breaking or bypassing any security
>> >> measure.
>> >> 4) Acknowledge the responses you receive, good or bad.
>> >> 5) Jobs posting is not allowed.
>> >> 6) Sharing copyrighted material and their links is not allowed.
>> >>
>> >> NOTE : Don't ever post confidential data in a workbook. Forum owners
>> >> and
>> >> members are not responsible for any loss.
>> >> ---
>> >> You received this message because you are subscribed to the Google
>> >> Groups
>> >> "MS EXCEL AND VBA MACROS" group.
>> >> To post to this group, send email to excel-macros@googlegroups.com.
>> >> To unsubscribe from this group, send email to
>> >> excel-macros+unsubscr...@googlegroups.com.
>> >> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>> >>
>> >>
>>
>> --
>> Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
>> not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE  : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>
>
>
>
> --
>
> thanks and regards,
> -Shekhar
>
> --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed

Re: $$Excel-Macros$$ Consolidate data from 31 sheets to one master sheet

[Paul Schreiner]

how do you identify "date criteria"?
is it by sheet name?

I don't see the dates on any of the individual sheets.

I'm pretty sure we can't include a date parameter with a simple function.
We'd have to write some VBA to do it.
 
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-





From: kasper 
To: excel-macros@googlegroups.com
Sent: Tue, January 22, 2013 8:13:42 AM
Subject: Re: $$Excel-Macros$$ Consolidate data from 31 sheets to one master 
sheet

Hi Paul 

Thanks for the idea you gave. Is there any way to add date criteria also there 
eg: 01/01/13 to 05/01/13 or 01/01/13 to 10/01/13.


With regards and thanks

Rajesh kainikkara

On Tuesday, January 22, 2013 6:28:14 PM UTC+5:30, Paul Schreiner wrote: 
Because no two people have the same file format or requirements, there really 
isn't a single solution to fit all needs.
>
>HOWEVER:
>
>IF all of the data sheets are in the same format and
>IF all of the data sheets have all entries
>
>Basically, if the value for "Cola" "Op STK" is always in cell C2
>or even more basic:
>
>each of your 31 sheets is made from the same "template"
>so that all ITEMS are listed in the same row on all sheets..
>
>Then, here's what I did in Excel 2010.
>(I THINK it works in earlier versions)
>
>First, make sure your "Consolidated" sheet is either the first or the last 
>sheet 
>of your workbook.
>
>In your "Consolidated" sheet, select cell C7 (Cola, Op Stk)
>type =sum(
>then select the first sheet (01)
>hold down the shift key and select the last sheet (05 in the sample)
>(Be sure to NOT include the Consolidated sheet)
> 
>This will input:
>=sum('01:05'!
>in the cell
>Your first sheet should be displayed (01)
>click in the "Cola, Op STK" cell (C2)
>
>then type a closing parenthesis.
>
>You should end up with:
>=SUM('01:05'!C2)
>
>This will sum all of contents of cell C2 in each of your sheets.
>copy/drag this formula across the columns, then down the rows
>and you should have your consolidation sheet.
>
>let me know how it works.
>
>
>Paul
>-- ---
>“Do all the good you can,
>By all the means you can,
>In all the ways you can,
>In all the places you can,
>At all the times you can,
>To all the people you can,
>As long as ever you can.” - John Wesley
>-- ---
>
>
>
>
>

From: Rajesh thrissur 
>To: excel-macros 
>Sent: Tue, January 22, 2013 7:36:40 AM
>Subject: $$Excel-Macros$$ Consolidate data from 31 sheets to one master sheet
>
>Hi Experts,
>
>Is there any method to consolidate data from many worksheets to one
>master worksheet, here I  attached a simple work book it have only 5
>data sheets and 1 master sheet. being data is very less I solve it
>with just adding data from reference cells but when data is more this
>method is not practical. If there is any special method pls advise me.
>
>with Regards
>
>Rajesh Kainikkara
>
>-- 
>Join official Facebook page of this forum @ https://www.facebook.com/ 
>discussexcel
>
>FORUM RULES
>
>1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
>Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
>quick attention or may not be answered.
>2) Don't post a question in the thread of another member.
>3) Don't post questions regarding breaking or bypassing any security measure.
>4) Acknowledge the responses you receive, good or bad.
>5) Jobs posting is not allowed.
>6) Sharing copyrighted material and their links is not allowed.
>
>NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
>members are not responsible for any loss.
>--- 
>You received this message because you are subscribed to the Google Groups "MS 
>EXCEL AND VBA MACROS" group.
>To post to this group, send email to excel-...@googlegroups.com.
>To unsubscribe from this group, send email to excel-macros+unsub...@ 
>googlegroups.com.
>Visit this group at http://groups.google.com/ group/excel-macros?hl=en.
>
>
>-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members 
are not responsible for any loss.
--- 
You received this message because you are

FW: $$Excel-Macros$$ need formula Highlight

[Manjunath Narayanappa]

Dear Kuldeep,

Its really cool link which you have sent me... There was a glow in my face.

Thanks for sending me. Please send me if you have any more link for other 
functions

Regards
Manjunath

From: Kuldeep Singh [mailto:naukrikuld...@gmail.com]
Sent: 22 January 2013 11:41
To: excel-macros@googlegroups.com
Cc: Manjunath Narayanappa; Prince
Subject: Re: FW: $$Excel-Macros$$ need formula Highlight


Hi Manjunath,

See below pdf. I hope it will help you.

http://ide20.com/upload/ModuleAE/Lesson01.pdf
http://ide20.com/upload/ModuleAE/Lesson02.pdf
http://ide20.com/upload/ModuleAE/Lesson03.pdf
http://ide20.com/upload/ModuleAE/Lesson04.pdf

http://lis.dickinson.edu/technology/training/Tutorials/2010/excel/excel_cond_format.pdf
http://wbc.fit.edu/courses/longcourses/home/Microsoft%20Excel/Conditional%20Formatting.pdf
http://pd.clcillinois.edu/manuals/clctech/Excel/Excel_2010_Unit_3_PG.pdf
http://chandoo.org/wp/tag/conditional-formatting/

Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.: +91-120-4763789, Extn.: 789,9716615535
naukrikuld...@gmail.com || 
www.naukri.com
Please Consider the environment. Please don't print this e-mail unless you 
really need to.

On Tue, Jan 22, 2013 at 4:59 PM, Prince 
mailto:prince141...@gmail.com>> wrote:
Hi Manjunath,

Please see this if this can help you.

http://www.free-training-tutorial.com/conditional-formatting.html

Regards
Prince

Manjunath


On Tuesday, January 22, 2013 4:54:11 PM UTC+5:30, Manjunath Narayanappa wrote:
Thank you very much. I was not knowing abt conditional formatting.
Is there any link to learn more abt Conditional formatting

Regarda
Manjunath

From: excel-...@googlegroups.com [mailto:excel-...@googlegroups.com] On Behalf 
Of Kuldeep Singh

Sent: 22 January 2013 10:05
To: excel-...@googlegroups.com

Subject: Re: FW: $$Excel-Macros$$ need formula Highlight


1st Conditional Formatting:

Error! Filename not specified.
2nd Conditional Formatting Rules Manager:

Error! Filename not specified.

Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.: +91-120-4763789, Extn.: 
789,9716615535
naukri...@gmail.com || www.naukri.com

Please Consider the environment. Please don't print this e-mail unless you 
really need to.

On Tue, Jan 22, 2013 at 3:02 PM, Manjunath Narayanappa 
 wrote:
Dear Prince,

I'm keen to learn this.  please teach me.

Thanks
Manjunath

From: excel-...@googlegroups.com [mailto:excel-...@googlegroups.com] On Behalf 
Of Manjunath Narayanappa

Sent: 18 January 2013 08:09
To: 'excel-...@googlegroups.com'
Cc: 'Prince'

Subject: $$Excel-Macros$$ need formula Highlight

Dear Prince,

Thank you very much. Can you please teach me how to execute on 2007 excel
 Await your assistance

Regards
Manjunath

From: Prince [mailto:prince...@gmail.com]
Sent: 17 January 2013 16:32
To: excel-...@googlegroups.com

Cc: Manjunath Narayanappa
Subject: Re: FW: $$Excel-Macros$$ need formula Highlight

Hi Manjunath,

PFA,

Regards
Prince

On Thursday, January 17, 2013 6:41:46 PM UTC+5:30, Manjunath Narayanappa wrote:
Dear all,

Please can I get macro for below requests

Regards
Manjunath


From: excel-...@googlegroups.com [mailto:excel-...@googlegroups.com] On Behalf 
Of Manjunath Narayanappa
Sent: 17 January 2013 08:47
To: 'excel-...@googlegroups.com'
Subject: $$Excel-Macros$$ need formula Highlight

Dear Expert,

Good afternoon  have a nice day :)

I have a data in the attached spreadsheet, automatically data in B column 
should get highlighted when there is a duplicate or repeated entry.

Please help me on this.

Thanks
Manjunath



PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL



For Aon's standard conditions associated with this e-mail please visit 
http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp

Aon UK Limited

Registered Office: 8 Devonshire Square, London EC2M 4PL

Registered in London No. 210725 . VAT Registration No. 480 8401 48



Aon UK Limited is authorised and regulated by the Financial Services Authority 
in respect of insurance mediation activities only.
--
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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

NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" g

Re: $$Excel-Macros$$ VBA Help:Excel table copy paste in word (with formatting as it)

[bpascal123]

Set ws = wb.Worksheets("Feuil")
to
Set ws = wb.activesheet

run the code from the excel sheet the table is located
else you can replace "Feuil" with the name of the sheet where the table is 
located, most likely "sheet1"

btw Feuil means Sheet in French...

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Re: VBA Solution Requried

[Shekhar Pujari]

Hi Amar,

SortButtons is called by program SortData every time you click on any
arrow. Hence SortData is the piece macro you need to assign to all arrows.


Thanks and regards,
Shekhar
On Tue, Jan 22, 2013 at 6:46 PM, amar takale  wrote:

> Hi shekhar,
> Thanks for explain.I got all hidden arrow by changing in VBA code
> False.but yet I confused that Now I saw 12 arrow but which code assign
> that all arrow.Pls tell me
> Amar
>
> On Tue, Jan 22, 2013 at 5:52 PM, Shekhar Pujari
>  wrote:
> > In that sheet there are 12 arrows. 6 represents up arrow and 6 are down.
> As
> > of now, there are 6 hidden arrow as to suit your sort criteria.
> >
> > thanks and regards,
> > Shekhar
> > On Tue, Jan 22, 2013 at 5:40 PM, amar takale 
> wrote:
> >>
> >> Hi Shekhar,
> >> Can you explain me how to do it.I try it separate file with same
> >> data.I insert same 6 arrow but which macro to asign it.It is two
> >> code.How arrow move up & down.I insert only UP arrow
> >> Pls explain me it is very useful to routine work
> >> Appreciate the help
> >> Amar
> >>
> >> On Tue, Jan 22, 2013 at 5:27 PM, amar takale 
> wrote:
> >> > Dear Shekhar,
> >> > This solution is beyond my expectation. Great work Boss. Thanks a lot.
> >> >
> >> > One more solution for in my sheet there are data validation if I
> >> > select sector & click GO button then show only that sector company not
> >> > other sector company bcos then I concentrate only that specific
> >> > sector.If possible guide me.
> >> >
> >> > Regards
> >> > Amar
> >> >
> >> >
> >> > On Tue, Jan 22, 2013 at 5:07 PM, Shekhar 
> >> > wrote:
> >> >> Hi Amar,
> >> >>
> >> >> Please find attached spreadsheet that has more flexible sorting
> method.
> >> >> Please let me know for further info.
> >> >>
> >> >>
> >> >> thanks and regards,
> >> >> Shekhar
> >> >>
> >> >>
> >> >> On Monday, 21 January 2013 19:00:58 UTC+5:30, amar takale wrote:
> >> >>>
> >> >>> Hi All Experts,
> >> >>> All of you request of my solution,Can we sort data
> >> >>> Alphabetically,sector wise,price wise.IF I have 100 companies then I
> >> >>> want to create VBA Code Button on that data.when I click sector then
> >> >>> show all that sector companies as it other.I know it is very
> time
> >> >>> consuming work for VBA coding but if anyone suggest me this VBA code
> >> >>> button I am very much thankful.
> >> >>> Thank you all for your help. I greatly appreciated it.
> >> >>> Regards
> >> >>> Amar
> >> >>
> >> >> --
> >> >> Join official Facebook page of this forum @
> >> >> https://www.facebook.com/discussexcel
> >> >>
> >> >> FORUM RULES
> >> >>
> >> >> 1) Use concise, accurate thread titles. Poor thread titles, like
> Please
> >> >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice
> >> >> will
> >> >> not get quick attention or may not be answered.
> >> >> 2) Don't post a question in the thread of another member.
> >> >> 3) Don't post questions regarding breaking or bypassing any security
> >> >> measure.
> >> >> 4) Acknowledge the responses you receive, good or bad.
> >> >> 5) Jobs posting is not allowed.
> >> >> 6) Sharing copyrighted material and their links is not allowed.
> >> >>
> >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners
> >> >> and
> >> >> members are not responsible for any loss.
> >> >> ---
> >> >> You received this message because you are subscribed to the Google
> >> >> Groups
> >> >> "MS EXCEL AND VBA MACROS" group.
> >> >> To post to this group, send email to excel-macros@googlegroups.com.
> >> >> To unsubscribe from this group, send email to
> >> >> excel-macros+unsubscr...@googlegroups.com.
> >> >> Visit this group at
> http://groups.google.com/group/excel-macros?hl=en.
> >> >>
> >> >>
> >>
> >> --
> >> Join official Facebook page of this forum @
> >> https://www.facebook.com/discussexcel
> >>
> >> FORUM RULES
> >>
> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will
> >> not get quick attention or may not be answered.
> >> 2) Don't post a question in the thread of another member.
> >> 3) Don't post questions regarding breaking or bypassing any security
> >> measure.
> >> 4) Acknowledge the responses you receive, good or bad.
> >> 5) Jobs posting is not allowed.
> >> 6) Sharing copyrighted material and their links is not allowed.
> >>
> >> NOTE  : Don't ever post confidential data in a workbook. Forum owners
> and
> >> members are not responsible for any loss.
> >> ---
> >> You received this message because you are subscribed to the Google
> Groups
> >> "MS EXCEL AND VBA MACROS" group.
> >> To post to this group, send email to excel-macros@googlegroups.com.
> >> To unsubscribe from this group, send email to
> >> excel-macros+unsubscr...@googlegroups.com.
> >> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> >>
> >>
> >
> >
> >
> > --
> >
> > thanks and regards,
> > -Shekhar
> >
> > --
> > Join official Face

$$Excel-Macros$$ pivot need macro

[Sara Lee]

i have a pivot in excel. this pivot table in current format displays data
in plain number format. I want to display the numbers as "% of row" format.

i know there is an excel feature under options. but i want to add a toggle
which can have users change between number and %of row format, by clicking
or non clicking the toggle or list boxso need a macro

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

FORUM RULES

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

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