$$Excel-Macros$$ Index and Match

[Darwin Chan]

Hi group,

Currently I m reviewing the use of Index and match. However, anyone can
point out what is missing in my forumla?

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

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

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

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

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

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

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

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

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


Index&Match.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Index and Match

[PrIyAnKa]

ear Darwin

Kindly find the attached file

On Tue, Feb 7, 2012 at 2:09 PM, Darwin Chan wrote:

> Hi group,
>
> Currently I m reviewing the use of Index and match. However, anyone can
> point out what is missing in my forumla?
>
> --
> Darwin Chan
> darwin.chankaw...@gmail.com
> kw42c...@yahoo.com.hk
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

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


Solved Index&Match.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Excel 2007 not opening the sheet

[NOORAIN ANSARI]

Dear Idhrees,

Please check below link..
http://www.mrexcel.com/forum/showthread.php?t=289850

On Mon, Feb 6, 2012 at 4:15 PM, Idhrees Mohamed wrote:

> Dear Friends,
>
> I am using excel 2007 and my files are not opening in the first attempt if
> i minimize the window and maximize or right click inside open or new then
> once the contents will show. Please let me know how can i rectify the
> error.
>
> --
> Thanks & Regards,
>
> Mohamed Idhrees. S.
>
> --
> 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$$ Index and Match

[NOORAIN ANSARI]

Dear Darwin,

Please try it without using helping coloun.
=INDEX($A$2:$A$14,MATCH(SMALL($B$2:$B$14,ROW(A1)),$B$2:$B$14,0))


See attached sheet..
On Tue, Feb 7, 2012 at 2:09 PM, Darwin Chan wrote:

> Hi group,
>
> Currently I m reviewing the use of Index and match. However, anyone can
> point out what is missing in my forumla?
>
> --
> Darwin Chan
> darwin.chankaw...@gmail.com
> kw42c...@yahoo.com.hk
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



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


Copy of Index&Match(Solved).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Index and Match

[NOORAIN ANSARI]

Dear Darwin,

Actually, It was query of one of our group member Mr. Pravesh kashyap, He
wanted to extract all vertical data in horizontal way as per
provided heading.

In this case.Heading is repeating again by again in column "A"
below function was used to extract column "B" data in horizontal way
against Duplicate Column A heading


*
=INDEX($B$3:$B$1930,SMALL(IF($A$3:$A$1930=D$2,ROW($B$3:$B$1930),""),ROW(A1))-2)
*this function is array function so need to press
CSE.

I hope my explanation will helpful for you.


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


On Tue, Feb 7, 2012 at 3:14 PM, Darwin Chan wrote:

> Thanks all,
>
> the reason is i m reviewing the use of index and match. Found when
> browsing this group from another thread, can anyone help to explain how is
> the logic?
>
>
> 2012/2/7 NOORAIN ANSARI 
>
>> Dear Darwin,
>>
>> Please try it without using helping coloun.
>> =INDEX($A$2:$A$14,MATCH(SMALL($B$2:$B$14,ROW(A1)),$B$2:$B$14,0))
>>
>>
>> See attached sheet..
>> On Tue, Feb 7, 2012 at 2:09 PM, Darwin Chan 
>> wrote:
>>
>>> Hi group,
>>>
>>> Currently I m reviewing the use of Index and match. However, anyone can
>>> point out what is missing in my forumla?
>>>
>>> --
>>> Darwin Chan
>>> darwin.chankaw...@gmail.com
>>> kw42c...@yahoo.com.hk
>>>
>>>  --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>
>>
>> --
>>
>>  --
>> 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
>>
>
>
>
> --
> Darwin Chan
> darwin.chankaw...@gmail.com
> kw42c...@yahoo.com.hk
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



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

Re: $$Excel-Macros$$ Excel test file Basic & Advance

[NOORAIN ANSARI]

Thanks Maries for useful attachment.

On Tue, Feb 7, 2012 at 4:08 PM, Maries  wrote:

> *Find the attached Excel File
> *
> On Tue, Feb 7, 2012 at 11:43 AM, NOORAIN ANSARI 
> wrote:
>
>> PFA
>>
>>
>> On Tue, Feb 7, 2012 at 12:42 PM, Amit Desai (MERU) <
>> amit.de...@merucabs.com> wrote:
>>
>>>  Dear Team,
>>>
>>> ** **
>>>
>>> Please forward excel test file for basic & advance level, if anybody
>>> have it.
>>>
>>>  
>>>
>>> Best Regards,
>>>
>>> Amit
>>>
>>> ** **
>>>
>>> --
>>> 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 (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
>



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

RE: $$Excel-Macros$$ paste special problem

[Rajan_Verma]

You can try Application.calculation = xlMannual , if calculation is not 
required everytime

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of vijayajith VA
Sent: Feb/Fri/2012 11:47
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ paste special problem

 

Hi mansoor,

 

sub tex()

selection.value = selection.value

end sub

 

On Fri, Feb 3, 2012 at 9:08 PM, danial mansoor  wrote:

i have a big file with many sheets i want to convert formula in values,if i do 
individually it will take lotes of time can any one tell me the macro which 
will work?

Note:macro should work fine in huge file i have a macro which is working fine 
with small file but not in huge file urgent help will be appreciated.




 

  _  

Date: Thu, 2 Feb 2012 09:21:22 +0530
Subject: Re: $$Excel-Macros$$ $$Excel-Ma​cros$$ Index & Match Formula
From: vijayendrar...@gmail.com
To: excel-macros@googlegroups.com

Hi Sam,

 

Your formulas resolves my problem and thanks a lot for the same. Can you please 
let me know the logic behind of this formula.

 

Rohan,

I wanted to pick the employees name from the same project and Sam done it in 
right way.

 

Regards,

Vijayendra

2012/2/1 Sam Mathai Chacko 

Here's the result.

I have also sorted the list based on project. Please confirm if that is what 
you are looking for.

Regards,
Sam Mathai Chacko 

 

On Wed, Feb 1, 2012 at 8:53 PM, Vijayendra Rao  wrote:

Dear All,

 

I want to put index & match formula (or any other formula) in attached file, 
can you please help me to put the formula.

 

Excel file is attached along with email.

 

Regards,
Vijayendra
94491 67631


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





-- 
Sam Mathai Chacko 



-- 
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,
Vijayendra
94491 67631



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

Re: $$Excel-Macros$$ Extract the single word called "cell" from the corresponding Rows().

[dguillett1]

Or a simple macro
‘=
Option Explicit
Option Compare Text
Sub getword()
Dim c As Range
For Each c In Range("e13:e21")
If InStr(c, "Cell") > 0 Then c.Offset(, 1) = "cell"
Next c
End Sub
‘
Don Guillett
SalesAid Software
dguille...@gmail.com

From: NOORAIN ANSARI 
Sent: Tuesday, February 07, 2012 2:17 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Extract the single word called "cell" from the 
corresponding Rows().

Dear Muneer,

Please use..

=IF(ISERROR(SEARCH("cell",E13,1)),"","cell")

See attached sheet.


On Mon, Feb 6, 2012 at 7:38 PM, Mohammed Muneer  wrote:





  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




-- 

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

Re: $$Excel-Macros$$ vlookup in Text Box

[Sam Mathai Chacko]

No dispute Asa, just a careful examination. Yes, the lines of code are more
or less the same.

Sam

On Tue, Feb 7, 2012 at 9:20 AM, Asa Rossoff  wrote:

> Sam, I think we have the same number of lines of code, by the way I have
> On Error, plus two lines of code.  You have two lines of code plus a
> suggestion to use On Error.  Only, yours resets Textbox5 at every Change
> event, whereas mine only does so if the Vlookup failed after entry is
> complete.. which is actually less code execution (but different behavior).
> 
>
> Asa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Sam Mathai Chacko
>
> *Sent:* Monday, February 06, 2012 9:42 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ vlookup in Text Box
>
> ** **
>
> A more appropriate event for this case would be the Exit event. You can
> just type in your number, for example 3 and hit the ENTER key. And
> generally speaking, the lesser the lines, the more efficient the code.
>
> Private Sub TextBox8_Exit(ByVal Cancel As MSForms.ReturnBoolean)
> TextBox5.Value = WorksheetFunction.VLookup(Val(TextBox8.Value),
> Range("DBase"), 2, False)
> End Sub
>
> Private Sub TextBox8_Change()
> TextBox5.Text = ""
> End Sub
>
> And just in case you want to ensure that there are no errors in case the
> user hits the enter key (return key) by mistake, you can add On Error
> Resume Next as Asa mentioned (in the Exit event that is).
>
> Regards,
> Sam Mathai Chacko
>
> On Mon, Feb 6, 2012 at 2:27 PM, Asa Rossoff  wrote:
>
> Hi charlie,
>
> Got it.
>
> Ok, the error is just indicating that the vlookup failed to find the
> Part#.  It failed for at least two reasons: (1) The VLookup is in the
> Change event, which fires after every change, such as after each keypress -
> -so the whole part# was probably not entered yet, and (2) The value of
> textboxes is text (a string in vba terminology), but the Part#s in your
> database are numbers.
>
>  
>
> You can resolve issue #1 by handling/ignoring errors, but leaving the code
> in the Change event, if you want Vlookups to execute repeatedly while
> someone types, i.e.:
>
> Private Sub TextBox8_Change()
>
> *On Error Resume Next*
>
> TextBox5.Value = WorksheetFunction.VLookup(TextBox8.Value, Range("DBase"),
> 2, False)
>
> End Sub
>
>  
>
> You can resolve issue #2 by use of the Val() function to convert the text
> to a number:
>
> Private Sub TextBox8_Change()
>
> On Error Resume Next
>
> TextBox5.Value = WorksheetFunction.VLookup(*Val(TextBox8.Value)*,
> Range("DBase"), 2, False)
>
> End Sub
>
>  
>
> You could, if desired, make the description field go blank rather than
> retaining it's previous value if there was an error in the vlookup:
>
> Private Sub TextBox8_Change()
>
> On Error Resume Next
>
> TextBox5.Value = WorksheetFunction.VLookup(Val(TextBox8.Value),
> Range("DBase"), 2, False)
>
> *If Err.Number <> 0 Then TextBox5.Value = ""*
>
> End Sub
>
>  
>
> *Back to issue #1:*  If you want to only do your Vlookups when the user
> has completely finished entering the part#, you should use a different
> event instead.  There are several events that might be appropriate, but
> probably BeforeUpdate would be a good call barring a specific reason to use
> another event:
>
> Private Sub TextBox8_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)**
> **
>
> On Error Resume Next
>
> TextBox5.Value = WorksheetFunction.VLookup(Val(TextBox8.Value),
> Range("DBase"), 2, False)
>
> If Err.Number <> 0 Then TextBox5.Value = "" ' Optional
>
> End Sub
>
>  
>
> Asa
>
>  
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Cab Boose
> *Sent:* Sunday, February 05, 2012 10:48 PM
> *To:* excel-macros@googlegroups.com
>
>
> *Subject:* Re: $$Excel-Macros$$ vlookup in Text Box
>
>  
>
> Hi Asa
>
>  
>
> Found the files see attached.
>
>  
>
> Charlie in New Zealand
>
>
>
>  
>
> On Mon, Feb 6, 2012 at 7:14 PM, Asa Rossoff  wrote:
>
> Charlie,
>
> Hmm… still not getting it.  Maybe an Excel 2010 incompatibility with your
> file?
>
> Can you right-click the userform and select Export File...  then send the
> resulting .frm and .frx files?
>
> Thanks,
>
> Asa
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Cab Boose
> *Sent:* Sunday, February 05, 2012 9:10 PM
>
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ vlookup in Text Box
>
>  
>
> Hi Asa
>
>  
>
> Workbook attached.  The code is in Userform 1.   Textbox 8
>
>  
>
>  
>
> Thanks 
>
>  
>
> Charlie
>
> On Mon, Feb 6, 2012 at 2:43 PM, Asa Rossoff  wrote:
>
> Hi Charlie,
>
> Can you post your workbook?  The orig

