$$Excel-Macros$$ Replace #N/A with next Valid Data

[Amit Gandhi]

Hi Experts

I have excel data in column *B*.  In some cells there is data *#N/A*

--> I want to Replace *#N/A* , with data in *next cell.*
--> If *#N/A* is in more than 1 cells (continuous) , then Replace them
with *next
valid data*.
--> If there is no Valid data in any next cell, then Replace them with
*Blank*.

I have attached excel file which shows sample data and result required for
better understanding.

Please help me here.

Regards

Amit

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

FORUM RULES

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

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


Sample File.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Replace #N/A with next Valid Data

[Amit Gandhi]

Hi Experts

I have excel data in column *B*.  In some cells there is data *#N/A*

--> I want to Replace *#N/A* , with data in *next cell.*
--> If *#N/A* is in more than 1 cells (continuous) , then Replace them
with *next
valid data*.
--> If there is no Valid data in any next cell, then Replace them with
*Blank*.

I have attached excel file which shows sample data and result required for
better understanding.

Please help me here.

Regards

Amit

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

FORUM RULES

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

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


Sample File.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ - Fetching Vertical data into Horizontal

[Amit Gandhi]

Hi Vaibhav

One more thing, i use this formula to fetch output into another sheet, it
doesn't work. Pls help me here.

Regards

Amit


On 11 November 2014 11:01, Amit Gandhi  wrote:

> Thanks Vaibhav.
>
> Its exactly what is needed, thanks a lot.
>
> Can we do this using Excel VBA as well ?
> I mean to say, Raw Data is in one sheet (same as shown in this sheet);
> Output required is in another sheet Having names only as shown below.
>
>  Output Required :  Manoj  Amit  Suresh  Rajni  abc  xyz
>
>
>
> Then VBA fetches DATES and output data clicking one button.
>
> Thanks in advance for your time.
>
> Regards
>
> Amit
>
>
>
> On 10 November 2014 16:36, Vaibhav Joshi  wrote:
>
>> Hi
>>
>> Pl check this...
>>
>> Cheers!!
>>
>> +++++
>> *I did not do this for you. God is here working through me for you.*
>>
>> On Mon, Nov 10, 2014 at 4:15 PM, Amit Gandhi 
>> wrote:
>>
>>> Hi All
>>>
>>> I am using Excel 2010.
>>> I have Raw Data shown in range C1:M9.
>>> I need a vba macro to get desired output as shown in Range B14:Q20.
>>>
>>> Pls help me here.
>>>
>>>
>>> Take care
>>>
>>> Amit
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> --
> 'Expecting the world to treat u fairly coz u r a good person is like
> expecting the lion not to attack u coz u r a vegetarian.
> Think about it.'
>
> Take care
>
> Amit
>



-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! 

Re: $$Excel-Macros$$ - Fetching Vertical data into Horizontal

[Amit Gandhi]

Thanks Vaibhav.

Its exactly what is needed, thanks a lot.

Can we do this using Excel VBA as well ?
I mean to say, Raw Data is in one sheet (same as shown in this sheet);
Output required is in another sheet Having names only as shown below.

 Output Required :  Manoj  Amit  Suresh  Rajni  abc  xyz



Then VBA fetches DATES and output data clicking one button.

Thanks in advance for your time.

Regards

Amit



On 10 November 2014 16:36, Vaibhav Joshi  wrote:

> Hi
>
> Pl check this...
>
> Cheers!!
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Mon, Nov 10, 2014 at 4:15 PM, Amit Gandhi  wrote:
>
>> Hi All
>>
>> I am using Excel 2010.
>> I have Raw Data shown in range C1:M9.
>> I need a vba macro to get desired output as shown in Range B14:Q20.
>>
>> Pls help me here.
>>
>>
>> Take care
>>
>> Amit
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

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

FORUM RULES

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

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

$$Excel-Macros$$ - Fetching Vertical data into Horizontal

[Amit Gandhi]

Hi All

I am using Excel 2010.
I have Raw Data shown in range C1:M9.
I need a vba macro to get desired output as shown in Range B14:Q20.

Pls help me here.


Take care

Amit

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

FORUM RULES

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

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


Contribution.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$

[Amit Gandhi]

Hi All

I am using Excel 2010.
I have Raw Data shown in range C1:M9.
I need a vba macro to get desired output as shown in Range B14:Q20.

Pls help me here.


Take care

Amit

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

FORUM RULES

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

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


Contribution.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ PIVOT TABLE FROM MULTIPLE SHEETS

[Amit Gandhi]

How it is to be used?


On Fri, May 17, 2013 at 10:27 AM, Rajan_Verma wrote:

> *Use it *
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *P.VIJAYKUMAR
> *Sent:* 17 May 2013 10:19
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ PIVOT TABLE FROM MULTIPLE SHEETS
>
> ** **
>
> Respected Experts,
> 
>
> ** **
>
> Is it possible to create a pivot table taking data (or fields) from
> different  sheets of the workbook.
>  
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> Regards,
>
> P.VIJAY KUMAR 
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>  
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>



-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Macro to sort cells based on highlights

[Amit Gandhi]

If anyone can help me on this.

On Fri, Mar 8, 2013 at 12:41 PM, Amit Gandhi  wrote:

> Thanks Ashish. Good work.
>
> But this UDF doesn't satisfy Criteria 3 i.e.
> Criteria 3 --> Sorting order will be from B --> J.
>
> (a) if you see in your solution file Row 6 & 7 (Name G & A) has count 4,
> but Row 7 (Name A) should come first then row 6 (Name G), as Row 7 has
> first highlight in Column C and Row 6 has first highlight in Column D.
>
> (b) if you see in your solution file Row 8 & 9 (Name I & C) has count 3,
> but Row 9 (Name C) should come first then row 8 (Name I), as Row 9 has 3rd
> highlight in Column G and Row 8 has 3rd highlight in Column H.
>
>
> Can you solve this as well?
>
> Pls help.
>
> Regards
>
> Amit
>
>
>
>
> On Thu, Mar 7, 2013 at 11:26 PM, ashish koul wrote:
>
>> hi try this attached file
>>
>> I have created a simple UDF to count cells in a range which are having
>> fill color red and once you have count. You can simply sort it
>>
>> Regards
>> Ashish
>>
>>
>> On Thu, Mar 7, 2013 at 3:55 PM, Amit Gandhi  wrote:
>>
>>> Hi Experts
>>>
>>> I have an excel data and I want to sort data based on below criteria
>>> using Macro. pls help me here.
>>>
>>> *Column B to J has data which is to be sorted as per Highlighted CELLS *
>>> Criteria 1 -->  Highlighted cells should come first.
>>> Criteria 2 --> Row which has more highlighted cells from B to J, should
>>> come first.
>>> Criteria 3 --> Sorting order will be from B --> J.
>>>
>>> I have attached excel file which shows sample data and result required
>>> for better understanding.
>>>
>>>
>>> Regards
>>>
>>> Amit
>>>
>>>  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>>
>>
>> *Visit*
>> *My Excel Blog <http://www.excelvbamacros.com/>*
>> Like Us on 
>> Facebook<http://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897>
>> Join Us on Facebook <http://www.facebook.com/groups/163491717053198/>
>>
>>
>> P Before printing, think about the environment.
>>
>>
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post co

Re: $$Excel-Macros$$ Macro to sort cells based on highlights

[Amit Gandhi]

Thanks Ashish. Good work.

But this UDF doesn't satisfy Criteria 3 i.e.
Criteria 3 --> Sorting order will be from B --> J.

(a) if you see in your solution file Row 6 & 7 (Name G & A) has count 4,
but Row 7 (Name A) should come first then row 6 (Name G), as Row 7 has
first highlight in Column C and Row 6 has first highlight in Column D.

(b) if you see in your solution file Row 8 & 9 (Name I & C) has count 3,
but Row 9 (Name C) should come first then row 8 (Name I), as Row 9 has 3rd
highlight in Column G and Row 8 has 3rd highlight in Column H.


Can you solve this as well?

Pls help.

Regards

Amit




On Thu, Mar 7, 2013 at 11:26 PM, ashish koul  wrote:

> hi try this attached file
>
> I have created a simple UDF to count cells in a range which are having
> fill color red and once you have count. You can simply sort it
>
> Regards
> Ashish
>
>
> On Thu, Mar 7, 2013 at 3:55 PM, Amit Gandhi  wrote:
>
>> Hi Experts
>>
>> I have an excel data and I want to sort data based on below criteria
>> using Macro. pls help me here.
>>
>> *Column B to J has data which is to be sorted as per Highlighted CELLS *
>> Criteria 1 -->  Highlighted cells should come first.
>> Criteria 2 --> Row which has more highlighted cells from B to J, should
>> come first.
>> Criteria 3 --> Sorting order will be from B --> J.
>>
>> I have attached excel file which shows sample data and result required
>> for better understanding.
>>
>>
>> Regards
>>
>> Amit
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
>
>
> *Visit*
> *My Excel Blog <http://www.excelvbamacros.com/>*
> Like Us on 
> Facebook<http://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897>
> Join Us on Facebook <http://www.facebook.com/groups/163491717053198/>
>
>
> P Before printing, think about the environment.
>
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
&

$$Excel-Macros$$ Macro to sort cells based on highlights

[Amit Gandhi]

Hi Experts

I have an excel data and I want to sort data based on below criteria using
Macro. pls help me here.

*Column B to J has data which is to be sorted as per Highlighted CELLS *
Criteria 1 -->  Highlighted cells should come first.
Criteria 2 --> Row which has more highlighted cells from B to J, should
come first.
Criteria 3 --> Sorting order will be from B --> J.

I have attached excel file which shows sample data and result required for
better understanding.


Regards

Amit

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

FORUM RULES

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

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




SORTING BY MACRO.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Minimum Value of particular columns to be highlighted

[Amit Gandhi]

Thanks Pankaj

On Wed, Feb 13, 2013 at 5:38 PM, pankaj sangotra wrote:

> Hello Amit,
>
> Please find the aatched solution, please let me know if it works fine for
> you..
>
> Thanks
> Pankaj Sangotra
>
> On Wed, Feb 13, 2013 at 11:15 AM, Amit Gandhi 
> wrote:
> > Hi Experts
> >
> > I want to highlight minimum value of some particular columns say columns
> > D,H,L in attached file through Conditional Formatting. How it can be
> > possible? Pls help me here.
> >
> > Regards
> >
> > Amit
> >
> > --
> > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> > https://www.facebook.com/discussexcel
> >
> > FORUM RULES
> >
> > 1) Use concise, accurate thread titles. Poor thread titles, like Please
> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will
> > not get quick attention or may not be answered.
> > 2) Don't post a question in the thread of another member.
> > 3) Don't post questions regarding breaking or bypassing any security
> > measure.
> > 4) Acknowledge the responses you receive, good or bad.
> > 5) Jobs posting is not allowed.
> > 6) Sharing copyrighted material and their links is not allowed.
> >
> > NOTE : Don't ever post confidential data in a workbook. Forum owners and
> > members are not responsible for any loss.
> > ---
> > You received this message because you are subscribed to the Google Groups
> > "MS EXCEL AND VBA MACROS" group.
> > To unsubscribe from this group and stop receiving emails from it, send an
> > email to excel-macros+unsubscr...@googlegroups.com.
> > To post to this group, send email to excel-macros@googlegroups.com.
> > Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> > For more options, visit https://groups.google.com/groups/opt_out.
> >
> >
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE  : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>


-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Minimum Value of particular columns to be highlighted

[Amit Gandhi]

Thank Viper

On Wed, Feb 13, 2013 at 5:36 PM, The Viper  wrote:

> pfa and check formula in conditional formating
>
>
> On Wed, Feb 13, 2013 at 4:45 PM, Amit Gandhi  wrote:
>
>> Hi Experts
>>
>> I want to highlight minimum value of some particular columns say columns
>> D,H,L in attached file through Conditional Formatting. How it can be
>> possible? Pls help me here.
>>
>> Regards
>>
>> Amit
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>



-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

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

FORUM RULES

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

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

$$Excel-Macros$$ Minimum Value of particular columns to be highlighted

[Amit Gandhi]

Hi Experts

I want to highlight minimum value of some particular columns say columns
D,H,L in attached file through Conditional Formatting. How it can be
possible? Pls help me here.

Regards

Amit

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

FORUM RULES

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

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




GETTING MINIMUM NO HIGHLIGHTED.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Getting Minimum no highlighted

[Amit Gandhi]

Thanks Anil

I am following all below steps, but unable to apply right min formula. Can
you please suggest what MIN formula to be applied based on attached sample
file.

Regards

Amit


On Thu, Jan 17, 2013 at 11:08 AM, अनिल नारायण गवली
wrote:

> Dear Amit,
>
> First select the desire coloum and click on conditional formatting and
> there select a new rule and then click on format only cell that contain.
> there u'll find cellvalue,between,and two formula text box
> change the text box of between to lessthanequalto and then the next texbox
> write the min formula like =min(rangedesire) and then click on format and
> apply the color on that cell and click on ok .
>
>
> Warm Regards,
> Gawli Anil
>
> On Wed, Jan 16, 2013 at 6:33 PM, Amresh Maurya 
> wrote:
>
>> PFA ATTACHED FILE.
>>
>> USE THIS CODE
>> Sub minmm()
>> Dim n As Integer
>> Range("B5:B5").Select
>>   With Selection.Interior
>> .PatternColorIndex = xlAutomatic
>> .ThemeColor = xlThemeColorDark1
>> .TintAndShade = 0
>> .PatternTintAndShade = 0
>> End With
>> n = 5
>> Sheet1.Cells(5, 14).Formula = "=MIN(RC[-10],RC[-6],RC[-2])"
>> Sheet1.Range(Cells(5, 14), Cells(10, 14)).Select
>> Selection.FillDown
>> Sheet1.Range(Cells(5, 15), Cells(10, 15)) =
>>
>> "=IF(RC[-1]=RC[-3],""Suresh"",IF(RC[-7]=RC[-1],""mukesh"",IF(RC[-1]=RC[-11],""amit"")))"
>> Sheet1.Range(Cells(5, 14), Cells(10, 15)).Copy
>> ActiveCell.PasteSpecial xlPasteValues
>> Application.CutCopyMode = False
>> Range("o5").Select
>> For s = 1 To 6
>> Cells(n, 15).Select
>> If ActiveCell.Value = "Suresh" Then
>> Cells(n, 12).Select
>> With Selection.Interior
>> .Pattern = xlSolid
>> .PatternColorIndex = xlAutomatic
>> .ThemeColor = xlThemeColorAccent6
>> .TintAndShade = -0.24997717893
>> .PatternTintAndShade = 0
>> End With
>> Cells(n, 12).Select
>>   ElseIf ActiveCell.Value = "mukesh" Then
>> Cells(n, 8).Select
>> With Selection.Interior
>> .Pattern = xlSolid
>> .PatternColorIndex = xlAutomatic
>> .ThemeColor = xlThemeColorAccent6
>> .TintAndShade = -0.24997717893
>> .PatternTintAndShade = 0
>> End With
>>Cells(5, 12).Select
>>   ElseIf ActiveCell.Value = "amit" Then
>> Cells(n, 4).Select
>> With Selection.Interior
>> .Pattern = xlSolid
>> .PatternColorIndex = xlAutomatic
>> .ThemeColor = xlThemeColorAccent6
>> .TintAndShade = -0.24997717893
>> .PatternTintAndShade = 0
>> End With
>> End If
>> n = n + 1
>>Next
>>Range("a1").Select
>>
>> End Sub
>>
>> On Wed, Jan 16, 2013 at 4:57 PM, Amit Gandhi 
>> wrote:
>> > Thanks Anil
>> >
>> > But i am unable to do so? Can you show this in example file.
>> >
>> > Regards
>> >
>> > Amit
>> >
>> >
>> > On Wed, Jan 16, 2013 at 2:03 PM, अनिल नारायण गवली <
>> gawlianil8...@gmail.com>
>> > wrote:
>> >>
>> >> Dear Amit,
>> >>
>> >> U can use conditional format for each col in that u can use format only
>> >> rows that contain lessthanequalto and in formula write =min(range) and
>> >> format cell color to desire color.
>> >>
>> >> Regards,
>> >> Gawli Anil
>> >>
>> >>
>> >>
>> >> On Wed, Jan 16, 2013 at 1:24 PM, Amresh Maurya <
>> amreshkushw...@gmail.com>
>> >> wrote:
>> >>>
>> >>> Hello Amit,
>> >>>
>> >>> PFA file .Kindly use the below code.
>> >>>
>> >>> Sub minmm()
>> >>> n = 5
>> >>> Sheet1.Cells(5, 14).Formula = "=MIN(RC[-10],RC[-6],RC[-2])"
>> >>> Sheet1.Range(Cells(5, 14), Cells(10, 14)).Select
>> >>> Selection.FillDown
>> >>> Sheet1.Range(Cells(5, 15), Cells(10, 15)) =
>> >>>
>> >>>
>> "=IF(RC[-1]=RC[-3],""Suresh"",IF(RC[-7]=RC[-1],""mukesh"",IF(RC[-1]=RC[-11],""amit"")))"
>> >>> Sheet1.Range(Cells(5, 14), Cells(10, 15)).Copy
>> >>> ActiveCell.PasteSpecial xlPasteValues
>> >>> Appli

