Re: $$Excel-Macros$$ Movie Collection Manager

[Abhishek Jain]

Anyone...?

On Thu, Mar 1, 2012 at 6:57 PM, Abhishek Jain wrote:

> Hi friends,
>
> For the sake of learning I just keep doing some thing or the other, mostly
> in excel. Once something occurred to me and this is what I have
> accomplished so far -
>
> http://www.youtube.com/watch?v=-NT6IYrTqew
>
> Please view the video to understand what exactly I am talking about
> (recommended in full screen for better view).
>
> As can be viewed, whenever I need to add a movie details in this file I
> have to manually enter the same. Before this, I tried several movie manager
> softwares, but none of them seemed perfect (due to one or the other
> problem). These movie manager sofwares use scripts (PHP or Sql, may be, I
> have no idea) to connect to different movie database sites (imdb, amazon,
> etc.) and then to automatically download the details, covers, etc.
>
> My question - is there any way we can make some thing similar to those
> scripts OR incorporate one of them in VBA to retrieve these details via
> Excel only.
>
> The reason why am I asking this - I have 1200+ Hollywood movies, 200+
> Bollywood movies, 300+ Documentaries, Over 40 seasons of various serials
> (Prison Break, Two and a Half Men, I dream of jeannie, Lie to me, Big bang
> theory, How I met your mother, etc.) and some other stuff. Now you all can
> easily understand that I would loose all my hair if I had to update all
> these.manually.
>
> Any and all ideas are welcome.
>
> I would be happy to share further details if anyone is interested in
> working with me on this.
>
> Thanks & regards,
>
> Abhishek
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

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

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

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

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

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

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

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

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

$$Excel-Macros$$ Excel VBA Password protection

[PrIyAnKa]

Dear Team

Kindly let me know how to protect macro in Excel 2007

I want to lock the VBA so no one can step into it w/o the password

-- 
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$$ how to subscribe?

[Mohammed Muneer]

Thanx Noorain,

 

I will try once and let u know.

 

 

Regards,

Muneer,

CC...



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI
Sent: Tuesday, March 06, 2012 8:34 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ how to subscribe?

 

Dear Muneer,

 

Please use below link to subscriobe Email ID munnu130134...@gmail.com

http://groups.google.com/group/excel-macros/subscribe

Hope it will help to you.

 

-- 

Thanks & regards,

Noorain Ansari

 http://noorainansari.com/

http://excelmacroworld.blogspot.com/
 


 

On Tue, Mar 6, 2012 at 9:20 AM, Mohammed Muneer 
wrote:

Dear Friends,

 

I want to subscribe this group with another mail id not Outlook -
munnu130134...@gmail.com

 

Can u please tell me how to subscribe?

 

 

 

Regards,

Muneer,

CC...

 

 

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

Re: $$Excel-Macros$$ GLOBAL COLLECTION

[NOORAIN ANSARI]

Dear Javivd,

can you share a sample with group

On Mon, Mar 5, 2012 at 5:38 AM, javivd  wrote:

> I want to work with Global Collections.
>
> I need to asociate IdProvider with NameIdProvider, but i don't want to
> use range because i need to use it in a function with a million
> records. And because i need to use this function in Ms Access as
> well.
>
> I would like to have a collection that, for each idProvider it give me
> the NameProvider. So the idea is to use IdProvider as the Key of the
> members of the collection, and NameProvider as the content.
>
> Does anyone know how to instanciate a Global Collection?
>
> Thanks in advance!!
>
>
> Javier
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Thanks & regards,
Noorain Ansari
 *http://noorainansari.com/* 
*http://excelmacroworld.blogspot.com/*

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Conditional Sum by negative & positive value

[Maries]

My Try,

For Negative,
=SUM(IF(IF($A$2:$A$27=E2,$C$2:$C$27,0)<0,$C$2:$C$27,0))
For Positive,
=SUM(IF(IF($A$2:$A$27=E2,$C$2:$C$27,0)>0,$C$2:$C$27,0))

Formula Apply with *CSE*.

Regards,

MARIES.
+971502420957
On Tue, Mar 6, 2012 at 9:40 AM, NOORAIN ANSARI wrote:

