Re: $$Excel-Macros$$ 西藏问题与语言问题

2017-06-22 Thread Jitendra Singh 
?? ☺

⁣Sent from BlueMail ​

On 22 Jun 2017, 1:19 PM, at 1:19 PM, fanfenlie2...@gmail.com wrote:
>西藏问题与语言问题
>徐明旭
>有位匿名网友在拙文《达赖喇嘛的鬼蜮伎俩》后面发表跟帖如下：
>“大陆一年可能要为西藏付出几百亿。也许将来有一天，代价太高的时候，大陆政府会作出让步，给予藏人等一定自治权。 
>比如允许藏人企业的发展。但藏人企业本身就可能让大陆政府感到威胁。如果一个企业里面都在讲藏语，放心吗？也许徐博会说藏人懒，笨，也许。但政府肯让藏人直接和印度通商，学习一点现代社会发展的技巧吗？
>
>恐怕不肯。”
>这些话说明外面的人们对于今日西藏极不了解。首先，中国政府鼓励藏人自己开办企业。在314事件中被藏独暴徒推下楼致使腰椎骨折的藏族女店主马阿英社就是向工行借了30万元钱才开店的。可见打击藏人开企业的正是疯狂仇富的藏独暴徒。
>西藏由于严重缺氧、交通险恶（世界屋脊布满雪山深沟、山崩雪崩泥石流频繁）、没有石化能源、离海洋太远，交通、原料、能源成本太高，无法大规模发展制造业，只能因地制宜发展服务业与加工业。这不是中国政府的阴谋，而是无法改变的地理自然。
>其次中国政府并未禁止藏人与印度通商，问题在于印度至今在亚东口岸外驻重兵、设关卡，致使中印通商困难重重。中国与尼泊尔的边境贸易就热火朝天，藏人可与尼人直接通商，我早在1983年去中尼边境的樟木口岸旅游时就看见大批尼商与苦力在中国境内居住、通商，许多尼泊尔苦力就住在当地藏人开设的旅店内，甚至被当地藏人雇佣干苦活（尼泊尔比中国穷得多，人民币在尼人眼里是硬通货）。
>1985年我在西藏时听说有些藏人从拉萨购入羊毛，用卡车运到樟木口岸卖给尼商，可以赚大钱。
>再次，中国政府不遗余力在西藏普及教育，藏人读大中小学都是免费的，政府还为住读的藏族中小学生免费提供食宿。还有大批藏人到内地大城市读中学与大学，全部免费，政府还发给生活津贴与假期回藏的旅费。这些努力都是为了帮助藏人掌握“现代社会发展的技巧”。
>这位网友也许会说，藏人说不好汉语，所以中国政府的这些努力没有用处。按照他的主张，藏人只有向印度学习。然而印度的官方语言是英语与印地语，藏人更说不好，又如何向印度学习呢？
>在全球化与高科技突飞猛进的时代，非英语国家与民族都面临着语言劣势。因为世界上经济与科技最发达的美国使用英语，不懂英语就无法与美国通商，也无法及时追踪日新月异的科技发展。印度独立时，其领导人没有出于对殖民主义的痛恨，或出于民族自豪感，把英语也一起赶走，相反却把殖民主义者的语言定为官方语言，这一富于远见的政策使印度得益匪浅。有人指出今日印度成为世界第一软件出口大国的重要原因之一是印度具有世界第二多的懂英语的人才（第一多是美国）。爱尔兰有自己的民族语言，英国统治爱尔兰期间强行普及英语，爱尔兰独立时也未赶走英语，而是将其定为国语，英语成为大多数爱尔兰人的母语，诞生了像萧伯纳、乔伊斯那样用英语写作的世界级大文豪。爱尔兰民族并未因为采用了异族语言而消亡，反而更加出名了。如今爱尔兰是世界第二软件出口大国，根据印度的经验，爱尔兰全民说英语的事实也起了很大作用（本文只谈语言问题，不拟全面论述印爱两国软件业起飞的各种原因，有兴趣的网友请将“印度软件”或“爱尔兰软件”输入google，即可看到相关介绍文章）。
>日本拥有1.3亿人口，几乎等于美国人口的一半，但他们在二战后不遗余力地普及英语，同时拥有一支强大高效的翻译队伍，从而能及时跟踪美国的科技新潮。德国也是大语种国家（德国、奥地利、瑞士、卢森堡等国拥有上亿德语人口），但他们在二战后也不遗余力地普及英语，在德国某些大学某些专业甚至使用英语为教学、科研语言。日德两国能成为世界第二、第三经济大国，其语言政策功不可没。
>英国是世界第五经济大国（第四是中国），跟它是英语的发源地不无关系。法国在上世纪七、八十年代经济一度超过英国。但许多法国人为自己的语言自豪，不屑于学习英语，信息革命兴起后，其经济落到英国后面。
>欧洲许多小语种国家如荷兰、丹麦、瑞典、挪威、芬兰等人口太少，无法建立强大高效的翻译队伍，干脆在科技领域使用英语（在其它领域与日常生活中仍然使用母语）。
>许多非洲与拉美国家独立后也像印度那样把前宗主国的语言定为官方语言，从而在经济上获益。
>那些出于民族自豪感或其它考虑而不愿意或不屑于普及英语的小语种国家或民族则不得不付出经济与科技越来越落后的代价。
>苏联政府不重视普及英语，他们学校里的第一外语是德语，因为苏联与德国的经济联系最密切，与美国没有什么生意。苏联崩溃后，俄国政府才把英语作为第一外语，今日俄国的信息产业与互联网事业比中国还落后。
>我在许多文章里指出，古老的藏文没有科技词汇，离口语太远，难以承载科技知识，所以达赖在印度的流亡藏人学校里不得不用英语教授数理化，而中国政府在西藏的中学里不得不用汉语教授数理化，同时开设藏文课。如果说这就是毁灭西藏语文，那么达赖就是毁灭西藏语文的罪魁祸首。（顺便说说，清朝的北洋舰队使用英语作为指挥操作语言，因为当时的文言文里没有相关的科技词汇）
>即便藏文口语化了，有了成熟的科技词汇，它仍是一个小语种，只有几百万人口。单靠这几百万人口是无法建立起强大高效的、不会亏本的翻译队伍来的，那么藏人要现代化，只有两条路可走，或者普及英语，或者普及汉语，因为汉语毕竟是个大语种，拥有较强的翻译队伍，可以较快地追踪世界科技新潮。如果在藏人中普及汉语就是汉人的殖民主义，那么在藏人中普及英语就是英美人的殖民主义——达赖在流亡藏人中就是这样做的。
>顺便说说，美国政府在夏威夷土著、印第安人、爱斯基摩人与新墨西哥州说西班牙语的原住民中也在大力普及英语，他们的英语如不好就不能上大学。中国政府在高考中对藏族学生降低录取分数线50%，而美国的大学并不给上述以非英语为母语的原住民任何优待。如果中国政府在西藏的语言政策是殖民主义，那么美国政府的语言政策更是殖民主义。
>
>-- 
>Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>https://www.facebook.com/discussexcel
>
>FORUM RULES
>
>1) Use concise, accurate thread titles. Poor thread titles, like Please
>Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>will not get quick attention or may not be answered.
>2) Don't post a question in the thread of another member.
>3) Don't post questions regarding breaking or bypassing any security
>measure.
>4) Acknowledge the responses you receive, good or bad.
>5) Jobs posting is not allowed.
>6) Sharing copyrighted material and their links is not allowed.
>
>NOTE  : Don't ever post confidential data in a workbook. Forum owners
>and members are not responsible for any loss.
>--- 
>You received this message because you are subscribed to the Google
>Groups "MS EXCEL AND VBA MACROS" group.
>To unsubscribe from this group and stop receiving emails from it, send
>an email to excel-macros+unsubscr...@googlegroups.com.
>To post to this group, send email to excel-macros@googlegroups.com.
>Visit this group at https://groups.google.com/group/excel-macros.
>For more options, visit https://groups.google.com/d/optout.

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

