Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists
Thank you very much !!! On 7/7/13, vba wrote: > Hi > > PFA... > > > Reason for error: cell was referring to NA. Make sure cell is referred > correctly. > > > Thanks > > > On Sun, Jul 7, 2013 at 10:04 AM, Mangesh Vimay > wrote: > >> Hi, >> >> When I am trying to run the macro, I am getting the error of type >> mismatch. (Please see the tab error in the attached sheet and the line >> which is getting error is highlighted in red color,) >> >> Also, it may be due to the cell K7 from the data sheet. >> >> Please suggest how to resolve it. >> >> Many thanks ! >> >> On 7/6/13, Mangesh Vimay wrote: >> > This group becomes special and the popular in a very small span of >> > timebecause of the members like you and others. >> > >> > Thanks a lot !!! >> > >> > On 7/6/13, vba wrote: >> >> Thanks for Acknowledgement.. Cheers!! >> >> >> >> >> >> On Sat, Jul 6, 2013 at 5:50 PM, Mangesh Vimay >> >> wrote: >> >> >> >>> Thanks you both for your great help. >> >>> >> >>> Ravinder, >> >>> >> >>> I didn't get what you said. Do I need to use the mentioned formula in >> >>> data validation box? >> >>> >> >>> Please suggest. >> >>> >> >>> On 7/6/13, ravinder negi wrote: >> >>> > PFAtry this and advise if this does not work propery.. you just >> >>> > need >> >>> to >> >>> > copy paste formula in validation rng selection box and it will >> >>> automatically >> >>> > create range from the second sheet and in second sheet you can add >> >>> > more >> >>> data >> >>> > and those will be also add in list...but your second sheet data >> should >> >>> > formated as given by you. >> >>> > >> >>> > --- On Sat, 7/6/13, Mangesh Vimay wrote: >> >>> > >> >>> > From: Mangesh Vimay >> >>> > Subject: Re: $$Excel-Macros$$ To create drop down list for many IDs >> as >> >>> per >> >>> > many lists >> >>> > To: excel-macros@googlegroups.com >> >>> > Date: Saturday, July 6, 2013, 11:20 AM >> >>> > >> >>> > Hi Be Tran Van, >> >>> > >> >>> > Thank you for your quick help. >> >>> > >> >>> > However, in my original workbook there are total 1200 lists and its >> >>> > quite time consuming job to create named range for all 1200 lists >> >>> > and >> >>> > then to specify the source for all the lists for data validations. >> >>> > >> >>> > Could you please suggest shortcut way/method so that I can create >> >>> > named range for all and then drop down list using data validation. >> >>> > >> >>> > I think, we can use vlookup, vba code to specify the named range >> >>> > and >> >>> > then to create data validations. But how, I really don't know. >> >>> > >> >>> > Appreciate your help. >> >>> > >> >>> > Thanks again !!! >> >>> > >> >>> > Regards, >> >>> > >> >>> > Mangesh >> >>> > >> >>> > On 7/6/13, Bé Trần Văn wrote: >> >>> >> You select C3: C6 setting Name1, C7:C12 setting Name2, C13:C20 >> >>> >> setting >> >>> >> Name3. >> >>> >> >> >>> >> B2 Validation with Source = Name1 >> >>> >> B3 Validation with Source = Name2 >> >>> >> B4 Validation with Source = Name3 >> >>> >> >> >>> >> >> >>> >> >> >>> >> 2013/7/6 Mangesh Vimay >> >>> >> >> >>> >>> Hi Friends, >> >>> >>> >> >>> >>> I have attached Excel file for the reference. >> >>> >>> I am unable to create a list for each ID as there are such 1200 >> >>> >>> lists >> >>> >>> for many IDs. So I need formula or vba macro to create such drop >> >>> >>> down >> >>> >
Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists
This group becomes special and the popular in a very small span of timebecause of the members like you and others. Thanks a lot !!! On 7/6/13, vba wrote: > Thanks for Acknowledgement.. Cheers!! > > > On Sat, Jul 6, 2013 at 5:50 PM, Mangesh Vimay > wrote: > >> Thanks you both for your great help. >> >> Ravinder, >> >> I didn't get what you said. Do I need to use the mentioned formula in >> data validation box? >> >> Please suggest. >> >> On 7/6/13, ravinder negi wrote: >> > PFAtry this and advise if this does not work propery.. you just >> > need >> to >> > copy paste formula in validation rng selection box and it will >> automatically >> > create range from the second sheet and in second sheet you can add more >> data >> > and those will be also add in list...but your second sheet data should >> > formated as given by you. >> > >> > --- On Sat, 7/6/13, Mangesh Vimay wrote: >> > >> > From: Mangesh Vimay >> > Subject: Re: $$Excel-Macros$$ To create drop down list for many IDs as >> per >> > many lists >> > To: excel-macros@googlegroups.com >> > Date: Saturday, July 6, 2013, 11:20 AM >> > >> > Hi Be Tran Van, >> > >> > Thank you for your quick help. >> > >> > However, in my original workbook there are total 1200 lists and its >> > quite time consuming job to create named range for all 1200 lists and >> > then to specify the source for all the lists for data validations. >> > >> > Could you please suggest shortcut way/method so that I can create >> > named range for all and then drop down list using data validation. >> > >> > I think, we can use vlookup, vba code to specify the named range and >> > then to create data validations. But how, I really don't know. >> > >> > Appreciate your help. >> > >> > Thanks again !!! >> > >> > Regards, >> > >> > Mangesh >> > >> > On 7/6/13, Bé Trần Văn wrote: >> >> You select C3: C6 setting Name1, C7:C12 setting Name2, C13:C20 setting >> >> Name3. >> >> >> >> B2 Validation with Source = Name1 >> >> B3 Validation with Source = Name2 >> >> B4 Validation with Source = Name3 >> >> >> >> >> >> >> >> 2013/7/6 Mangesh Vimay >> >> >> >>> Hi Friends, >> >>> >> >>> I have attached Excel file for the reference. >> >>> I am unable to create a list for each ID as there are such 1200 lists >> >>> for many IDs. So I need formula or vba macro to create such drop down >> >>> lists for every Id given in the column A so that I can select >> >>> required >> >>> option from the drop down list for every ID. Appreciate your help. >> >>> >> >>> Detailed explanation is given in the attached sheet. >> >>> >> >>> Please help. >> >>> >> >>> Thank a ton. >> >>> >> >>> With regards, >> >>> >> >>> *MaNgEsH* >> >>> >> >>> -- >> >>> 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 >> >>&
Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists
Thanks for Acknowledgement.. Cheers!! On Sat, Jul 6, 2013 at 5:50 PM, Mangesh Vimay wrote: > Thanks you both for your great help. > > Ravinder, > > I didn't get what you said. Do I need to use the mentioned formula in > data validation box? > > Please suggest. > > On 7/6/13, ravinder negi wrote: > > PFAtry this and advise if this does not work propery.. you just need > to > > copy paste formula in validation rng selection box and it will > automatically > > create range from the second sheet and in second sheet you can add more > data > > and those will be also add in list...but your second sheet data should > > formated as given by you. > > > > --- On Sat, 7/6/13, Mangesh Vimay wrote: > > > > From: Mangesh Vimay > > Subject: Re: $$Excel-Macros$$ To create drop down list for many IDs as > per > > many lists > > To: excel-macros@googlegroups.com > > Date: Saturday, July 6, 2013, 11:20 AM > > > > Hi Be Tran Van, > > > > Thank you for your quick help. > > > > However, in my original workbook there are total 1200 lists and its > > quite time consuming job to create named range for all 1200 lists and > > then to specify the source for all the lists for data validations. > > > > Could you please suggest shortcut way/method so that I can create > > named range for all and then drop down list using data validation. > > > > I think, we can use vlookup, vba code to specify the named range and > > then to create data validations. But how, I really don't know. > > > > Appreciate your help. > > > > Thanks again !!! > > > > Regards, > > > > Mangesh > > > > On 7/6/13, Bé Trần Văn wrote: > >> You select C3: C6 setting Name1, C7:C12 setting Name2, C13:C20 setting > >> Name3. > >> > >> B2 Validation with Source = Name1 > >> B3 Validation with Source = Name2 > >> B4 Validation with Source = Name3 > >> > >> > >> > >> 2013/7/6 Mangesh Vimay > >> > >>> Hi Friends, > >>> > >>> I have attached Excel file for the reference. > >>> I am unable to create a list for each ID as there are such 1200 lists > >>> for many IDs. So I need formula or vba macro to create such drop down > >>> lists for every Id given in the column A so that I can select required > >>> option from the drop down list for every ID. Appreciate your help. > >>> > >>> Detailed explanation is given in the attached sheet. > >>> > >>> Please help. > >>> > >>> Thank a ton. > >>> > >>> With regards, > >>> > >>> *MaNgEsH* > >>> > >>> -- > >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? > >>> It’s > >>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > >>> https://www.facebook.com/discussexcel > >>> > >>> FORUM RULES > >>> > >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please > >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > >>> will not get quick attention or may not be answered. > >>> 2) Don't post a question in the thread of another member. > >>> 3) Don't post questions regarding breaking or bypassing any security > >>> measure. > >>> 4) Acknowledge the responses you receive, good or bad. > >>> 5) Jobs posting is not allowed. > >>> 6) Sharing copyrighted material and their links is not allowed. > >>> > >>> NOTE : Don't ever post confidential data in a workbook. Forum owners > >>> and > >>> members are not responsible for any loss. > >>> --- > >>> You received this message because you are subscribed to the Google > >>> Groups > >>> "MS EXCEL AND VBA MACROS" group. > >>> To unsubscribe from this group and stop receiving emails from it, send > >>> an > >>> email to excel-macros+unsubscr...@googlegroups.com. > >>> To post to this group, send email to excel-macros@googlegroups.com. > >>> Visit this group at http://groups.google.com/group/excel-macros. > >>> For more options, visit https://groups.google.com/groups/opt_out. > >>> > >>> > >>> > >> > >> -- > >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? > It’s
Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists
Thanks you both for your great help. Ravinder, I didn't get what you said. Do I need to use the mentioned formula in data validation box? Please suggest. On 7/6/13, ravinder negi wrote: > PFAtry this and advise if this does not work propery.. you just need to > copy paste formula in validation rng selection box and it will automatically > create range from the second sheet and in second sheet you can add more data > and those will be also add in list...but your second sheet data should > formated as given by you. > > --- On Sat, 7/6/13, Mangesh Vimay wrote: > > From: Mangesh Vimay > Subject: Re: $$Excel-Macros$$ To create drop down list for many IDs as per > many lists > To: excel-macros@googlegroups.com > Date: Saturday, July 6, 2013, 11:20 AM > > Hi Be Tran Van, > > Thank you for your quick help. > > However, in my original workbook there are total 1200 lists and its > quite time consuming job to create named range for all 1200 lists and > then to specify the source for all the lists for data validations. > > Could you please suggest shortcut way/method so that I can create > named range for all and then drop down list using data validation. > > I think, we can use vlookup, vba code to specify the named range and > then to create data validations. But how, I really don't know. > > Appreciate your help. > > Thanks again !!! > > Regards, > > Mangesh > > On 7/6/13, Bé Trần Văn wrote: >> You select C3: C6 setting Name1, C7:C12 setting Name2, C13:C20 setting >> Name3. >> >> B2 Validation with Source = Name1 >> B3 Validation with Source = Name2 >> B4 Validation with Source = Name3 >> >> >> >> 2013/7/6 Mangesh Vimay >> >>> Hi Friends, >>> >>> I have attached Excel file for the reference. >>> I am unable to create a list for each ID as there are such 1200 lists >>> for many IDs. So I need formula or vba macro to create such drop down >>> lists for every Id given in the column A so that I can select required >>> option from the drop down list for every ID. Appreciate your help. >>> >>> Detailed explanation is given in the attached sheet. >>> >>> Please help. >>> >>> Thank a ton. >>> >>> With regards, >>> >>> *MaNgEsH* >>> >>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It’s >>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> 2) Don't post a question in the thread of another member. >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> 4) Acknowledge the responses you receive, good or bad. >>> 5) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>> and >>> members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups >>> "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an >>> email to excel-macros+unsubscr...@googlegroups.com. >>> To post to this group, send email to excel-macros@googlegroups.com. >>> Visit this group at http://groups.google.com/group/excel-macros. >>> For more options, visit https://groups.google.com/groups/opt_out. >>> >>> >>> >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will >> not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >&g
Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists
Simply Great !!! Could you please share final workbook. Sorry, for this. Thanks a ton !!! On 7/6/13, vba wrote: > Hi > > You dont have to create name, this will be created programatically for data > in DATA sheet. > > Just copy paste B2 or drag down. > > > Hoe Name is created by this Macro: > > First Data sheet is sort on the basis of ID; then unique ID is pasted in > range J2 & downwards. Then Name is defined for each ID beginning with "_" > > > Cheers!! > > > On Sat, Jul 6, 2013 at 2:45 PM, Mangesh Vimay > wrote: > >> Hi, >> >> Thanks for the help. >> >> But, how to create data validations in the first sheet based on the >> list which you have retrieved by using code. >> >> Please help. >> >> On 7/6/13, vba wrote: >> > Hey >> > >> > PFA. >> > >> > HTH >> > >> > >> > On Sat, Jul 6, 2013 at 11:20 AM, Mangesh Vimay >> > wrote: >> > >> >> Hi Be Tran Van, >> >> >> >> Thank you for your quick help. >> >> >> >> However, in my original workbook there are total 1200 lists and its >> >> quite time consuming job to create named range for all 1200 lists and >> >> then to specify the source for all the lists for data validations. >> >> >> >> Could you please suggest shortcut way/method so that I can create >> >> named range for all and then drop down list using data validation. >> >> >> >> I think, we can use vlookup, vba code to specify the named range and >> >> then to create data validations. But how, I really don't know. >> >> >> >> Appreciate your help. >> >> >> >> Thanks again !!! >> >> >> >> Regards, >> >> >> >> Mangesh >> >> >> >> On 7/6/13, Bé Trần Văn wrote: >> >> > You select C3: C6 setting Name1, C7:C12 setting Name2, C13:C20 >> >> > setting >> >> > Name3. >> >> > >> >> > B2 Validation with Source = Name1 >> >> > B3 Validation with Source = Name2 >> >> > B4 Validation with Source = Name3 >> >> > >> >> > >> >> > >> >> > 2013/7/6 Mangesh Vimay >> >> > >> >> >> Hi Friends, >> >> >> >> >> >> I have attached Excel file for the reference. >> >> >> I am unable to create a list for each ID as there are such 1200 >> >> >> lists >> >> >> for many IDs. So I need formula or vba macro to create such drop >> >> >> down >> >> >> lists for every Id given in the column A so that I can select >> required >> >> >> option from the drop down list for every ID. Appreciate your help. >> >> >> >> >> >> Detailed explanation is given in the attached sheet. >> >> >> >> >> >> Please help. >> >> >> >> >> >> Thank a ton. >> >> >> >> >> >> With regards, >> >> >> >> >> >> *MaNgEsH* >> >> >> >> >> >> -- >> >> >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna >> >> >> be? >> >> It’s >> >> >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> >> >> https://www.facebook.com/discussexcel >> >> >> >> >> >> FORUM RULES >> >> >> >> >> >> 1) Use concise, accurate thread titles. Poor thread titles, like >> >> >> Please >> >> >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >> >> >> Advice >> >> >> will not get quick attention or may not be answered. >> >> >> 2) Don't post a question in the thread of another member. >> >> >> 3) Don't post questions regarding breaking or bypassing any >> >> >> security >> >> >> measure. >> >> >> 4) Acknowledge the responses you receive, good or bad. >> >> >> 5) Jobs posting is not allowed. >> >> >> 6) Sharing copyrighted material and their links is not allowed. >> >> >> >> >> >> NOTE : Don't ever post confidential data in a workbook. Forum >> >> >> owners >> >> and >> >> >> members are not responsible for any loss. >> >> >> --- >> >> >> You received this message because you are subscribed to the Google >> >> Groups >> >> >> "MS EXCEL AND VBA MACROS" group. >> >> >> To unsubscribe from this group and stop receiving emails from it, >> send >> >> an >> >> >> email to excel-macros+unsubscr...@googlegroups.com. >> >> >> To post to this group, send email to excel-macros@googlegroups.com. >> >> >> Visit this group at http://groups.google.com/group/excel-macros. >> >> >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> >> >> >> >> >> >> >> >> > >> >> > -- >> >> > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >> >> > It’s >> >> > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> >> > https://www.facebook.com/discussexcel >> >> > >> >> > FORUM RULES >> >> > >> >> > 1) Use concise, accurate thread titles. Poor thread titles, like >> Please >> >> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >> Advice >> >> will >> >> > not get quick attention or may not be answered. >> >> > 2) Don't post a question in the thread of another member. >> >> > 3) Don't post questions regarding breaking or bypassing any security >> >> > measure. >> >> > 4) Acknowledge the responses you receive, good or bad. >> >> > 5) Jobs posting is not allowed. >> >> > 6) Sharing copyrighted material and their links is not allowed. >> >> > >> >> > NOTE : Don't ever post confidential data in a workbook. Forum >>
Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists
Hi You dont have to create name, this will be created programatically for data in DATA sheet. Just copy paste B2 or drag down. Hoe Name is created by this Macro: First Data sheet is sort on the basis of ID; then unique ID is pasted in range J2 & downwards. Then Name is defined for each ID beginning with "_" Cheers!! On Sat, Jul 6, 2013 at 2:45 PM, Mangesh Vimay wrote: > Hi, > > Thanks for the help. > > But, how to create data validations in the first sheet based on the > list which you have retrieved by using code. > > Please help. > > On 7/6/13, vba wrote: > > Hey > > > > PFA. > > > > HTH > > > > > > On Sat, Jul 6, 2013 at 11:20 AM, Mangesh Vimay > > wrote: > > > >> Hi Be Tran Van, > >> > >> Thank you for your quick help. > >> > >> However, in my original workbook there are total 1200 lists and its > >> quite time consuming job to create named range for all 1200 lists and > >> then to specify the source for all the lists for data validations. > >> > >> Could you please suggest shortcut way/method so that I can create > >> named range for all and then drop down list using data validation. > >> > >> I think, we can use vlookup, vba code to specify the named range and > >> then to create data validations. But how, I really don't know. > >> > >> Appreciate your help. > >> > >> Thanks again !!! > >> > >> Regards, > >> > >> Mangesh > >> > >> On 7/6/13, Bé Trần Văn wrote: > >> > You select C3: C6 setting Name1, C7:C12 setting Name2, C13:C20 setting > >> > Name3. > >> > > >> > B2 Validation with Source = Name1 > >> > B3 Validation with Source = Name2 > >> > B4 Validation with Source = Name3 > >> > > >> > > >> > > >> > 2013/7/6 Mangesh Vimay > >> > > >> >> Hi Friends, > >> >> > >> >> I have attached Excel file for the reference. > >> >> I am unable to create a list for each ID as there are such 1200 lists > >> >> for many IDs. So I need formula or vba macro to create such drop down > >> >> lists for every Id given in the column A so that I can select > required > >> >> option from the drop down list for every ID. Appreciate your help. > >> >> > >> >> Detailed explanation is given in the attached sheet. > >> >> > >> >> Please help. > >> >> > >> >> Thank a ton. > >> >> > >> >> With regards, > >> >> > >> >> *MaNgEsH* > >> >> > >> >> -- > >> >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? > >> It’s > >> >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > >> >> https://www.facebook.com/discussexcel > >> >> > >> >> FORUM RULES > >> >> > >> >> 1) Use concise, accurate thread titles. Poor thread titles, like > >> >> Please > >> >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need > >> >> Advice > >> >> will not get quick attention or may not be answered. > >> >> 2) Don't post a question in the thread of another member. > >> >> 3) Don't post questions regarding breaking or bypassing any security > >> >> measure. > >> >> 4) Acknowledge the responses you receive, good or bad. > >> >> 5) Jobs posting is not allowed. > >> >> 6) Sharing copyrighted material and their links is not allowed. > >> >> > >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners > >> and > >> >> members are not responsible for any loss. > >> >> --- > >> >> You received this message because you are subscribed to the Google > >> Groups > >> >> "MS EXCEL AND VBA MACROS" group. > >> >> To unsubscribe from this group and stop receiving emails from it, > send > >> an > >> >> email to excel-macros+unsubscr...@googlegroups.com. > >> >> To post to this group, send email to excel-macros@googlegroups.com. > >> >> Visit this group at http://groups.google.com/group/excel-macros. > >> >> For more options, visit https://groups.google.com/groups/opt_out. > >> >> > >> >> > >> >> > >> > > >> > -- > >> > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? > >> > It’s > >> > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > >> > https://www.facebook.com/discussexcel > >> > > >> > FORUM RULES > >> > > >> > 1) Use concise, accurate thread titles. Poor thread titles, like > Please > >> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need > Advice > >> will > >> > not get quick attention or may not be answered. > >> > 2) Don't post a question in the thread of another member. > >> > 3) Don't post questions regarding breaking or bypassing any security > >> > measure. > >> > 4) Acknowledge the responses you receive, good or bad. > >> > 5) Jobs posting is not allowed. > >> > 6) Sharing copyrighted material and their links is not allowed. > >> > > >> > NOTE : Don't ever post confidential data in a workbook. Forum owners > >> > and > >> > members are not responsible for any loss. > >> > --- > >> > You received this message because you are subscribed to the Google > >> > Groups > >> > "MS EXCEL AND VBA MACROS" group. > >> > To unsubscribe from this group and stop receiving emails from it, send > >> > an > >> > email to excel-macros+unsubscr...@
Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists
Hi, Thanks for the help. But, how to create data validations in the first sheet based on the list which you have retrieved by using code. Please help. On 7/6/13, vba wrote: > Hey > > PFA. > > HTH > > > On Sat, Jul 6, 2013 at 11:20 AM, Mangesh Vimay > wrote: > >> Hi Be Tran Van, >> >> Thank you for your quick help. >> >> However, in my original workbook there are total 1200 lists and its >> quite time consuming job to create named range for all 1200 lists and >> then to specify the source for all the lists for data validations. >> >> Could you please suggest shortcut way/method so that I can create >> named range for all and then drop down list using data validation. >> >> I think, we can use vlookup, vba code to specify the named range and >> then to create data validations. But how, I really don't know. >> >> Appreciate your help. >> >> Thanks again !!! >> >> Regards, >> >> Mangesh >> >> On 7/6/13, Bé Trần Văn wrote: >> > You select C3: C6 setting Name1, C7:C12 setting Name2, C13:C20 setting >> > Name3. >> > >> > B2 Validation with Source = Name1 >> > B3 Validation with Source = Name2 >> > B4 Validation with Source = Name3 >> > >> > >> > >> > 2013/7/6 Mangesh Vimay >> > >> >> Hi Friends, >> >> >> >> I have attached Excel file for the reference. >> >> I am unable to create a list for each ID as there are such 1200 lists >> >> for many IDs. So I need formula or vba macro to create such drop down >> >> lists for every Id given in the column A so that I can select required >> >> option from the drop down list for every ID. Appreciate your help. >> >> >> >> Detailed explanation is given in the attached sheet. >> >> >> >> Please help. >> >> >> >> Thank a ton. >> >> >> >> With regards, >> >> >> >> *MaNgEsH* >> >> >> >> -- >> >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >> It’s >> >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> >> https://www.facebook.com/discussexcel >> >> >> >> FORUM RULES >> >> >> >> 1) Use concise, accurate thread titles. Poor thread titles, like >> >> Please >> >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >> >> Advice >> >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Jobs posting is not allowed. >> >> 6) Sharing copyrighted material and their links is not allowed. >> >> >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners >> and >> >> members are not responsible for any loss. >> >> --- >> >> You received this message because you are subscribed to the Google >> Groups >> >> "MS EXCEL AND VBA MACROS" group. >> >> To unsubscribe from this group and stop receiving emails from it, send >> an >> >> email to excel-macros+unsubscr...@googlegroups.com. >> >> To post to this group, send email to excel-macros@googlegroups.com. >> >> Visit this group at http://groups.google.com/group/excel-macros. >> >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> >> >> >> >> > >> > -- >> > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >> > It’s >> > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> > https://www.facebook.com/discussexcel >> > >> > FORUM RULES >> > >> > 1) Use concise, accurate thread titles. Poor thread titles, like Please >> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will >> > not get quick attention or may not be answered. >> > 2) Don't post a question in the thread of another member. >> > 3) Don't post questions regarding breaking or bypassing any security >> > measure. >> > 4) Acknowledge the responses you receive, good or bad. >> > 5) Jobs posting is not allowed. >> > 6) Sharing copyrighted material and their links is not allowed. >> > >> > NOTE : Don't ever post confidential data in a workbook. Forum owners >> > and >> > members are not responsible for any loss. >> > --- >> > You received this message because you are subscribed to the Google >> > Groups >> > "MS EXCEL AND VBA MACROS" group. >> > To unsubscribe from this group and stop receiving emails from it, send >> > an >> > email to excel-macros+unsubscr...@googlegroups.com. >> > To post to this group, send email to excel-macros@googlegroups.com. >> > Visit this group at http://groups.google.com/group/excel-macros. >> > For more options, visit https://groups.google.com/groups/opt_out. >> > >> > >> > >> >> >> -- >> With regards, >> >> *MaNgEsH* >> >> -- >> 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 >>
Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists
Hey PFA. HTH On Sat, Jul 6, 2013 at 11:20 AM, Mangesh Vimay wrote: > Hi Be Tran Van, > > Thank you for your quick help. > > However, in my original workbook there are total 1200 lists and its > quite time consuming job to create named range for all 1200 lists and > then to specify the source for all the lists for data validations. > > Could you please suggest shortcut way/method so that I can create > named range for all and then drop down list using data validation. > > I think, we can use vlookup, vba code to specify the named range and > then to create data validations. But how, I really don't know. > > Appreciate your help. > > Thanks again !!! > > Regards, > > Mangesh > > On 7/6/13, Bé Trần Văn wrote: > > You select C3: C6 setting Name1, C7:C12 setting Name2, C13:C20 setting > > Name3. > > > > B2 Validation with Source = Name1 > > B3 Validation with Source = Name2 > > B4 Validation with Source = Name3 > > > > > > > > 2013/7/6 Mangesh Vimay > > > >> Hi Friends, > >> > >> I have attached Excel file for the reference. > >> I am unable to create a list for each ID as there are such 1200 lists > >> for many IDs. So I need formula or vba macro to create such drop down > >> lists for every Id given in the column A so that I can select required > >> option from the drop down list for every ID. Appreciate your help. > >> > >> Detailed explanation is given in the attached sheet. > >> > >> Please help. > >> > >> Thank a ton. > >> > >> With regards, > >> > >> *MaNgEsH* > >> > >> -- > >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? > It’s > >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > >> https://www.facebook.com/discussexcel > >> > >> FORUM RULES > >> > >> 1) Use concise, accurate thread titles. Poor thread titles, like Please > >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > >> will not get quick attention or may not be answered. > >> 2) Don't post a question in the thread of another member. > >> 3) Don't post questions regarding breaking or bypassing any security > >> measure. > >> 4) Acknowledge the responses you receive, good or bad. > >> 5) Jobs posting is not allowed. > >> 6) Sharing copyrighted material and their links is not allowed. > >> > >> NOTE : Don't ever post confidential data in a workbook. Forum owners > and > >> members are not responsible for any loss. > >> --- > >> You received this message because you are subscribed to the Google > Groups > >> "MS EXCEL AND VBA MACROS" group. > >> To unsubscribe from this group and stop receiving emails from it, send > an > >> email to excel-macros+unsubscr...@googlegroups.com. > >> To post to this group, send email to excel-macros@googlegroups.com. > >> Visit this group at http://groups.google.com/group/excel-macros. > >> For more options, visit https://groups.google.com/groups/opt_out. > >> > >> > >> > > > > -- > > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > > https://www.facebook.com/discussexcel > > > > FORUM RULES > > > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will > > not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Jobs posting is not allowed. > > 6) Sharing copyrighted material and their links is not allowed. > > > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > > members are not responsible for any loss. > > --- > > You received this message because you are subscribed to the Google Groups > > "MS EXCEL AND VBA MACROS" group. > > To unsubscribe from this group and stop receiving emails from it, send an > > email to excel-macros+unsubscr...@googlegroups.com. > > To post to this group, send email to excel-macros@googlegroups.com. > > Visit this group at http://groups.google.com/group/excel-macros. > > For more options, visit https://groups.google.com/groups/opt_out. > > > > > > > > > -- > With regards, > > *MaNgEsH* > > -- > 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. > > NOT
Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists
Hi Be Tran Van, Thank you for your quick help. However, in my original workbook there are total 1200 lists and its quite time consuming job to create named range for all 1200 lists and then to specify the source for all the lists for data validations. Could you please suggest shortcut way/method so that I can create named range for all and then drop down list using data validation. I think, we can use vlookup, vba code to specify the named range and then to create data validations. But how, I really don't know. Appreciate your help. Thanks again !!! Regards, Mangesh On 7/6/13, Bé Trần Văn wrote: > You select C3: C6 setting Name1, C7:C12 setting Name2, C13:C20 setting > Name3. > > B2 Validation with Source = Name1 > B3 Validation with Source = Name2 > B4 Validation with Source = Name3 > > > > 2013/7/6 Mangesh Vimay > >> Hi Friends, >> >> I have attached Excel file for the reference. >> I am unable to create a list for each ID as there are such 1200 lists >> for many IDs. So I need formula or vba macro to create such drop down >> lists for every Id given in the column A so that I can select required >> option from the drop down list for every ID. Appreciate your help. >> >> Detailed explanation is given in the attached sheet. >> >> Please help. >> >> Thank a ton. >> >> With regards, >> >> *MaNgEsH* >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will > not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- With regards, *MaNgEsH* -- 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...@
$$Excel-Macros$$ To create drop down list for many IDs as per many lists
Hi Friends, I have attached Excel file for the reference. I am unable to create a list for each ID as there are such 1200 lists for many IDs. So I need formula or vba macro to create such drop down lists for every Id given in the column A so that I can select required option from the drop down list for every ID. Appreciate your help. Detailed explanation is given in the attached sheet. Please help. Thank a ton. With regards, *MaNgEsH* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. DropDownList.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