> Dear Ashish,
>
> You can also try..
>
> For Negative
> =SUMIFS($C$2:$C$27,$C$2:$C$27,"<"&0,$A$2:$A$27,$E2)
> For Positive
> =SUMIFS($C$2:$C$27,$C$2:$C$27,">"&0,$A$2:$A$27,$E2)
>
> --
> Thanks & regards,
> Noorain Ansari
>  ** *http://noorainansari.com/*
> *http://excelmacroworld.blogspot.com/*
> On Tue, Mar 6, 2012 at 10:26 AM, Ashish Bhalara  > wrote:
>
>> Dear expert,
>>
>> I need a condition of sum which sum only positive value and only negative
>> value, the example sheet are attached herewith.
>>
>> Thanks & regards
>>
>> Ashish Bhalara
>>
>> --
>> 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


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

Re: $$Excel-Macros$$ Conditional Sum by negative & positive value

[NOORAIN ANSARI]

Dear Ashish,

You can also try..

For Negative
=SUMIFS($C$2:$C$27,$C$2:$C$27,"<"&0,$A$2:$A$27,$E2)
For Positive
=SUMIFS($C$2:$C$27,$C$2:$C$27,">"&0,$A$2:$A$27,$E2)

-- 
Thanks & regards,
Noorain Ansari
 *http://noorainansari.com/* 
*http://excelmacroworld.blogspot.com/*
On Tue, Mar 6, 2012 at 10:26 AM, Ashish Bhalara
wrote:

> Dear expert,
>
> I need a condition of sum which sum only positive value and only negative
> value, the example sheet are attached herewith.
>
> Thanks & regards
>
> Ashish Bhalara
>
> --
> 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


CONDITIONAL SUM(Solved).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Conditional Sum by negative & positive value

[Abhishek Jain]

For Negatives - (in F2 and drag down) -

=SUMPRODUCT(($A$2:$A$27=E2)*($C$2:$C$27<0)*$C$2:$C$27)

For Positives - (in G2 and drag down) -

=SUMPRODUCT(($A$2:$A$27=E2)*($C$2:$C$27>0)*$C$2:$C$27)

Attached.

HTH
Abhishek

On Tue, Mar 6, 2012 at 10:26 AM, Ashish Bhalara
wrote:

> Dear expert,
>
> I need a condition of sum which sum only positive value and only negative
> value, the example sheet are attached herewith.
>
> Thanks & regards
>
> Ashish Bhalara
>
> --
> 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


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

RE: $$Excel-Macros$$ how to subscribe?

[Mohammed Muneer]

Mr. Seraj I try, this way last night but not working.

 

Reply me

 

 

Regards,

Muneer,

CC...

 



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Seraj Alam
Sent: Tuesday, March 06, 2012 7:06 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ how to subscribe?

 

Hi,

 

Please find below link to join this group.

 

http://groups.google.com/group/excel-macros 

 

On Mon, Mar 5, 2012 at 7:50 PM, Mohammed Muneer 
wrote:

Dear Friends,

 

I want to subscribe this group with another mail id not Outlook -
munnu130134...@gmail.com

 

Can u please tell me how to subscribe?

 

 

 

Regards,

Muneer,

CC...

 

 

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

Re: $$Excel-Macros$$ how to subscribe?

[Seraj Alam]

Hi,

Please find below link to join this group.

http://groups.google.com/group/excel-macros


On Mon, Mar 5, 2012 at 7:50 PM, Mohammed Muneer  wrote:

>  Dear Friends,
>
> ** **
>
> I want to subscribe this group with another mail id not Outlook –
> munnu130134...@gmail.com
>
> ** **
>
> Can u please tell me how to subscribe?
>
> ** **
>
> ** **
>
> ** **
>
> Regards,
>
> Muneer,
>
> CC...
>
> ** **
>
> ** **
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

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

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

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

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

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

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

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

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

$$Excel-Macros$$ how to subscribe?

[Mohammed Muneer]

Dear Friends,

 

I want to subscribe this group with another mail id not Outlook -
munnu130134...@gmail.com

 

Can u please tell me how to subscribe?

 

 

 

Regards,

Muneer,

CC...

 

 

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

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

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

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

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

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

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

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

$$Excel-Macros$$ copy range

[LearnExcel]

Hi Guys/Girls i use VBA to copy a range using the following code

Selection.AutoFilter Field:=7, Criteria1:="bob"
ActiveSheet.Range("a1:o1", ActiveSheet.Range("a1").End(xlDown)).Select

the problem that i have is in cell "G" after the last cell there is a
3 lines of blank cell and then the report,


once the filter is made i want the cell to also include the"Name
report"


can anyone help?