FORUM RULES

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

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

Re: Fwd: Fwd: $$Excel-Macros$$ copy data from one sheet to other based on condition

2017-05-19 Thread Jitendra Singh 
Plz use 2nd attachment.

https://vbatutorial.blogspot.in/2017/05/problem-1-filter-data-and-paste-to.html?m=1

⁣Sent from BlueMail ​

On 19 May 2017, 1:19 PM, at 1:19 PM, Sanjib Chatterjee 
 wrote:
>-- Forwarded message --
>From: Sanjib Chatterjee 
>Date: Fri, May 19, 2017 at 1:18 PM
>Subject: Re: Fwd: $$Excel-Macros$$ copy data from one sheet to other
>based
>on condition
>To: excel-macros ,
>schreiner_p...@att.net
>
>
>Dear Paul Schreiner,
>
>Here find the attachment,
>I have a problem I want to copy data base on the Person name which i
>highlighted with yellow colour.
>suppose if the person name "JKM" a sheet will created with the name
>"JKM"
>and the entire rows data relating to Jkm WILL copy to the new sheets of
>JKM.  if the person name is HM the the same rule will be follow.
>
>thouth Preeti Tomar, help me a lot of doing the project.  But I got an
>error while
>running the vba code.
>
>Please help
>
>Thanking you
>
>SANJIB CHATTERJEE
>
>
>
>
>
>On Thu, May 18, 2017 at 5:28 PM, Paul Schreiner
>
>wrote:
>
>> Your error seems to indicate that you're trying to create a sheet and
>> change the name to one that already exists.
>>
>> without seeing a sample of your file and macros, it will be difficult
>to
>> determine what is going on.
>> *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*
>> -
>>
>>
>> On Thursday, May 18, 2017 1:37 AM, Sanjib Chatterjee <
>> chatterjee.kolk...@gmail.com> wrote:
>>
>>
>> Sir / Madam,
>>
>> Please help I am having a of copying data from one sheet to another
>sheets
>> based on some criteria
>>
>> regards
>>
>> Sanjib Chatterjee
>> -- Forwarded message --
>> From: *Sanjib Chatterjee* 
>> Date: Wed, May 17, 2017 at 9:56 AM
>> Subject: Re: $$Excel-Macros$$ copy data from one sheet to other based
>on
>> condition
>> To: excel-macros 
>>
>>
>> Dear Preeti Tomar
>>
>> Many Many thank you for your prompt help.
>>
>> This is what exactly I am looking for.  But I am getting an error
>while
>> trying the execute the command for the next time.
>>
>> for your reference I am attaching the error snap short
>>
>> Please help
>>
>> Once again many many thank you in advance
>>
>> Sanjib Chatterjee
>>
>>
>>
>> On Tue, May 16, 2017 at 10:48 PM, Preeti Tomar
>
>> wrote:
>>
>> https://jeetexltips.blogspot.i n/2017/05/Filterinvba.html
>> 
>>
>>
>> On Tue, May 16, 2017 at 2:00 PM, Sanjib Chatterjee <
>> chatterjee.kolk...@gmail.com> wrote:
>>
>>
>> Dear Sir / madam,
>>
>> Please see the attachment.
>>
>> I have a problem I want to copy data base on the Person name which i
>> highlighted with yellow colour.
>> suppose if the person name "JKM" a sheet will created with the name
>"JKM"
>> and the entire rows data relating to Jkm WILL copy to the new sheets
>of
>> JKM.  if the person name is HM the the same rule will be follow.
>>
>> Please help
>>
>> Thanking you
>>
>> SANJIB CHATTERJEE
>>
>>
>>
>> --
>> -
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>https://www.facebook.com/discu
>> ssexcel 
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like
>Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google
>Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it,
>send an
>> email to excel-macros+unsubscribe@googl egroups.com
>> .
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at https://groups.google.com/grou p/excel-macros
>> .
>> For more options, visit https://groups.google.com/d/op tout
>> .
>>
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>https://www.facebook.com/discu
>> ssexcel 
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, lik

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

