Simply Great !!! Could you please share final workbook.
Sorry, for this. Thanks a ton !!! On 7/6/13, vba <v...@vabs.in> 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 > <mangesh.da...@gmail.com>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 <v...@vabs.in> wrote: >> > Hey >> > >> > PFA. >> > >> > HTH >> > >> > >> > On Sat, Jul 6, 2013 at 11:20 AM, Mangesh Vimay >> > <mangesh.da...@gmail.com>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 <betnmtdongna...@gmail.com> 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 <mangesh.da...@gmail.com> >> >> > >> >> >> 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...@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...@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...@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.