datanamenam nam nam nam nam nam nam
3/5/2012random  johnbob dog bob johnnew name
nam
3/6/2012random  johnbob dog bob johnnew name
nam
3/6/2012random  johnbob dog bob johnnew name
nam
3/6/2012bob dog bob johnrandom  random  johnbob
3/6/2012johnbob dog bob johnrandom  johnbob
3/6/2012random  johnbob dog bob johnnew name
nam
3/6/2012bob bob dog bob johnrandom  johnbob
3/6/2012random  johnbob bob random  random  johnbob
3/6/2012random  johnbob dog bob johnnew name
nam



Name report

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

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

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

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

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

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

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

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

$$Excel-Macros$$ GLOBAL COLLECTION

[javivd]

I want to work with Global Collections.

I need to asociate IdProvider with NameIdProvider, but i don't want to
use range because i need to use it in a function with a million
records. And because i need to use this function in Ms Access as
well.

I would like to have a collection that, for each idProvider it give me
the NameProvider. So the idea is to use IdProvider as the Key of the
members of the collection, and NameProvider as the content.

Does anyone know how to instanciate a Global Collection?

Thanks in advance!!


Javier

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

[Seran Senguttuvan. M.N]

Please Help & Urgent
anybody pls forward me a employee database entery excel vba file

On 3/3/12, Seran Senguttuvan. M.N  wrote:
> hai ,
>
> any can forward me a employee database entery excel vba file
>
> --
> Regards
>
>
> M.N.Seran Senguttuvan,
>
> --
> 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
>


-- 
Regards


M.N.Seran Senguttuvan,MBA.,D.LL,.
Assistant Manager - HRD
G.M.Pens International Pvt. Limited.
Reynolds: *The Pen world Prefers*

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

[Mahesh parab]

Hi

Try :

Sub Mtest()
Dim i As Long
Application.ScreenUpdating = False
On Error Resume Next
For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1
If InStr(1, Cells(i, 1).Value, "This page", 1) Or _
InStr(1, Cells(i, 1).Value, "Search Results", 1) Or _
InStr(1, Cells(i, 1).Value, "Pick Ticket/ Release #", 1) Or _
Cells(i, 1).Value = "" _
Then Cells(i, 1).EntireRow.Delete
Next i
End Sub

Thanks
Mahesh

On Fri, Mar 2, 2012 at 12:38 PM, vijayajith VA wrote:

> hi shaik.
>
> Sorry. i need code for ths..
>
>
> On Fri, Mar 2, 2012 at 12:38 PM, vijayajith VA wrote:
>
>> Hi Sahik,,
>>
>> Sorry ..i need required code for ths .. Thanks''
>>
>>
>> On Fri, Mar 2, 2012 at 12:35 PM, Shaik Waheed wrote:
>>
>>> Hi,
>>> PFA solved, hope this is what u need.
>>>
>>> Steps:1) Select ur data range--> click on "data" menu, ---> Remove
>>> Duplicates--->Just click OK.
>>>
>>> On Fri, Mar 2, 2012 at 12:14 PM, vijayajith VA 
>>> wrote:
>>>
 Hi



 Please find the attached query///


 Thanks

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

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

[Mahesh parab]

Try :

http://makeagif.com/
http://picasion.com/

On Tue, Mar 6, 2012 at 12:00 AM, Asa Rossoff  wrote:

> Hi Rekha,
>
> Outlook doesn't support animated GIFs.  Hasn't for many years.  They will
> just appear as a still image in Outlook, although they will probably still
> be animated for your mail recipients that use other mail clients, at least
> for web mail accounts.
>
> ** **
>
> Alternatively you can send a video file for the recipient to open, or a
> file with an embedded video, perhaps using Powerpoint; a link to an
> animated GIF or PNG on a web server, or a link to a hosted video such as on
> Youtube.
>
> Asa
>
> ** **
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *rekha siri
> *Sent:* Monday, March 05, 2012 1:44 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Need advise
>
> ** **
>
> Thanks Xls time, if i want to send  mail using outlook will it work over
> there if so please can you 
>
> ** **
>
> help me out in this concern.
>
> On Mon, Mar 5, 2012 at 7:58 AM, xlstime  wrote:
>
>
> use Google Insert Image option  in G mail or you can use link a .gif
> file...
> [image: Inline image 1]
>
>
>
>
> 
>
> On Mon, Mar 5, 2012 at 12:41 AM, rekha siri 
> wrote:
>
> hi Experts,
>
> ** **
>
> I Am excel trainer, just wanted to know how can we place this kind of
> animation in mail for excel functions or training's
>
> ** **
> Use CTRL + Enter To Enter Same Data in to Multiple Cells(Quick Tip)
>
> created by *Raja Sekhar P* 
> on
> Mar 4, 2012 1:34 PM, last modified by *Raja Sekhar 
> P* on
> Mar 4, 2012 1:39 PM
>
> *Use CTRL + Enter To Enter Same Data in to Multiple Cells(Quick Tip)*
>
>  
>
> 
>
> Here is a quick Excel tip to kick start your 
> week.
>
> Sometimes, we want to enter same data in to several cells. You can use
> CTRL+Enter to do this in a 
> snap.
>
> (1) Select all the cells where you want to enter the same data.
> (2) Type the data
> (3) Press CTRL+Enter
> (4) 
> Done!
>
> ** 
> **
>
> ** 
> **
>
> --
> 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 advise