2017-05-19 Thread Jitendra Singh 
My self Jitendra Singh working as a data analyst in noida.

Thanks

⁣Sent from BlueMail ​

On 19 May 2017, 1:12 PM, at 1:12 PM, Sanjib Chatterjee 
 wrote:
>I am Sanjib Chatterjee, working in a stock broking firm, name Sunidhi
>securities and finance ltd,Kolkata, sa Bank office Mis executive.  I
>get
>lot of support from the excel community whenever I need any help. I
>have a
>great passion of Excel.
>Hope You will continue supporting us.
>
>Thanking you
>
>Sanjib Chatterjee
>
>
>
>-- Forwarded message --
>From: Michael Vinoth 
>Date: Fri, May 19, 2017 at 3:06 AM
>Subject: $$Excel-Macros$$ Introduce Yourself !!
>To: MS EXCEL AND VBA MACROS 
>
>
>Hi Friends..
>
>I am Michael Vinoth.. I have 5 years experience in developing the excel
>vba
>macros.. I love what I am doing.. Excel is my passion.. I hope I will
>learn
>many things from you all and I will share what I know..
>
>Thanks
>MV
>VBA Developer
>
>--
>Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>It’s
>=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>https://www.facebook.com/discussexcel
>
>FORUM RULES
>
>1) Use concise, accurate thread titles. Poor thread titles, like Please
>Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>will not get quick attention or may not be answered.
>2) Don't post a question in the thread of another member.
>3) Don't post questions regarding breaking or bypassing any security
>measure.
>4) Acknowledge the responses you receive, good or bad.
>5) Jobs posting is not allowed.
>6) Sharing copyrighted material and their links is not allowed.
>
>NOTE  : Don't ever post confidential data in a workbook. Forum owners
>and
>members are not responsible for any loss.
>---
>You received this message because you are subscribed to the Google
>Groups
>"MS EXCEL AND VBA MACROS" group.
>To unsubscribe from this group and stop receiving emails from it, send
>an
>email to excel-macros+unsubscr...@googlegroups.com.
>To post to this group, send email to excel-macros@googlegroups.com.
>Visit this group at https://groups.google.com/group/excel-macros.
>For more options, visit https://groups.google.com/d/optout.
>
>
>
>-- 
>-
>
>-- 
>Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>https://www.facebook.com/discussexcel
>
>FORUM RULES
>
>1) Use concise, accurate thread titles. Poor thread titles, like Please
>Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>will not get quick attention or may not be answered.
>2) Don't post a question in the thread of another member.
>3) Don't post questions regarding breaking or bypassing any security
>measure.
>4) Acknowledge the responses you receive, good or bad.
>5) Jobs posting is not allowed.
>6) Sharing copyrighted material and their links is not allowed.
>
>NOTE  : Don't ever post confidential data in a workbook. Forum owners
>and members are not responsible for any loss.
>--- 
>You received this message because you are subscribed to the Google
>Groups "MS EXCEL AND VBA MACROS" group.
>To unsubscribe from this group and stop receiving emails from it, send
>an email to excel-macros+unsubscr...@googlegroups.com.
>To post to this group, send email to excel-macros@googlegroups.com.
>Visit this group at https://groups.google.com/group/excel-macros.
>For more options, visit https://groups.google.com/d/optout.

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ copy data from one sheet to other based on condition