$$Excel-Macros$$ Plz, suggest can we do like this for the macro's. (for better explanation if u need plz check the attached file (Grm Details here) and Grm is the main file with two command buttons (F

[Mohammed Muneer]

1. This is original macro.

Sub fill()

 

 

 

'

 

 

 

' fill Macro

 

 

' Macro recorded 2/7/2012 by mmuneer

'

 

 

 

' Keyboard Shortcut: Ctrl+Shift+N

 

'

 

 

 

ActiveCell.FormulaR1C1 = "aa"

 

Selection.AutoFilter Field:=2, Criteria1:="aa"

End Sub

 

 

 

 

 

1. Can we do alterations in the original macro.

Sub fill()

 

 

 

'

 

 

 

' fill Macro

 

 

' Macro recorded 2/7/2012 by mmuneer

'

 

 

 

' Keyboard Shortcut: Ctrl+Shift+N

 

'

 

 

 

ActiveCell.FormulaR1C1 = "aa"

 

Selection.AutoFilter Field:=2, Criteria1:="aa"

---

ActiveCell.FormulaR1C1 = "bb"

 

Selection.AutoFilter Field:=2, Criteria1:="bb"

---

ActiveCell.FormulaR1C1 = "cc"

 

Selection.AutoFilter Field:=2, Criteria1:="cc"

 

End Sub

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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

Re: $$Excel-Macros$$ Hi friends, now its clear.....

[Sam Mathai Chacko]

Just a thought. Are you trying to say that if there is a common word in all
the lines, you need to know that word?

Example

I let you go
Let me in
Who let the dogs out
To let

and you need the value in your first column to be '*let*'?

I'd say caramba! if that's the case


And Excel_Lover, you need to add in error condition, otherwise it will
error out when there is no 'cell' in the text. Check Noorain's solution
where he suggested using IFERROR along with the SEARCH function.

Regards,
Sam Mathai Chacko


On Tue, Feb 7, 2012 at 11:15 AM, Excel_Lover  wrote:

> =IF(FIND("cell",E13),"cell","")
>
>
> On Tue, Feb 7, 2012 at 8:38 AM, Mohammed Muneer wrote:
>
>> ** **
>>
>> *del** cell   *
>>
>> *bel cell del*
>>
>> *cell bel del*
>>
>> *cell ell llec*
>>
>> *blood consist of red cell and white cell*
>>
>> *simos is a cell*
>>
>> *max cell*
>>
>> *sony cell*
>>
>> *a cell is a source of energy for some electronic devices and stands as
>> a two way power.*
>>
>> ** **
>>
>> Above mentioned lines are having the word “cell” in common, Ok I want to
>> extract the same in the cell beside (the highlighted).
>>
>> For example, we are at first line *del** cell *and if I can do
>> this to extract the word *cell.*
>>
>> * *
>>
>> cell
>>
>> del cell
>>
>> cell
>>
>> bel cell del
>>
>> cell
>>
>> cell bel del
>>
>> cell
>>
>> cell ell llec
>>
>> cell
>>
>> blood consist of red cell and white cell
>>
>> cell
>>
>> simos is a cell
>>
>> cell
>>
>> max cell
>>
>> cell
>>
>> sony cell
>>
>> cell
>>
>> a cell is a source of energy for some electronic devices and stands as a
>> two way power.
>>
>> ** **
>>
>> ** **
>>
>> 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
>



-- 
Sam Mathai Chacko

-- 
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$$ Sorry Muneer's file attachment - Grm!

[Sam Mathai Chacko]

The answer would be Yes, you can combine multiple sub-routines in to one.
However, you need to know what exactly you want to achieve before putting
them together. In your case, you have three routines, but all of them do
not actually produce an output, although they are performing some (similar)
actions. What do you want the macro to do is the question, and then you'll
know how to put them together.

Another point to keep in mind is that, a lot of recorded macro is
superfluous. You will in time learn to take out a lot of redundancies.
However, just to give you a slight idea of taking out redundant
codelook at the lines below

Range("A1").Select
Selection.Value = "Muneer"
Selection.Offset(1,0).Select

Look at all those superfluous selection action

Now, you could actually write this as Range("A1").Value = Muneer

and the next line is just a waste of resources as far as the developer is
concerned. It is just performing an action, but there is no output. Unless
you specifically need to select the next cell in that column, you can take
out that code, which is redundant.

Regards,

Sam Mathai Chacko

On Tue, Feb 7, 2012 at 7:34 PM, Mohammed Muneer  wrote:

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