Re: $$Excel-Macros$$ Getting Minimum no highlighted

[Amit Gandhi]

Thanks Amresh


On Wed, Jan 16, 2013 at 6:33 PM, Amresh Maurya wrote:

> PFA ATTACHED FILE.
>
> USE THIS CODE
> Sub minmm()
> Dim n As Integer
> Range("B5:B5").Select
>   With Selection.Interior
> .PatternColorIndex = xlAutomatic
> .ThemeColor = xlThemeColorDark1
> .TintAndShade = 0
> .PatternTintAndShade = 0
> End With
> n = 5
> Sheet1.Cells(5, 14).Formula = "=MIN(RC[-10],RC[-6],RC[-2])"
> Sheet1.Range(Cells(5, 14), Cells(10, 14)).Select
> Selection.FillDown
> Sheet1.Range(Cells(5, 15), Cells(10, 15)) =
>
> "=IF(RC[-1]=RC[-3],""Suresh"",IF(RC[-7]=RC[-1],""mukesh"",IF(RC[-1]=RC[-11],""amit"")))"
> Sheet1.Range(Cells(5, 14), Cells(10, 15)).Copy
> ActiveCell.PasteSpecial xlPasteValues
> Application.CutCopyMode = False
> Range("o5").Select
> For s = 1 To 6
> Cells(n, 15).Select
> If ActiveCell.Value = "Suresh" Then
> Cells(n, 12).Select
> With Selection.Interior
> .Pattern = xlSolid
> .PatternColorIndex = xlAutomatic
> .ThemeColor = xlThemeColorAccent6
> .TintAndShade = -0.24997717893
> .PatternTintAndShade = 0
> End With
> Cells(n, 12).Select
>   ElseIf ActiveCell.Value = "mukesh" Then
> Cells(n, 8).Select
> With Selection.Interior
> .Pattern = xlSolid
> .PatternColorIndex = xlAutomatic
> .ThemeColor = xlThemeColorAccent6
> .TintAndShade = -0.24997717893
> .PatternTintAndShade = 0
> End With
>Cells(5, 12).Select
>   ElseIf ActiveCell.Value = "amit" Then
> Cells(n, 4).Select
> With Selection.Interior
> .Pattern = xlSolid
> .PatternColorIndex = xlAutomatic
> .ThemeColor = xlThemeColorAccent6
> .TintAndShade = -0.24997717893
> .PatternTintAndShade = 0
> End With
> End If
> n = n + 1
>Next
>Range("a1").Select
>
> End Sub
>
> On Wed, Jan 16, 2013 at 4:57 PM, Amit Gandhi  wrote:
> > Thanks Anil
> >
> > But i am unable to do so? Can you show this in example file.
> >
> > Regards
> >
> > Amit
> >
> >
> > On Wed, Jan 16, 2013 at 2:03 PM, अनिल नारायण गवली <
> gawlianil8...@gmail.com>
> > wrote:
> >>
> >> Dear Amit,
> >>
> >> U can use conditional format for each col in that u can use format only
> >> rows that contain lessthanequalto and in formula write =min(range) and
> >> format cell color to desire color.
> >>
> >> Regards,
> >> Gawli Anil
> >>
> >>
> >>
> >> On Wed, Jan 16, 2013 at 1:24 PM, Amresh Maurya <
> amreshkushw...@gmail.com>
> >> wrote:
> >>>
> >>> Hello Amit,
> >>>
> >>> PFA file .Kindly use the below code.
> >>>
> >>> Sub minmm()
> >>> n = 5
> >>> Sheet1.Cells(5, 14).Formula = "=MIN(RC[-10],RC[-6],RC[-2])"
> >>> Sheet1.Range(Cells(5, 14), Cells(10, 14)).Select
> >>> Selection.FillDown
> >>> Sheet1.Range(Cells(5, 15), Cells(10, 15)) =
> >>>
> >>>
> "=IF(RC[-1]=RC[-3],""Suresh"",IF(RC[-7]=RC[-1],""mukesh"",IF(RC[-1]=RC[-11],""amit"")))"
> >>> Sheet1.Range(Cells(5, 14), Cells(10, 15)).Copy
> >>> ActiveCell.PasteSpecial xlPasteValues
> >>> Application.CutCopyMode = False
> >>> Range("n4").Select
> >>> End Sub
> >>>
> >>> Regards
> >>> Amresh
> >>>
> >>> On Wed, Jan 16, 2013 at 12:31 PM, Amit Gandhi 
> >>> wrote:
> >>> > Hi Experts
> >>> >
> >>> > I have some data and I have get minimum no out of that by MIN
> formula.
> >>> > Now I
> >>> > want a formula or VBA macro to do following.
> >>> >
> >>> > 1. Minimum of column D, H, L  gets highlighted as shown above.
> >>> > 2. Minimum's name is mentioned against each cell in column O.
> >>> >
> >>> > Pls see sample file attached.
> >>> >
> >>> > Pls help me here.
> >>> >
> >>> > Regards
> >>> >
> >>> > Amit
> >>> >
> >>> > --
> >>> > Join official Facebook page of this forum @
> >>> > https://www.facebook.com/discussexcel
> >>> >

Re: $$Excel-Macros$$ Getting Minimum no highlighted

[Amit Gandhi]

Thanks Anil

But i am unable to do so? Can you show this in example file.

Regards

Amit


On Wed, Jan 16, 2013 at 2:03 PM, अनिल नारायण गवली
wrote:

> Dear Amit,
>
> U can use conditional format for each col in that u can use format only
> rows that contain lessthanequalto and in formula write =min(range) and
> format cell color to desire color.
>
> Regards,
> Gawli Anil
>
>
>
> On Wed, Jan 16, 2013 at 1:24 PM, Amresh Maurya 
> wrote:
>
>> Hello Amit,
>>
>> PFA file .Kindly use the below code.
>>
>> Sub minmm()
>> n = 5
>> Sheet1.Cells(5, 14).Formula = "=MIN(RC[-10],RC[-6],RC[-2])"
>> Sheet1.Range(Cells(5, 14), Cells(10, 14)).Select
>> Selection.FillDown
>> Sheet1.Range(Cells(5, 15), Cells(10, 15)) =
>>
>> "=IF(RC[-1]=RC[-3],""Suresh"",IF(RC[-7]=RC[-1],""mukesh"",IF(RC[-1]=RC[-11],""amit"")))"
>> Sheet1.Range(Cells(5, 14), Cells(10, 15)).Copy
>> ActiveCell.PasteSpecial xlPasteValues
>> Application.CutCopyMode = False
>> Range("n4").Select
>> End Sub
>>
>> Regards
>> Amresh
>>
>> On Wed, Jan 16, 2013 at 12:31 PM, Amit Gandhi 
>> wrote:
>> > Hi Experts
>> >
>> > I have some data and I have get minimum no out of that by MIN formula.
>> Now I
>> > want a formula or VBA macro to do following.
>> >
>> > 1. Minimum of column D, H, L  gets highlighted as shown above.
>> > 2. Minimum's name is mentioned against each cell in column O.
>> >
>> > Pls see sample file attached.
>> >
>> > Pls help me here.
>> >
>> > Regards
>> >
>> > Amit
>> >
>> > --
>> > Join official Facebook page of this forum @
>> > https://www.facebook.com/discussexcel
>> >
>> > FORUM RULES
>> >
>> > 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will
>> > not get quick attention or may not be answered.
>> > 2) Don't post a question in the thread of another member.
>> > 3) Don't post questions regarding breaking or bypassing any security
>> > measure.
>> > 4) Acknowledge the responses you receive, good or bad.
>> > 5) Jobs posting is not allowed.
>> > 6) Sharing copyrighted material and their links is not allowed.
>> >
>> > NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> > members are not responsible for any loss.
>> > ---
>> > You received this message because you are subscribed to the Google
>> Groups
>> > "MS EXCEL AND VBA MACROS" group.
>> > To post to this group, send email to excel-macros@googlegroups.com.
>> > To unsubscribe from this group, send email to
>> > excel-macros+unsubscr...@googlegroups.com.
>> > Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>> >
>> >
>>
>> --
>> Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE  : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>
>>
>
>
> --
> Thanks & Regards,
> Gawli Anil Narayan
> Software Developer,
> Abacus Software Services Pvt Ltd
>
> --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please

$$Excel-Macros$$ Getting Minimum no highlighted

[Amit Gandhi]

Hi Experts

I have some data and I have get minimum no out of that by MIN formula. Now
I want a formula or VBA macro to do following.

1. Minimum of column D, H, L  gets highlighted as shown above.
2. Minimum's name is mentioned against each cell in column O.

Pls see sample file attached.

Pls help me here.

Regards

Amit

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

FORUM RULES

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

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




GETTING MINIMUM NO.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ GETTING MINIMUM NO HIGHLIGHTED

[Amit Gandhi]

-- Forwarded message --
From: Amit Gandhi 
Date: Tue, Jan 15, 2013 at 1:07 PM
Subject: $$Excel-Macros$$
To: excel-macros@googlegroups.com


Hi Experts

I have some data and I have get minimum no out of that by MIN formula. Now
I want a formula or VBA macro to do following.

1. Minimum of column D, H, L  gets highlighted as shown above.
2. Minimum's name is mentioned against each cell in column O.

Pls see sample file attached.

Pls help me here.

Regards

Amit

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

FORUM RULES

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

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





-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

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

FORUM RULES

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

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




GETTING MINIMUM NO.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$

[Amit Gandhi]

Hi Experts

I have some data and I have get minimum no out of that by MIN formula. Now
I want a formula or VBA macro to do following.

1. Minimum of column D, H, L  gets highlighted as shown above.
2. Minimum's name is mentioned against each cell in column O.

Pls see sample file attached.

Pls help me here.

Regards

Amit

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

FORUM RULES

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

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




GETTING MINIMUM NO.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ lookup values with 2 conditions

[Amit Gandhi]

Thanks dear

Its really fast.

Regards

Amit


On Sat, Dec 22, 2012 at 6:45 PM, >>Excel Beginner<<  wrote:

> Hi Amit,
>
>  Please find the attachment.
>
>
>
>
> --
> *Regards,*
> *
> *
> *Excel Beginner*
> On Sat, Dec 22, 2012 at 4:56 PM, Amit Gandhi  wrote:
>
>> Hi Experts
>>
>> I am attaching an excel file, where I have applied LOOKUP/INDIRECT
>> function in sheet "backup". But its very slow in working/opening. And
>> when data is large, it takes too much time for processing.
>>
>> Is there any better & fast way to get the same output?
>>
>> Please help me here.
>>
>> Regards
>>
>> Amit
>>
>>  --
>> Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>
>>
>
>
>
>
>  --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>



-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

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

FORUM RULES

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

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

$$Excel-Macros$$ lookup values with 2 conditions

[Amit Gandhi]

Hi Experts

I am attaching an excel file, where I have applied LOOKUP/INDIRECT function
in sheet "backup". But its very slow in working/opening. And when data is
large, it takes too much time for processing.

Is there any better & fast way to get the same output?

Please help me here.

Regards

Amit

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

FORUM RULES

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

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




lookup with 2 conditions & INDIRECT.xlsm
Description: Binary data

Re: $$Excel-Macros$$ how to create formula in vba through cell references

[Amit Gandhi]

Thank you so much Swapnil.

Its working fine

Thanks

Amit


On Tue, Dec 18, 2012 at 2:06 PM, Swapnil Palande <
palande.swapni...@gmail.com> wrote:

> Hi Amit,
>
> No need of macro for this. You can use INDIRECT function.
>
> Check following formula.
> =LOOKUP(2,1/((INDIRECT("'" & B3 & "_WBQ'!$D:$D")=$B3)*(INDIRECT("'" & B3 &
> "_WBQ'!$E:$E")=C$2)),INDIRECT("'" & B3 & "_WBQ'!$K:$K"))
>
> PFA file for reference, have hilighted cell in green which has correct
> formula.
>
> Regards,
>
> Swapnil.
>
> On Tue, Dec 18, 2012 at 12:11 PM, Amit Gandhi wrote:
>
>> Hi Swapnil
>>
>> I want a vba code/ or excel formula to make below yellow highlighted as
>> DYNAMIC, this value should come from cell $B3, $B4 etc.
>>
>>
>> activesheet.range("c2").formula= "=LOOKUP(2,1/(('^BSESN_WBQ'!$
>> D:$D=$B3)*('^BSESN_WBQ'!$E:$E= C$2)),'^BSESN_WBQ'!$K:$K)"
>>
>>
>> Hope you understand.
>>
>> I have created one vba code in attached file to do this, but its not
>> working.
>>
>> Pls help me here.
>>
>> Regards
>>
>> Amit
>>
>>
>> On Mon, Dec 17, 2012 at 7:34 PM, Swapnil Palande <
>> palande.swapni...@gmail.com> wrote:
>>
>>> Hi Amit
>>>
>>> Try following code, if get any error let me know
>>>
>>> activesheet.range("c2").formula= "=LOOKUP(2,1/(('^BSESN_WBQ'!$
>>> D:$D=$B3)*('^BSESN_WBQ'!$E:$E= C$2)),'^BSESN_WBQ'!$K:$K)"
>>>
>>> Regards
>>> Swapnil
>>>  On Dec 17, 2012 6:17 PM, "Amit Gandhi"  wrote:
>>>
>>>> Hi Swapnil
>>>>
>>>> I am not very good in VBA, can you please send me macro code for this.
>>>>
>>>> Regards
>>>>
>>>> Amit
>>>>
>>>>
>>>> On Mon, Dec 17, 2012 at 5:54 PM, Swapnil Palande <
>>>> palande.swapni...@gmail.com> wrote:
>>>>
>>>>> Hi,
>>>>>
>>>>> Try formula function of class Range
>>>>>
>>>>> Regards
>>>>> Swapnil
>>>>>  On Dec 17, 2012 5:16 PM, "Amit Gandhi"  wrote:
>>>>>
>>>>>> Hi Experts
>>>>>>
>>>>>> I need a macro which will fill-in mentioned formulas in cell C3 to K4
>>>>>> for sheet "backup" and get the desired results.
>>>>>>
>>>>>> activesheet.range("c2")= "=LOOKUP(2,1/(('*^BSESN*_WBQ'!$D:$D=$B3)*('*
>>>>>> ^BSESN*_WBQ'!$E:$E=C$2)),'*^BSESN*_WBQ'!$K:$K)"
>>>>>>
>>>>>> i need macro to get above red highlighted values from cell B3, B4 etc.
>>>>>>
>>>>>> Hope you can understand what I want.
>>>>>>
>>>>>> Regards
>>>>>>
>>>>>> Amit
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Join official Facebook page of this forum @
>>>>>> https://www.facebook.com/discussexcel
>>>>>>
>>>>>> FORUM RULES
>>>>>>
>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>>> Advice will not get quick attention or may not be answered.
>>>>>> 2) Don't post a question in the thread of another member.
>>>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>>>> measure.
>>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>>> 5) Jobs posting is not allowed.
>>>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>>>
>>>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>>>> and members are not responsible for any loss.
>>>>>> ---
>>>>>> You received this message because you are subscribed to the Google
>>>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>>>> To post to this group, send email to excel-macros@googlegroups.com.
>>>>>> To unsubscrib

Re: $$Excel-Macros$$ how to create formula in vba through cell references

[Amit Gandhi]

Hi Swapnil

I am not very good in VBA, can you please send me macro code for this.

Regards

Amit


On Mon, Dec 17, 2012 at 5:54 PM, Swapnil Palande <
palande.swapni...@gmail.com> wrote:

> Hi,
>
> Try formula function of class Range
>
> Regards
> Swapnil
> On Dec 17, 2012 5:16 PM, "Amit Gandhi"  wrote:
>
>> Hi Experts
>>
>> I need a macro which will fill-in mentioned formulas in cell C3 to K4 for
>> sheet "backup" and get the desired results.
>>
>> activesheet.range("c2")= "=LOOKUP(2,1/(('*^BSESN*_WBQ'!$D:$D=$B3)*('*
>> ^BSESN*_WBQ'!$E:$E=C$2)),'*^BSESN*_WBQ'!$K:$K)"
>>
>> i need macro to get above red highlighted values from cell B3, B4 etc.
>>
>> Hope you can understand what I want.
>>
>> Regards
>>
>> Amit
>>
>>
>>
>>
>>  --
>> Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>
>>
>  --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>



-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

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

FORUM RULES

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

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

$$Excel-Macros$$ how to create formula in vba through cell references

[Amit Gandhi]

Hi Experts

I need a macro which will fill-in mentioned formulas in cell C3 to K4 for
sheet "backup" and get the desired results.

activesheet.range("c2")= "=LOOKUP(2,1/(('*^BSESN*_WBQ'!$D:$D=$B3)*('*^BSESN*
_WBQ'!$E:$E=C$2)),'*^BSESN*_WBQ'!$K:$K)"

i need macro to get above red highlighted values from cell B3, B4 etc.

Hope you can understand what I want.

Regards

Amit

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

FORUM RULES

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

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




lookup values.xlsm
Description: Binary data

Re: $$Excel-Macros$$ MACRO FOR LIST CHECK AND ADD ROWS

[Amit Gandhi]

Thanks Mr. Paul

No need to say Sorry. You helped me a lot. This macro is running perfectly
now.

Thanks a lot once again.

Regards

Amit


On Tue, Dec 4, 2012 at 6:04 PM, Paul Schreiner wrote:

> Amit,
>
> Sorry,
>
> Since I didn't know how large your data set would end up being,
> I used a "Dictionary Object" to read the existing records.
> then, I would check this list to determine if the record existed.
>
> Since I made the object "public", it didn't clear out when the macro
> finished.
> So in the next execution, it retained the previous values.
>
> (thought you ought to know MY mistake)
>
> I fixed the macro and "tuned it up" a little.
>
> hope it serves you well!
>
>
> *Paul*
>
> -
> *“Do all the good you can,
> By all the means you can,
> In all the ways you can,
> In all the places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> *-
>
>
>  --
> *From:* Amit Gandhi 
> *To:* excel-macros@googlegroups.com
> *Sent:* Mon, December 3, 2012 11:55:15 PM
>
> *Subject:* Re: $$Excel-Macros$$ MACRO FOR LIST CHECK AND ADD ROWS
>
> Thanks Mr. Paul
>
> This is what I require. May be I was unable to explain my requirement, but
> you rightly understood and give me solution.
> Thanks a lot.
>
> But this macro has some problems.
>
> 1. If I run this macro 1st time, it add the rows correctly. But when I run
> this macro again, it again add those rows and create duplicity of records.
> COLUMN A should have unique values always.
>
> 2. In my example I had copied 1st two values of TTlist in cell A6 & A7,
> and this macro has copied down rest of the values from cell A8 onwards
> rightly. BUT when I have copied any random values from TTlist in cell A6 &
> A7, then macro hasn't checked the values and left 1st two values of TTlist
> and copied down rest of the values.
>
> I have attached file for your ready reference.
>
> Pls provide solution to this problem as well.
>
> Thanks in advance.
>
> Regards
>
> Amit
>
>
>
> On Mon, Dec 3, 2012 at 6:16 PM, Paul Schreiner wrote:
>
>>   The problem is that you described your problem "backwards".
>>
>> You SAID that you wanted to compare the list in sheet "TT"
>> to the values in the named range "TTlist"
>> and copy the values from row 1 if it doesn't exist.
>>
>> --
>> I "assumed" that you were going to be adding values to sheet "TT"
>> and wanted to check to see if they existed in "TTlist".
>> If they did NOT, then add the value and copy row 1.
>> So, I gave you what you asked for.
>> --
>>
>> Instead, from your example, you want to compare the values in the
>> named range "TTlist" to the values in sheet "TT"
>> and add any that do not already exist FROM "TTlist" TO the sheet.
>>
>> The attached file, macro Add_Records
>> should perform this task.
>>
>>
>>
>>
>> *Paul*
>>
>> -
>> *“Do all the good you can,
>> By all the means you can,
>> In all the ways you can,
>> In all the places you can,
>> At all the times you can,
>> To all the people you can,
>> As long as ever you can.” - John Wesley
>> *-
>>
>>
>>  --
>> *From:* Amit Gandhi 
>> *To:* excel-macros@googlegroups.com
>> *Sent:* Sat, December 1, 2012 1:15:34 AM
>>
>> *Subject:* Re: $$Excel-Macros$$ MACRO FOR LIST CHECK AND ADD ROWS
>>
>> Hi Paul
>>
>> This is not working. I am trying to elaborate more step by step what I
>> required.
>>
>> Step 1. Macro will check in sheet *"TT",* column A (A6 onwards) with *
>> "TTlist"* for values.
>>
>> e.g. (a) it will check 1st value of "TTlist" i.e. "DPR/FIBC15544/12" in
>> cell A6.
>>(b) if this value already exists in A6, then no action and go to
>> next cell A7.
>>(c) if this value already exists in A7, then no action and go to
>> next cell A8.
>>   This step goes on until BLANK cell in column A.
>>
>>  Step 2. If a value of "TTlist" doesn't exist in column A, then it
>> copies Row 1 and paste it at the end (say at row 8 in attached file), then
>> it fill-in the value in cell A8, an

Re: $$Excel-Macros$$ MACRO FOR LIST CHECK AND ADD ROWS

[Amit Gandhi]

Hi Experts

Pls help me on below.

Regards

Amit


On Sat, Dec 1, 2012 at 11:40 AM, Amit Gandhi  wrote:

> Hi Paul
>
> This is not working. I am trying to elaborate more step by step what I
> required.
>
> Step 1. Macro will check in sheet *"TT",* column A (A6 onwards) with *
> "TTlist"* for values.
>
> e.g. (a) it will check 1st value of "TTlist" i.e. "DPR/FIBC15544/12" in
> cell A6.
>(b) if this value already exists in A6, then no action and go to
> next cell A7.
>(c) if this value already exists in A7, then no action and go to
> next cell A8.
>   This step goes on until BLANK cell in column A.
>
> Step 2. If a value of "TTlist" doesn't exist in column A, then it copies
> Row 1 and paste it at the end (say at row 8 in attached file), then it
> fill-in the value in cell A8, and search for next value.
>
> e.g. (a) 3rd value "DPR/FIBC15509/12" of "TTlist" doesn't exist in column
> A of sheet "TT".
>(b) Macro will copy Row 1 and paste it at Row 8.
>(c) Macro will copy above value of (a) to cell A8.
>
> Then macro will check for 4th value "DPR/FIBC15508/12" of "TTlist" in
> column A of sheet "TT" and so on till complete list has been checked.
>
> After running macro final solution will be as shown in sheet
> "Solution_Reqd".
>
> Hope I make you understand what I need.
>
> Pls help me here.
>
> Regards
>
> Amit
>
>
> On Fri, Nov 30, 2012 at 7:30 PM, Paul Schreiner wrote:
>
>> Your description and sample is somewhat conflicting.
>>
>> You SAID:
>> 1. Macro will check in sheet "TT" column A (A6 onwards) with "TTlist" for
>> values.
>> 2. If a value exists in column A, it ignores and go to next cell.
>> 3. If a value doesn't exist in column A, then it copies Row 1 and paste
>> it at the end (say at row 8 in attached file), then it fill-in the value in
>> cell A8, and search for next value.
>>
>> Yet in your sample, the value in Column A DOES exist,
>> yet you copy line 1 to the indicated row.
>>
>> In the attached file, I did as you requested, not as your sample
>>
>>
>> *Paul*
>>
>> -
>> *“Do all the good you can,
>> By all the means you can,
>> In all the ways you can,
>> In all the places you can,
>> At all the times you can,
>> To all the people you can,
>> As long as ever you can.” - John Wesley
>> *-
>>
>>
>>  --
>> *From:* Amit Gandhi 
>> *To:* excel-macros@googlegroups.com
>> *Sent:* Fri, November 30, 2012 2:31:51 AM
>> *Subject:* Re: $$Excel-Macros$$ MACRO FOR LIST CHECK AND ADD ROWS
>>
>> Hi Experts
>>
>>  I have created a list in "Name Manager" named "TTlist" for values shown
>> in "LIST" sheet of attached file. I used to update this "TTlist" with some
>> other macro.
>> I have another sheet named "TT" in which 1st 5 rows are constant. I sued
>> to fill-in data from 6th row on-wards.
>>
>> I need a macro which will help me doing following.
>>
>> 1. Macro will check in sheet "TT" column A (A6 onwards) with "TTlist" for
>> values.
>> 2. If a value exists in column A, it ignores and go to next cell.
>> 3. If a value doesn't exist in column A, then it copies Row 1 and paste
>> it at the end (say at row 8 in attached file), then it fill-in the value in
>> cell A8, and search for next value.
>>
>> To summarise, i need solution as shown in sheet "SOLUTION_REQD".
>>
>> Pls help me here.
>>
>> Regards
>>
>> Amit
>>
>>
>> On Wed, Nov 28, 2012 at 12:30 PM, Amit Gandhi wrote:
>>
>>> Hi Experts
>>>
>>>  I have created a list in "Name Manager" named "TTlist" for values
>>> shown in "LIST" sheet of attached file. I used to update this "TTlist" with
>>> some other macro.
>>> I have another sheet named "TT" in which 1st 5 rows are constant. I sued
>>> to fill-in data from 6th row on-wards.
>>>
>>> I need a macro which will help me doing following.
>>>
>>> 1. Macro will check in sheet "TT" column A (A6 onwards) with "TTlist"
>>> for values.
>>> 2. If a value exists in column A, it ignores and go to next cell.
>>> 3. If a value doesn't exist in c

Re: $$Excel-Macros$$ MACRO FOR LIST CHECK AND ADD ROWS

[Amit Gandhi]

Hi Experts

I have created a list in "Name Manager" named "TTlist" for values shown in
"LIST" sheet of attached file. I used to update this "TTlist" with some
other macro.
I have another sheet named "TT" in which 1st 5 rows are constant. I sued to
fill-in data from 6th row on-wards.

I need a macro which will help me doing following.

1. Macro will check in sheet "TT" column A (A6 onwards) with "TTlist" for
values.
2. If a value exists in column A, it ignores and go to next cell.
3. If a value doesn't exist in column A, then it copies Row 1 and paste it
at the end (say at row 8 in attached file), then it fill-in the value in
cell A8, and search for next value.

To summarise, i need solution as shown in sheet "SOLUTION_REQD".

Pls help me here.

Regards

Amit


On Wed, Nov 28, 2012 at 12:30 PM, Amit Gandhi  wrote:

> Hi Experts
>
> I have created a list in "Name Manager" named "TTlist" for values shown in
> "LIST" sheet of attached file. I used to update this "TTlist" with some
> other macro.
> I have another sheet named "TT" in which 1st 5 rows are constant. I sued
> to fill-in data from 6th row on-wards.
>
> I need a macro which will help me doing following.
>
> 1. Macro will check in sheet "TT" column A (A6 onwards) with "TTlist" for
> values.
> 2. If a value exists in column A, it ignores and go to next cell.
> 3. If a value doesn't exist in column A, then it copies Row 1 and paste it
> at the end (say at row 8 in attached file), then it fill-in the value in
> cell A8, and search for next value.
>
> To summarise, i need solution as shown in sheet "SOLUTION_REQD".
>
> Pls help me here.
>
> Regards
>
> Amit
>
>  --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>



-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

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

FORUM RULES

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

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




LIST CHECK & ADD ROWS.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ LIST CHECK AND ADD ROWS

[Amit Gandhi]

Hi Experts

I have created a list in "Name Manager" named "TTlist" for values shown in
"LIST" sheet of attached file. I used to update this "TTlist" with some
other macro.
I have another sheet named "TT" in which 1st 5 rows are constant. I sued to
fill-in data from 6th row on-wards.

I need a macro which will help me doing following.

1. Macro will check in sheet "TT" column A (A6 onwards) with "TTlist" for
values.
2. If a value exists in column A, it ignores and go to next cell.
3. If a value doesn't exist in column A, then it copies Row 1 and paste it
at the end (say at row 8 in attached file), then it fill-in the value in
cell A8, and search for next value.