2017-05-16 Thread Jitendra Singh 
Hi Mr. chatterjee,

Before executing please delete all sheets.

Thanks
http://vbatutorial.blogspot.in/

⁣Sent from BlueMail ​

On 17 May 2017, 9:56 AM, at 9:56 AM, Sanjib Chatterjee 
 wrote:
>Dear Preeti Tomar
>
>Many Many thank you for your prompt help.
>
>This is what exactly I am looking for.  But I am getting an error while
>trying the execute the command for the next time.
>
>for your reference I am attaching the error snap short
>
>Please help
>
>Once again many many thank you in advance
>
>Sanjib Chatterjee
>
>
>
>On Tue, May 16, 2017 at 10:48 PM, Preeti Tomar
>
>wrote:
>
>> https://jeetexltips.blogspot.in/2017/05/Filterinvba.html
>>
>>
>> On Tue, May 16, 2017 at 2:00 PM, Sanjib Chatterjee <
>> chatterjee.kolk...@gmail.com> wrote:
>>
>>>
>>> Dear Sir / madam,
>>>
>>> Please see the attachment.
>>>
>>> I have a problem I want to copy data base on the Person name which i
>>> highlighted with yellow colour.
>>> suppose if the person name "JKM" a sheet will created with the name
>"JKM"
>>> and the entire rows data relating to Jkm WILL copy to the new sheets
>of
>>> JKM.  if the person name is HM the the same rule will be follow.
>>>
>>> Please help
>>>
>>> Thanking you
>>>
>>> SANJIB CHATTERJEE
>>>
>>>
>>>
>>> --
>>> -
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>It’s
>>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>Groups
>>> "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it,
>send an
>>> email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at https://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like
>Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google
>Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it,
>send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
>-- 
>-
>
>-- 
>Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>https://www.facebook.com/discussexcel
>
>FORUM RULES
>
>1) Use concise, accurate thread titles. Poor thread titles, like Please
>Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>will not get quick attention or may not be answered.
>2) Don't post a question in the thread of another member.
>3) Don't post questions regarding breaking or bypassing any security
>measure.
>4) Acknowledge the responses you receive, good or bad.
>5) Jobs posting is not allowed.
>6) Sharing copyrighted material and their links is not allowed.
>
>NOTE  : Don't ever post confidential data in a workbook. Forum owners
>and members are not responsible for any loss.
>--- 
>You received this message because you are subscribed to the Google
>Groups "MS EXCEL AND VBA MACROS" group.
>To unsubscribe from this group and stop receiving emails from it, send
>an email to excel-macros+unsubscr...@googlegroups.com.
>To post to this grou

