Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

2017-07-07 Thread 'Margareta Tolliver' via MS EXCEL AND VBA MACROS 


On Fri, 7/7/17, Puttu * <puttu...@gmail.com> wrote:

 Subject: Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value
 To: "MS EXCEL AND VBA MACROS" <excel-macros@googlegroups.com>
 Date: Friday, July 7, 2017, 2:18 PM
 
 Hi Swapnil,
 
 Just to let you know all your comments
 should be based on the error code.
 
 Error Code column
 1
 2
 3
 
 all these three has
 different error description.
 
 Thanks
 Putta
 
 On Thu, Jul 6, 2017 at 7:14
 PM, Puttu * <puttu...@gmail.com>
 wrote:
 Hi Swapnil,
 
 Thanks you so much
 appreciate your time and help on getting this macro. I think
 got almost what required, there is only small changes, which
 need to be done. Sorry its my mistake not giving right
 information on that.
 
 The reason I am looking a macro is I
 can't educate others who are very beginning stage of
 learning. Macro will be more easier for them to use than
 conditional formatting.
 
 I have added my comments in Final Tab.
 Please review and let me know if any points are unclear.
 
 Thanks
 Putta
 
 
 On Wed, Jul 5, 2017 at 2:18
 PM, Swapnil Palande <palande.swapni...@gmail.com>
 wrote:
 Hi,
 
 Why are you not using conditional
 formatting. If your main purpose is to display user
 duplicates and empty cells, conditional formatting is best
 solution.
 
 Have
 applied both solutions (conditional formatting as well as
 macro) in attached excel.
 
 Regards,
 Swapnil.
 
 On Wed, Jul 5, 2017 at
 12:24 AM, Puttu * <puttu...@gmail.com>
 wrote:
 anyhelp please
 
 On Tue, Jul 4, 2017 at
 12:33 PM, Puttu * <puttu...@gmail.com>
 wrote:
 Thanks Sir, Formula match exactly my
 requirement, however I have more than 50 columns, quite
 difficult to input formula for every column. Thus the reason
 I am looking for macro.
 
 Please help
 
 On Tue,
 Jul 4, 2017 at 11:21 AM, Swapnil Palande <palande.swapni...@gmail.com>
 wrote:
 Hi,
 
 No need of macro, you can do it using
 formulas also. Attached is the excel for your reference.
 
 Regards,
 Swapnil
 On Tue, Jul 4, 2017 at
 10:36 AM, Puttu * <puttu...@gmail.com>
 wrote:
 Experts, Any help on this will be much appreciated
 
 
 On Mon, Jul 3, 2017 at
 10:33 PM, Puttu * <puttu...@gmail.com>
 wrote:
 Hi Experts
 
 Please help on this.
 
 Thanks
 Putta
 
 On Mon,
 Jul 3, 2017 at 9:42 PM, Puttu * <puttu...@gmail.com>
 wrote:
 Hi Experts,
 
 I am not a vba expert
 and need your help me on the attached requirement. 
 
 I have list of columns
 and from that I need to know based on the Model No. column
 filter if the other columns have any duplicate values, if
 yes then it should display comments column as Column Name
 + duplicate value (Ex: Category_description having duplicate
 value)
 
 2. If the
 any of the column is blank it should print Column Name is
 blank (Ex: Parent Category ID has blank value).
 
 Attached is the sample
 spread sheet. Please review and help me on it.
 
 -- 
 Putta
 
 
 
 
 -- 
 
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
 wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
 Facebook page of this forum @ https://www.facebook.com/discu
 ssexcel
 
  
 
 FORUM RULES
 
  
 
 1) Use concise, accurate thread titles. Poor thread titles,
 like Please Help, Urgent, Need Help, Formula Problem, Code
 Problem, and Need Advice will not get quick attention or may
 not be answered.
 
 2) Don't post a question in the thread of another
 member.
 
 3) Don't post questions regarding breaking or bypassing
 any security measure.
 
 4) Acknowledge the responses you receive, good or bad.
 
 5) Jobs posting is not allowed.
 
 6) Sharing copyrighted material and their links is not
 allowed.
 
  
 
 NOTE  : Don't ever post confidential data in a workbook.
 Forum owners and members are not responsible for any
 loss.
 
 --- 
 
 You received this message because you are subscribed to the
 Google Groups "MS EXCEL AND VBA MACROS" group.
 
 To unsubscribe from this group and stop receiving emails
 from it, send an email to excel-macros+unsubscribe@googl
 egroups.com.
 
 To post to this group, send email to excel-macros@googlegroups.com.
 
 Visit this group at https://groups.google.com/grou
 p/excel-macros.
 
 For more options, visit https://groups.google.com/d/op
 tout.
 
 
 
 
 -- 
 Putta
 
 
 
 
 -- 
 Putta
 
 
 
 
 -- 
 
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
 wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
 Facebook page of this forum @ https://www.facebook.com/discu
 ssexcel
 
  
 
 FORUM RULES
 
  
 
 1) Use concise, accurate thread titles. Poor thread titles,
 like Please Help, Urgent, Need Help, Formula Problem, Code
 Problem, and Need Advice will not get quick attention or may
 not be answered.
 
 2) Don't post a question in the thread of another
 member.
 
 3) Don't post questions regarding breaking or bypassing
 any security measure.
 
 4) Acknowledge the responses you receive, good or bad.
 
 5)

Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

2017-07-07 Thread Puttu * 
Hi Swapnil,

Just to let you know all your comments should be based on the error code.

Error Code column
1
2
3

all these three has different error description.

Thanks
Putta

On Thu, Jul 6, 2017 at 7:14 PM, Puttu *  wrote:

> Hi Swapnil,
>
> Thanks you so much appreciate your time and help on getting this macro. I
> think got almost what required, there is only small changes, which need to
> be done. Sorry its my mistake not giving right information on that.
>
> The reason I am looking a macro is I can't educate others who are very
> beginning stage of learning. Macro will be more easier for them to use than
> conditional formatting.
>
> I have added my comments in Final Tab. Please review and let me know if
> any points are unclear.
>
> Thanks
> Putta
>
>
> On Wed, Jul 5, 2017 at 2:18 PM, Swapnil Palande <
> palande.swapni...@gmail.com> wrote:
>
>> Hi,
>>
>> Why are you not using conditional formatting. If your main purpose is to
>> display user duplicates and empty cells, conditional formatting is best
>> solution.
>>
>> Have applied both solutions (conditional formatting as well as macro) in
>> attached excel.
>>
>> Regards,
>> Swapnil.
>>
>> On Wed, Jul 5, 2017 at 12:24 AM, Puttu *  wrote:
>>
>>> anyhelp please
>>>
>>> On Tue, Jul 4, 2017 at 12:33 PM, Puttu *  wrote:
>>>
 Thanks Sir, Formula match exactly my requirement, however I have more
 than 50 columns, quite difficult to input formula for every column. Thus
 the reason I am looking for macro.

 Please help

 On Tue, Jul 4, 2017 at 11:21 AM, Swapnil Palande <
 palande.swapni...@gmail.com> wrote:

> Hi,
>
> No need of macro, you can do it using formulas also. Attached is the
> excel for your reference.
>
> Regards,
> Swapnil
>
> On Tue, Jul 4, 2017 at 10:36 AM, Puttu *  wrote:
>
>> Experts, Any help on this will be much appreciated
>>
>> On Mon, Jul 3, 2017 at 10:33 PM, Puttu *  wrote:
>>
>>> Hi Experts
>>>
>>> Please help on this.
>>>
>>> Thanks
>>> Putta
>>>
>>> On Mon, Jul 3, 2017 at 9:42 PM, Puttu *  wrote:
>>>
 Hi Experts,

 I am not a vba expert and need your help me on the attached
 requirement.

 I have list of columns and from that I need to know based on the
 Model No. column filter if the other columns have any duplicate 
 values, if
 yes then it should display comments column as *Column Name +
 duplicate value (Ex: Category_description having duplicate value)*

 2. If the any of the column is blank it should print Column Name is
 blank (*Ex: Parent Category ID has blank value).*

 Attached is the sample spread sheet. Please review and help me on
 it.

 --
 Putta

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

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

Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

2017-07-06 Thread 'Julienne Schindler' via MS EXCEL AND VBA MACROS 


On Thu, 7/6/17, 'Martinez David' via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value
 To: excel-macros@googlegroups.com
 Date: Thursday, July 6, 2017, 11:16 PM
 
 
 
 On Thu, 7/6/17, Puttu * <puttu...@gmail.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Macro
 for Blank Cell and Duplicate Value
  To: "MS EXCEL AND VBA MACROS" <excel-macros@googlegroups.com>
  Date: Thursday, July 6, 2017, 4:44 PM
  
  Hi Swapnil,
  
  Thanks you so much
  appreciate your time and help on
 getting this macro. I think
  got almost what required, there is
 only small changes, which
  need to be done. Sorry its my mistake
 not giving right
  information on that.
  
  The reason I am looking a macro is I
  can't educate others who are very
 beginning stage of
  learning. Macro will be more easier
 for them to use than
  conditional formatting.
  
  I have added my comments in Final
 Tab.
  Please review and let me know if any
 points are unclear.
  
  Thanks
  Putta
  
  
  On Wed, Jul 5, 2017 at 2:18
  PM, Swapnil Palande <palande.swapni...@gmail.com>
  wrote:
  Hi,
  
  Why are you not using conditional
  formatting. If your main purpose is to
 display user
  duplicates and empty cells,
 conditional formatting is best
  solution.
  
  Have
  applied both solutions (conditional
 formatting as well as
  macro) in attached excel.
  
  Regards,
  Swapnil.
  
  On Wed, Jul 5, 2017 at
  12:24 AM, Puttu * <puttu...@gmail.com>
  wrote:
  anyhelp please
  
  On Tue, Jul 4, 2017 at
  12:33 PM, Puttu * <puttu...@gmail.com>
  wrote:
  Thanks Sir, Formula match exactly my
  requirement, however I have more than
 50 columns, quite
  difficult to input formula for every
 column. Thus the reason
  I am looking for macro.
  
  Please help
  
  On Tue,
  Jul 4, 2017 at 11:21 AM, Swapnil
 Palande <palande.swapni...@gmail.com>
  wrote:
  Hi,
  
  No need of macro, you can do it using
  formulas also. Attached is the excel
 for your reference.
  
  Regards,
  Swapnil
  On Tue, Jul 4, 2017 at
  10:36 AM, Puttu * <puttu...@gmail.com>
  wrote:
  Experts, Any help on this will be much
 appreciated
  
  
  On Mon, Jul 3, 2017 at
  10:33 PM, Puttu * <puttu...@gmail.com>
  wrote:
  Hi Experts
  
  Please help on this.
  
  Thanks
  Putta
  
  On Mon,
  Jul 3, 2017 at 9:42 PM, Puttu * <puttu...@gmail.com>
  wrote:
  Hi Experts,
  
  I am not a vba expert
  and need your help me on the attached
 requirement. 
  
  I have list of columns
  and from that I need to know based on
 the Model No. column
  filter if the other columns have any
 duplicate values, if
  yes then it should display comments
 column as Column Name
  + duplicate value (Ex:
 Category_description having duplicate
  value)
  
  2. If the
  any of the column is blank it should
 print Column Name is
  blank (Ex: Parent Category ID has
 blank value).
  
  Attached is the sample
  spread sheet. Please review and help
 me on it.
  
  -- 
  Putta
  
  
  
  
  -- 
  
  Are you =EXP(E:RT) or =NOT(EXP(E:RT))
 in Excel? And do you
  wanna be? It’s =TIME(2,DO:IT,N:OW) !
 Join official
  Facebook page of this forum @ https://www.facebook.com/discu
  ssexcel
  
   
  
  FORUM RULES
  
   
  
  1) Use concise, accurate thread
 titles. Poor thread titles,
  like Please Help, Urgent, Need Help,
 Formula Problem, Code
  Problem, and Need Advice will not get
 quick attention or may
  not be answered.
  
  2) Don't post a question in the thread
 of another
  member.
  
  3) Don't post questions regarding
 breaking or bypassing
  any security measure.
  
  4) Acknowledge the responses you
 receive, good or bad.
  
  5) Jobs posting is not allowed.
  
  6) Sharing copyrighted material and
 their links is not
  allowed.
  
   
  
  NOTE  : Don't ever post
 confidential data in a workbook.
  Forum owners and members are not
 responsible for any
  loss.
  
  --- 
  
  You received this message because you
 are subscribed to the
  Google Groups "MS EXCEL AND VBA
 MACROS" group.
  
  To unsubscribe from this group and
 stop receiving emails
  from it, send an email to
 excel-macros+unsubscribe@googl
  egroups.com.
  
  To post to this group, send email to
 excel-macros@googlegroups.com.
  
  Visit this group at https://groups.google.com/grou
  p/excel-macros.
  
  For more options, visit https://groups.google.com/d/op
  tout.
  
  
  
  
  -- 
  Putta
  
  
  
  
  -- 
  Putta
  
  
  
  
  -- 
  
  Are you =EXP(E:RT) or =NOT(EXP(E:RT))
 in Excel? And do you
  wanna be? It’s =TIME(2,DO:IT,N:OW) !
 Join official
  Facebook page of this forum @ https://www.facebook.com/discu
  ssexcel
  
   
  
  FORUM RULES
  
   
  
  1) Use concise, accurate thread
 titles. Poor thread titles,
  like Please Help, Urgent, Need Help,
 Formula Problem, Code
  Problem, and N

Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