[Asa Rossoff]

Hi Rekha,

Outlook doesn't support animated GIFs.  Hasn't for many years.  They will
just appear as a still image in Outlook, although they will probably still
be animated for your mail recipients that use other mail clients, at least
for web mail accounts.

 

Alternatively you can send a video file for the recipient to open, or a file
with an embedded video, perhaps using Powerpoint; a link to an animated GIF
or PNG on a web server, or a link to a hosted video such as on Youtube.

Asa

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of rekha siri
Sent: Monday, March 05, 2012 1:44 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need advise

 

Thanks Xls time, if i want to send  mail using outlook will it work over
there if so please can you 

 

help me out in this concern.

On Mon, Mar 5, 2012 at 7:58 AM, xlstime  wrote:


use Google Insert Image option  in G mail or you can use link a .gif file...
 Inline image 1
 






On Mon, Mar 5, 2012 at 12:41 AM, rekha siri 
wrote:

hi Experts,

 

I Am excel trainer, just wanted to know how can we place this kind of
animation in mail for excel functions or training's

 


Use CTRL + Enter To Enter Same Data in to Multiple Cells(Quick Tip)


created by   Raja Sekhar P
on Mar 4, 2012 1:34 PM, last modified by
 Raja Sekhar P on Mar 4,
2012 1:39 PM

Use CTRL + Enter To Enter Same Data in to Multiple Cells(Quick Tip)

 

 
 

 
 Here is a quick Excel tip to kick start your week.

 
 Sometimes, we want to enter same data in to several cells. You can use
CTRL+Enter to do this in a snap.

 
 (1) Select all the cells where you want to enter the same data.
(2) Type the data
(3) Press CTRL+Enter
(4) Done!

 
  

 
  

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

Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

[Jorge Marques]

Perfect, I wasn´t aware of that. Thank you very much.

2012/2/29 dguillett1 

>   range uses Range9(“a1:z21”)
> cells uses cells(1,1) or cells(1,”a”) for Row first and column second.
> result is the same
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Jorge Marques 
> *Sent:* Wednesday, February 29, 2012 5:11 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Help on gathering duplicate summing and
> counting
>
>  Sorry my friends for writting again in the post, it just that i
> understood this code, the only thing i don´t get is if the control cell is
> Z and not A, how can i change it, because, i have a another report that is
> exactly like the initial post but now the control is not A- Order but cell
> Z - Shop, how can i turn this around, is it done in the code line:
>
> If Cells(i + 1, 1) = Cells(i, 1) do i have to change the 1 to the
> correspondent Column of Z? Thank you again :).
>
> 2012/2/22 dguillett1 
>
>>   Glad to help
>>
>> Don Guillett
>> SalesAid Software
>> dguille...@gmail.com
>>
>>  *From:* Jorge Marques 
>> *Sent:* Wednesday, February 22, 2012 10:00 AM
>>  *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ Help on gathering duplicate summing and
>> counting
>>
>>
>> Hi, Aamir Shahzad was option was good, but it suited me for doing another
>> thing in another report, but i needed in a macro format in order to delete
>> the data whenever i pull a report, dguillett1 was exactly as i wanted :).
>> thank you very much both of you.
>>
>> 2012/2/20 dguillett1 
>>
>>>   I didn’t do columns F & G so use this
>>> Sub ConsolidateTotalsSAS()
>>> Dim i As Long
>>> For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1
>>> If Cells(i + 1, 1) = Cells(i, 1) Then
>>> Cells(i, "e") = Val(Cells(i + 1, "e")) + Val(Cells(i, "e"))
>>> Cells(i, "f") = Val(Cells(i + 1, "f")) + Val(Cells(i, "f"))
>>> Cells(i, "g") = Val(Cells(i + 1, "g")) + Val(Cells(i, "g"))
>>> Rows(i + 1).Delete
>>> End If
>>> Next i
>>> End Sub
>>>
>>>
>>> Don Guillett
>>> SalesAid Software
>>> dguille...@gmail.com
>>>
>>>  *From:* Aamir Shahzad 
>>> *Sent:* Monday, February 20, 2012 11:11 AM
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* Re: $$Excel-Macros$$ Help on gathering duplicate summing and
>>> counting
>>>
>>>   Dear Jorge,
>>>
>>> See the third table in attached sheet.
>>>
>>> Aamir Shahzad
>>>
>>> On Mon, Feb 20, 2012 at 9:30 PM, Jorge Marques wrote:
>>>
 Hi friends, i have a problem,
 1. i trying to use a report and i have to sum the column H, G, F, if
 the orders numbers are equal and
 2. leave the information in column B,C,D, gathered.
 3. The problem is that i was doing it with formulas, but didn´t have a
 dinamic range that´s the first,
 4. then the system has changed, the report is generated by a sql, so i
 loose the formulas everytime i generate a report and i can´t gather the
 column B,C,D.
 5. is there any way i can do it, by macro, running it after i push the
 report from SQL? Thank you very much.


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