Re: $$Excel-Macros$$ copy data from one sheet to other based on condition

2017-05-16 Thread Jitendra Singh 
Use advance filter ||

⁣Sent from BlueMail ​

On 16 May 2017, 2:00 PM, at 2:00 PM, Sanjib Chatterjee 
 wrote:
>Dear Sir / madam,
>
>Please see the attachment.
>
>I have a problem I want to copy data base on the Person name which i
>highlighted with yellow colour.
>suppose if the person name "JKM" a sheet will created with the name
>"JKM"
>and the entire rows data relating to Jkm WILL copy to the new sheets of
>JKM.  if the person name is HM the the same rule will be follow.
>
>Please help
>
>Thanking you
>
>SANJIB CHATTERJEE
>
>
>
>-- 
>-
>
>-- 
>Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>https://www.facebook.com/discussexcel
>
>FORUM RULES
>
>1) Use concise, accurate thread titles. Poor thread titles, like Please
>Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>will not get quick attention or may not be answered.
>2) Don't post a question in the thread of another member.
>3) Don't post questions regarding breaking or bypassing any security
>measure.
>4) Acknowledge the responses you receive, good or bad.
>5) Jobs posting is not allowed.
>6) Sharing copyrighted material and their links is not allowed.
>
>NOTE  : Don't ever post confidential data in a workbook. Forum owners
>and members are not responsible for any loss.
>--- 
>You received this message because you are subscribed to the Google
>Groups "MS EXCEL AND VBA MACROS" group.
>To unsubscribe from this group and stop receiving emails from it, send
>an email to excel-macros+unsubscr...@googlegroups.com.
>To post to this group, send email to excel-macros@googlegroups.com.
>Visit this group at https://groups.google.com/group/excel-macros.
>For more options, visit https://groups.google.com/d/optout.

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

FORUM RULES

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

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

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

2012-06-04 Thread Jitendra singh 
Option Explicit



Function RangetoHTML(rng As Range)

' Changed by Ron de Bruin 28-Oct-2006

' Working in Office 2000-2010

Dim fso As Object

Dim ts As Object

Dim TempFile As String

Dim TempWB As Workbook



TempFile = Environ$("temp") & "\" & Format(Now, "dd-mm-yy h-mm-ss") &
".htm"



'Copy the range and create a new workbook to past the data in

rng.Copy

Set TempWB = Workbooks.Add(1)

With TempWB.Sheets(1)

.Cells(1).PasteSpecial Paste:=8

.Cells(1).PasteSpecial xlPasteValues, , False, False

.Cells(1).PasteSpecial xlPasteFormats, , False, False

.Cells(1).Select

Application.CutCopyMode = False

On Error Resume Next

.DrawingObjects.Visible = True

.DrawingObjects.Delete

On Error GoTo 0

End With



'Publish the sheet to a htm file

With TempWB.PublishObjects.Add( _

 SourceType:=xlSourceRange, _

 Filename:=TempFile, _

 Sheet:=TempWB.Sheets(1).Name, _

 Source:=TempWB.Sheets(1).UsedRange.Address, _

 HtmlType:=xlHtmlStatic)

.Publish (True)

End With



'Read all data from the htm file into RangetoHTML

Set fso = CreateObject("Scripting.FileSystemObject")

Set ts = fso.GetFile(TempFile).OpenAsTextStream(1, -2)

RangetoHTML = ts.readall

ts.Close

RangetoHTML = Replace(RangetoHTML, "align=center x:publishsource=", _

  "align=left x:publishsource=")



'Close TempWB

TempWB.Close savechanges:=False



'Delete the htm file we used in this function

Kill TempFile



Set ts = Nothing

Set fso = Nothing

Set TempWB = Nothing

End Function





Function GetBoiler(ByVal sFile As String) As String

'Dick Kusleika

Dim fso As Object

Dim ts As Object

Set fso = CreateObject("Scripting.FileSystemObject")

Set ts = fso.GetFile(sFile).OpenAsTextStream(1, -2)

GetBoiler = ts.readall