To summarise, i need solution as shown in sheet "SOLUTION_REQD".

Pls help me here.

Regards

Amit

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

FORUM RULES

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

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




LIST CHECK & ADD ROWS.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ MOST REPEATED NO

[Amit Gandhi]

Thanks Mr. Don, Mr. Sam, Mr Rajan.

Thanks a lot.

On Fri, Aug 17, 2012 at 11:09 PM, Rajan_Verma wrote:

> * *
>
> *Another solution is *
>
> * *
>
> *=Mode(rng)*
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> *From:* Rajan_Verma [mailto:rajanverma1...@gmail.com]
> *Sent:* 17 August 2012 10:19
> *To:* 'excel-macros@googlegroups.com'
> *Subject:* RE: $$Excel-Macros$$ MOST REPEATED NO
>
> ** **
>
> * *
>
> *If your list is Name is rng *
>
> * *
>
> *Without Array *
>
> *=INDEX(rng,MATCH(MAX(FREQUENCY(rng,rng)),FREQUENCY(rng,rng),0),0)*
>
> * *
>
> *With Array*
>
> *=SMALL(IF(COUNTIF(rng,rng)=MAX(COUNTIF(rng,rng)),rng,""),1)*
>
> * *
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *dguillett1
>
> *Sent:* 17 August 2012 9:22
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ MOST REPEATED NO
>
> ** **
>
> Or, a macro to round b..
>
>  
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
>  
>
> *From:* Sam Mathai Chacko  
>
> *Sent:* Friday, August 17, 2012 10:43 AM
>
> *To:* excel-macros@googlegroups.com 
>
> *Subject:* Re: $$Excel-Macros$$ MOST REPEATED NO
>
>  
>
> Or directly by rounding in the formula itself
>
> =ROUND(INDEX(B3:B21,MATCH(LARGE(FREQUENCY(ROUND(B3:B21,2),ROUND(B3:B21,2)),
> 2),FREQUENCY(ROUND(B3:B21,2),ROUND(B3:B21,2)),0)),2)
>
> Change the RED colored 2 to 3 for third most repeated number and so on
>
> And if you only need to get the second largest number, you can use a
> simpler formula
>
>
> =MODE(--SUBSTITUTE(ROUND(B3:B21,2),MODE(ROUND(B3:B21,2)),MAX(B3:B21)+ROW(INDIRECT("1:"&ROWS(B3:B21)
>
> Regards,
> Sam Mathai Chacko
>
> On Fri, Aug 17, 2012 at 7:07 PM, dguillett1  wrote:*
> ***
>
> Looks like homework to me also but this should do it AFTER rounding your
> column B into column A
>
>  
>
>
> =INDEX($A$3:$A$21,MATCH(LARGE(FREQUENCY($A$3:$A$21,$A$3:$A$21),ROW(A1)),FREQUENCY($A$3:$A$21,$A$3:$A$21),0))
> 
>
>  
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
>  
>
> *From:* Amit Gandhi  
>
> *Sent:* Friday, August 17, 2012 1:30 AM
>
> *To:* excel-macros@googlegroups.com 
>
> *Subject:* $$Excel-Macros$$ MOST REPEATED NO
>
>  
>
> Hi Experts 
>
>  
>
> If there is any formula which can calculate MOST REPEATED NO from a list?
> Sample file attached.
>
>  
>
> Pls help me here.
>
>  
>
> Regards
>
>  
>
> Amit
>
>  
>
>  
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> mailto:excel-macros%2bunsubscr...@googlegroups.com
> .
>
>  
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the threa

Re: $$Excel-Macros$$ MOST REPEATED NO

[Amit Gandhi]

Thanks Mr. Paul

For such a beautiful & accurate reply.


On Fri, Aug 17, 2012 at 6:50 PM, Paul Schreiner wrote:

> Is this homework?
> It sure looks like it.
> I think we've been getting a LOT of that lately, school must have begun!
>
> I SUPPOSE that school should be teaching how best to use resources at your
> disposal to accomplish a task,
> and this forum is DEFINITELY a valuable resource, so...
>
> First of all, you've asked this question in a forum for Excel MACROS,
> not EXCEL Users.
> That is, this group is primarily for providing assistance with writing VBA
> macros for Excel.
> But most of us have "some" experience with Excel functions.
>
> --
> In Statistics, there are three (or more) numeric values of importance:
> Mode, Median, Mean
>
> Mean is the Average,
> Median is the number in the "middle" of the series.
> Mode is the value most repeated.
>
> Excel 2010+ had three variations of this:
> Mode (used for backward compatibility to Excel 2007)
> Mode.SNGL
> Mode.MULT
>
> To get the most repeated number, you COULD use:
> =Mode(B3:B21)
> or
> =Mode.sngl(B3:B21)
>
> But your numbers don't actually repeat.
>  That's because you may SEE a couple of values like 1.32, but
> they are actually
> 1.31853816584186
> 1.32496254963853
>
> So you need to round them (to 2 decimal places)
>
> =MODE.SNGL(ROUND(B3:B21,2))
>
> That should give you the most repeated number.
>
> Now, for the second,
> you should be able to use:
> =Mode.Mult(round(B2:B21,2))
> as an array function,
> then, use:
> index(mode.mult(round(B2:B21,2)))
>
> as an array function, but I haven't been able to get it to work.
>
> Perhaps this is enough to get you pointed in the right direction?
>
>
> *Paul*
>
> -
> *“Do all the good you can,
> By all the means you can,
> In all the ways you can,
> In all the places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> *-
>
>
>  --
> *From:* Amit Gandhi 
> *To:* excel-macros@googlegroups.com
> *Sent:* Fri, August 17, 2012 2:30:41 AM
> *Subject:* $$Excel-Macros$$ MOST REPEATED NO
>
> Hi Experts
>
> If there is any formula which can calculate MOST REPEATED NO from a list?
> Sample file attached.
>
> Pls help me here.
>
> Regards
>
> Amit
>
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Fo

Re: $$Excel-Macros$$ MOST REPEATED NO

[Amit Gandhi]

Hi Kuldeep

Its not working. Pls show example in sample file.

Regards

Amit


On Fri, Aug 17, 2012 at 12:08 PM, Kuldeep Singh wrote:

>
> You can try this.
>
> =COUNTIF(B3:B21,B3)>1
>
> Regards,
> Kuldeep Singh
> Phone.: +91-120-4763789, Extn.: 789
> naukrikuld...@gmail.com || www.naukri.com
> *Please* *Consider the environment. Please don't print this e-mail unless
> you really need to.*
>
>
> On Fri, Aug 17, 2012 at 12:00 PM, Amit Gandhi wrote:
>
>> Hi Experts
>>
>> If there is any formula which can calculate MOST REPEATED NO from a list?
>> Sample file attached.
>>
>> Pls help me here.
>>
>> Regards
>>
>> Amit
>>
>>
>>  --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

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

$$Excel-Macros$$ MOST REPEATED NO

[Amit Gandhi]

Hi Experts

If there is any formula which can calculate MOST REPEATED NO from a list?
Sample file attached.

Pls help me here.

Regards

Amit

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

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




FIND MOST REPEATED NO.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Re: Noorain Ansari - Most Helpful Member July 2012

[Amit Gandhi]

Congrats Noorain


On Sun, Aug 5, 2012 at 11:41 PM, prkhan56  wrote:

> Great Work Noorain Bhai..Keep it up
> On Friday, August 3, 2012 9:40:25 PM UTC+4, Ayush Jain wrote:
>>
>> Dear members,
>>
>> Noorain Ansari has been selected as 'Most Helpful Member' for the month
>> of July'12. He has posted 143 posts in July 2012 and helped many forum
>> members through his excel expertise.
>>
>> I truly appreciate his consistency and commitment to the group. He is
>> really doing great job.
>>
>> Thanks to Don, Deba Ranjan, Magnesh, Ashish, Rajan, bpascal, Prince,
>> Sunita and other folks for helping excel enthusiasts voluntarily !!
>> Keep posting.
>>
>> Regards,
>> Ayush Jain
>> Group Manager
>> Microsoft MVP
>>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

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

Re: $$Excel-Macros$$ VBA code for Updating External links in excel

[Amit Gandhi]

Hi Noorain

I think you haven't understood what I want. You are giving me code to
UPDATE LINKS in other files. But I need something different. I am sitting
in File1 and I want code to update links of File1 itself.

1st Example -->
I have file named "File1", which have too many external links to different
excel files (File2, File3, File4 ) through VLOOKUP. I want to write a
VBA code in "File1" Open event, so that it can UPDATE all external links.

2nd Example -->
I have file named "File1", which have too many external links to different
excel files (File2, File3, File4 ) through VLOOKUP. I want to write a
VBA code in "File1" Open event, so that it CANNOT update any external links.

I will wait for your reply.

Regards

Amit



On Thu, Jul 5, 2012 at 11:42 AM, NOORAIN ANSARI wrote:

> Dear Amit,
>
> We have to write code for each file in Workbook_Open Event like..
>
> Private Sub Workbook_Open()
>
> 'For File1
>
> Workbooks.Open FileNmae:="D:\VBA_Class\File1.xls",
> UpdateLinks:=xlUpdateLinksAlways
>
>
> 'For File2
>
> Workbooks.Open FileNmae:="D:\VBA_Class\File2.xls",
> UpdateLinks:=xlUpdateLinksAlways
>
> 'For File3
>
> Workbooks.Open FileNmae:="D:\VBA_Class\File3.xls",
> UpdateLinks:=xlUpdateLinksAlways
>
> End Sub
>
>
>
> On Wed, Jul 4, 2012 at 4:38 PM, Amit Gandhi  wrote:
>
>> Hi Noorain
>>
>> Pls elaborate more.
>>
>> 1st Example -->
>> I have file named "File1", which have too many external links to
>> different excel files (File2, File3, File4 ) through VLOOKUP. I want to
>> write a VBA code in "File1" Open event, so that it can UPDATE all external
>> links.
>>
>> 2nd Example -->
>> I have file named "File1", which have too many external links to
>> different excel files (File2, File3, File4 ) through VLOOKUP. I want to
>> write a VBA code in "File1" Open event, so that it CANNOT update any
>> external links.
>>
>> Pls help me here in both cases
>>
>> Regards
>>
>> Amit
>>
>>
>> On Wed, Jul 4, 2012 at 4:03 PM, NOORAIN ANSARI 
>> wrote:
>>
>>> Dear Amit,
>>>
>>> Please use it..in Workbook_Open Event
>>>
>>> Private Sub Workbook_Open()
>>>
>>> Workbooks.Open FileNmae:="D:\VBA_Class\LinkedBook.xls",
>>> UpdateLinks:=xlUpdateLinksAlways
>>> End Sub
>>>
>>>
>>>
>>> On Wed, Jul 4, 2012 at 3:48 PM, Amit Gandhi wrote:
>>>
>>>> Hi Experts
>>>>
>>>> Pls help me with VBA code for UPDATING External links in a excel file
>>>> whenever I open that file.
>>>>
>>>> Pls help me with VBA code to PREVENT excel to UPDATE External links in
>>>> a excel file whenever I open that file.
>>>>
>>>> Regards
>>>>
>>>> Amit
>>>>
>>>>  --
>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>>
>>>> 2) Don't post a question in the thread of another member.
>>>>
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>>
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>
>>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>>> signatures are prohibited.
>>>>
>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>> Forum owners and members are not responsible for any loss.
>>>>
>>>>
>>>> --
>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>
>>>> To unsubscribe, send a blank email to
>>>> excel-macros+unsubscr...@googlegroups.com
>>>
>>>
>>>
>>>
>>> --
>>> Thanks & regards,
>>> Noorain Ansari
>>> www.noorainansari.com
>>> www.excelmacroworld.blogspot.com
>>>
>>>
>>>
>>>
>>>  --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) 

Re: $$Excel-Macros$$ COLOR CHANGE MACRO

[Amit Gandhi]

Thanks Diwakar for lots of options, its really useful.


On Thu, Jul 5, 2012 at 4:45 PM, Divaker Pandey  wrote:

>
>
> use this one
>
> Sub ChangeRowColor()
>
> Dim sheet As Worksheet
> Dim row_min As Integer
> Dim row_max As Integer
> Dim rowC As Long
>
> ' Select the used range.
> Set sheet = ActiveSheet
> 'sheet.UsedRange.Select
>
> ' Display the range's rows and columns.
> row_min = sheet.UsedRange.Row
> row_max = row_min + sheet.UsedRange.Rows.Count - 1
>
>
> For rowC = row_min To row_max
>  With sheet.Range("c" & rowC).EntireRow.Font
> .Color = sheet.Range("C" & rowC).Font.Color
>  .TintAndShade = 0
> End With
>  Next
>
>
> End Sub
>
>
> or
>
> if you want to change color only used cells
>
> Sub ChangeRowColorOnlyUsedCells()
>
> Dim sheet As Worksheet
> Dim row_min As Integer
> Dim row_max As Integer
> Dim col_min As Integer
> Dim col_max As Integer
> Dim rowC As Long
> Dim colC As Long
>
> ' Select the used range.
> Set sheet = ActiveSheet
> 'sheet.UsedRange.Select
>
> ' Display the range's rows and columns.
> row_min = sheet.UsedRange.Row
> row_max = row_min + sheet.UsedRange.Rows.Count - 1
> col_min = sheet.UsedRange.Column
> col_max = col_min + sheet.UsedRange.Columns.Count - 1
>
> For rowC = row_min To row_max
> For colC = col_min To col_max
> With sheet.Cells(rowC, colC).Font
> .Color = sheet.Range("C" & rowC).Font.Color
>  .TintAndShade = 0
> End With
> Next
>   Next
>
> End Sub
>
>
> or
>
> if you want change on particular cell color change event then used this
> one (Few modification in noorain code
>
>
> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
> If Target.Column = "3" And Target.Value <> "" Then
> Target.EntireRow.Font.Color = Target.Cells.Font.Color
> End If
> End Sub
>
>
>
>
> On Thu, Jul 5, 2012 at 4:13 PM, NOORAIN ANSARI 
> wrote:
>
>> Dear Amit,
>>
>> Please try it..
>>
>> *Private Sub Worksheet_SelectionChange(ByVal Target As Range)
>> If Target.Column = "3" And Target.Value <> "" Then
>> Target.EntireRow.Interior.ColorIndex = Target.Cells.Font.ColorIndex
>> End If
>> End Sub
>> *
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> www.noorainansari.com
>> www.excelmacroworld.blogspot.com
>>
>> On Thu, Jul 5, 2012 at 3:51 PM, Amit Gandhi  wrote:
>>
>>> Hi Experts
>>>
>>> I need a macro which changes the FONT COLOR of ENTIRE ROW as per font
>>> color of a particular cell in that row. Sample file attached.
>>>
>>> Pls help me here.
>>>
>>> Regards
>>>
>>> Amit
>>>
>>>  --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>>
>>
>>
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.

Re: $$Excel-Macros$$ COLOR CHANGE MACRO

[Amit Gandhi]

thanks noorain

On Thu, Jul 5, 2012 at 4:13 PM, NOORAIN ANSARI wrote:

> Dear Amit,
>
> Please try it..
>
> *Private Sub Worksheet_SelectionChange(ByVal Target As Range)
> If Target.Column = "3" And Target.Value <> "" Then
> Target.EntireRow.Interior.ColorIndex = Target.Cells.Font.ColorIndex
> End If
> End Sub
> *
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Thu, Jul 5, 2012 at 3:51 PM, Amit Gandhi  wrote:
>
>> Hi Experts
>>
>> I need a macro which changes the FONT COLOR of ENTIRE ROW as per font
>> color of a particular cell in that row. Sample file attached.
>>
>> Pls help me here.
>>
>> Regards
>>
>> Amit
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
>
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

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

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

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

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

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

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

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

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

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

$$Excel-Macros$$ COLOR CHANGE MACRO

[Amit Gandhi]

Hi Experts

I need a macro which changes the FONT COLOR of ENTIRE ROW as per font color
of a particular cell in that row. Sample file attached.

Pls help me here.

Regards

Amit

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

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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ VBA code for Updating External links in excel

[Amit Gandhi]

Hi Experts

I am waiting for your reply on below.

1st Example -->
I have file named "File1", which have too many external links to different
excel files (File2, File3, File4 ) through VLOOKUP. I want to write a
VBA code in "File1" Open event, so that it can UPDATE all external links.

2nd Example -->
I have file named "File1", which have too many external links to different
excel files (File2, File3, File4 ) through VLOOKUP. I want to write a
VBA code in "File1" Open event, so that it CANNOT update any external links.

Pls help me here in both cases


Regards

Amit


On Wed, Jul 4, 2012 at 4:38 PM, Amit Gandhi  wrote:

> Hi Noorain
>
> Pls elaborate more.
>
> 1st Example -->
> I have file named "File1", which have too many external links to different
> excel files (File2, File3, File4 ) through VLOOKUP. I want to write a
> VBA code in "File1" Open event, so that it can UPDATE all external links.
>
> 2nd Example -->
> I have file named "File1", which have too many external links to different
> excel files (File2, File3, File4 ) through VLOOKUP. I want to write a
> VBA code in "File1" Open event, so that it CANNOT update any external links.
>
> Pls help me here in both cases
>
> Regards
>
> Amit
>
>
> On Wed, Jul 4, 2012 at 4:03 PM, NOORAIN ANSARI 
> wrote:
>
>> Dear Amit,
>>
>> Please use it..in Workbook_Open Event
>>
>> Private Sub Workbook_Open()
>>
>> Workbooks.Open FileNmae:="D:\VBA_Class\LinkedBook.xls",
>> UpdateLinks:=xlUpdateLinksAlways
>> End Sub
>>
>>
>>
>> On Wed, Jul 4, 2012 at 3:48 PM, Amit Gandhi  wrote:
>>
>>> Hi Experts
>>>
>>> Pls help me with VBA code for UPDATING External links in a excel file
>>> whenever I open that file.
>>>
>>> Pls help me with VBA code to PREVENT excel to UPDATE External links in a
>>> excel file whenever I open that file.
>>>
>>> Regards
>>>
>>> Amit
>>>
>>>  --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> www.noorainansari.com
>> www.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
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
>
>
> --
> 'Expecting the world to treat u fairly coz u r a good person is like
> expe

Re: $$Excel-Macros$$ VBA code for Updating External links in excel

[Amit Gandhi]

Hi Noorain

Pls elaborate more.

1st Example -->
I have file named "File1", which have too many external links to different
excel files (File2, File3, File4 ) through VLOOKUP. I want to write a
VBA code in "File1" Open event, so that it can UPDATE all external links.

2nd Example -->
I have file named "File1", which have too many external links to different
excel files (File2, File3, File4 ) through VLOOKUP. I want to write a
VBA code in "File1" Open event, so that it CANNOT update any external links.

Pls help me here in both cases

Regards

Amit


On Wed, Jul 4, 2012 at 4:03 PM, NOORAIN ANSARI wrote:

> Dear Amit,
>
> Please use it..in Workbook_Open Event
>
> Private Sub Workbook_Open()
>
> Workbooks.Open FileNmae:="D:\VBA_Class\LinkedBook.xls",
> UpdateLinks:=xlUpdateLinksAlways
> End Sub
>
>
>
> On Wed, Jul 4, 2012 at 3:48 PM, Amit Gandhi  wrote:
>
>> Hi Experts
>>
>> Pls help me with VBA code for UPDATING External links in a excel file
>> whenever I open that file.
>>
>> Pls help me with VBA code to PREVENT excel to UPDATE External links in a
>> excel file whenever I open that file.
>>
>> Regards
>>
>> Amit
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

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

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

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

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

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

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

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

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

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

$$Excel-Macros$$ VBA code for Updating External links in excel

[Amit Gandhi]

Hi Experts

Pls help me with VBA code for UPDATING External links in a excel file
whenever I open that file.

Pls help me with VBA code to PREVENT excel to UPDATE External links in a
excel file whenever I open that file.

Regards

Amit

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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Re: CTRL+D macro

[Amit Gandhi]

Thanks Prince

On Tue, Jul 3, 2012 at 10:08 PM, Prince Dubey wrote:

> Hi Amit,
>
> Please see the attachment.
>
> regards
> Prince Dubey.
>
> On Tuesday, 3 July 2012 13:35:23 UTC+5:30, Mitr wrote:
>>
>> Hi Experts
>>
>> I want to copy formula of cell D6 to D7 to D8 upto D20 using macro in
>> attached file.
>>
>> Pls help me providing this macro code.
>>
>> Regards
>>
>> Amit
>>
>>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ CTRL+D macro

[Amit Gandhi]

Thanks Ashish

Its perfectly working.

On Tue, Jul 3, 2012 at 7:43 PM, ashish koul  wrote:

> Sub sample()
> Sheets("Sheet1").Range("d4:d20").FillDown
> End Sub
>
>
>
> On Tue, Jul 3, 2012 at 1:35 PM, Amit Gandhi  wrote:
>
>> Hi Experts
>>
>> I want to copy formula of cell D6 to D7 to D8 upto D20 using macro in
>> attached file.
>>
>> Pls help me providing this macro code.
>>
>> Regards
>>
>> Amit
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *http://www.excelvbamacros.com/*
> *http://www.accessvbamacros.com/* <http://www.accessvbamacros.com/>
>
>
> P Before printing, think about the environment.
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

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

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

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

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

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

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

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

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

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

$$Excel-Macros$$ CTRL+D macro

[Amit Gandhi]

Hi Experts

I want to copy formula of cell D6 to D7 to D8 upto D20 using macro in
attached file.

Pls help me providing this macro code.

Regards

Amit

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

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

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

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

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

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

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

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

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

CTRL+D.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ MY NEW EXCEL DASHBOARD PROJECTS

[Amit Gandhi]

Thanks Hilary

On Tue, Jun 26, 2012 at 3:37 PM, hilary lomotey  wrote:

> Hi Amit
>
> Click on the column header you want to hide, in my case column H, which
> will highlight the whole column and hold ctrl + shift + forward arrow key ,
> right click and select hide, same is true for the row headers. thanks
>
>
> On Tue, Jun 26, 2012 at 9:54 AM, Amit Gandhi  wrote:
>
>> Nice Creativity Hilary
>>
>> As I am new to these things, can I know how you Freezed Columns A to G
>> and Rows 1 to 18 (and others Column & Row headers are not showing)? How you
>> freezed scrolling thereafter?
>>
>> Regards
>>
>> Amit
>>
>>
>> On Mon, Jun 25, 2012 at 7:41 PM, hilary lomotey wrote:
>>
>>> Hello Guys
>>>
>>> i just completed my two excel projects and want to share. The first one
>>> is like an accounting system where you can enter clients information as
>>> well as transactions and post it to a database and also able to retrieve
>>> the information. Since i am not good with VBA , i used macro recording
>>> techniques to achieve these as well as of course formula's. Try it out and
>>> have fun and hope someone can improve upon it and give feedback. the pass
>>> word on the file is 'kiss"
>>> The second is a fixed income dashboard, its easy to understand when you
>>> test how it works,
>>>
>>> keep excelling cos excel is fun, have a great day.
>>>
>>> --
>>> -- FORUM RULES (986+ members already BANNED for violation) 1) Use
>>> concise, accurate thread titles. Poor thread titles, like Please Help,
>>> Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not
>>> get quick attention or may not be answered. 2) Don't post a question in the
>>> thread of another member. 3) Don't post questions regarding breaking or
>>> bypassing any security measure. 4) Acknowledge the responses you receive,
>>> good or bad. 5) Cross-promotion of, or links to, forums competitive to this
>>> forum in signatures are prohibited. NOTE : Don't ever post personal or
>>> confidential data in a workbook. Forum owners and members are not
>>> responsible for any loss.
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com To
>>> unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>>
>> --
>> 'Expecting the world to treat u fairly coz u r a good person is like
>> expecting the lion not to attack u coz u r a vegetarian.
>> Think about it.'
>>
>> Take care
>>
>> Amit
>>
>> --
>> -- FORUM RULES (986+ members already BANNED for violation) 1) Use
>> concise, accurate thread titles. Poor thread titles, like Please Help,
>> Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not
>> get quick attention or may not be answered. 2) Don't post a question in the
>> thread of another member. 3) Don't post questions regarding breaking or
>> bypassing any security measure. 4) Acknowledge the responses you receive,
>> good or bad. 5) Cross-promotion of, or links to, forums competitive to this
>> forum in signatures are prohibited. NOTE : Don't ever post personal or
>> confidential data in a workbook. Forum owners and members are not
>> responsible for any loss.
>> --
>> To post to this group, send email to excel-macros@googlegroups.com To
>> unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
>  --
> -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise,
> accurate thread titles. Poor thread titles, like Please Help, Urgent, Need
> Help, Formula Problem, Code Problem, and Need Advice will not get quick
> attention or may not be answered. 2) Don't post a question in the thread of
> another member. 3) Don't post questions regarding breaking or bypassing any
> security measure. 4) Acknowledge the responses you receive, good or bad. 5)
> Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited. NOTE : Don't ever post personal or confidential
> data in a workbook. Forum owners and members are not responsible for any
> loss.
> --
> To post to this group,