2017-07-06 Thread 'Martinez David' via MS EXCEL AND VBA MACROS 


On Thu, 7/6/17, Puttu * <puttu...@gmail.com> wrote:

 Subject: Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value
 To: "MS EXCEL AND VBA MACROS" <excel-macros@googlegroups.com>
 Date: Thursday, July 6, 2017, 4:44 PM
 
 Hi Swapnil,
 
 Thanks you so much
 appreciate your time and help on getting this macro. I think
 got almost what required, there is only small changes, which
 need to be done. Sorry its my mistake not giving right
 information on that.
 
 The reason I am looking a macro is I
 can't educate others who are very beginning stage of
 learning. Macro will be more easier for them to use than
 conditional formatting.
 
 I have added my comments in Final Tab.
 Please review and let me know if any points are unclear.
 
 Thanks
 Putta
 
 
 On Wed, Jul 5, 2017 at 2:18
 PM, Swapnil Palande <palande.swapni...@gmail.com>
 wrote:
 Hi,
 
 Why are you not using conditional
 formatting. If your main purpose is to display user
 duplicates and empty cells, conditional formatting is best
 solution.
 
 Have
 applied both solutions (conditional formatting as well as
 macro) in attached excel.
 
 Regards,
 Swapnil.
 
 On Wed, Jul 5, 2017 at
 12:24 AM, Puttu * <puttu...@gmail.com>
 wrote:
 anyhelp please
 
 On Tue, Jul 4, 2017 at
 12:33 PM, Puttu * <puttu...@gmail.com>
 wrote:
 Thanks Sir, Formula match exactly my
 requirement, however I have more than 50 columns, quite
 difficult to input formula for every column. Thus the reason
 I am looking for macro.
 
 Please help
 
 On Tue,
 Jul 4, 2017 at 11:21 AM, Swapnil Palande <palande.swapni...@gmail.com>
 wrote:
 Hi,
 
 No need of macro, you can do it using
 formulas also. Attached is the excel for your reference.
 
 Regards,
 Swapnil
 On Tue, Jul 4, 2017 at
 10:36 AM, Puttu * <puttu...@gmail.com>
 wrote:
 Experts, Any help on this will be much appreciated
 
 
 On Mon, Jul 3, 2017 at
 10:33 PM, Puttu * <puttu...@gmail.com>
 wrote:
 Hi Experts
 
 Please help on this.
 
 Thanks
 Putta
 
 On Mon,
 Jul 3, 2017 at 9:42 PM, Puttu * <puttu...@gmail.com>
 wrote:
 Hi Experts,
 
 I am not a vba expert
 and need your help me on the attached requirement. 
 
 I have list of columns
 and from that I need to know based on the Model No. column
 filter if the other columns have any duplicate values, if
 yes then it should display comments column as Column Name
 + duplicate value (Ex: Category_description having duplicate
 value)
 
 2. If the
 any of the column is blank it should print Column Name is
 blank (Ex: Parent Category ID has blank value).
 
 Attached is the sample
 spread sheet. Please review and help me on it.
 
 -- 
 Putta
 
 
 
 
 -- 
 
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
 wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
 Facebook page of this forum @ https://www.facebook.com/discu
 ssexcel
 
  
 
 FORUM RULES
 
  
 
 1) Use concise, accurate thread titles. Poor thread titles,
 like Please Help, Urgent, Need Help, Formula Problem, Code
 Problem, and Need Advice will not get quick attention or may
 not be answered.
 
 2) Don't post a question in the thread of another
 member.
 
 3) Don't post questions regarding breaking or bypassing
 any security measure.
 
 4) Acknowledge the responses you receive, good or bad.
 
 5) Jobs posting is not allowed.
 
 6) Sharing copyrighted material and their links is not
 allowed.
 
  
 
 NOTE  : Don't ever post confidential data in a workbook.
 Forum owners and members are not responsible for any
 loss.
 
 --- 
 
 You received this message because you are subscribed to the
 Google Groups "MS EXCEL AND VBA MACROS" group.
 
 To unsubscribe from this group and stop receiving emails
 from it, send an email to excel-macros+unsubscribe@googl
 egroups.com.
 
 To post to this group, send email to excel-macros@googlegroups.com.
 
 Visit this group at https://groups.google.com/grou
 p/excel-macros.
 
 For more options, visit https://groups.google.com/d/op
 tout.
 
 
 
 
 -- 
 Putta
 
 
 
 
 -- 
 Putta
 
 
 
 
 -- 
 
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
 wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
 Facebook page of this forum @ https://www.facebook.com/discu
 ssexcel
 
  
 
 FORUM RULES
 
  
 
 1) Use concise, accurate thread titles. Poor thread titles,
 like Please Help, Urgent, Need Help, Formula Problem, Code
 Problem, and Need Advice will not get quick attention or may
 not be answered.
 
 2) Don't post a question in the thread of another
 member.
 
 3) Don't post questions regarding breaking or bypassing
 any security measure.
 
 4) Acknowledge the responses you receive, good or bad.
 
 5) Jobs posting is not allowed.
 
 6) Sharing copyrighted material and their links is not
 allowed.
 
  
 
 NOTE  : Don't ever post confidential data in a workbook.
 Forum owners and members are not responsible for any
 loss.
 
 --- 
 
 You received this message becaus

Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