ts.Close

End Function



Option Explicit



Sub Send_Row()

' Don't forget to copy the function RangetoHTML in the module.

' Working in Office 2000-2010

Dim OutApp As Object

Dim OutMail As Object

Dim cell As Range

Dim rng As Range

Dim Ash As Worksheet



Set Ash = ActiveSheet

On Error GoTo cleanup

Set OutApp = CreateObject("Outlook.Application")



With Application

.EnableEvents = False

.ScreenUpdating = False

End With



For Each cell In
Ash.Columns("B").Cells.SpecialCells(xlCellTypeConstants)

If cell.Value Like "?*@?*.?*" And LCase(cell.Offset(0, 1).Value) =
"yes" Then



Ash.Range("A1:O100").AutoFilter Field:=2, Criteria1:=cell.Value



With Ash.AutoFilter.Range

On Error Resume Next

Set rng = .SpecialCells(xlCellTypeVisible)

On Error GoTo 0

End With



Set OutMail = OutApp.CreateItem(0)



On Error Resume Next

With OutMail

.To = cell.Value

.Subject = " Month Target vs Achievement"

.HTMLBody = RangetoHTML(rng)

.Display  'Or use Send

End With

On Error GoTo 0



Set OutMail = Nothing

Ash.AutoFilterMode = False

End If

Next cell



cleanup:

Set OutApp = Nothing

With Application

.EnableEvents = True

.ScreenUpdating = True

End With

End Sub










--END--

REGARDS
JITENDRA SINGH
9015340017

On Mon, Jun 4, 2012 at 4:03 PM, Puttu *  wrote:

> Experts,
>
> Could you please please help on the below request.
>
> On Mon, Jun 4, 2012 at 2:00 PM, Puttu *  wrote:
>
>> below is the required details for your reference once again.
>>
>>   Sr. No. Task (Subject Name) First Reminder Date & Time Second
>> Reminder Date & Time Final Reminder Date & Time Status Email Group 1 Status
>> Mail 6/4/12 17:00 6/5/12 20:00 6/6/12 22:00 Inprogress
>> puttu...@gmail.com
>> puttu_...@yahoo.co.in  2 QC 6/5/12 17:00 6/5/12 17:00 
>> 6/6/12
>> 22:00 Completed puttu...@gmail.com
>> puttu_...@yahoo.co.in  3 Buddy Check 6/6/12 18:00 6/6/12
>> 18:00 6/6/12 22:00 Completed puttu...@gmail.com
>> puttu_...@yahoo.co.in  4 Release 6/7/12 17:00 6/7/12
>> 5:00 6/6/12 22:00 Inprogress  puttu...@gmail.com
>> puttu_...@yahoo.co.in  5 Confirmation Mail 6/8/12
>> 17:00 6/8/12 5:00 6/8/12 22:00 Completed puttu...@gmail.com
>> puttu_...@yahoo.co.in 
>>
>>
>>
>>
>>
>

Re: $$Excel-Macros$$ email extraction from gmail

2012-03-21 Thread Jitendra singh 
give email id A1 box in sheet and run macro

---

Sub Mail_Every_Worksheet()

'Working in 2000-2010

Dim sh As Worksheet

Dim wb As Workbook

Dim FileExtStr As String

Dim FileFormatNum As Long

Dim TempFilePath As String

Dim TempFileName As String

Dim OutApp As Object

Dim OutMail As Object



TempFilePath = Environ$("temp") & "\"



If Val(Application.Version) < 12 Then

'You use Excel 97-2003

FileExtStr = ".xls": FileFormatNum = -4143

Else

'You use Excel 2007-2010

FileExtStr = ".xlsx": FileFormatNum = 51

End If



With Application

.ScreenUpdating = False

.EnableEvents = False

End With



Set OutApp = CreateObject("Outlook.Application")



For Each sh In ThisWorkbook.Worksheets

If sh.Range("A1").Value Like "?*@?*.?*" Then



sh.Copy

Set wb = ActiveWorkbook



TempFileName = " " & sh.Name & " of " _

 & ThisWorkbook.Name





Set OutMail = OutApp.CreateItem(0)

With wb

.SaveAs TempFilePath & TempFileName & FileExtStr, _

FileFormat:=FileFormatNum

On Error Resume Next

With OutMail

.To = sh.Range("A1").Value

.CC = ""

.BCC = ""

.Subject = "DAILY DASHBOARD"