Re: $$Excel-Macros$$ MY NEW EXCEL DASHBOARD PROJECTS

[Amit Gandhi]

Nice Creativity Hilary

As I am new to these things, can I know how you Freezed Columns A to G and
Rows 1 to 18 (and others Column & Row headers are not showing)? How you
freezed scrolling thereafter?

Regards

Amit


On Mon, Jun 25, 2012 at 7:41 PM, hilary lomotey  wrote:

> Hello Guys
>
> i just completed my two excel projects and want to share. The first one is
> like an accounting system where you can enter clients information as well
> as transactions and post it to a database and also able to retrieve the
> information. Since i am not good with VBA , i used macro recording
> techniques to achieve these as well as of course formula's. Try it out and
> have fun and hope someone can improve upon it and give feedback. the pass
> word on the file is 'kiss"
> The second is a fixed income dashboard, its easy to understand when you
> test how it works,
>
> keep excelling cos excel is fun, have a great day.
>
> --
> -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise,
> accurate thread titles. Poor thread titles, like Please Help, Urgent, Need
> Help, Formula Problem, Code Problem, and Need Advice will not get quick
> attention or may not be answered. 2) Don't post a question in the thread of
> another member. 3) Don't post questions regarding breaking or bypassing any
> security measure. 4) Acknowledge the responses you receive, good or bad. 5)
> Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited. NOTE : Don't ever post personal or confidential
> data in a workbook. Forum owners and members are not responsible for any
> loss.
> --
> To post to this group, send email to excel-macros@googlegroups.com To
> unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

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

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

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

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

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

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

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

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

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

$$Excel-Macros$$ Run Macro at OPEN of an Excel file

[Amit Gandhi]

Hi Experts

Pls help me with a way, so that a Macro runs whenever I open a particular
excel file. (Macro is in that excel file only).


Regards

Amit

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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ VLOOKUP OR SUMPRODUCT FORMULA HELP

[Amit Gandhi]

Thanks alot Mr. Rajan

This function is Perfectly as per my requirement.

Thanks once again

Amit Gandhi


On Sat, Jun 23, 2012 at 6:45 PM, Rajan_Verma wrote:

> HI Amit,
>
> ** **
>
> This function can work independently, you just need to understand the
> function Arguments :
>
> *Function* GetTotal(rngLookUpRange, rngMapping As Range, rngLookup As
> Range, lngCOlumnresult As Long, lngMinusValue As Double) As *Double*
>
> rngLookUpRange = it is a value you want to look in table1
>
> rngMapping  =  Select whole Table1
>
> rngLookup  =select the Table2
>
> lngCOlumnresult = Which column you want to Sum from Table2
>
> lngMinusValue   = If you want to minus any value from the result formula
> at every iteration
>
> ** **
>
> so if you are increasing column in table2 you also need to increase
> lngCOlumnresult value in the formula 
>
> ** **
>
> use the below function  in *J15*:
>
> =GetTotal(G15,$A$8:$B$18,$F$4:$I$9,4,0)
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Amit Gandhi
> *Sent:* 23 June 2012 5:19
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ VLOOKUP OR SUMPRODUCT FORMULA HELP
>
> ** **
>
> Thanks Mr. Rajan
>
> ** **
>
> For given set of values, its working perfectly. But I have some questions.
> 
>
> ** **
>
> 1. If values in H5:H9 are changed, then it doesn't give correct result.***
> *
>
> ** **
>
> Pls suggest function, which can work independently and doesn't depend on
> adjacent column. I am attaching modified task file for your quick reference.
> 
>
> ** **
>
> It will be a great help if you can suggest formula with inbuilt functions
> (INDIRECT, MATCH, SUMPRODUCT) as well.
>
> ** **
>
> Regards
>
> ** **
>
> Amit
>
> ** **
>
> On Sat, Jun 23, 2012 at 1:38 PM, Rajan_Verma 
> wrote:
>
> Hi Amit,
>
>  
>
> It will fulfil your requirement . J , See the attached.
>
>  
>
> *Function* GetTotal(rngLookUpRange, rngMapping As Range, rngLookup As
> Range, lngCOlumnresult As Long, lngMinusValue As Double) As *Double*
>
> 
>
> Dim VarMapping
>
> Dim VarLookup
>
> Dim strLookUp
>
> *Dim lngResult  As Double*
>
> Dim lngCounter As Long
>
> Dim StrLookupValue As String
>
> 
>
> VarMapping = rngMapping
>
> VarLookup = rngLookup
>
> StrLookupValue = rngLookUpRange.Value
>
> 
>
> strLookUp = ""
>
>For lngCounter = LBound(VarMapping) To UBound(VarMapping)
>
> If VarMapping(lngCounter, 1) = StrLookupValue Then
>
> strLookUp = strLookUp & VarMapping(lngCounter, 2) & "|"
>
> End If
>
> Next lngCounter
>
> 
>
> For lngCounter = LBound(VarLookup) To UBound(VarLookup)
>
> If InStr(strLookUp, VarLookup(lngCounter, 1)) Then
>
> lngResult = lngResult + VarLookup(lngCounter, lngCOlumnresult)
> - lngMinusValue
>
> End If
>
> Next lngCounter
>
> GetTotal = lngResult
>
> 
>
> End Function
>
>  
>
> * *
>
> * *
>
> *Revert if it is not desired *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Amit Gandhi
> *Sent:* 22 June 2012 5:20
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ VLOOKUP OR SUMPRODUCT FORMULA HELP
>
>  
>
> Hi Experts
>
>  
>
> I have two Input/Lookup tables, and 1 result table. I want a formula which
> can give me desired result instantly. Sample file is attached for your
> ready reference.
>
>  
>
> How it will be possible? Pls help me here.
>
>  
>
> Regards
>
>  
>
> Amit
>
>  
>
> --
> -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise,
> accurate thread titles. Poor thread titles, like Please Help, Urgent, Need
> Help, Formula Problem, Code Problem, and Need Advice will not get quick
> attention or may not be answered. 2) Don't post a question in the thread of
> another m