2017-07-06 Thread Puttu * 
Hi Swapnil,

Thanks you so much appreciate your time and help on getting this macro. I
think got almost what required, there is only small changes, which need to
be done. Sorry its my mistake not giving right information on that.

The reason I am looking a macro is I can't educate others who are very
beginning stage of learning. Macro will be more easier for them to use than
conditional formatting.

I have added my comments in Final Tab. Please review and let me know if any
points are unclear.

Thanks
Putta


On Wed, Jul 5, 2017 at 2:18 PM, Swapnil Palande  wrote:

> Hi,
>
> Why are you not using conditional formatting. If your main purpose is to
> display user duplicates and empty cells, conditional formatting is best
> solution.
>
> Have applied both solutions (conditional formatting as well as macro) in
> attached excel.
>
> Regards,
> Swapnil.
>
> On Wed, Jul 5, 2017 at 12:24 AM, Puttu *  wrote:
>
>> anyhelp please
>>
>> On Tue, Jul 4, 2017 at 12:33 PM, Puttu *  wrote:
>>
>>> Thanks Sir, Formula match exactly my requirement, however I have more
>>> than 50 columns, quite difficult to input formula for every column. Thus
>>> the reason I am looking for macro.
>>>
>>> Please help
>>>
>>> On Tue, Jul 4, 2017 at 11:21 AM, Swapnil Palande <
>>> palande.swapni...@gmail.com> wrote:
>>>
 Hi,

 No need of macro, you can do it using formulas also. Attached is the
 excel for your reference.

 Regards,
 Swapnil

 On Tue, Jul 4, 2017 at 10:36 AM, Puttu *  wrote:

> Experts, Any help on this will be much appreciated
>
> On Mon, Jul 3, 2017 at 10:33 PM, Puttu *  wrote:
>
>> Hi Experts
>>
>> Please help on this.
>>
>> Thanks
>> Putta
>>
>> On Mon, Jul 3, 2017 at 9:42 PM, Puttu *  wrote:
>>
>>> Hi Experts,
>>>
>>> I am not a vba expert and need your help me on the attached
>>> requirement.
>>>
>>> I have list of columns and from that I need to know based on the
>>> Model No. column filter if the other columns have any duplicate values, 
>>> if
>>> yes then it should display comments column as *Column Name +
>>> duplicate value (Ex: Category_description having duplicate value)*
>>>
>>> 2. If the any of the column is blank it should print Column Name is
>>> blank (*Ex: Parent Category ID has blank value).*
>>>
>>> Attached is the sample spread sheet. Please review and help me on it.
>>>
>>> --
>>> Putta
>>>
>>> --
>>> 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.
>>>
>>
>>
>>
>> --
>> Putta
>>
>
>
>
> --
> Putta
>
> --
> 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

Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

2017-07-05 Thread 'Karleen Biggs' via MS EXCEL AND VBA MACROS 