>>>
>>>
>>>
>>> --
>>>
>>> Regards,
>>>
>>> Aamir Shahzad
>>>
>>> --
>>> 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

Re: $$Excel-Macros$$ Need advise

[xlstime]

same. got to insert option then click picture option ..and select your
image ..

On Mon, Mar 5, 2012 at 3:13 PM, rekha siri  wrote:

> Thanks Xls time, if i want to send  mail using outlook will it work over
> there if so please can you
>
> help me out in this concern.
>
>
> On Mon, Mar 5, 2012 at 7:58 AM, xlstime  wrote:
>
>>
>> use Google Insert Image option  in G mail or you can use link a .gif
>> file...
>> [image: Inline image 1]
>>
>>
>>
>>
>> On Mon, Mar 5, 2012 at 12:41 AM, rekha siri wrote:
>>
>>> hi Experts,
>>>
>>> I Am excel trainer, just wanted to know how can we place this kind of
>>> animation in mail for excel functions or training's
>>>
>>> Use CTRL + Enter To Enter Same Data in to Multiple Cells(Quick Tip)
>>> created by Raja Sekhar P 
>>> on
>>> Mar 4, 2012 1:34 PM, last modified by Raja Sekhar 
>>> P on
>>> Mar 4, 2012 1:39 PM
>>>
>>> *Use CTRL + Enter To Enter Same Data in to Multiple Cells(Quick Tip)*
>>>
>>>
>>> [image: Use CTRL+Enter to Enter Same Data in to Multiple Cells [Quick
>>> Tip]]
>>>
>>> Here is a quick Excel tip to kick start your week.
>>>
>>> Sometimes, we want to enter same data in to several cells. You can use
>>> CTRL+Enter to do this in a snap.
>>>
>>> (1) Select all the cells where you want to enter the same data.
>>> (2) Type the data
>>> (3) Press CTRL+Enter
>>> (4) Done!
>>>
>>>
>>>
>>>  --
>>> 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
>



-- 
.

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

RE: $$Excel-Macros$$ Split Number into multiple cell

[Rajan_Verma]