Re: $$Excel-Macros$$ VLOOKUP OR SUMPRODUCT FORMULA HELP

[Amit Gandhi]

Thanks Mr. Rajan

For given set of values, its working perfectly. But I have some questions.

1. If values in H5:H9 are changed, then it doesn't give correct result.

Pls suggest function, which can work independently and doesn't depend on
adjacent column. I am attaching modified task file for your quick reference.

It will be a great help if you can suggest formula with inbuilt functions
(INDIRECT, MATCH, SUMPRODUCT) as well.

Regards

Amit


On Sat, Jun 23, 2012 at 1:38 PM, Rajan_Verma wrote:

> Hi Amit,
>
> ** **
>
> It will fulfil your requirement . J , See the attached.
>
> ** **
>
> *Function* GetTotal(rngLookUpRange, rngMapping As Range, rngLookup As
> Range, lngCOlumnresult As Long, lngMinusValue As Double) As *Double*
>
> 
>
> Dim VarMapping
>
> Dim VarLookup
>
> Dim strLookUp
>
> *Dim lngResult  As Double*
>
> Dim lngCounter As Long
>
> Dim StrLookupValue As String
>
> 
>
> VarMapping = rngMapping
>
> VarLookup = rngLookup
>
> StrLookupValue = rngLookUpRange.Value
>
> 
>
> strLookUp = ""
>
>For lngCounter = LBound(VarMapping) To UBound(VarMapping)
>
> If VarMapping(lngCounter, 1) = StrLookupValue Then
>
> strLookUp = strLookUp & VarMapping(lngCounter, 2) & "|"
>
> End If
>
> Next lngCounter
>
> 
>
> For lngCounter = LBound(VarLookup) To UBound(VarLookup)
>
> If InStr(strLookUp, VarLookup(lngCounter, 1)) Then
>
> lngResult = lngResult + VarLookup(lngCounter, lngCOlumnresult)
> - lngMinusValue
>
> End If
>
> Next lngCounter
>
> GetTotal = lngResult
>
> 
>
> End Function
>
> ** **
>
> * *
>
> * *
>
> *Revert if it is not desired *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Amit Gandhi
> *Sent:* 22 June 2012 5:20
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ VLOOKUP OR SUMPRODUCT FORMULA HELP
>
> ** **
>
> Hi Experts
>
> ** **
>
> I have two Input/Lookup tables, and 1 result table. I want a formula which
> can give me desired result instantly. Sample file is attached for your
> ready reference.
>
> ** **
>
> How it will be possible? Pls help me here.
>
> ** **
>
> Regards
>
> ** **
>
> Amit
>
> ** **
>
> --
> -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise,
> accurate thread titles. Poor thread titles, like Please Help, Urgent, Need
> Help, Formula Problem, Code Problem, and Need Advice will not get quick
> attention or may not be answered. 2) Don't post a question in the thread of
> another member. 3) Don't post questions regarding breaking or bypassing any
> security measure. 4) Acknowledge the responses you receive, good or bad. 5)
> Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited. NOTE : Don't ever post personal or confidential
> data in a workbook. Forum owners and members are not responsible for any
> loss.
> --
> To post to this group, send email to excel-macros@googlegroups.com To
> unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com 
>
> --
> -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise,
> accurate thread titles. Poor thread titles, like Please Help, Urgent, Need
> Help, Formula Problem, Code Problem, and Need Advice will not get quick
> attention or may not be answered. 2) Don't post a question in the thread of
> another member. 3) Don't post questions regarding breaking or bypassing any
> security measure. 4) Acknowledge the responses you receive, good or bad. 5)
> Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited. NOTE : Don't ever post personal or confidential
> data in a workbook. Forum owners and members are not responsible for any
> loss.
> --
> To post to this group, send email to excel-macros@googlegroups.com To
> unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
'Expecting the world to treat u fairly coz u r a good person is like
ex

Re: $$Excel-Macros$$ VLOOKUP OR SUMPRODUCT FORMULA HELP

[Amit Gandhi]

Hi Rajan

no counts are calculated, Input table 2 is manual feeded table. In result
table I want TOTAL of values in column G and/or H against each "BL#_MAWB#"
against each "Invoice#".

Regards

Amit

On Fri, Jun 22, 2012 at 6:09 PM, Rajan_Verma wrote:

> One instant question:
>
> ** **
>
> How is counts Calculated in Input table 2?
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Amit Gandhi
> *Sent:* 22 June 2012 5:20
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ VLOOKUP OR SUMPRODUCT FORMULA HELP
>
> ** **
>
> Hi Experts
>
> ** **
>
> I have two Input/Lookup tables, and 1 result table. I want a formula which
> can give me desired result instantly. Sample file is attached for your
> ready reference.
>
> ** **
>
> How it will be possible? Pls help me here.
>
> ** **
>
> Regards
>
> ** **
>
> Amit
>
> ** **
>
> --
> -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise,
> accurate thread titles. Poor thread titles, like Please Help, Urgent, Need
> Help, Formula Problem, Code Problem, and Need Advice will not get quick
> attention or may not be answered. 2) Don't post a question in the thread of
> another member. 3) Don't post questions regarding breaking or bypassing any
> security measure. 4) Acknowledge the responses you receive, good or bad. 5)
> Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited. NOTE : Don't ever post personal or confidential
> data in a workbook. Forum owners and members are not responsible for any
> loss.
> --
> To post to this group, send email to excel-macros@googlegroups.com To
> unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com 
>
> --
> -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise,
> accurate thread titles. Poor thread titles, like Please Help, Urgent, Need
> Help, Formula Problem, Code Problem, and Need Advice will not get quick
> attention or may not be answered. 2) Don't post a question in the thread of
> another member. 3) Don't post questions regarding breaking or bypassing any
> security measure. 4) Acknowledge the responses you receive, good or bad. 5)
> Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited. NOTE : Don't ever post personal or confidential
> data in a workbook. Forum owners and members are not responsible for any
> loss.
> --
> To post to this group, send email to excel-macros@googlegroups.com To
> unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

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

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

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

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

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

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

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

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

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

$$Excel-Macros$$ VLOOKUP OR SUMPRODUCT FORMULA HELP

[Amit Gandhi]

Hi Experts

I have two Input/Lookup tables, and 1 result table. I want a formula which
can give me desired result instantly. Sample file is attached for your
ready reference.

How it will be possible? Pls help me here.

Regards

Amit

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

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

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

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

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

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

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

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

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




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

Re: $$Excel-Macros$$ VLOOKUP IN MULTIPLE OCCURRENCES

[Amit Gandhi]

thanks Mr Pandey

On Sat, Jun 9, 2012 at 3:03 PM, Dilip Pandey  wrote:

> Hi Amit,
>
> See the attached file where I have used Index & Match function in
> combination with Row n Arrays to achieve the desired result.  Thanks.
>
> Regards,
> DILIPandey
>
> On 6/9/12, Amit Gandhi  wrote:
> > Hi Experts
> >
> > I want to Lookup PO No. from Lookup data and return all results if there
> > are multiple occurrences.
> >
> > How it will be possible? Pls help me here.
> >
> > Regards
> >
> > Amit
> >
> > --
> > FORUM RULES (986+ members already BANNED for violation)
> >
> > 1) Use concise, accurate thread titles. Poor thread titles, like Please
> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will
> > not get quick attention or may not be answered.
> >
> > 2) Don't post a question in the thread of another member.
> >
> > 3) Don't post questions regarding breaking or bypassing any security
> > measure.
> >
> > 4) Acknowledge the responses you receive, good or bad.
> >
> > 5)  Cross-promotion of, or links to, forums competitive to this forum in
> > signatures are prohibited.
> >
> > NOTE  : Don't ever post personal or confidential data in a workbook.
> Forum
> > owners and members are not responsible for any loss.
> >
> >
> --
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> > To unsubscribe, send a blank email to
> > excel-macros+unsubscr...@googlegroups.com
>
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY, mvp
>   MBA,B.Com(Hons),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 62, India
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

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

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

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

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

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

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

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

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

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

$$Excel-Macros$$ VLOOKUP IN MULTIPLE OCCURRENCES

[Amit Gandhi]

Hi Experts

I want to Lookup PO No. from Lookup data and return all results if there
are multiple occurrences.

How it will be possible? Pls help me here.

Regards

Amit

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

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

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

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

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

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

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

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

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

VLOOKUP MULTIPLE OCCURRENCE.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ How to pick values from particular table/list

[Amit Gandhi]

thanks

On Wed, May 30, 2012 at 1:20 AM, Bé Trần Văn wrote:

>
>
> 2012/5/29 NOORAIN ANSARI 
>
>> Dear Amit,
>>
>> Please See attached sheet, I hope your requirement is this one otherwise
>> revert.
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> www.noorainansari.com
>> www.excelmacroworld.blogspot.com
>>
>>  On Tue, May 29, 2012 at 12:48 PM, Amit Gandhi wrote:
>>
>>> Thanks Noorain
>>>
>>> But i need something else. Let me clarify more. I am attaching revised
>>> excel file.
>>>
>>> I have some BL numbers in 2nd sheet "BL_list" and I want to enter
>>> Invoice details (INV#, INV DATE, INV AMT) against some B/L#s. I want to
>>> choose B/L# in each cell C5, C6, C7 ... from available list in 2nd
>>> sheet "BL_list", column A and then fill in corresponding Invoice details
>>> against this.
>>>
>>> If its possible in Excel?
>>>
>>> Pls help me here.
>>>
>>> Regards
>>>
>>> Amit
>>>
>>>
>>> On Tue, May 29, 2012 at 12:03 PM, NOORAIN ANSARI <
>>> noorain.ans...@gmail.com> wrote:
>>>
>>>> Dear Amit,
>>>>
>>>> You can use it..
>>>>
>>>> *=INDIRECT(ADDRESS(9+ROW(A3),12))*
>>>> See attached sheet
>>>>
>>>> Hope it will help to you.
>>>>
>>>>
>>>> --
>>>> Thanks & regards,
>>>> Noorain Ansari
>>>> www.noorainansari.com
>>>> www.excelmacroworld.blogspot.com
>>>>
>>>>  On Tue, May 29, 2012 at 11:18 AM, Amit Gandhi wrote:
>>>>
>>>>> Hi Experts
>>>>>
>>>>> I want to pick value in Cell C7, C8, C9 ………from List given in
>>>>> Column "L" in attached file.
>>>>>
>>>>> How it will be possible? Pls help me here.
>>>>>
>>>>> Regards
>>>>>
>>>>> Amit
>>>>>
>>>>>
>>>>> --
>>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>>
>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>> Advice will not get quick attention or may not be answered.
>>>>>
>>>>> 2) Don't post a question in the thread of another member.
>>>>>
>>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>>> measure.
>>>>>
>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>>
>>>>> 5) Cross-promotion of, or links to, forums competitive to this forum
>>>>> in signatures are prohibited.
>>>>>
>>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>>> Forum owners and members are not responsible for any loss.
>>>>>
>>>>>
>>>>> --
>>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>>
>>>>> To unsubscribe, send a blank email to
>>>>> excel-macros+unsubscr...@googlegroups.com
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>>
>>>> 2) Don't post a question in the thread of another member.
>>>>
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>>
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>
>>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>>> signatures are prohibited.
>>>>
>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>> Forum owners and members are not responsible for any loss.
>>>>
>>>>
>>>>

Re: $$Excel-Macros$$ How to pick values from particular table/list

[Amit Gandhi]

Thanks Noorain

On Tue, May 29, 2012 at 3:36 PM, NOORAIN ANSARI wrote:

> Dear Amit,
>
> Please See attached sheet, I hope your requirement is this one otherwise
> revert.
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Tue, May 29, 2012 at 12:48 PM, Amit Gandhi wrote:
>
>> Thanks Noorain
>>
>> But i need something else. Let me clarify more. I am attaching revised
>> excel file.
>>
>> I have some BL numbers in 2nd sheet "BL_list" and I want to enter Invoice
>> details (INV#, INV DATE, INV AMT) against some B/L#s. I want to choose B/L#
>> in each cell C5, C6, C7 ... from available list in 2nd sheet "BL_list",
>> column A and then fill in corresponding Invoice details against this.
>>
>> If its possible in Excel?
>>
>> Pls help me here.
>>
>> Regards
>>
>> Amit
>>
>>
>> On Tue, May 29, 2012 at 12:03 PM, NOORAIN ANSARI <
>> noorain.ans...@gmail.com> wrote:
>>
>>> Dear Amit,
>>>
>>> You can use it..
>>>
>>> *=INDIRECT(ADDRESS(9+ROW(A3),12))*
>>> See attached sheet
>>>
>>> Hope it will help to you.
>>>
>>>
>>> --
>>> Thanks & regards,
>>> Noorain Ansari
>>> www.noorainansari.com
>>> www.excelmacroworld.blogspot.com
>>>
>>> On Tue, May 29, 2012 at 11:18 AM, Amit Gandhi wrote:
>>>
>>>> Hi Experts
>>>>
>>>> I want to pick value in Cell C7, C8, C9 ………from List given in
>>>> Column "L" in attached file.
>>>>
>>>> How it will be possible? Pls help me here.
>>>>
>>>> Regards
>>>>
>>>> Amit
>>>>
>>>>
>>>>  --
>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>>
>>>> 2) Don't post a question in the thread of another member.
>>>>
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>>
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>
>>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>>> signatures are prohibited.
>>>>
>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>> Forum owners and members are not responsible for any loss.
>>>>
>>>>
>>>> --
>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>
>>>> To unsubscribe, send a blank email to
>>>> excel-macros+unsubscr...@googlegroups.com
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>  --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>>
>>
>>
>>
>> --
>> 'Expecting the world to treat u fairly coz u r a good person is like
>> expecting the lion not to attack u coz u r a vegetarian.
>> Think about it.'
>>
&

Re: $$Excel-Macros$$ How to pick values from particular table/list

[Amit Gandhi]

Thanks Noorain

But i need something else. Let me clarify more. I am attaching revised
excel file.