On Wed, 7/5/17, 'Martinez David' via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value
 To: excel-macros@googlegroups.com
 Date: Wednesday, July 5, 2017, 11:42 AM
 
 
 
 On Wed, 7/5/17, 'Yu Spain' via MS EXCEL
 AND VBA MACROS <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Macro
 for Blank Cell and Duplicate Value
  To: excel-macros@googlegroups.com
  Date: Wednesday, July 5, 2017, 2:43
 AM
  
  
 
 
  On Tue, 7/4/17, Puttu * <puttu...@gmail.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$
 Macro
  for Blank Cell and Duplicate Value
   To: "MS EXCEL AND VBA MACROS"
 <excel-macros@googlegroups.com>
   Date: Tuesday, July 4, 2017,
 10:03 AM
   
   Thanks Sir, Formula match
 exactly my
   requirement, however I have more
 than
  50 columns, quite
   difficult to input formula for
 every
  column. Thus the reason
   I am looking for macro.
   
   Please help
   
   On Tue, Jul 4, 2017 at
   11:21 AM, Swapnil Palande <palande.swapni...@gmail.com>
   wrote:
   Hi,
   
   No need of macro, you can do it
 using
   formulas also. Attached is the
 excel
  for your reference.
   
   Regards,
   Swapnil
   On Tue, Jul 4, 2017 at
   10:36 AM, Puttu * <puttu...@gmail.com>
   wrote:
   Experts, Any help on this will
 be much
  appreciated
   
   
   On Mon, Jul 3, 2017 at
   10:33 PM, Puttu * <puttu...@gmail.com>
   wrote:
   Hi Experts
   
   Please help on this.
   
   Thanks
   Putta
   
   On Mon,
   Jul 3, 2017 at 9:42 PM, Puttu *
 <puttu...@gmail.com>
   wrote:
   Hi Experts,
   
   I am not a vba expert
   and need your help me on the
 attached
  requirement. 
   
   I have list of columns
   and from that I need to know
 based on
  the Model No. column
   filter if the other columns have
 any
  duplicate values, if
   yes then it should display
 comments
  column as Column Name
   + duplicate value (Ex:
  Category_description having duplicate
   value)
   
   2. If the
   any of the column is blank it
 should
  print Column Name is
   blank (Ex: Parent Category ID
 has
  blank value).
   
   Attached is the sample
   spread sheet. Please review and
 help
  me on it.
   
   -- 
   Putta
   
   
   
   
   -- 
   
   Are you =EXP(E:RT) or
 =NOT(EXP(E:RT))
  in Excel? And do you
   wanna be? It’s
 =TIME(2,DO:IT,N:OW) !
  Join official
   Facebook page of this forum @ https://www.facebook.com/discu
   ssexcel
   
    
   
   FORUM RULES
   
    
   
   1) Use concise, accurate thread
  titles. Poor thread titles,
   like Please Help, Urgent, Need
 Help,
  Formula Problem, Code
   Problem, and Need Advice will
 not get
  quick attention or may
   not be answered.
   
   2) Don't post a question in the
 thread
  of another
   member.
   
   3) Don't post questions
 regarding
  breaking or bypassing
   any security measure.
   
   4) Acknowledge the responses
 you
  receive, good or bad.
   
   5) Jobs posting is not allowed.
   
   6) Sharing copyrighted material
 and
  their links is not
   allowed.
   
    
   
   NOTE  : Don't ever post
  confidential data in a workbook.
   Forum owners and members are
 not
  responsible for any
   loss.
   
   --- 
   
   You received this message
 because you
  are subscribed to the
   Google Groups "MS EXCEL AND VBA
  MACROS" group.
   
   To unsubscribe from this group
 and
  stop receiving emails
   from it, send an email to
  excel-macros+unsubscribe@googl
   egroups.com.
   
   To post to this group, send
 email to
  excel-macros@googlegroups.com.
   
   Visit this group at https://groups.google.com/grou
   p/excel-macros.
   
   For more options, visit https://groups.google.com/d/op
   tout.
   
   
   
   
   -- 
   Putta
   
   
   
   
   -- 
   Putta
   
   
   
   
   -- 
   
   Are you =EXP(E:RT) or
 =NOT(EXP(E:RT))
  in Excel? And do you
   wanna be? It’s
 =TIME(2,DO:IT,N:OW) !
  Join official
   Facebook page of this forum @ https://www.facebook.com/discu
   ssexcel
   
    
   
   FORUM RULES
   
    
   
   1) Use concise, accurate thread
  titles. Poor thread titles,
   like Please Help, Urgent, Need
 Help,
  Formula Problem, Code
   Problem, and Need Advice will
 not get
  quick attention or may
   not be answered.
   
   2) Don't post a question in the
 thread
  of another
   member.
   
   3) Don't post questions
 regarding
  breaking or bypassing
   any security measure.
   
   4) Acknowledge the responses
 you
  receive, good or bad.
   
   5) Jobs posting is not allowed.
   
   6) Sharing copyrighted material
 and
  their links is not
   allowed.
   
    
   
   NOTE  : Don't ever post
  confidential data in a workbook.
   Forum owners and members are
 not
  responsible for any
   loss.
   
   --- 
   
   You received this message
 because you

Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

2017-07-05 Thread 'Martinez David' via MS EXCEL AND VBA MACROS 