.Body = "DAILY DASHBOARD"

.Attachments.Add wb.FullName

'You can add other files also like this

'.Attachments.Add ("C:\test.txt")

.Send   'or use .Display

End With

On Error GoTo 0

.Close SaveChanges:=False

End With

Set OutMail = Nothing



Kill TempFilePath & TempFileName & FileExtStr

End If

Next sh



Set OutApp = Nothing



With Application

.ScreenUpdating = True

.EnableEvents = True

End With

End Sub











=

On Thu, Mar 22, 2012 at 8:58 AM, NOORAIN ANSARI wrote:

> Dear Raj,
>
> Please try through below link.
>
> http://www.gmailextractor.com/
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://noorainansari.com/*
> *http://excelmacroworld.blogspot.com/*
>
>
> On Wed, Mar 21, 2012 at 11:56 PM, Raj Mahapatra wrote:
>
>> hi group,
>>
>> can you please advice me how to extract email id's from gmail or outlook
>> using VBA
>>
>> Thanks & Regards
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

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

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

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

3) Don't post questions regarding breaking or bypass

Re: $$Excel-Macros$$ JOB

2012-01-27 Thread Jitendra singh 
a person is required in this job

name :- Devraj
mob :- 9899399499

On Fri, Jan 27, 2012 at 5:12 PM, NOORAIN ANSARI wrote:

>
> *Job Location:* Gurgaon
> *Email ID* : resume.curv...@gmail.com
>
>
> 
>
> *Dear Candidate,*
>
> Mission Control Analyst/WFM-Executive/MIS
>
> Candidate must be comfortable with night shifts
>
> Job Responsibilities:
>
> Would act as the first point of contact for all service related
> escalations occurring on account of issues such as call routing, technical
> glitches, unscheduled absence OR any other.
>
> Would constantly monitor, track, document and communicate real time floor
> activities in terms of adherence to process defined AUX/ACW/BREAKS &
> SHIFTS.
>
> Would ensure availability of analysts on phones as per the business model
> requirement.
>
> Complete all required forms, reports, etc. within established timelines
>
> Interested candidate can send their profile @ resume.curv...@gmail.com
>
> And Mention details ;
>
> Total Experience :
> Relevant Experience :
> Current CTC :
> Expected CTC:
> Lead Time to Join :
>
> Regards
> Pooja
> 9716451777
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Need help on Resigned staffs statistic

2012-01-20 Thread Jitendra singh 
fyi

regards
jitendra singh
9015340017

On Fri, Jan 20, 2012 at 12:57 PM, PrIyAnKa  wrote:

> Dear Sunita
>
> Kindly give one example of what u want in your sheet as to study the data
> and analyse the same and preparing format as per your requirement takes a
> lot time
>
> So kindly provide one output example in output format
>
> 2012/1/20 सुनिता पौडेल 
>
>> Dear all,
>>
>> Can you please help me on resigned staffs statistic? I need the
>> information as below:
>>
>>
>> the number of resigned staffs in 2006 and ratio of resigned staffs
>>> male:female
>>>
>>
>> Like wise till 2012
>>>
>>
>>
>> Your help will be highly effective for my work.
>>
>> Regards,
>>
>> Sunita
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

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

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

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

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

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

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

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

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


Book1 (1).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Reduce the Size

2011-12-13 Thread Jitendra singh 
thanks for all

On Wed, Dec 14, 2011 at 12:09 AM, Paul Schreiner wrote:

>  Not enough info.
>
> What version of Excel are you using?
> What file format? (.xls, .xlt, .xlsx, .xlsm)
>
> If you're using Office 2007 or 2010, then you have lots of options.
>
> I have a file with 90,000 rows an over 70 columns.
> In Excel 97, (which truncates at 64,000 rows) the file is 80Mb
> In Excel 2007, file type .xlsm the file is 46Mb
> in Excel 2007, file type .xlsb the file is 14.6Mb
>
>
> *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:* Jitendra singh 
> *To:* excel-macros@googlegroups.com
> *Sent:* Tue, December 13, 2011 1:25:58 PM
> *Subject:* $$Excel-Macros$$ Reduce the Size
>
>  Dear all expert,
>
> Too much data in my Excel sheet. The Size is 700 mb. i Want to reduce the
> Size without touch  data.
>
> Thanks and Regards
> Jitendra Singh
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

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

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

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

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

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

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

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

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

$$Excel-Macros$$ Reduce the Size