-- 
Sam Mathai Chacko

-- 
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$$ vlookup and index/match functions help required

[Maries]

Hi Sourabh,

Find the attached file. I have used only VLOOKUP to achieve your
requirement.

I hope this clarify clear.

Regards,

MARIES.

On Tue, Feb 7, 2012 at 6:35 PM, Sourabh Salgotra wrote:

>
> dear sir,
>   plz help me in attached file.
>
>
> Thanks & Regards
> Sourabh
> Contact Numbers: +91-94630-49202
> Website:http://adhurapyaar.co.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


HELP REQUIRED.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ vlookup and index/match functions help required

[NOORAIN ANSARI]

Dear Sourabh,

Sort the data and use it..

=LOOKUP(B3&"*",$G$3:$G$9,$H$3:$H$9)

See attached sheet..

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

On Tue, Feb 7, 2012 at 8:05 PM, Sourabh Salgotra wrote:

>
> dear sir,
>   plz help me in attached file.
>
>
> Thanks & Regards
> Sourabh
> Contact Numbers: +91-94630-49202
> Website:http://adhurapyaar.co.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


HELP REQUIRED(Solved).xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ IF FUNCTION PROBLEM

[hilary lomotey]

Hello Experts,

i have a data, i want the data to read " decrease" when the % change for
the selected year is -ve eg (7.9%)  otherwise to read "positive", i have
used the formula ="This represents a % "&IF(P7<0,"decrease","increase"),
but it doesnt change when the sign changes. kindly assist. 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


if function problem.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ vlookup and index/match functions help required

[Sourabh Salgotra]

thanx for help but its giving #na on entering 3.2 in any cell


in bucket

3.2 to 4  range
4.1 to 5 range
5.1 to 6 range
6.1 to 7 range



On Tue, Feb 7, 2012 at 8:39 PM, NOORAIN ANSARI wrote:

> Dear Sourabh,
>
> Sort the data and use it..
>
> =LOOKUP(B3&"*",$G$3:$G$9,$H$3:$H$9)
>
> See attached sheet..
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://noorainansari.com/*
> *http://excelmacroworld.blogspot.com/*
>
> On Tue, Feb 7, 2012 at 8:05 PM, Sourabh Salgotra wrote:
>
>>
>> dear sir,
>>   plz help me in attached file.
>>
>>
>> Thanks & Regards
>> Sourabh
>> Contact Numbers: +91-94630-49202
>> Website:http://adhurapyaar.co.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
>



-- 
mujhay dukh is baat ka nahin kay meri zaat ko
muntashir karny walay haath tairy thy
mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko
samaitnay walay haath tairy na thy





Thanks & Regards
Sourabh
Contact Numbers: +91-94630-49202
Website:http://adhurapyaar.co.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

Re: $$Excel-Macros$$ Header and Footer Based on Cell Value

[NOORAIN ANSARI]

Dear John,

Please try through below link..

http://www.cpearson.com/excel/headfoot.htm
http://www.exceltip.com/st/Insert_headers_and_footers_using_VBA_in_Microsoft_Excel/454.html

Hope it will help to you.
-- 
Thanks & regards,
Noorain Ansari
 *http://noorainansari.com/*
*http://excelmacroworld.blogspot.com/*


On Tue, Feb 7, 2012 at 8:20 PM, John A. Smith wrote:

> Dear Group,
>
> Is it possible to control your header and footers with the value of a
> specific cell?  If it is and requires a macro could you provide?
>
> Also, since you can insert a picture in a header and footer, can you
> control which from a cell?  Like different reports for different facilities
> which have their own logo's that you could control inside a cell.
>
> I appreciate all and any help on this.
>
> John
>
> --
> 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$$ Re: IF FUNCTION PROBLEM

[Kris]

Hi,

Replace your Col I formula. In I4 and copied down,

=IFERROR(C4/C3-1,"N/A")

custom format the cell as *0.00%;(0.00%)*
*
*
Kris

-- 
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$$ Re: IF FUNCTION PROBLEM

[hilary lomotey]

Thanks Kris, very helpful

On Tue, Feb 7, 2012 at 4:13 PM, Kris  wrote:

> Hi,
>
> Replace your Col I formula. In I4 and copied down,
>
> =IFERROR(C4/C3-1,"N/A")
>
> custom format the cell as *0.00%;(0.00%)*
> *
> *
> Kris
>
> --
> 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$$ IF FUNCTION PROBLEM

[Sam Mathai Chacko]

You don't format the value using TEXT function in this case. Use format
cells to format. Check the attachment.

Regards,

Sam Mathai Chacko

On Tue, Feb 7, 2012 at 8:49 PM, hilary lomotey  wrote:

> Hello Experts,
>
> i have a data, i want the data to read " decrease" when the % change for
> the selected year is -ve eg (7.9%)  otherwise to read "positive", i have
> used the formula ="This represents a % "&IF(P7<0,"decrease","increase"),
> but it doesnt change when the sign changes. kindly assist. 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
>



-- 
Sam Mathai Chacko

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


if function problem.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ vlookup and index/match functions help required

[Kris]

Hi,

In C2 and copied down,

=LOOKUP(B2,$I$3:$J$11)

and arrange your table like

 RANGE GRADE  0 No Grade  3.2 D  4.1 C2  5.1 C1  6.1 B2  7.1 B1  8.1 A2  9.1 
A1  10.1 No Grade 
Kris

-- 
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$$ Re: IF FUNCTION PROBLEM

[Kris]

Hi

You are welcome !!

BTW, you could replace the P7 formula with

=INDEX(I4:I26,A1)

Kris

-- 
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$$ Re: IF FUNCTION PROBLEM

[hilary lomotey]

Thanks Kris, wow, this index formula makes my work really easy, thanks
boss, u r great,

On Tue, Feb 7, 2012 at 4:27 PM, Kris  wrote:

> Hi
>
> You are welcome !!
>
> BTW, you could replace the P7 formula with
>
> =INDEX(I4:I26,A1)
>
> Kris
>
> --
> 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$$ Excel test file Basic & Advance

[Nikhil Shah]

Hi Maries,

Thanks..Excellent Tools..

Regards

Nikhil Shah

On Tue, Feb 7, 2012 at 4:08 PM, Maries  wrote:

> *Find the attached Excel File
> *
> On Tue, Feb 7, 2012 at 11:43 AM, NOORAIN ANSARI 
> wrote:
>
>> PFA
>>
>>
>> On Tue, Feb 7, 2012 at 12:42 PM, Amit Desai (MERU) <
>> amit.de...@merucabs.com> wrote:
>>
>>>  Dear Team,
>>>
>>> ** **
>>>
>>> Please forward excel test file for basic & advance level, if anybody
>>> have it.
>>>
>>>  
>>>
>>> Best Regards,
>>>
>>> Amit
>>>
>>> ** **
>>>
>>> --
>>> 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 (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 may not be answered.

2) Don't post a question in the thread of 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 

Re: $$Excel-Macros$$ vlookup and index/match functions help required

[Sam Mathai Chacko]

I would also go with the LOOKUP suggested by Kris as it is direct, and
simple. But if you do not want to make any change to your layout, you could
also use a CSE formula

