Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value
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
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
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
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
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 Palandewrote: > 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
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
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
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
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
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
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
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
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
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.
$$Excel-Macros$$ Macro for Blank Cell and Duplicate Value
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. Null & Duplicate.xlsx Description: MS-Excel 2007 spreadsheet