=Transpose(Mid(A1,Row(Indirect("1:" & Len(A1"))),1)) with CSE

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ICWAI Help
Sent: Mar/Mon/2012 07:28
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Split Number into multiple cell

Hi Ashish,

could  you plese tell me the formula for Spliting number into multiple cell
appriciate fi  you have vba code but it shouold be dynamics


12345 like 1  2   3   4   5  in multiple columnsa

--
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$$ Hi Expert- please spend your few minute only on this question.

[Divaker Pandey]

yeah, that is true. Google is our universal friend.

but it will be awesome if group members  got list of  real time problem, or
difference expert faces during use of different versions of excel.


Divaker


On Mon, Mar 5, 2012 at 8:43 PM, dguillett1  wrote:

>   Google is your friend.
>
> excel version differences
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Divaker Pandey 
> *Sent:* Monday, March 05, 2012 8:53 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Hi Expert- please spend your few minute only
> on this question.
>
> Hi Expert,
>
> Can anyone list out different between Excel 2003,2007 and 2010.
>
> 1. Basis of Basic Enhancement.
> 2. Advanced Enhancement.
> 3.VBA Object Enhancement
> 4. Macros Enhancement
>
> Really, if you expert spend you few minute to give you comment on your
> level, it may be great learning for each and everyone member of this
> blogger.
>
> thanks in advance for your precious contribution.
>
> Divaker
>
> --
> 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

Re: $$Excel-Macros$$ Hi Expert- please spend your few minute only on this question.

[dguillett1]

Google is your friend.

excel version differences

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

From: Divaker Pandey 
Sent: Monday, March 05, 2012 8:53 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Hi Expert- please spend your few minute only on this 
question.

Hi Expert,

Can anyone list out different between Excel 2003,2007 and 2010.

1. Basis of Basic Enhancement.
2. Advanced Enhancement.
3.VBA Object Enhancement
4. Macros Enhancement

Really, if you expert spend you few minute to give you comment on your level, 
it may be great learning for each and everyone member of this blogger.

thanks in advance for your precious contribution.

Divaker

-- 
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$$ Object Hyperlin : Deletion

[Rajan_Verma]

Try this:

 

Sub RemoveHyperLink()

Dim shpShape As Shape

For Each shpShape In ActiveSheet.Shapes

shpShape.Hyperlink.Delete

Next shpShape

End Sub

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Chandra Shekar
Sent: Mar/Fri/2012 04:57
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Object Hyperlin : Deletion

 

Hello,

 

Could you please let me know how to remove hyperlinks linked to graphical
objects (Its nearly 1000 objects)

 

Thanks in advance.

 

Regards,

 

Chandra Shekar B

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

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

-- 
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$$ Split Number into multiple cell

[dguillett1]

Why not just use
data>text to columns>fixed width>>



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

Sent: Monday, March 05, 2012 7:58 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Split Number into multiple cell

Hi Ashish,

could  you plese tell me the formula for Spliting number into multiple
cell appriciate fi  you have vba code
but it shouold be dynamics


12345 like 1  2   3   4   5  in multiple columnsa

--
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$$ Kindly help me with my question on Excel

[Rajan_Verma]

 

HI,

Do you want this :

Format : HH:MM:SS

 

=TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW())+20)

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Aruna jayaram
Sent: Mar/Fri/2012 12:27
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Kindly help me with my question on Excel

 

Kindly help me with my question on Excel i.e., I have time in the format
01:02:40 ( hh:mm:ss) but I want the time to be shown as 01:03 i.e., seconds
to be rounded off to minutes. 

And if you have any files on visual basic 2008 with examples that I can use
to learn with screenshots and codes. Please send it to me.

Please reply ASAP.

Thanks 

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

[Rajan_Verma]

Try this :

 

To get the list of file in selected folder :

 

Option Compare Text

Sub GetFileListFromFolder()

 

Dim strFolderPath   As String

Dim objFso  As Object

Dim objFolder   As Object

Dim objFile As Object

Dim lngICounter As Integer



With Application.FileDialog(msoFileDialogFolderPicker)

.Show

.AllowMultiSelect = False

strFolderPath = .SelectedItems(1)

End With



If strFolderPath = "" Then

MsgBox "Cancelled by User", vbCritical

Exit Sub

End If



Set objFso = CreateObject("Scripting.FileSystemobject")

Set objFolder = objFso.getFolder(strFolderPath)

lngICounter = 2



For Each objFile In objFolder.Files

Cells(lngICounter, 1).Value = objFile.Path

lngICounter = lngICounter + 1

Next



MsgBox "Total File Found : " & lngICounter - 1, vbInformation



strFolderPath = Empty

Set objFso = Nothing

Set objFolder = Nothing

Set objFile = Nothing

lngICounter = Empty



End Sub

 

To Delete the selected files :

 

Sub DeleteFiles()

  

Dim objFso  As Object

Dim rngCell As Range

Dim rngRangeAs Range

Dim objFile As Object

Set objFso = CreateObject("Scripting.FileSystemobject")

Set rngRange = Sheet1.Range("B1:B" & Sheet1.UsedRange.Rows.Count)

For Each rngCell In rngRange

If rngCell.Value = "Yes" Then

Set objFile = objFso.getFile(rngCell.Offset(, -1).Value)

objFile.Delete

End If

Next

End Sub

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shinda Singh
Sent: Mar/Thu/2012 03:03
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need Urgent Help_Surendra

 

Hi Team,

 

I need a help from your side, i have a folder where more that 2000 xls and
word and PDF file save. i want to make a list of name in MS excel and then i
want to delete the unusable file from the list,

 

Please help me.

 

Thanks and Regards,

 

Surendra Singh

+91 95842 66415

 

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


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

$$Excel-Macros$$ Split Number into multiple cell

[ICWAI Help]

Hi Ashish,

could  you plese tell me the formula for Spliting number into multiple
cell appriciate fi  you have vba code
but it shouold be dynamics


12345 like 1  2   3   4   5  in multiple columnsa

-- 
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$$ Needle Gauge Chart

[Rajan_Verma]

You can check in Name ranges. Here many name ranges are showing reference
error..

 

Rajan.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of hilary lomotey
Sent: Mar/Thu/2012 09:02
To: excel-macros; David Grugeon
Subject: $$Excel-Macros$$ Needle Gauge Chart

 

Hello Experts

 

 

i am trying to follow the logic behind how the figures behind column K was
derived but i still cant see any connection. could you kindly explain to me
pls. thanks 

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

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

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

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

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

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

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

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

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

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

$$Excel-Macros$$ custom number formating

[danial mansoor]

7928688.conver this number using custom number format into 1000 mean i 
need custom number formating 7929 same goes with othe rnumber also.



 




Date: Mon, 5 Mar 2012 16:49:27 +0530
Subject: $$Excel-Macros$$ Help On Chart
From: shrinivas...@gmail.com
To: excel-macros@googlegroups.com



Dear Experts
I want a help for charts.
I wants  to make a 3 charts in one graph,but problem is that the ranges are 
different for eg ranges are as follows 
range -1  =: 13 to 15
range -2  =: 19 to 22
range -1  =: 28 to 32
 
If i make all the charts in one graph then the scale will taken as from (min 13 
to max 32) which is very large scale suppose there is a reading in the range 
(12.8, 13.1, 12.5) due to large scale it doesnot show difference on graph
Actually I want is that Can I adjust the Y scale Like (13 to 15 then 19 to 22 
and then 28 to 32) as there is no reading in between
 
DAta sheet and graph attached (chart1 sheet 1)
 
Waiting for reply
 
Thanks in advance
 
Ragards
Shrinivas 
-- 
Shrini

-- 
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$$ Data saving problem

[Abhishek Jain]

I'd like to help...just that I never understood your exact problem. I mean
when I made a sample entry, it was fine (for first few columns). Can you
send screen shots of your input (what you are entering in the form) and a
sample output (what you want in which column)

Regards,

On Mon, Mar 5, 2012 at 3:16 PM, Shankar Bheema wrote:

> Dear experts
>
> Pls provide solution.  I stuck with that problem and my work is held up
> due to the problem.
>
> waiting for your valuable reply
>
> -- Forwarded message --
> From: Shankar Bheema 
> Date: Fri, Mar 2, 2012 at 1:54 PM
> Subject: Fwd: $$Excel-Macros$$ Data saving problem
> To: excel-macros@googlegroups.com
>
>
> Dear Experts
>
> Please provide solution. Please look at the "Employee Details" worksheet,
> it saves all unwanted data.  I did not understand where I made mistake in
> the saving option.  Kindly provide solution.
>
> regards
> shankar sb
>
>
> -- Forwarded message --
> From: Shankar Bheema 
> Date: Thu, Mar 1, 2012 at 12:16 PM
> Subject: $$Excel-Macros$$ Data saving problem
> To: excel-macros@googlegroups.com, Sam Mathai Chacko 
>
>
> Dear Experts
>
> I am attaching a workbook.
>
> The userform namely "formcalsheet" is the main form connects to the other
> worksheets.  I am facing a problem while saving data by clicking Save
> command button on the userform.  Actually after clicking on the Get Form
> command button of the worksheet namely "datasheet", the above userform will
> open and after entry of the data I am clicking save command and then
> Datasheet command for obtaining relevant data on the "employee details"
> worksheet.  But, Datasheet details also coming on the employee details
> datasheet.  Please provide solution for how to restrict that data not to
> come in the employee details.
>
> regards
> shankar sb
>
> --
> 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

RE: $$Excel-Macros$$ Extract the numbers....

[Mohammed Muneer]

Dear Maries,   thanx for the help.

 



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Maries
Sent: Monday, March 05, 2012 1:52 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Extract the numbers

 

Hi,

 

Try it...

 

=RIGHT(A1,LEN(A1)-FIND("-",A1,1))

 

Regards,

 

MARIES.

On Mon, Mar 5, 2012 at 2:47 PM, Mohammed Muneer 
wrote:

Dear Group,

 please help to extract the numbers in one cell to
another through formula.

 

 

Regards,

Muneer,

CC

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

Re: $$Excel-Macros$$ Extract the numbers....

[Maries]

Hi,

Try it...

=RIGHT(A1,LEN(A1)-FIND("-",A1,1))

Regards,

MARIES.

On Mon, Mar 5, 2012 at 2:47 PM, Mohammed Muneer  wrote:

> **
> Dear Group,
>  please help to extract the numbers in one cell to another
> through formula.
>
>
> Regards,
> Muneer,
> CC
>
> --
> 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


Solution.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Extract the numbers....

[Mohammed Muneer]

Dear Group,
 please help to extract the numbers in one cell to
another through formula.
 
 
Regards,
Muneer,
CC

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


yn2.xls
Description: yn2.xls

Re: $$Excel-Macros$$ Need advise

[rekha siri]

Thanks Xls time, if i want to send  mail using outlook will it work over
there if so please can you

help me out in this concern.

On Mon, Mar 5, 2012 at 7:58 AM, xlstime  wrote:

>
> use Google Insert Image option  in G mail or you can use link a .gif
> file...
> [image: Inline image 1]
>
>
>
>
> On Mon, Mar 5, 2012 at 12:41 AM, rekha siri wrote:
>
>> hi Experts,
>>
>> I Am excel trainer, just wanted to know how can we place this kind of
>> animation in mail for excel functions or training's
>>
>> Use CTRL + Enter To Enter Same Data in to Multiple Cells(Quick Tip)
>> created by Raja Sekhar P on
>> Mar 4, 2012 1:34 PM, last modified by Raja Sekhar 
>> P on
>> Mar 4, 2012 1:39 PM
>>
>> *Use CTRL + Enter To Enter Same Data in to Multiple Cells(Quick Tip)*
>>
>>
>> [image: Use CTRL+Enter to Enter Same Data in to Multiple Cells [Quick
>> Tip]]
>>
>> Here is a quick Excel tip to kick start your week.
>>
>> Sometimes, we want to enter same data in to several cells. You can use
>> CTRL+Enter to do this in a snap.
>>
>> (1) Select all the cells where you want to enter the same data.
>> (2) Type the data
>> (3) Press CTRL+Enter
>> (4) Done!
>>
>>
>>
>>  --
>> 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

Re: $$Excel-Macros$$ Charts in Excel

[Shrinivas Shevde]

Dear Experts
I want a help for charts.
I wants  to make a 3 charts in one graph,but problem is that the ranges are
different for eg ranges are as follows
range -1  =: 13 to 15
 range -2  =: 19 to 22
range -1  =: 28 to 32

If i make all the charts in one graph then the scale will taken as from
(min 13 to max 32) which is very large scale suppose there is a reading in
the range (12.8, 13.1, 12.5) due to large scale it doesnot show difference
on graph
Actually I want is that Can I adjust the Y scale Like (13 to 15 then 19 to
22 and then 28 to 32) as there is no reading in between

DAta sheet and graph attached (chart1 sheet 1)

Waiting for reply

Thanks in advance

Ragards
Shrinivas


On Wed, Feb 29, 2012 at 12:55 PM, PrIyAnKa  wrote:

> THanks Abhishek ,its also done
>
>
> On Wed, Feb 29, 2012 at 12:53 PM, Abhishek Jain wrote:
>
>> http://peltiertech.com/Excel/Charts/ComboCharts.html
>>
>>
>> On Wed, Feb 29, 2012 at 11:45 AM, PrIyAnKa  wrote:
>>
>>> have already  downloaded all and have learnt some charts from chandoo
>>> org.
>>>
>>> Thanka
>>>
>>>  On Wed, Feb 29, 2012 at 11:15 AM, NOORAIN ANSARI <
>>> noorain.ans...@gmail.com> wrote:
>>>
 Hi Priyanka,

 Please visit on Chandoo site, he has good colletions of charts

 see below link..
 http://chandoo.org/wp/2009/11/30/quick-chart-formatting/

  On Wed, Feb 29, 2012 at 10:51 AM, PrIyAnKa wrote:

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



 --
 Thanks & regards,
 Noorain Ansari
  ** *http://noorainansari.com/*
 *http://excelmacroworld.blogspot.com/*


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

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

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

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

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

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

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


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

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