=INDEX($H$3:$H$9,MATCH(B2,--TRIM(RIGHT(SUBSTITUTE($G$3:$G$9,"-",REPT("
",20)),10)),-1))

Regards,

Sam Mathai Chacko

On Tue, Feb 7, 2012 at 9:52 PM, Kris  wrote:

> Hi,
>
> In C2 and copied down,
>
> =LOOKUP(B2,$I$3:$J$11)
>
> and arrange your table like
>
>   RANGE GRADE  0 No Grade  3.2 D  4.1 C2  5.1 C1  6.1 B2  7.1 B1  8.1 A2
> 9.1 A1  10.1 No Grade
> Kris
>
>  --
> 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
>



-- 
Sam Mathai Chacko

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


HELP REQUIRED.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ vlookup and index/match functions help required

[Sourabh Salgotra]

thanks kris sir and sam sir .

On Tue, Feb 7, 2012 at 10:30 PM, Sam Mathai Chacko wrote:

> I would also go with the LOOKUP suggested by Kris as it is direct, and
> simple. But if you do not want to make any change to your layout, you could
> also use a CSE formula
>
> =INDEX($H$3:$H$9,MATCH(B2,--TRIM(RIGHT(SUBSTITUTE($G$3:$G$9,"-",REPT("
> ",20)),10)),-1))
>
> Regards,
>
> Sam Mathai Chacko
>
>
> On Tue, Feb 7, 2012 at 9:52 PM, Kris  wrote:
>
>> Hi,
>>
>> In C2 and copied down,
>>
>> =LOOKUP(B2,$I$3:$J$11)
>>
>> and arrange your table like
>>
>>   RANGE GRADE  0 No Grade  3.2 D  4.1 C2  5.1 C1  6.1 B2  7.1 B1  8.1 A2
>> 9.1 A1  10.1 No Grade
>> Kris
>>
>>  --
>> 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
>>
>
>
>
> --
> Sam Mathai Chacko
>
>  --
> 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
>



-- 
mujhay dukh is baat ka nahin kay meri zaat ko
muntashir karny walay haath tairy thy
mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko
samaitnay walay haath tairy na thy





Thanks & Regards
Sourabh
Contact Numbers: +91-94630-49202
Website:http://adhurapyaar.co.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$$ Solution required plz

[Steven Dsouza]

Hi,

Iam an ardent follower of this group. I was just wondering if someone can
help me find a solution. I have mentioned the issue in the attached file.
thanks in advance for the Patience in going through my email.

Regards
Steve

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


Completion Status.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Add to this group

[Krishna madolli]

Hi my friend want to add his ID to this group, please let us know the procedure
-- 
Krishnaraddi V Madolli.

-- 
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$$ Fwd: Solution required plz

[Steven Dsouza]

-- Forwarded message --
From: Steven Dsouza 
Date: Tue, Feb 7, 2012 at 10:59 AM
Subject: Solution required plz
To: excel-macros@googlegroups.com


Hi,

Iam an ardent follower of this group. I was just wondering if someone can
help me find a solution. I have mentioned the issue in the attached file.
thanks in advance for the Patience in going through my email.

Regards
Steve

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


Completion Status.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Regarding Vlookup and Hlookup function

[Anoop K Sharma]

Dear Sanjib,

Please find the Attached Sheet


Let me know for any other Assistance.

Regards,
Anoop

On Tue, Feb 7, 2012 at 12:08 PM, Sanjib Chatterjee <
chatterjee.kolk...@gmail.com> wrote:

>
>
> Dear Sir / Madam,
>
> Would you provide me more example for Vlookup and Hlookup function
>
> Thanking you in advance
>
>
> 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
>



-- 
Regards,
Anoop

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


Vlookup and Hlookup.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Solution required plz

[Sam Mathai Chacko]

I have added two named ranges for activities and the states.

The formula for percentage will then be

=COUNTIF(OFFSET(Activities,0,MATCH($B2,States,0)),"Yes")/COUNTA(Activities)

and for the status will be

=IF(C2>=1,"Complete","Incomplete")

OR

=IF(C2<1,"Incomplete","Complete")

Regards

Sam Mathai Chacko

On Tue, Feb 7, 2012 at 4:29 PM, Steven Dsouza  wrote:

> Hi,
>
> Iam an ardent follower of this group. I was just wondering if someone can
> help me find a solution. I have mentioned the issue in the attached file.
> thanks in advance for the Patience in going through my email.
>
> Regards
> Steve
>
> --
> 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
>



-- 
Sam Mathai Chacko

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


Completion Status.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Add to this group

[Sam Mathai Chacko]

I have sent you an invite just now. Please check the link

Regards,

Sam Mathai Chacko

On Tue, Feb 7, 2012 at 10:26 PM, Krishna madolli  wrote:

> Hi my friend want to add his ID to this group, please let us know the
> procedure
> --
> Krishnaraddi V Madolli.
>
> --
> 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
>



-- 
Sam Mathai Chacko

-- 
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$$ Add to this group

[Sam Mathai Chacko]

Use this link and send an invite to your friend

https://groups.google.com/group/excel-macros/members_invite?hl=en

Regards,

Sam

On Tue, Feb 7, 2012 at 11:00 PM, Sam Mathai Chacko wrote:

> I have sent you an invite just now. Please check the link
>
> Regards,
>
> Sam Mathai Chacko
>
>
> On Tue, Feb 7, 2012 at 10:26 PM, Krishna madolli wrote:
>
>> Hi my friend want to add his ID to this group, please let us know the
>> procedure
>> --
>> Krishnaraddi V Madolli.
>>
>> --
>> 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
>>
>
>
>
> --
> Sam Mathai Chacko
>



-- 
Sam Mathai Chacko

-- 
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$$ Solution required plz

[Sam Mathai Chacko]

The basic premise of a solution oriented approach is that it requires some
element of dynamic adjustment or a self corrective modus operandus that
will ensure proximity to correctness within a set of expected variations.

1. Your suggestion of having each column hard coded will (may) not suffice
the end user requirement. A simple and obvious reason would be that the
user will be bound from changing the order of the states vertically in the
front-end sheet, or horizontally in the back-end sheet.

2. It is not always a given that the count of activities will remain
constant at 17. Apparently, there are only 14 activities in the sample
provided.

3. Least intervention from an end-user perspective should be considered as
one of the criteria for a solution to be considered optimal.

Regards,

Sam Mathai Chacko

On Tue, Feb 7, 2012 at 11:09 PM, Sourabh Salgotra wrote:

>
> CHK ATTACHMENT
>
>
> On Tue, Feb 7, 2012 at 10:58 PM, Sam Mathai Chacko wrote:
>
>> I have added two named ranges for activities and the states.
>>
>> The formula for percentage will then be
>>
>>
>> =COUNTIF(OFFSET(Activities,0,MATCH($B2,States,0)),"Yes")/COUNTA(Activities)
>>
>> and for the status will be
>>
>> =IF(C2>=1,"Complete","Incomplete")
>>
>> OR
>>
>> =IF(C2<1,"Incomplete","Complete")
>>
>> Regards
>>
>> Sam Mathai Chacko
>>
>>
>> On Tue, Feb 7, 2012 at 4:29 PM, Steven Dsouza wrote:
>>
>>> Hi,
>>>
>>> Iam an ardent follower of this group. I was just wondering if someone
>>> can help me find a solution. I have mentioned the issue in the attached
>>> file. thanks in advance for the Patience in going through my email.
>>>
>>> Regards
>>> Steve
>>>
>>> --
>>> 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
>>>
>>
>>
>>
>> --
>> Sam Mathai Chacko
>>
>>  --
>> 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
>>
>
>
>
> --
> mujhay dukh is baat ka nahin kay meri zaat ko
> muntashir karny walay haath tairy thy
> mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko
> samaitnay walay haath tairy na thy
>
>
>
> 
>
>
> Thanks & Regards
> Sourabh
> Contact Numbers: +91-94630-49202
> Website:http://adhurapyaar.co.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
>



-- 
Sam Mathai Chacko

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

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, 

Re: $$Excel-Macros$$ Fwd: Solution required plz

[dguillett1]

You should give a MEANINGFUL subject line. Explain in the body of the email 
what you want.  Give examples. See attached for formulas in sheet 2 and then 
formulas in sheet1 to fetch the result. Can be combined into a more complex 

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Steven Dsouza 
Sent: Tuesday, February 07, 2012 9:14 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Fwd: Solution required plz




-- Forwarded message --
From: Steven Dsouza 
Date: Tue, Feb 7, 2012 at 10:59 AM
Subject: Solution required plz
To: excel-macros@googlegroups.com


Hi, 

Iam an ardent follower of this group. I was just wondering if someone can help 
me find a solution. I have mentioned the issue in the attached file. thanks in 
advance for the Patience in going through my email.

Regards
Steve

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


Completion Status.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Fwd: Solution required plz

[dguillett1]

Don Guillett
SalesAid Software
dguille...@gmail.com

From: dguillett1 
Sent: Tuesday, February 07, 2012 1:00 PM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Fwd: Solution required plz

You should give a MEANINGFUL subject line. Explain in the body of the email 
what you want.  Give examples. See attached for formulas in sheet 2 and then 
formulas in sheet1 to fetch the result. Can be combined into a more complex 

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Steven Dsouza 
Sent: Tuesday, February 07, 2012 9:14 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Fwd: Solution required plz




-- Forwarded message --
From: Steven Dsouza 
Date: Tue, Feb 7, 2012 at 10:59 AM
Subject: Solution required plz
To: excel-macros@googlegroups.com


Hi, 

Iam an ardent follower of this group. I was just wondering if someone can help 
me find a solution. I have mentioned the issue in the attached file. thanks in 
advance for the Patience in going through my email.

Regards
Steve

-- 
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$$ Solution required plz

[dguillett1]

Sam, pls go back and test your MATCH

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Sam Mathai Chacko 
Sent: Tuesday, February 07, 2012 11:28 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Solution required plz

I have added two named ranges for activities and the states.

The formula for percentage will then be

=COUNTIF(OFFSET(Activities,0,MATCH($B2,States,0)),"Yes")/COUNTA(Activities)

and for the status will be

=IF(C2>=1,"Complete","Incomplete")

OR

=IF(C2<1,"Incomplete","Complete")

Regards

Sam Mathai Chacko


On Tue, Feb 7, 2012 at 4:29 PM, Steven Dsouza  wrote:

  Hi, 

  Iam an ardent follower of this group. I was just wondering if someone can 
help me find a solution. I have mentioned the issue in the attached file. 
thanks in advance for the Patience in going through my email.

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




-- 
Sam Mathai Chacko
-- 
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


Completion Status.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Solution required plz

[Sam Mathai Chacko]

OKAY

On Wed, Feb 8, 2012 at 12:41 AM, dguillett1  wrote:

>   Sam, pls go back and test your MATCH
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Sam Mathai Chacko 
> *Sent:* Tuesday, February 07, 2012 11:28 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Solution required plz
>
> I have added two named ranges for activities and the states.
>
> The formula for percentage will then be
>
> =COUNTIF(OFFSET(Activities,0,MATCH($B2,States,0)),"Yes")/COUNTA(Activities)
>
> and for the status will be
>
> =IF(C2>=1,"Complete","Incomplete")
>
> OR
>
> =IF(C2<1,"Incomplete","Complete")
>
> Regards
>
> Sam Mathai Chacko
>
> On Tue, Feb 7, 2012 at 4:29 PM, Steven Dsouza wrote:
>
>> Hi,
>>
>> Iam an ardent follower of this group. I was just wondering if someone can
>> help me find a solution. I have mentioned the issue in the attached file.
>> thanks in advance for the Patience in going through my email.
>>
>> Regards
>> Steve
>> --
>> 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
>>
>
>
>
> --
> Sam Mathai Chacko
> --
> 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
>



-- 
Sam Mathai Chacko

-- 
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$$ Solution required plz

[Sam Mathai Chacko]

Just checked it Don. Couldn't figure out what you were referring to. Could
you please let me know.

Sam

On Wed, Feb 8, 2012 at 12:43 AM, Sam Mathai Chacko wrote:

> OKAY
>
>
> On Wed, Feb 8, 2012 at 12:41 AM, dguillett1  wrote:
>
>>   Sam, pls go back and test your MATCH
>>
>> Don Guillett
>> SalesAid Software
>> dguille...@gmail.com
>>
>>  *From:* Sam Mathai Chacko 
>> *Sent:* Tuesday, February 07, 2012 11:28 AM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ Solution required plz
>>
>> I have added two named ranges for activities and the states.
>>
>> The formula for percentage will then be
>>
>>
>> =COUNTIF(OFFSET(Activities,0,MATCH($B2,States,0)),"Yes")/COUNTA(Activities)
>>
>> and for the status will be
>>
>> =IF(C2>=1,"Complete","Incomplete")
>>
>> OR
>>
>> =IF(C2<1,"Incomplete","Complete")
>>
>> Regards
>>
>> Sam Mathai Chacko
>>
>> On Tue, Feb 7, 2012 at 4:29 PM, Steven Dsouza wrote:
>>
>>> Hi,
>>>
>>> Iam an ardent follower of this group. I was just wondering if someone
>>> can help me find a solution. I have mentioned the issue in the attached
>>> file. thanks in advance for the Patience in going through my email.
>>>
>>> Regards
>>> Steve
>>> --
>>> 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
>>>
>>
>>
>>
>> --
>> Sam Mathai Chacko
>> --
>> 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
>>
>
>
>
> --
> Sam Mathai Chacko
>



-- 
Sam Mathai Chacko

-- 
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$$ Solution required plz

[dguillett1]

OK. Just add some text  to the rest of the rows in col A on sheet2 so the 
“activites”name works

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Sam Mathai Chacko 
Sent: Tuesday, February 07, 2012 1:14 PM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Solution required plz

Just checked it Don. Couldn't figure out what you were referring to. Could you 
please let me know.

Sam


On Wed, Feb 8, 2012 at 12:43 AM, Sam Mathai Chacko  wrote:

  OKAY 



  On Wed, Feb 8, 2012 at 12:41 AM, dguillett1  wrote:

Sam, pls go back and test your MATCH

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Sam Mathai Chacko 
Sent: Tuesday, February 07, 2012 11:28 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Solution required plz

I have added two named ranges for activities and the states.

The formula for percentage will then be

=COUNTIF(OFFSET(Activities,0,MATCH($B2,States,0)),"Yes")/COUNTA(Activities)

and for the status will be

=IF(C2>=1,"Complete","Incomplete")

OR

=IF(C2<1,"Incomplete","Complete")

Regards

Sam Mathai Chacko


On Tue, Feb 7, 2012 at 4:29 PM, Steven Dsouza  wrote:

  Hi, 

  Iam an ardent follower of this group. I was just wondering if someone can 
help me find a solution. I have mentioned the issue in the attached file. 
thanks in advance for the Patience in going through my email.

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




-- 
Sam Mathai Chacko
-- 
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





  -- 
  Sam Mathai Chacko




-- 
Sam Mathai Chacko
-- 
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

Re: $$Excel-Macros$$ INDEX FUNCTION & MATCH FUNCTION

[Jai]

Thanks to all Excel group Members,

On Mon, Feb 6, 2012 at 11:46 PM, Sam Mathai Chacko wrote:

> I would actually explain the use of MATCH in a little more detail. You
> have omitted the use of the greater than / lesser than arguments.
>
> Regards,
>
> Sam Mathai Chacko
>
>
> On Mon, Feb 6, 2012 at 4:54 PM, NOORAIN ANSARI 
> wrote:
>
>> Dear Jai,
>>
>> See attached sheet
>>
>> On Mon, Feb 6, 2012 at 3:33 PM, Jai  wrote:
>>
>>> Dear Excel Group Member,
>>>
>>>
>>> Please give the some example of  index function & Match Function  & how
>>> can use both function in combined.
>>>
>>> --
>>> 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
>>
>
>
>
> --
> Sam Mathai Chacko
>
>  --
> 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$$ Plz, suggest can we do like this for the macro's. (for better explanation if u need plz check the attached file (Grm Details here) and Grm is the main file with two command button

[PrIyAnKa]

attachment missing

On Tue, Feb 7, 2012 at 7:33 PM, Mohammed Muneer  wrote:

>1. This is original macro.
>
> Sub fill()
>
> ** **
>
> ** **
>
> ** **
>
> '
>
> ** **
>
> ** **
>
> ** **
>
> ' fill Macro
>
> ** **
>
> ** **
>
> ' Macro recorded 2/7/2012 by mmuneer
>
> '
>
> ** **
>
> ** **
>
> ** **
>
> ' Keyboard Shortcut: Ctrl+Shift+N
>
> ** **
>
> '
>
> ** **
>
> ** **
>
> ** **
>
> ActiveCell.FormulaR1C1 = "aa"
>
> ** **
>
> Selection.AutoFilter Field:=2, Criteria1:="aa"
>
> End Sub
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> 1. Can we do alterations in the original macro.
>
> Sub fill()
>
> ** **
>
> ** **
>
> ** **
>
> '
>
> ** **
>
> ** **
>
> ** **
>
> ' fill Macro
>
> ** **
>
> ** **
>
> ' Macro recorded 2/7/2012 by mmuneer
>
> '
>
> ** **
>
> ** **
>
> ** **
>
> ' Keyboard Shortcut: Ctrl+Shift+N
>
> ** **
>
> '
>
> ** **
>
> ** **
>
> ** **
>
> ActiveCell.FormulaR1C1 = "aa"
>
> ** **
>
> Selection.AutoFilter Field:=2, Criteria1:="aa"
>
> ---
>
> ActiveCell.FormulaR1C1 = "bb"
>
> ** **
>
> Selection.AutoFilter Field:=2, Criteria1:="bb"
>
> ---
>
> ActiveCell.FormulaR1C1 = "cc"
>
> ** **
>
> Selection.AutoFilter Field:=2, Criteria1:="cc"
>
> ** **
>
> End Sub
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> 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

Re: $$Excel-Macros$$ Learn Macros and Basics VBA

[NOORAIN ANSARI]

Excellent Effort Amresh,
Keep it up

On Wed, Feb 8, 2012 at 10:18 AM, Amresh Maurya wrote:

> Hi All My Friends,
>
> Please find the attached file.
>
> I have made PPT for Learn Macros and Basics VBA. Might be helping someone
> to learn.
>
>
> Cheers!!
> Amresh Kumar
> 9958418578
>
> --
> 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$$ unable to open file of 2007 in 2003

[dhartikumar]

Send the file.
Sent from BlackBerry® on Airtel

-Original Message-
From: Sanjib Chatterjee 
Sender: excel-macros@googlegroups.com
Date: Wed, 8 Feb 2012 11:37:09 
To: excel-macros
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ unable to open file of 2007 in 2003

Dear Sir,

Is there any way to open excel 2007 files in 2003.  I have try
the patch that Microsoft provide to open 2007 file 2003, but failed


Please help me..

Thank you in Advance

Regards,

Sanjib



-- 
-

-- 
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$$ Target.cell issues

[chandra sekaran]

Dear all

i have wrriten this code   for worksheet change   module My contion is
workingbut  second contion is not working  any one help me


Private Sub Worksheet_Change(ByVal Target As Range)
  If Target.Column = 8 And Target.Cells = "Billed" Or Target.Cells =
"BILLED" Then
 Target.Offset(0, -2).Value = "Booked"

  End if

  If Target.Column = 6 And Target.Cells = "Open" Or Target.Cells = "OPEN"
Then
 Target.Offset(0, 2).Value = "UnBilled"
  End If

End Sub

Regards
Chandru

-- 
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$$ Target.cell issues

[dhartikumar]

Copy this code..
Private Sub Worksheet_Change(ByVal Target As Range)
  If Target.Column = 8 And Target.Cells = "Billed" Or Target.Cells = "BILLED" 
Then
 Target.Offset(0, -2).Value = "Booked"
  If Target.Column = 6 And Target.Cells = "Open" Or Target.Cells = "OPEN" Then
 Target.Offset(0, 2).Value = "UnBilled"
  End If
  End If

End sub
Sent from BlackBerry® on Airtel

-Original Message-
From: chandra sekaran 
Sender: excel-macros@googlegroups.com
Date: Wed, 8 Feb 2012 11:39:34 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Target.cell issues

Dear all

i have wrriten this code   for worksheet change   module My contion is
workingbut  second contion is not working  any one help me


Private Sub Worksheet_Change(ByVal Target As Range)
  If Target.Column = 8 And Target.Cells = "Billed" Or Target.Cells =
"BILLED" Then
 Target.Offset(0, -2).Value = "Booked"

  End if

  If Target.Column = 6 And Target.Cells = "Open" Or Target.Cells = "OPEN"
Then
 Target.Offset(0, 2).Value = "UnBilled"
  End If

End Sub

Regards
Chandru

-- 
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$$ Target.cell issues

[chandra sekaran]

sorry  one Contion  only worked



On Wed, Feb 8, 2012 at 11:44 AM,  wrote:

> **
> Copy this code..
>
> Private Sub Worksheet_Change(ByVal Target As Range)
>   If Target.Column = 8 And Target.Cells = "Billed" Or Target.Cells =
> "BILLED" Then
>  Target.Offset(0, -2).Value = "Booked"
>   If Target.Column = 6 And Target.Cells = "Open" Or Target.Cells = "OPEN"
> Then
>  Target.Offset(0, 2).Value = "UnBilled"
>   End If
> End If
>
> End sub
> Sent from BlackBerry® on Airtel
> --
> *From: *chandra sekaran 
> *Sender: *excel-macros@googlegroups.com
> *Date: *Wed, 8 Feb 2012 11:39:34 +0530
> *To: *
> *ReplyTo: *excel-macros@googlegroups.com
> *Subject: *$$Excel-Macros$$ Target.cell issues
>
> Dear all
>
> i have wrriten this code   for worksheet change   module My contion is
> workingbut  second contion is not working  any one help me
>
>
> Private Sub Worksheet_Change(ByVal Target As Range)
>   If Target.Column = 8 And Target.Cells = "Billed" Or Target.Cells =
> "BILLED" Then
>  Target.Offset(0, -2).Value = "Booked"
>
>   End if
>
>   If Target.Column = 6 And Target.Cells = "Open" Or Target.Cells = "OPEN"
> Then
>  Target.Offset(0, 2).Value = "UnBilled"
>   End If
>
> End Sub
>
> Regards
> Chandru
>
>
>
> --
> 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$$ Target.cell issues

[NOORAIN ANSARI]

Dear Chandra Sekaran,

Please try it..

Private Sub Worksheet_Change(ByVal Target As Range)
  If Target.Column = 8 And VBA.UCase(Target.Value) = "BILLED" Then
 Target.Offset(0, -2).Value = "Booked"
  End If
 If Target.Column = 6 And VBA.UCase(Target.Value) = "OPEN" Then
 Target.Offset(0, 2).Value = "UnBilled"
  End If
End Sub
or

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 8 And VBA.UCase(Target.Value) = "BILLED" Then
 Target.Offset(0, -2).Value = "Booked"
  End If
 If Target.Column = 6 And VBA.UCase(Target.Value) = "OPEN" Then
 Target.Offset(0, 2).Value = "UnBilled"
  End If
End Sub


On Wed, Feb 8, 2012 at 11:54 AM, chandra sekaran wrote:

> sorry  one Contion  only worked
>
>
>
> On Wed, Feb 8, 2012 at 11:44 AM,  wrote:
>
>> **
>> Copy this code..
>>
>> Private Sub Worksheet_Change(ByVal Target As Range)
>>   If Target.Column = 8 And Target.Cells = "Billed" Or Target.Cells =
>> "BILLED" Then
>>  Target.Offset(0, -2).Value = "Booked"
>>   If Target.Column = 6 And Target.Cells = "Open" Or Target.Cells = "OPEN"
>> Then
>>  Target.Offset(0, 2).Value = "UnBilled"
>>   End If
>> End If
>>
>> End sub
>> Sent from BlackBerry® on Airtel
>> --
>> *From: *chandra sekaran 
>> *Sender: *excel-macros@googlegroups.com
>> *Date: *Wed, 8 Feb 2012 11:39:34 +0530
>> *To: *
>> *ReplyTo: *excel-macros@googlegroups.com
>> *Subject: *$$Excel-Macros$$ Target.cell issues
>>
>> Dear all
>>
>> i have wrriten this code   for worksheet change   module My contion
>> is workingbut  second contion is not working  any one help me
>>
>>
>> Private Sub Worksheet_Change(ByVal Target As Range)
>>   If Target.Column = 8 And Target.Cells = "Billed" Or Target.Cells =
>> "BILLED" Then
>>  Target.Offset(0, -2).Value = "Booked"
>>
>>   End if
>>
>>   If Target.Column = 6 And Target.Cells = "Open" Or Target.Cells = "OPEN"
>> Then
>>  Target.Offset(0, 2).Value = "UnBilled"
>>   End If
>>
>> End Sub
>>
>> Regards
>> Chandru
>>
>>
>>
>> --
>> 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
>



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

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

1) Use co

RE: $$Excel-Macros$$ unable to open file of 2007 in 2003

[Asa Rossoff]

Hello Sanjib!

Did installation of "the patch" fail, or did opening of an xlsx/xlsm file
fail?  What error did you get?

 

When you say "the patch", do you mean the Compatibility Pack for Office?

The latest Compatability Pack is at
http://www.microsoft.com/download/en/details.aspx?displaylang=en

&id=3

 

Ensure you follow all the instructions.  They emphasize several times that
you need to go to Microsoft Update first and install all high priority
updates before installation.  That especially means updates for Office, but,
I think, Windows too.  (http://update.microsoft.com).  If you installed the
Compatability Pack but not the updates from Microsoft Update, you might be
able to open your file by double=-clicking in Windows Explorer, but not by
File>Open or drag and drop.

 

Asa

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sanjib Chatterjee
Sent: Tuesday, February 07, 2012 10:07 PM
To: excel-macros
Subject: $$Excel-Macros$$ unable to open file of 2007 in 2003

 


Dear Sir,

Is there any way to open excel 2007 files in 2003.  I have try 
the patch that Microsoft provide to open 2007 file 2003, but failed


Please help me..

Thank you in Advance

Regards,

Sanjib



-- 
-

-- 
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$$ Target.cell issues

[chandra sekaran]

Thanks  Noorain Ansari ,its works fine

Regards
chandru



On Wed, Feb 8, 2012 at 11:59 AM, NOORAIN ANSARI wrote:

> Dear Chandra Sekaran,
>
> Please try it..
>
>  Private Sub Worksheet_Change(ByVal Target As Range)
>   If Target.Column = 8 And VBA.UCase(Target.Value) = "BILLED" Then
>  Target.Offset(0, -2).Value = "Booked"
>   End If
>  If Target.Column = 6 And VBA.UCase(Target.Value) = "OPEN" Then
>
>  Target.Offset(0, 2).Value = "UnBilled"
>   End If
> End Sub
> or
>
> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
> If Target.Column = 8 And VBA.UCase(Target.Value) = "BILLED" Then
>  Target.Offset(0, -2).Value = "Booked"
>   End If
>  If Target.Column = 6 And VBA.UCase(Target.Value) = "OPEN" Then
>
>  Target.Offset(0, 2).Value = "UnBilled"
>   End If
> End Sub
>
>
>   On Wed, Feb 8, 2012 at 11:54 AM, chandra sekaran  > wrote:
>
>> sorry  one Contion  only worked
>>
>>
>>
>> On Wed, Feb 8, 2012 at 11:44 AM,  wrote:
>>
>>> **
>>> Copy this code..
>>>
>>> Private Sub Worksheet_Change(ByVal Target As Range)
>>>   If Target.Column = 8 And Target.Cells = "Billed" Or Target.Cells =
>>> "BILLED" Then
>>>  Target.Offset(0, -2).Value = "Booked"
>>>   If Target.Column = 6 And Target.Cells = "Open" Or Target.Cells =
>>> "OPEN" Then
>>>  Target.Offset(0, 2).Value = "UnBilled"
>>>   End If
>>> End If
>>>
>>> End sub
>>> Sent from BlackBerry® on Airtel
>>> --
>>> *From: *chandra sekaran 
>>> *Sender: *excel-macros@googlegroups.com
>>> *Date: *Wed, 8 Feb 2012 11:39:34 +0530
>>> *To: *
>>> *ReplyTo: *excel-macros@googlegroups.com
>>> *Subject: *$$Excel-Macros$$ Target.cell issues
>>>
>>> Dear all
>>>
>>> i have wrriten this code   for worksheet change   module My contion
>>> is workingbut  second contion is not working  any one help me
>>>
>>>
>>> Private Sub Worksheet_Change(ByVal Target As Range)
>>>   If Target.Column = 8 And Target.Cells = "Billed" Or Target.Cells =
>>> "BILLED" Then
>>>  Target.Offset(0, -2).Value = "Booked"
>>>
>>>   End if
>>>
>>>   If Target.Column = 6 And Target.Cells = "Open" Or Target.Cells =
>>> "OPEN" Then
>>>  Target.Offset(0, 2).Value = "UnBilled"
>>>   End If
>>>
>>> End Sub
>>>
>>> Regards
>>> Chandru
>>>
>>>
>>>
>>> --
>>> 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, s

RE: $$Excel-Macros$$ Target.cell issues

[Asa Rossoff]

Hello Chandra,

I recommend using Application.Intersect to detect if a cell or range of
interest is in the Target range.  This is because multiple cells can be
changed at one time (for example, by copy/paste, search/replace, or fill
down), and your If/Then, depending on how you write it precisely, can either
miss when your range of interest is involved, or cause a Type Mismatch error
whether or not it's involved..

 

This should avoid that problem:

Private Sub Worksheet_Change(ByVal Target As Range)

Dim rng As Range

' Handle Column 8 Changes

for each rng in Application.Intersect(Target, Me.Columns(8)).areas

If Not rng is Nothing then

' the following uses an array formula to calculate a number of
cells at once

rng.offset(0, -2).Value2 = me.evaluate("IF((" & rng.address &
")=""BILLED"",""Booked"",(" & rng.offset(0, -2).address & "))"

End If

next rng

' Handle  Column 6 Changes

for each rng in Application.Intersect(Target, Me.Columns(6)).areas

If Not rng is Nothing then

' the following uses an array formula to calculate a number of
cells at once

rng.offset(0, 2).Value2 = me.evaluate("IF((" & rng.address &
")=""OPEN"",""UnBilled"",(" & rng.offset(0, -2).address & "))"

End If

next rng

End Sub

 

Let me know if this works for you;  I composed in email, so there could be
errors. 

 

Asa

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent: Tuesday, February 07, 2012 10:30 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Target.cell issues

 

Dear Chandra Sekaran,

 

Please try it..

 

Private Sub Worksheet_Change(ByVal Target As Range)
  If Target.Column = 8 And VBA.UCase(Target.Value) = "BILLED" Then
 Target.Offset(0, -2).Value = "Booked"
  End If
 If Target.Column = 6 And VBA.UCase(Target.Value) = "OPEN" Then
 Target.Offset(0, 2).Value = "UnBilled"
  End If
End Sub

or

 

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 8 And VBA.UCase(Target.Value) = "BILLED" Then
 Target.Offset(0, -2).Value = "Booked"
  End If
 If Target.Column = 6 And VBA.UCase(Target.Value) = "OPEN" Then
 Target.Offset(0, 2).Value = "UnBilled"
  End If
End Sub



On Wed, Feb 8, 2012 at 11:54 AM, chandra sekaran 
wrote:

sorry  one Contion  only worked 



 

On Wed, Feb 8, 2012 at 11:44 AM,  wrote:

Copy this code.. 


Private Sub Worksheet_Change(ByVal Target As Range)
  If Target.Column = 8 And Target.Cells = "Billed" Or Target.Cells =
"BILLED" Then
 Target.Offset(0, -2).Value = "Booked"

  If Target.Column = 6 And Target.Cells = "Open" Or Target.Cells = "OPEN"
Then
 Target.Offset(0, 2).Value = "UnBilled"
  End If

End If

End sub 

Sent from BlackBerryR on Airtel

  _  

From: chandra sekaran  

Sender: excel-macros@googlegroups.com 

Date: Wed, 8 Feb 2012 11:39:34 +0530

To: 

ReplyTo: excel-macros@googlegroups.com 

Subject: $$Excel-Macros$$ Target.cell issues

 

Dear all

 

i have wrriten this code   for worksheet change   module My contion is
workingbut  second contion is not working  any one help me 

 

 

Private Sub Worksheet_Change(ByVal Target As Range)

  If Target.Column = 8 And Target.Cells = "Billed" Or Target.Cells =
"BILLED" Then
 Target.Offset(0, -2).Value = "Booked"
  
  End if 
  
  If Target.Column = 6 And Target.Cells = "Open" Or Target.Cells = "OPEN"
Then
 Target.Offset(0, 2).Value = "UnBilled"
  End If
  
End Sub

 

Regards

Chandru 

 

 

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

RE: $$Excel-Macros$$ Target.cell issues

[Asa Rossoff]

I said there could be errors, and I spotted one immediately :)  -- I forgot
some parenthesis.  Here it is corrected:

Private Sub Worksheet_Change(ByVal Target As Range)

Dim rng As Range

' Handle Column 8 Changes

for each rng in Application.Intersect(Target, Me.Columns(8)).areas

If Not rng is Nothing then

' the following uses an array formula to calculate a number of
cells at once

rng.offset(0, -2).Value2 = me.evaluate("IF((" & rng.address &
")=""BILLED"",""Booked"",(" & rng.offset(0, -2).address & "))")

End If

next rng

' Handle  Column 6 Changes

for each rng in Application.Intersect(Target, Me.Columns(6)).areas

If Not rng is Nothing then

' the following uses an array formula to calculate a number of
cells at once

rng.offset(0, 2).Value2 = me.evaluate("IF((" & rng.address &
")=""OPEN"",""UnBilled"",(" & rng.offset(0, -2).address & "))")

End If

next rng

End Sub

 

Asa

 

From: Asa Rossoff [mailto:a...@lovetour.info] 
Sent: Tuesday, February 07, 2012 11:06 PM
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ Target.cell issues

 

Hello Chandra,

I recommend using Application.Intersect to detect if a cell or range of
interest is in the Target range.  This is because multiple cells can be
changed at one time (for example, by copy/paste, search/replace, or fill
down), and your If/Then, depending on how you write it precisely, can either
miss when your range of interest is involved, or cause a Type Mismatch error
whether or not it's involved..

 

This should avoid that problem:

Private Sub Worksheet_Change(ByVal Target As Range)

Dim rng As Range

' Handle Column 8 Changes

for each rng in Application.Intersect(Target, Me.Columns(8)).areas

If Not rng is Nothing then

' the following uses an array formula to calculate a number of
cells at once

rng.offset(0, -2).Value2 = me.evaluate("IF((" & rng.address &
")=""BILLED"",""Booked"",(" & rng.offset(0, -2).address & "))"

End If

next rng

' Handle  Column 6 Changes

for each rng in Application.Intersect(Target, Me.Columns(6)).areas

If Not rng is Nothing then

' the following uses an array formula to calculate a number of
cells at once

rng.offset(0, 2).Value2 = me.evaluate("IF((" & rng.address &
")=""OPEN"",""UnBilled"",(" & rng.offset(0, -2).address & "))"

End If

next rng

End Sub

 

Let me know if this works for you;  I composed in email, so there could be
errors. 

 

Asa

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent: Tuesday, February 07, 2012 10:30 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Target.cell issues

 

Dear Chandra Sekaran,

 

Please try it..

 

Private Sub Worksheet_Change(ByVal Target As Range)
  If Target.Column = 8 And VBA.UCase(Target.Value) = "BILLED" Then
 Target.Offset(0, -2).Value = "Booked"
  End If
 If Target.Column = 6 And VBA.UCase(Target.Value) = "OPEN" Then
 Target.Offset(0, 2).Value = "UnBilled"
  End If
End Sub

or

 

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 8 And VBA.UCase(Target.Value) = "BILLED" Then
 Target.Offset(0, -2).Value = "Booked"
  End If
 If Target.Column = 6 And VBA.UCase(Target.Value) = "OPEN" Then
 Target.Offset(0, 2).Value = "UnBilled"
  End If
End Sub

On Wed, Feb 8, 2012 at 11:54 AM, chandra sekaran 
wrote:

sorry  one Contion  only worked 



 

On Wed, Feb 8, 2012 at 11:44 AM,  wrote:

Copy this code.. 


Private Sub Worksheet_Change(ByVal Target As Range)
  If Target.Column = 8 And Target.Cells = "Billed" Or Target.Cells =
"BILLED" Then
 Target.Offset(0, -2).Value = "Booked"

  If Target.Column = 6 And Target.Cells = "Open" Or Target.Cells = "OPEN"
Then
 Target.Offset(0, 2).Value = "UnBilled"
  End If

End If

End sub 

Sent from BlackBerryR on Airtel

  _  

From: chandra sekaran  

Sender: excel-macros@googlegroups.com 

Date: Wed, 8 Feb 2012 11:39:34 +0530

To: 

ReplyTo: excel-macros@googlegroups.com 

Subject: $$Excel-Macros$$ Target.cell issues

 

Dear all

 

i have wrriten this code   for worksheet change   module My contion is
workingbut  second contion is not working  any one help me 

 

 

Private Sub Worksheet_Change(ByVal Target As Range)

  If Target.Column = 8 And Target.Cells = "Billed" Or Target.Cells =
"BILLED" Then
 Target.Offset(0, -2).Value = "Booked"
  
  End if 
  
  If Target.Column = 6 And Target.Cells = "Open" Or Target.Cells = "OPEN"
Then
 Target.Offset(0, 2).Value = "UnBilled"
  End If
  
End Sub

 

Regards

Chandru 

 

 

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

$$Excel-Macros$$ Custom Excel Functions

[Rahematulla Khan]

Could anybody explain how to create Custom Excel Function for
converting Numbers to Words i.e. 1250 (One thousand two hundred and
fifty)

-- 
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$$ unable to open file of 2007 in 2003

[Sanjib Chatterjee]

Dear Sir,

The installation completed sucessfully, there is no error during
installation, but while trying to open the file it is showing that the file
is not recognize by excel 2003.

regards,

Sanjib


On Wed, Feb 8, 2012 at 12:04 PM, Asa Rossoff  wrote:

> Hello Sanjib!
>
> Did installation of "the patch" fail, or did opening of an xlsx/xlsm file
> fail?  What error did you get?
>
> ** **
>
> When you say "the patch", do you mean the Compatibility Pack for Office?**
> **
>
> The latest Compatability Pack is at
> http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=3
>
> ** **
>
> Ensure you follow all the instructions.  They emphasize several times that
> you need to go to Microsoft Update first and install all high priority
> updates before installation.  That especially means updates for Office,
> but, I think, Windows too.  (http://update.microsoft.com).  If you
> installed the Compatability Pack but not the updates from Microsoft Update,
> you might be able to open your file by double=-clicking in Windows
> Explorer, but not by File>Open or drag and drop.
>
> ** **
>
> Asa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Sanjib Chatterjee
> *Sent:* Tuesday, February 07, 2012 10:07 PM
> *To:* excel-macros
>
> *Subject:* $$Excel-Macros$$ unable to open file of 2007 in 2003
>
> ** **
>
>
> Dear Sir,
>
> Is there any way to open excel 2007 files in 2003.  I have try
> the patch that Microsoft provide to open 2007 file 2003, but failed
>
>
> Please help me..
>
> Thank you in Advance
>
> Regards,
>
> Sanjib
>
>
>
> --
> -
>
> --
> 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$$ unable to open file of 2007 in 2003

[Asa Rossoff]

Dear Sanjib,

Please check http://update.microsoft.com  for updates.  If there are any
updates for Office, install them.  If there are any high priority updates
for Windows, install them.  Then reboot and see if fixed.

 

You can also test if you can open the Excel 2007 file(s) by double-clicking
in Windows Explorer, which might work even when you are unable to open the
file from Excel's File menu.

 

Asa

 

From: Sanjib Chatterjee [mailto:chatterjee.kolk...@gmail.com] 
Sent: Tuesday, February 07, 2012 11:48 PM
To: excel-macros@googlegroups.com; a...@lovetour.info
Subject: Re: $$Excel-Macros$$ unable to open file of 2007 in 2003

 


Dear Sir,

The installation completed sucessfully, there is no error during
installation, but while trying to open the file it is showing that the file
is not recognize by excel 2003.

regards,

Sanjib

On Wed, Feb 8, 2012 at 12:04 PM, Asa Rossoff  wrote:

Hello Sanjib!

Did installation of "the patch" fail, or did opening of an xlsx/xlsm file
fail?  What error did you get?

 

When you say "the patch", do you mean the Compatibility Pack for Office?

The latest Compatability Pack is at
http://www.microsoft.com/download/en/details.aspx?displaylang=en

&id=3

 

Ensure you follow all the instructions.  They emphasize several times that
you need to go to Microsoft Update first and install all high priority
updates before installation.  That especially means updates for Office, but,
I think, Windows too.  (http://update.microsoft.com).  If you installed the
Compatability Pack but not the updates from Microsoft Update, you might be
able to open your file by double=-clicking in Windows Explorer, but not by
File>Open or drag and drop.

 

Asa

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sanjib Chatterjee
Sent: Tuesday, February 07, 2012 10:07 PM
To: excel-macros


Subject: $$Excel-Macros$$ unable to open file of 2007 in 2003

 

 

Dear Sir,

Is there any way to open excel 2007 files in 2003.  I have try 
the patch that Microsoft provide to open 2007 file 2003, but failed


Please help me..

Thank you in Advance

Regards,

Sanjib



-- 
-

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