I have some BL numbers in 2nd sheet "BL_list" and I want to enter Invoice
details (INV#, INV DATE, INV AMT) against some B/L#s. I want to choose B/L#
in each cell C5, C6, C7 ... from available list in 2nd sheet "BL_list",
column A and then fill in corresponding Invoice details against this.

If its possible in Excel?

Pls help me here.

Regards

Amit


On Tue, May 29, 2012 at 12:03 PM, NOORAIN ANSARI
wrote:

> Dear Amit,
>
> You can use it..
>
> *=INDIRECT(ADDRESS(9+ROW(A3),12))*
> See attached sheet
>
> Hope it will help to you.
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Tue, May 29, 2012 at 11:18 AM, Amit Gandhi wrote:
>
>> Hi Experts
>>
>> I want to pick value in Cell C7, C8, C9 ………from List given in Column
>> "L" in attached file.
>>
>> How it will be possible? Pls help me here.
>>
>> Regards
>>
>> Amit
>>
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
>
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

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

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

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

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

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

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

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

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

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

PICKING DATA IN EACH CELL.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ How to pick values from particular table/list

[Amit Gandhi]

Hi Mr. Anil

This is not the solution i am looking for. I need to pick this from some
LIST for every cell.

Regards

Amit


On Tue, May 29, 2012 at 11:41 AM, Anil Gawli wrote:

> see the attached sheet
> Regards
> Gawli Anil
>
> On Tue, May 29, 2012 at 11:18 AM, Amit Gandhi wrote:
>
>> Hi Experts
>>
>> I want to pick value in Cell C7, C8, C9 ………from List given in Column
>> "L" in attached file.
>>
>> How it will be possible? Pls help me here.
>>
>> Regards
>>
>> Amit
>>
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
> --
> Thanks & Regards,
> Gawli Anil Narayan
> Software Developer,
> Abacus Software Services Pvt Ltd
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

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

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

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

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

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

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

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

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

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

$$Excel-Macros$$ How to pick values from particular table/list

[Amit Gandhi]

Hi Experts

I want to pick value in Cell C7, C8, C9 ………from List given in Column
"L" in attached file.

How it will be possible? Pls help me here.

Regards

Amit

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

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

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

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

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

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

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

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

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

PICKING DATA IN EACH CELL.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Vlookup is not working

[Amit Gandhi]

Thanks Jay, for wonderful example.


On Thu, May 24, 2012 at 6:03 PM, Jai  wrote:

> please see the attachment
>
>
> On Thu, May 24, 2012 at 6:01 PM, Amit Gandhi  wrote:
>
>> thanks sir
>>
>> On Wed, May 23, 2012 at 6:00 PM, dguillett1  wrote:
>>
>>>   Also, please do not use entire columns. Restrict to only area needed.
>>>
>>> =VLOOKUP(E3,Sheet1!E1:G100,3,FALSE)
>>>
>>> Don Guillett
>>> Microsoft MVP Excel
>>> SalesAid Software
>>> dguille...@gmail.com
>>>
>>>  *From:* Paul Schreiner 
>>> *Sent:* Wednesday, May 23, 2012 7:06 AM
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* Re: $$Excel-Macros$$ Vlookup is not working
>>>
>>>First of all, no need to yell: (VLOOKUP IS NOT WORKING)
>>>
>>> Second:
>>> Vlookup has 4 parts:
>>> lookup_value,
>>> table_array,
>>> col_index_num,
>>> range_lookup
>>>
>>> Vlookup will look in the FIRST column of the "table_array" for a value
>>> that matches the "lookup_value"
>>>
>>> since your lookup value is found in column E of sheet 1, your
>>> table_array should be Sheet1!E:G not Sheet1!B:G
>>>
>>> so, the formula in cell G3 should be: =VLOOKUP(E3,Sheet1!E:G,3,FALSE)
>>>
>>> hope this helps
>>>
>>>
>>> *Paul*
>>>
>>> -
>>> *“Do all the good you can,
>>> By all the means you can,
>>> In all the ways you can,
>>> In all the places you can,
>>> At all the times you can,
>>> To all the people you can,
>>> As long as ever you can.” - John Wesley
>>> *-
>>>
>>>
>>>  --
>>> *From:* Amit Gandhi 
>>> *To:* excel-macros@googlegroups.com
>>> *Sent:* Wed, May 23, 2012 7:48:26 AM
>>> *Subject:* $$Excel-Macros$$ VLLOKUP IS NOT WORKING
>>>
>>>  Hi Experts
>>>>
>>>>
>>>>  VLOOKUP is not working in attached file, can anyone help me why its
>>>> not working and what will be right formula?
>>>>
>>>> Pls help me here.
>>>>
>>>> Regards
>>>>
>>>> Amit
>>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group

Re: $$Excel-Macros$$ How to distribute one value into different cells proportionately based on some conditions

[Amit Gandhi]

thanks

On Thu, May 24, 2012 at 5:50 PM, sreenivas kammari
wrote:

> use this formula:
>
> =VLOOKUP(E3,Sheet1!E:G,3,0).
>
> On Thu, May 24, 2012 at 4:09 PM, vijayajith VA 
> wrote:
> > Hi
> > Try ths
> > =VLOOKUP(E3,Sheet1!E3:G20,3,FALSE)
> >
> >
> > On Wed, May 23, 2012 at 5:16 PM, Amit Gandhi 
> wrote:
> >>>
> >>> Hi Experts
> >>>
> >>>
> >>> VLOOKUP is not working in attached file, can anyone help me why its not
> >>> working and what will be right formula?
> >>>
> >>> Pls help me here.
> >>>
> >>> Regards
> >>>
> >>> Amit
> >>>
> >>> --
> >>> FORUM RULES (986+ members already BANNED for violation)
> >>>
> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will
> >>> not get quick attention or may not be answered.
> >>>
> >>> 2) Don't post a question in the thread of another member.
> >>>
> >>> 3) Don't post questions regarding breaking or bypassing any security
> >>> measure.
> >>>
> >>> 4) Acknowledge the responses you receive, good or bad.
> >>>
> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in
> >>> signatures are prohibited.
> >>>
> >>> NOTE : Don't ever post personal or confidential data in a workbook.
> Forum
> >>> owners and members are not responsible for any loss.
> >>>
> >>>
> >>>
> --
> >>> To post to this group, send email to excel-macros@googlegroups.com
> >>>
> >>> To unsubscribe, send a blank email to
> >>> excel-macros+unsubscr...@googlegroups.com
> >>
> >>
> >>
> >>
> >> --
> >> FORUM RULES (986+ members already BANNED for violation)
> >>
> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will
> >> not get quick attention or may not be answered.
> >>
> >> 2) Don't post a question in the thread of another member.
> >>
> >> 3) Don't post questions regarding breaking or bypassing any security
> >> measure.
> >>
> >> 4) Acknowledge the responses you receive, good or bad.
> >>
> >> 5) Cross-promotion of, or links to, forums competitive to this forum in
> >> signatures are prohibited.
> >>
> >> NOTE : Don't ever post personal or confidential data in a workbook.
> Forum
> >> owners and members are not responsible for any loss.
> >>
> >>
> >>
> --
> >> To post to this group, send email to excel-macros@googlegroups.com
> >>
> >> To unsubscribe, send a blank email to
> >> excel-macros+unsubscr...@googlegroups.com
> >
> >
> > --
> > FORUM RULES (986+ members already BANNED for violation)
> >
> > 1) Use concise, accurate thread titles. Poor thread titles, like Please
> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will
> > not get quick attention or may not be answered.
> >
> > 2) Don't post a question in the thread of another member.
> >
> > 3) Don't post questions regarding breaking or bypassing any security
> > measure.
> >
> > 4) Acknowledge the responses you receive, good or bad.
> >
> > 5) Cross-promotion of, or links to, forums competitive to this forum in
> > signatures are prohibited.
> >
> > NOTE : Don't ever post personal or confidential data in a workbook. Forum
> > owners and members are not responsible for any loss.
> >
> >
> --
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> > To unsubscribe, send a blank email to
> > excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
&g

Re: $$Excel-Macros$$ How to distribute one value into different cells proportionately based on some conditions

[Amit Gandhi]

thanks

On Thu, May 24, 2012 at 4:09 PM, vijayajith VA wrote:

> Hi
> Try ths
> =VLOOKUP(E3,Sheet1!E3:G20,3,FALSE)
>
>
> On Wed, May 23, 2012 at 5:16 PM, Amit Gandhi  wrote:
>
>> Hi Experts
>>>
>>>
>>> VLOOKUP is not working in attached file, can anyone help me why its not
>>> working and what will be right formula?
>>>
>>> Pls help me here.
>>>
>>> Regards
>>>
>>> Amit
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>>
>>
>>
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Vlookup is not working

[Amit Gandhi]

thanks sir

On Wed, May 23, 2012 at 6:00 PM, dguillett1  wrote:

>   Also, please do not use entire columns. Restrict to only area needed.
>
> =VLOOKUP(E3,Sheet1!E1:G100,3,FALSE)
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Paul Schreiner 
> *Sent:* Wednesday, May 23, 2012 7:06 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Vlookup is not working
>
>   First of all, no need to yell: (VLOOKUP IS NOT WORKING)
>
> Second:
> Vlookup has 4 parts:
> lookup_value,
> table_array,
> col_index_num,
> range_lookup
>
> Vlookup will look in the FIRST column of the "table_array" for a value
> that matches the "lookup_value"
>
> since your lookup value is found in column E of sheet 1, your table_array
> should be Sheet1!E:G not Sheet1!B:G
>
> so, the formula in cell G3 should be: =VLOOKUP(E3,Sheet1!E:G,3,FALSE)
>
> hope this helps
>
>
> *Paul*
>
> -
> *“Do all the good you can,
> By all the means you can,
> In all the ways you can,
> In all the places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> *-
>
>
>  --
> *From:* Amit Gandhi 
> *To:* excel-macros@googlegroups.com
> *Sent:* Wed, May 23, 2012 7:48:26 AM
> *Subject:* $$Excel-Macros$$ VLLOKUP IS NOT WORKING
>
>  Hi Experts
>>
>>
>>  VLOOKUP is not working in attached file, can anyone help me why its not
>> working and what will be right formula?
>>
>> Pls help me here.
>>
>> Regards
>>
>> Amit
>>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, s

Re: $$Excel-Macros$$ Vlookup is not working

[Amit Gandhi]

Thanks Mr. Paul

Got the point.



On Wed, May 23, 2012 at 5:36 PM, Paul Schreiner wrote:

> First of all, no need to yell: (VLOOKUP IS NOT WORKING)
>
> Second:
> Vlookup has 4 parts:
> lookup_value,
> table_array,
> col_index_num,
> range_lookup
>
> Vlookup will look in the FIRST column of the "table_array" for a value
> that matches the "lookup_value"
>
> since your lookup value is found in column E of sheet 1, your table_array
> should be Sheet1!E:G not Sheet1!B:G
>
> so, the formula in cell G3 should be: =VLOOKUP(E3,Sheet1!E:G,3,FALSE)
>
> hope this helps
>
>
> *Paul*
>
> -
> *“Do all the good you can,
> By all the means you can,
> In all the ways you can,
> In all the places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> *-
>
>
>  --
> *From:* Amit Gandhi 
> *To:* excel-macros@googlegroups.com
> *Sent:* Wed, May 23, 2012 7:48:26 AM
> *Subject:* $$Excel-Macros$$ VLLOKUP IS NOT WORKING
>
>  Hi Experts
>>
>>
>>  VLOOKUP is not working in attached file, can anyone help me why its not
>> working and what will be right formula?
>>
>> Pls help me here.
>>
>> Regards
>>
>> Amit
>>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ VLLOKUP IS NOT WORKING

[Amit Gandhi]

Thanks Mr. Noorain

Got the point.


On Wed, May 23, 2012 at 5:48 PM, NOORAIN ANSARI wrote:

> Dear Amit,
>
> Your Formula is correct only change Range...
> Table Array(range) will start from Column No. E.
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Wed, May 23, 2012 at 5:18 PM, Amit Gandhi  wrote:
>
>> Hi Experts
>>>
>>>
>>> VLOOKUP is not working in attached file, can anyone help me why its not
>>> working and what will be right formula?
>>>
>>> Pls help me here.
>>>
>>> Regards
>>>
>>> Amit
>>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
>
>
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ VLLOKUP IS NOT WORKING

[Amit Gandhi]

Thanks Mr. Lakshman.

On Wed, May 23, 2012 at 5:37 PM, LAKSHMAN PRASAD wrote:

> see the  attached file
>
>
>
>   *From:* Amit Gandhi 
> *To:* excel-macros@googlegroups.com
> *Sent:* Wednesday, May 23, 2012 5:18 PM
> *Subject:* $$Excel-Macros$$ VLLOKUP IS NOT WORKING
>
>   Hi Experts
>
>
>  VLOOKUP is not working in attached file, can anyone help me why its not
> working and what will be right formula?
>
> Pls help me here.
>
> Regards
>
> Amit
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

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

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

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

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

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

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

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

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

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

$$Excel-Macros$$ VLLOKUP IS NOT WORKING

[Amit Gandhi]

>
> Hi Experts
>
>
> VLOOKUP is not working in attached file, can anyone help me why its not
> working and what will be right formula?
>
> Pls help me here.
>
> Regards
>
> Amit
>

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

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

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

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

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

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

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

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

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

VLOOKUP NOT WORKING.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ How to distribute one value into different cells proportionately based on some conditions

[Amit Gandhi]

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

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

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

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

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

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

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

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

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

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

VLOOKUP NOT WORKING.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ How to distribute one value into different cells proportionately based on some conditions

[Amit Gandhi]

Thanks Mr. Haseeb

Perfect solution.

Thanks a lot.

Amit


On Tue, May 22, 2012 at 11:06 PM, Haseeb A wrote:

> Hello Amit,
>
> Keep PO Bill & Party Bill on different tab, so can easily update it. See
> the attached.
>
> Addition: If you use Table format, formula will automatically insert, when
> you enter a new data. Or use dynamic range to limit calculation range. If
> you wish, you can also create a validation list of Party Bill's then apply
> those in PO Bills column, this way can avoid unnecessary bill numbers.
>
> Hope this helps,
> Haseeb
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ How to distribute one value into different cells proportionately based on some conditions

[Amit Gandhi]

Thanks Mr. Anil

You have almost solved my query. But I need it more dynamic. You have made
this formula cell specific and I need the formula which I can copy & paste
across all rows and it will give me result in one instant. Say for example,
if I will add same B/L no again at row 21, i won't get the result. Even if
I will copy the formula of cell J12 to cell J13, it won't work.

Hope you understand my requirement.

I will wait for your expert advise.

Thanks in advance.

Regards

Amit


On Tue, May 22, 2012 at 12:05 PM, Anil Gawli wrote:

> Pls Find Attached file
>
> On Tue, May 22, 2012 at 11:41 AM, Amit Gandhi wrote:
>
>> Hi Experts
>>
>>
>>  I am finding some problem in excel formula, pls help me here. I have a
>> excel data at two locations, 1st is Supplier's Bill details and 2nd is
>> Purchase order details. I need a formula that can distribute the "Party
>> Bill Amount" figure proportionately to "PO Amount" figures based on "B/L#"
>> . You can look into attached Sample File for better understanding. In that
>> file I have shown the result what I want in column "I".
>>
>> Pls help me here.
>>
>> Regards
>>
>> Amit
>>
>>
>>
>>  On Mon, May 21, 2012 at 4:47 PM, Amit Gandhi wrote:
>>
>>> Hi Experts
>>>
>>>
>>>  I am finding some problem in excel formula, pls help me here. I have a
>>> excel data at two locations, 1st is Supplier's Bill details and 2nd is
>>> Purchase order details. I need a formula that can distribute the "Party
>>> Bill Amount" figure proportionately to "PO Amount" figures based on "B/L#"
>>> . You can look into attached Sample File for better understanding. In that
>>> file I have shown the result what I want in column "I".
>>>
>>> Pls help me here.
>>>
>>> Regards
>>>
>>> Amit
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>>
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
>
>
> --
> Thanks & Regards,
> Gawli Anil Narayan
> Software Developer,
> Abacus Software Services Pvt Ltd
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
&g