2011-12-13 Thread Jitendra singh 
Dear all expert,

Too much data in my Excel sheet. The Size is 700 mb. i Want to reduce the
Size without touch  data.

Thanks and Regards
Jitendra Singh

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance

2011-12-13 Thread Jitendra singh 
Dear Noorain,
Thanks.
Regards
Jitendra Singh

On Tue, Dec 13, 2011 at 11:01 PM, NOORAIN ANSARI
wrote:

> Dear Jitender,
>
> I would suggest you to go ahead and record macro and then watch and
> relate these codes by your steps, which you had taken and start
> understanding VBA.  You can also refer to the Group's learning
> material and find below excel macro ebook..
>
> http://www.4shared.com/document/Kd7W3YMN/MicrosofExcel2007VBAMacroProgr.htm
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
> On Tue, Dec 13, 2011 at 10:34 PM, Jitendra singh wrote:
>
>> dear all,
>>      how can i learn macro.
>> please suggest me.
>>
>> Thanks & Regards
>> Jitendra Singh
>>
>> On Tue, Dec 13, 2011 at 10:04 PM, dguillett1 wrote:
>>
>>>   *http://tinyurl.com/7yt37xy*
>>>
>>>
>>>
>>> https://login.live.com/login.srf?wa=wsignin1.0&rpsnv=11&checkda=1&ct=1323793906&rver=6.0.5276.0&wp=MCLBI&wlcxt=msdn%24msdn%24msdn&wreply=http%3a%2f%2fmsdn.microsoft.com%2fen-us%2flibrary%2faa730921%2528v%3doffice.12%2529.aspx&lc=1033&id=254354&mkt=en-US
>>> **
>>> *http://tinyurl.com/8749ypq*
>>> ===
>>> Don Guillett
>>> SalesAid Software
>>> dguille...@gmail.com
>>>
>>>  *From:* Amit Desai (MERU) 
>>> *Sent:* Tuesday, December 13, 2011 9:51 AM
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* $$Excel-Macros$$ Urgent help needed on Slow Excel Performance
>>>
>>>
>>> Dear Friends,
>>>
>>> 
>>>
>>> I have attached one excel sheet. If you make any changes it is taking
>>> very long time.
>>>
>>> 
>>>
>>> Could you please check & suggest how to speed up its performance. It
>>> should not take more than few seconds to do any editing in this file!***
>>> *
>>>
>>> 
>>>
>>> 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.
>>>  --
>>> FORUM RULES (934+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>>
>>>
>>>
>>>
>>> --
>>> FORUM RULES (934+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>>

Re: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance

2011-12-13 Thread Jitendra singh 
dear all,
 how can i learn macro.
please suggest me.

Thanks & Regards
Jitendra Singh

On Tue, Dec 13, 2011 at 10:04 PM, dguillett1  wrote:

>   *http://tinyurl.com/7yt37xy*
>
>
>
> https://login.live.com/login.srf?wa=wsignin1.0&rpsnv=11&checkda=1&ct=1323793906&rver=6.0.5276.0&wp=MCLBI&wlcxt=msdn%24msdn%24msdn&wreply=http%3a%2f%2fmsdn.microsoft.com%2fen-us%2flibrary%2faa730921%2528v%3doffice.12%2529.aspx&lc=1033&id=254354&mkt=en-US
> **
> *http://tinyurl.com/8749ypq*
> ===
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Amit Desai (MERU) 
> *Sent:* Tuesday, December 13, 2011 9:51 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Urgent help needed on Slow Excel Performance
>
>
> Dear Friends,
>
> 
>
> I have attached one excel sheet. If you make any changes it is taking very
> long time.
>
> 
>
> Could you please check & suggest how to speed up its performance. It
> should not take more than few seconds to do any editing in this file!
>
> 
>
> 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.
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
>
>
>
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers

2011-12-01 Thread Jitendra singh 
=LARGE(A1:G1,2)
Regards
jeet

On Thu, Dec 1, 2011 at 3:51 PM, Aindril De  wrote:

> Hi Friends,
> I have a list of numbers, for e.g. 1,3,2,4,2,3,4,5,2. I would need to
> extract the second biggest number from this list.
> Note: This list cannot be sorted. I have already found out how to do it
> from a sorted list. Also I would need this to be done possibly through a
> formula and not any UDF.
>
> --
>
> Warm Regards,
> Andy
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

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

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

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

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

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

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

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

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