On Wed, 7/5/17, 'Yu Spain' via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value
 To: excel-macros@googlegroups.com
 Date: Wednesday, July 5, 2017, 2:43 AM
 
 
 
 On Tue, 7/4/17, Puttu * <puttu...@gmail.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Macro
 for Blank Cell and Duplicate Value
  To: "MS EXCEL AND VBA MACROS" <excel-macros@googlegroups.com>
  Date: Tuesday, July 4, 2017, 10:03 AM
  
  Thanks Sir, Formula match exactly my
  requirement, however I have more than
 50 columns, quite
  difficult to input formula for every
 column. Thus the reason
  I am looking for macro.
  
  Please help
  
  On Tue, Jul 4, 2017 at
  11:21 AM, Swapnil Palande <palande.swapni...@gmail.com>
  wrote:
  Hi,
  
  No need of macro, you can do it using
  formulas also. Attached is the excel
 for your reference.
  
  Regards,
  Swapnil
  On Tue, Jul 4, 2017 at
  10:36 AM, Puttu * <puttu...@gmail.com>
  wrote:
  Experts, Any help on this will be much
 appreciated
  
  
  On Mon, Jul 3, 2017 at
  10:33 PM, Puttu * <puttu...@gmail.com>
  wrote:
  Hi Experts
  
  Please help on this.
  
  Thanks
  Putta
  
  On Mon,
  Jul 3, 2017 at 9:42 PM, Puttu * <puttu...@gmail.com>
  wrote:
  Hi Experts,
  
  I am not a vba expert
  and need your help me on the attached
 requirement. 
  
  I have list of columns
  and from that I need to know based on
 the Model No. column
  filter if the other columns have any
 duplicate values, if
  yes then it should display comments
 column as Column Name
  + duplicate value (Ex:
 Category_description having duplicate
  value)
  
  2. If the
  any of the column is blank it should
 print Column Name is
  blank (Ex: Parent Category ID has
 blank value).
  
  Attached is the sample
  spread sheet. Please review and help
 me on it.
  
  -- 
  Putta
  
  
  
  
  -- 
  
  Are you =EXP(E:RT) or =NOT(EXP(E:RT))
 in Excel? And do you
  wanna be? It’s =TIME(2,DO:IT,N:OW) !
 Join official
  Facebook page of this forum @ https://www.facebook.com/discu
  ssexcel
  
   
  
  FORUM RULES
  
   
  
  1) Use concise, accurate thread
 titles. Poor thread titles,
  like Please Help, Urgent, Need Help,
 Formula Problem, Code
  Problem, and Need Advice will not get
 quick attention or may
  not be answered.
  
  2) Don't post a question in the thread
 of another
  member.
  
  3) Don't post questions regarding
 breaking or bypassing
  any security measure.
  
  4) Acknowledge the responses you
 receive, good or bad.
  
  5) Jobs posting is not allowed.
  
  6) Sharing copyrighted material and
 their links is not
  allowed.
  
   
  
  NOTE  : Don't ever post
 confidential data in a workbook.
  Forum owners and members are not
 responsible for any
  loss.
  
  --- 
  
  You received this message because you
 are subscribed to the
  Google Groups "MS EXCEL AND VBA
 MACROS" group.
  
  To unsubscribe from this group and
 stop receiving emails
  from it, send an email to
 excel-macros+unsubscribe@googl
  egroups.com.
  
  To post to this group, send email to
 excel-macros@googlegroups.com.
  
  Visit this group at https://groups.google.com/grou
  p/excel-macros.
  
  For more options, visit https://groups.google.com/d/op
  tout.
  
  
  
  
  -- 
  Putta
  
  
  
  
  -- 
  Putta
  
  
  
  
  -- 
  
  Are you =EXP(E:RT) or =NOT(EXP(E:RT))
 in Excel? And do you
  wanna be? It’s =TIME(2,DO:IT,N:OW) !
 Join official
  Facebook page of this forum @ https://www.facebook.com/discu
  ssexcel
  
   
  
  FORUM RULES
  
   
  
  1) Use concise, accurate thread
 titles. Poor thread titles,
  like Please Help, Urgent, Need Help,
 Formula Problem, Code
  Problem, and Need Advice will not get
 quick attention or may
  not be answered.
  
  2) Don't post a question in the thread
 of another
  member.
  
  3) Don't post questions regarding
 breaking or bypassing
  any security measure.
  
  4) Acknowledge the responses you
 receive, good or bad.
  
  5) Jobs posting is not allowed.
  
  6) Sharing copyrighted material and
 their links is not
  allowed.
  
   
  
  NOTE  : Don't ever post
 confidential data in a workbook.
  Forum owners and members are not
 responsible for any
  loss.
  
  --- 
  
  You received this message because you
 are subscribed to the
  Google Groups "MS EXCEL AND VBA
 MACROS" group.
  
  To unsubscribe from this group and
 stop receiving emails
  from it, send an email to
 excel-macros+unsubscribe@googl
  egroups.com.
  
  To post to this group, send email to
 excel-macros@googlegroups.com.
  
  Visit this group at https://groups.google.com/grou
  p/excel-macros.
  
  For more options, visit https://groups.google.com/d/op
  tout.
  
  
  
  
  
  
  -- 
  
  Are you =EXP(E:RT) or =NOT(EXP(E:RT))
 in Excel? And do you
  wanna be? It’s =TIME(2,DO:IT,N:OW) !

Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

2017-07-05 Thread Swapnil Palande 
Hi,

Why are you not using conditional formatting. If your main purpose is to
display user duplicates and empty cells, conditional formatting is best
solution.

Have applied both solutions (conditional formatting as well as macro) in
attached excel.

Regards,
Swapnil.

On Wed, Jul 5, 2017 at 12:24 AM, Puttu *  wrote:

> anyhelp please
>
> On Tue, Jul 4, 2017 at 12:33 PM, Puttu *  wrote:
>
>> Thanks Sir, Formula match exactly my requirement, however I have more
>> than 50 columns, quite difficult to input formula for every column. Thus
>> the reason I am looking for macro.
>>
>> Please help
>>
>> On Tue, Jul 4, 2017 at 11:21 AM, Swapnil Palande <
>> palande.swapni...@gmail.com> wrote:
>>
>>> Hi,
>>>
>>> No need of macro, you can do it using formulas also. Attached is the
>>> excel for your reference.
>>>
>>> Regards,
>>> Swapnil
>>>
>>> On Tue, Jul 4, 2017 at 10:36 AM, Puttu *  wrote:
>>>
 Experts, Any help on this will be much appreciated

 On Mon, Jul 3, 2017 at 10:33 PM, Puttu *  wrote:

> Hi Experts
>
> Please help on this.
>
> Thanks
> Putta
>
> On Mon, Jul 3, 2017 at 9:42 PM, Puttu *  wrote:
>
>> Hi Experts,
>>
>> I am not a vba expert and need your help me on the attached
>> requirement.
>>
>> I have list of columns and from that I need to know based on the
>> Model No. column filter if the other columns have any duplicate values, 
>> if
>> yes then it should display comments column as *Column Name +
>> duplicate value (Ex: Category_description having duplicate value)*
>>
>> 2. If the any of the column is blank it should print Column Name is
>> blank (*Ex: Parent Category ID has blank value).*
>>
>> Attached is the sample spread sheet. Please review and help me on it.
>>
>> --
>> Putta
>>
>> --
>> 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.
>>
>
>
>
> --
> Putta
>



 --
 Putta

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

 FORUM RULES

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

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

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

Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