Re: $$Excel-Macros$$ How to distribute one value into different cells proportionately based on some conditions

[Amit Gandhi]

Hi Experts


I am finding some problem in excel formula, pls help me here. I have a
excel data at two locations, 1st is Supplier's Bill details and 2nd is
Purchase order details. I need a formula that can distribute the "Party
Bill Amount" figure proportionately to "PO Amount" figures based on "B/L#"
. You can look into attached Sample File for better understanding. In that
file I have shown the result what I want in column "I".

Pls help me here.

Regards

Amit



On Mon, May 21, 2012 at 4:47 PM, Amit Gandhi  wrote:

> Hi Experts
>
>
> I am finding some problem in excel formula, pls help me here. I have a
> excel data at two locations, 1st is Supplier's Bill details and 2nd is
> Purchase order details. I need a formula that can distribute the "Party
> Bill Amount" figure proportionately to "PO Amount" figures based on "B/L#"
> . You can look into attached Sample File for better understanding. In that
> file I have shown the result what I want in column "I".
>
> Pls help me here.
>
> Regards
>
> Amit
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

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

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

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

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

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

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

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

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

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

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

$$Excel-Macros$$ How to distribute one value into different cells proportionately based on some conditions

[Amit Gandhi]

Hi Experts


I am finding some problem in excel formula, pls help me here. I have a
excel data at two locations, 1st is Supplier's Bill details and 2nd is
Purchase order details. I need a formula that can distribute the "Party
Bill Amount" figure proportionately to "PO Amount" figures based on "B/L#"
. You can look into attached Sample File for better understanding. In that
file I have shown the result what I want in column "I".

Pls help me here.

Regards

Amit

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

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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Almost all calculator in one sheet

[Amit Gandhi]

very useful sheet. thanks for sharing.

On Mon, Nov 28, 2011 at 12:20 PM, NOORAIN ANSARI
wrote:

> Thanks Ankit,
>
> Very useful sheet you have shared with Group.
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
> On Mon, Nov 28, 2011 at 12:06 PM, Ankit Agrawal <
> ankit.agrawal...@gmail.com> wrote:
>
>> Hello All,
>>
>> In our daily life we calculate so many thing & use different calculator.
>> Here is one excel file which contain almost all calculator.
>>
>>
>> Calculate & enjoy !!!
>>
>>
>> Regards,
>>
>> Ankit
>>
>> --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
>
>  --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Re: Retrieving data in horizontal form

[Amit Gandhi]

Hi Sam

solution provided by chilexcel is OK, but i want to go further in full
automation using excel formulas.

Thanks

Amit


On Mon, Sep 26, 2011 at 11:49 AM, Sam Mathai Chacko wrote:

> Nicely done by Noorain.
>
> Shouldn't the solution provided by ChilExcel suffice? Pivot tables as it is
> dynamic in nature, you just need to pass the source range.
>
> Regards,
>
> Sam Mathai Chacko (GL)
>
>
> On Mon, Sep 26, 2011 at 11:40 AM, NOORAIN ANSARI  > wrote:
>
>> Dear Amit,
>>
>> Please see attached sheet..
>>
>> and use
>> *
>> =INDEX($B$4:$B$150,SMALL(IF($D$4:$D$150=1,ROW($B$4:$B$150),""),ROW(A3))-3)
>> =Offset($B$4,SMALL(IF($D$4:$D$150=1,ROW($B$4:$B$150),""),ROW(A3))-3,0)*
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>>  *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
>> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>>
>> On Mon, Sep 26, 2011 at 10:33 AM, Amit Gandhi wrote:
>>
>>> Thanks alot Noorain
>>>
>>> It works fine.
>>>
>>> But I also want to automate Column E i.e. it automatically retrieve Co
>>> Name as well. If you can help me here as well.
>>>
>>> Regards
>>>
>>> Amit
>>>
>>>
>>> On Sat, Sep 24, 2011 at 8:54 PM, NOORAIN ANSARI <
>>> noorain.ans...@gmail.com> wrote:
>>>
>>>> Dear Amit,
>>>> Please see attached sheet, hope it will help to u.
>>>>
>>>> --
>>>> Thanks & regards,
>>>> Noorain Ansari
>>>>  
>>>> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
>>>> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>>>>
>>>>   On Sat, Sep 24, 2011 at 5:31 PM, Amit Gandhi wrote:
>>>>
>>>>> Hi Folks
>>>>>
>>>>> I am finding some problem in excel data. I have a excel data (attached
>>>>> file) in vertical form. I want to convert it into Horizontal form using
>>>>> Excel Formulas.
>>>>>
>>>>> Pls help me here.
>>>>>
>>>>> Regards
>>>>>
>>>>> Amit
>>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>> --
>>> 'Expecting the world to treat u fairly coz u r a good person is like
>>> expecting the lion not to attack u coz u r a vegetarian.
>>> Think about it.'
>>>
>>> Take care
>>>
>>> Amit
>>>
>>
>>
>>  --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Sam Mathai Chacko
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Re: Retrieving data in horizontal form

[Amit Gandhi]

thanks Noorain.

On Mon, Sep 26, 2011 at 11:40 AM, NOORAIN ANSARI
wrote:

> Dear Amit,
>
> Please see attached sheet..
>
> and use
> *
> =INDEX($B$4:$B$150,SMALL(IF($D$4:$D$150=1,ROW($B$4:$B$150),""),ROW(A3))-3)
> =Offset($B$4,SMALL(IF($D$4:$D$150=1,ROW($B$4:$B$150),""),ROW(A3))-3,0)*
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
> On Mon, Sep 26, 2011 at 10:33 AM, Amit Gandhi wrote:
>
>> Thanks alot Noorain
>>
>> It works fine.
>>
>> But I also want to automate Column E i.e. it automatically retrieve Co
>> Name as well. If you can help me here as well.
>>
>> Regards
>>
>> Amit
>>
>>
>> On Sat, Sep 24, 2011 at 8:54 PM, NOORAIN ANSARI > > wrote:
>>
>>> Dear Amit,
>>> Please see attached sheet, hope it will help to u.
>>>
>>> --
>>> Thanks & regards,
>>> Noorain Ansari
>>>  
>>> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
>>> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>>>
>>>   On Sat, Sep 24, 2011 at 5:31 PM, Amit Gandhi wrote:
>>>
>>>> Hi Folks
>>>>
>>>> I am finding some problem in excel data. I have a excel data (attached
>>>> file) in vertical form. I want to convert it into Horizontal form using
>>>> Excel Formulas.
>>>>
>>>> Pls help me here.
>>>>
>>>> Regards
>>>>
>>>> Amit
>>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>> --
>> 'Expecting the world to treat u fairly coz u r a good person is like
>> expecting the lion not to attack u coz u r a vegetarian.
>> Think about it.'
>>
>> Take care
>>
>> Amit
>>
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Retrieving data in horizontal form

[Amit Gandhi]

thanks dear

On Sat, Sep 24, 2011 at 11:22 PM, ChilExcel  wrote:

> Please see attachment
>
>
> 2011/9/24 ashish koul 
>
>> try this
>>
>>
>> cell f5 =  SUMPRODUCT(($A$4:$A$150=F$3)*($B$4:$B$150=$E5)*($C$4:$C$150))
>>
>> and drag the formula right
>>
>>
>> On Sat, Sep 24, 2011 at 5:31 PM, Amit Gandhi wrote:
>>
>>> Hi Folks
>>>
>>> I am finding some problem in excel data. I have a excel data (attached
>>> file) in vertical form. I want to convert it into Horizontal form using
>>> Excel Formulas.
>>>
>>> Pls help me here.
>>>
>>> Regards
>>>
>>> Amit
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>> *http://www.excelvbamacros.com/*
>>
>>
>> P Before printing, think about the environment.
>>
>>
>>   --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Visita ; http://sites.google.com/site/chilexcel/Home
> Visita ; http://www.youtube.com/user/timextag41
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Retrieving data in horizontal form

[Amit Gandhi]

thanks.

On Sat, Sep 24, 2011 at 8:53 PM, ashish koul  wrote:

> try this
>
>
> cell f5 =  SUMPRODUCT(($A$4:$A$150=F$3)*($B$4:$B$150=$E5)*($C$4:$C$150))
>
> and drag the formula right
>
>
> On Sat, Sep 24, 2011 at 5:31 PM, Amit Gandhi  wrote:
>
>> Hi Folks
>>
>> I am finding some problem in excel data. I have a excel data (attached
>> file) in vertical form. I want to convert it into Horizontal form using
>> Excel Formulas.
>>
>> Pls help me here.
>>
>> Regards
>>
>> Amit
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *http://www.excelvbamacros.com/*
>
>
> P Before printing, think about the environment.
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Retrieving data in horizontal form

[Amit Gandhi]

Hi Folks

I am finding some problem in excel data. I have a excel data (attached file)
in vertical form. I want to convert it into Horizontal form using Excel
Formulas.

Pls help me here.

Regards

Amit

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


retrieve data.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Finding Merged cells in excel

[Amit Gandhi]

thanks alot sir.

On Thu, Sep 15, 2011 at 5:47 PM, NOORAIN ANSARI wrote:

> To find a merged cell in Excel 2003.
>
> 1. Open a Find and Replace Menu.
> 2. Next to the Find What Field is a Format Box, Click it.
> 3. This opens the Find Format Menu screen which looks very similar to the
> Cell Format Tabs and screens
> 4. On the Alignment Tab, remove any ticks in the Wrap Text or Shrink to Fit
> boxes.
> 5. Leave a tick in the Merge Cells Box and click the OK Button to return to
> the Find and Replace screen.
> 6. Now click the Find All Button and ALL merged cells are shown in the
> lower
> window and are selectable to jump to their location
>
>
>
> http://www.pcreview.co.uk/forums/do-locate-merged-cells-my-excel-worksheet-t3785983.html
>
> On Thu, Sep 15, 2011 at 1:15 PM, Amit Gandhi  wrote:
>
>> Hi Folks
>>
>> I am finding some problem in excel data. Pls help me here. I have a excel
>> data in 10 columns and 2 rows. There are some MERGED CELLS in this data.
>> I am applying filters and its not working due to merged data. Is there any
>> way in Excel to find merged cells automatically.
>>
>> Pls help me here.
>>
>> Regards
>>
>> Amit
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Finding Merged cells in excel

[Amit Gandhi]

Hi Folks

I am finding some problem in excel data. Pls help me here. I have a excel
data in 10 columns and 2 rows. There are some MERGED CELLS in this data.
I am applying filters and its not working due to merged data. Is there any
way in Excel to find merged cells automatically.

Pls help me here.

Regards

Amit

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Excel :: Final Completion date problem

[Amit Gandhi]

Thanks Noorain

It solved my problem. Thanks alot.

Regards

Amit


On Wed, Jun 15, 2011 at 9:21 PM, NOORAIN ANSARI wrote:

> Dear Nemi,
>
> This is basically Array function...it come after press ctrl+shift+enter..
> Please use below formula to your convenience..it is easy to Copy Paste
>
> Kindly see attached sheet
> =SUMPRODUCT(MAX(($A$6:$A$15=A6)*($C$6:$C$15)))
>
> --
> Thanks & regards,
> Noorain Ansari
> On Wed, Jun 15, 2011 at 6:07 PM, Amit Gandhi  wrote:
>
>> Thanks Noorian
>>
>> But there is still some problem. If I copy your formula in my another
>> file, result came to "{=MAX(IF($A$6:$A$15=A6,$C$6:$C$15,""))}".
>>
>> If I press F2 in that cell, { } brackets disappears and result is
>> 10-oct-11 in all cells.
>>
>> Pls help me to get correct result.
>>
>> Regards
>>
>> Amit
>>
>>
>> On Tue, Jun 14, 2011 at 7:30 PM, NOORAIN ANSARI > > wrote:
>>
>>> Dear Amit,
>>>
>>> Please see attached sheet..
>>>
>>> --
>>> Thanks & regards,
>>> Noorain Ansari
>>>
>>>   On Tue, Jun 14, 2011 at 6:38 PM, Amit Gandhi wrote:
>>>
>>>> Hi Folks
>>>>
>>>> I am finding some problem in excel formula, pls help me here. I have a
>>>> excel data in two columns, one is some job code and 2nd is its completion
>>>> date in different units. I need a formula that can show final completion
>>>> date against each job code. You can look into attached excel  data file for
>>>> better understanding. In that file I have shown the result what I want.
>>>>
>>>> Pls help me here.
>>>>
>>>> Regards
>>>>
>>>> Amit
>>>>
>>>>
>>>> --
>>>>
>>>> --
>>>> Some important links for excel users:
>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>> http://twitter.com/exceldailytip
>>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>>
>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>
>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>> Like our page on facebook , Just follow below link
>>>> http://www.facebook.com/discussexcel
>>>>
>>>
>>>
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>> --
>> 'Expecting the world to treat u fairly coz u r a good person is like
>> expecting the lion not to attack u coz u r a vegetarian.
>> Think about it.'
>>
>> Take care
>>
>> Amit
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email

Re: $$Excel-Macros$$ Excel :: Final Completion date problem

[Amit Gandhi]

Thanks Noorian

But there is still some problem. If I copy your formula in my another file,
result came to "{=MAX(IF($A$6:$A$15=A6,$C$6:$C$15,""))}".

If I press F2 in that cell, { } brackets disappears and result is 10-oct-11
in all cells.

Pls help me to get correct result.

Regards

Amit


On Tue, Jun 14, 2011 at 7:30 PM, NOORAIN ANSARI wrote:

> Dear Amit,
>
> Please see attached sheet..
>
> --
> Thanks & regards,
> Noorain Ansari
>
> On Tue, Jun 14, 2011 at 6:38 PM, Amit Gandhi  wrote:
>
>> Hi Folks
>>
>> I am finding some problem in excel formula, pls help me here. I have a
>> excel data in two columns, one is some job code and 2nd is its completion
>> date in different units. I need a formula that can show final completion
>> date against each job code. You can look into attached excel  data file for
>> better understanding. In that file I have shown the result what I want.
>>
>> Pls help me here.
>>
>> Regards
>>
>> Amit
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Excel :: Final Completion date problem

[Amit Gandhi]

Hi Folks

I am finding some problem in excel formula, pls help me here. I have a excel
data in two columns, one is some job code and 2nd is its completion date in
different units. I need a formula that can show final completion date
against each job code. You can look into attached excel  data file for
better understanding. In that file I have shown the result what I want.

Pls help me here.

Regards

Amit

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


SAMPLE DATA.xls
Description: MS-Excel spreadsheet