2017-07-04 Thread 'Yu Spain' via MS EXCEL AND VBA MACROS 


On Tue, 7/4/17, Puttu * <puttu...@gmail.com> wrote:

 Subject: Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value
 To: "MS EXCEL AND VBA MACROS" <excel-macros@googlegroups.com>
 Date: Tuesday, July 4, 2017, 10:03 AM
 
 Thanks Sir, Formula match exactly my
 requirement, however I have more than 50 columns, quite
 difficult to input formula for every column. Thus the reason
 I am looking for macro.
 
 Please help
 
 On Tue, Jul 4, 2017 at
 11:21 AM, Swapnil Palande <palande.swapni...@gmail.com>
 wrote:
 Hi,
 
 No need of macro, you can do it using
 formulas also. Attached is the excel for your reference.
 
 Regards,
 Swapnil
 On Tue, Jul 4, 2017 at
 10:36 AM, Puttu * <puttu...@gmail.com>
 wrote:
 Experts, Any help on this will be much appreciated
 
 
 On Mon, Jul 3, 2017 at
 10:33 PM, Puttu * <puttu...@gmail.com>
 wrote:
 Hi Experts
 
 Please help on this.
 
 Thanks
 Putta
 
 On Mon,
 Jul 3, 2017 at 9:42 PM, Puttu * <puttu...@gmail.com>
 wrote:
 Hi Experts,
 
 I am not a vba expert
 and need your help me on the attached requirement. 
 
 I have list of columns
 and from that I need to know based on the Model No. column
 filter if the other columns have any duplicate values, if
 yes then it should display comments column as Column Name
 + duplicate value (Ex: Category_description having duplicate
 value)
 
 2. If the
 any of the column is blank it should print Column Name is
 blank (Ex: Parent Category ID has blank value).
 
 Attached is the sample
 spread sheet. Please review and help me on it.
 
 -- 
 Putta
 
 
 
 
 -- 
 
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
 wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
 Facebook page of this forum @ https://www.facebook.com/discu
 ssexcel
 
  
 
 FORUM RULES
 
  
 
 1) Use concise, accurate thread titles. Poor thread titles,
 like Please Help, Urgent, Need Help, Formula Problem, Code
 Problem, and Need Advice will not get quick attention or may
 not be answered.
 
 2) Don't post a question in the thread of another
 member.
 
 3) Don't post questions regarding breaking or bypassing
 any security measure.
 
 4) Acknowledge the responses you receive, good or bad.
 
 5) Jobs posting is not allowed.
 
 6) Sharing copyrighted material and their links is not
 allowed.
 
  
 
 NOTE  : Don't ever post confidential data in a workbook.
 Forum owners and members are not responsible for any
 loss.
 
 --- 
 
 You received this message because you are subscribed to the
 Google Groups "MS EXCEL AND VBA MACROS" group.
 
 To unsubscribe from this group and stop receiving emails
 from it, send an email to excel-macros+unsubscribe@googl
 egroups.com.
 
 To post to this group, send email to excel-macros@googlegroups.com.
 
 Visit this group at https://groups.google.com/grou
 p/excel-macros.
 
 For more options, visit https://groups.google.com/d/op
 tout.
 
 
 
 
 -- 
 Putta
 
 
 
 
 -- 
 Putta
 
 
 
 
 -- 
 
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
 wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
 Facebook page of this forum @ https://www.facebook.com/discu
 ssexcel
 
  
 
 FORUM RULES
 
  
 
 1) Use concise, accurate thread titles. Poor thread titles,
 like Please Help, Urgent, Need Help, Formula Problem, Code
 Problem, and Need Advice will not get quick attention or may
 not be answered.
 
 2) Don't post a question in the thread of another
 member.
 
 3) Don't post questions regarding breaking or bypassing
 any security measure.
 
 4) Acknowledge the responses you receive, good or bad.
 
 5) Jobs posting is not allowed.
 
 6) Sharing copyrighted material and their links is not
 allowed.
 
  
 
 NOTE  : Don't ever post confidential data in a workbook.
 Forum owners and members are not responsible for any
 loss.
 
 --- 
 
 You received this message because you are subscribed to the
 Google Groups "MS EXCEL AND VBA MACROS" group.
 
 To unsubscribe from this group and stop receiving emails
 from it, send an email to excel-macros+unsubscribe@googl
 egroups.com.
 
 To post to this group, send email to excel-macros@googlegroups.com.
 
 Visit this group at https://groups.google.com/grou
 p/excel-macros.
 
 For more options, visit https://groups.google.com/d/op
 tout.
 
 
 
 
 
 
 -- 
 
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
 wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
 Facebook page of this forum @ https://www.facebook.com/
 discussexcel
 
  
 
 FORUM RULES
 
  
 
 1) Use concise, accurate thread titles. Poor thread titles,
 like Please Help, Urgent, Need Help, Formula Problem, Code
 Problem, and Need Advice will not get quick attention or may
 not be answered.
 
 2) Don't post a question in the thread of another
 member.
 
 3) Don't post questions regarding breaking or bypassing
 any security measure.
 
 4) Acknowledge the responses you receive, good or bad.
 
 5) Jobs posting is not allowed.

Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

2017-07-04 Thread Puttu * 
anyhelp please

On Tue, Jul 4, 2017 at 12:33 PM, Puttu *  wrote:

> Thanks Sir, Formula match exactly my requirement, however I have more than
> 50 columns, quite difficult to input formula for every column. Thus the
> reason I am looking for macro.
>
> Please help
>
> On Tue, Jul 4, 2017 at 11:21 AM, Swapnil Palande <
> palande.swapni...@gmail.com> wrote:
>
>> Hi,
>>
>> No need of macro, you can do it using formulas also. Attached is the
>> excel for your reference.
>>
>> Regards,
>> Swapnil
>>
>> On Tue, Jul 4, 2017 at 10:36 AM, Puttu *  wrote:
>>
>>> Experts, Any help on this will be much appreciated
>>>
>>> On Mon, Jul 3, 2017 at 10:33 PM, Puttu *  wrote:
>>>
 Hi Experts

 Please help on this.

 Thanks
 Putta

 On Mon, Jul 3, 2017 at 9:42 PM, Puttu *  wrote:

> Hi Experts,
>
> I am not a vba expert and need your help me on the attached
> requirement.
>
> I have list of columns and from that I need to know based on the Model
> No. column filter if the other columns have any duplicate values, if yes
> then it should display comments column as *Column Name + duplicate
> value (Ex: Category_description having duplicate value)*
>
> 2. If the any of the column is blank it should print Column Name is
> blank (*Ex: Parent Category ID has blank value).*
>
> Attached is the sample spread sheet. Please review and help me on it.
>
> --
> Putta
>
> --
> 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.
>



 --
 Putta

>>>
>>>
>>>
>>> --
>>> Putta
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at https://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not

Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

2017-07-04 Thread Puttu * 
Thanks Sir, Formula match exactly my requirement, however I have more than
50 columns, quite difficult to input formula for every column. Thus the
reason I am looking for macro.

Please help

On Tue, Jul 4, 2017 at 11:21 AM, Swapnil Palande <
palande.swapni...@gmail.com> wrote:

> Hi,
>
> No need of macro, you can do it using formulas also. Attached is the excel
> for your reference.
>
> Regards,
> Swapnil
>
> On Tue, Jul 4, 2017 at 10:36 AM, Puttu *  wrote:
>
>> Experts, Any help on this will be much appreciated
>>
>> On Mon, Jul 3, 2017 at 10:33 PM, Puttu *  wrote:
>>
>>> Hi Experts
>>>
>>> Please help on this.
>>>
>>> Thanks
>>> Putta
>>>
>>> On Mon, Jul 3, 2017 at 9:42 PM, Puttu *  wrote:
>>>
 Hi Experts,

 I am not a vba expert and need your help me on the attached
 requirement.

 I have list of columns and from that I need to know based on the Model
 No. column filter if the other columns have any duplicate values, if yes
 then it should display comments column as *Column Name + duplicate
 value (Ex: Category_description having duplicate value)*

 2. If the any of the column is blank it should print Column Name is
 blank (*Ex: Parent Category ID has blank value).*

 Attached is the sample spread sheet. Please review and help me on it.

 --
 Putta

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

>>>
>>>
>>>
>>> --
>>> Putta
>>>
>>
>>
>>
>> --
>> Putta
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this

Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

2017-07-03 Thread Swapnil Palande 
Hi,

No need of macro, you can do it using formulas also. Attached is the excel
for your reference.

Regards,
Swapnil

On Tue, Jul 4, 2017 at 10:36 AM, Puttu *  wrote:

> Experts, Any help on this will be much appreciated
>
> On Mon, Jul 3, 2017 at 10:33 PM, Puttu *  wrote:
>
>> Hi Experts
>>
>> Please help on this.
>>
>> Thanks
>> Putta
>>
>> On Mon, Jul 3, 2017 at 9:42 PM, Puttu *  wrote:
>>
>>> Hi Experts,
>>>
>>> I am not a vba expert and need your help me on the attached requirement.
>>>
>>> I have list of columns and from that I need to know based on the Model
>>> No. column filter if the other columns have any duplicate values, if yes
>>> then it should display comments column as *Column Name + duplicate
>>> value (Ex: Category_description having duplicate value)*
>>>
>>> 2. If the any of the column is blank it should print Column Name is
>>> blank (*Ex: Parent Category ID has blank value).*
>>>
>>> Attached is the sample spread sheet. Please review and help me on it.
>>>
>>> --
>>> Putta
>>>
>>> --
>>> 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.
>>>
>>
>>
>>
>> --
>> Putta
>>
>
>
>
> --
> Putta
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

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


Null & Duplicate.xlsx

Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

2017-07-03 Thread Puttu * 
Experts, Any help on this will be much appreciated

On Mon, Jul 3, 2017 at 10:33 PM, Puttu *  wrote:

> Hi Experts
>
> Please help on this.
>
> Thanks
> Putta
>
> On Mon, Jul 3, 2017 at 9:42 PM, Puttu *  wrote:
>
>> Hi Experts,
>>
>> I am not a vba expert and need your help me on the attached requirement.
>>
>> I have list of columns and from that I need to know based on the Model
>> No. column filter if the other columns have any duplicate values, if yes
>> then it should display comments column as *Column Name + duplicate value
>> (Ex: Category_description having duplicate value)*
>>
>> 2. If the any of the column is blank it should print Column Name is blank
>> (*Ex: Parent Category ID has blank value).*
>>
>> Attached is the sample spread sheet. Please review and help me on it.
>>
>> --
>> Putta
>>
>> --
>> 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.
>>
>
>
>
> --
> Putta
>



-- 
Putta

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

2017-07-03 Thread Puttu * 
Hi Experts

Please help on this.

Thanks
Putta

On Mon, Jul 3, 2017 at 9:42 PM, Puttu *  wrote:

> Hi Experts,
>
> I am not a vba expert and need your help me on the attached requirement.
>
> I have list of columns and from that I need to know based on the Model No.
> column filter if the other columns have any duplicate values, if yes then
> it should display comments column as *Column Name + duplicate value (Ex:
> Category_description having duplicate value)*
>
> 2. If the any of the column is blank it should print Column Name is blank 
> (*Ex:
> Parent Category ID has blank value).*
>
> Attached is the sample spread sheet. Please review and help me on it.
>
> --
> Putta
>
> --
> 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.
>



-- 
Putta

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