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 mangesh.da...@gmail.comwrote: 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
$$Excel-Macros$$ Required editable maps in Excel
Hi Friends, I required editable map of EMEA Region or atleast by Continents in excel. With Regards, Putta Madaiah -- 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.
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 v...@vabs.in wrote: Hey PFA. HTH On Sat, Jul 6, 2013 at 11:20 AM, Mangesh Vimay mangesh.da...@gmail.comwrote: 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 :
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 mangesh.da...@gmail.comwrote: 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.comwrote: 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 @
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 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.comwrote: 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.comwrote: 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,
Re: $$Excel-Macros$$ required Result on Conditions
From: Rakesh Kumar Sharma rakeshks@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Thursday, 4 July 2013 11:42 AM Subject: $$Excel-Macros$$ required Result on Conditions Dear Experts, I want Result on conditions. Pls find the attachment. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- 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. Copy of Query2.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
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 ravi_colw...@yahoo.com 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 mangesh.da...@gmail.com wrote: From: Mangesh Vimay mangesh.da...@gmail.com 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 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
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 mangesh.da...@gmail.comwrote: 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 ravi_colw...@yahoo.com 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 mangesh.da...@gmail.com wrote: From: Mangesh Vimay mangesh.da...@gmail.com 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 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* --
Re: $$Excel-Macros$$ Validation through Macro!!!
Hi Indrajit, You have asked something diff.. PFA sheet where i have set restrictions for few cases.. I hope you can manage show for rest cases.. Let me know if you need further help. How it works: Set min max value in sheet 1 error message . As soon as you select any cell in sheet 2, cell will display Guidelines as entered in sheet 1 will apply restrictions too with error message. Cheers!! On Mon, Jul 1, 2013 at 12:21 AM, Indrajit $nai talk2indra...@gmail.comwrote: Hi All, PFA. I want to create the validation through Macro, can the EXPERTS help me on this? Requirement is on the 1st sheet and the Table data is on the 2nd sheet. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- 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. Validation help.xlsb Description: Binary data
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 v...@vabs.in wrote: Thanks for Acknowledgement.. Cheers!! On Sat, Jul 6, 2013 at 5:50 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: 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 ravi_colw...@yahoo.com 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 mangesh.da...@gmail.com wrote: From: Mangesh Vimay mangesh.da...@gmail.com 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 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$$ Creating a personalized data form (VBA/Macros) - To add, retrieve, modify delete info
I find it very easy to create forms that allow you to enter information. Creating a form that generates reports or a form that retrieves profiles or information is another story... I want a main form that is always opened (I've seen the codes for this before, not a major issue) and I want it to act as a main interface. As a lot of information will be added and modified constantly, I simply want users to also be able to use the form to retrieve our clients profiles (a profile = a row of information). Perhaps I could have a search button, as well as a Enter New info, or modify... The last thing, generating reports, would not be part of the main form. Other buttons placed on the first sheet would generate reports in the second sheet (or third if the second is used as a database?) allowing users to print or save those reports for zillion purposes. Should I be using conditional formatting in macros? This is where my knowledge goes a FVKQ#)$. perhaps somebody out there could help me? Many thanks, AdR -- 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.
Re: $$Excel-Macros$$ Autofilter criteria
Hi All, Please assist with Auto filter Here the data is limited only few lines as sample i have given. but in reality data will more two lac lines .. can you please place even if data rows count increases. i tried for vlookup like dis Range(F2).Select ActiveCell.FormulaR1C1 = =VLOOKUP(RC[-5],CCLIST,5,0) Selection.AutoFill Destination:=Range(F2:F Cells(Rows.Count, A).End(xlUp).Row) can you please advise how can i replicate same to autofilter Sub Anil() ActiveSheet.Range($A$1:$H$47).AutoFilter Field:=4, Criteria1:==ROY*, _ Operator:=xlOr, Criteria2:==ROD* ActiveSheet.Range($A$1:$H$47).AutoFilter Field:=7, Criteria1:=0, _ Operator:=xlAnd Range(H2).Select Range(H2).Value = Updated Range(H2).Select Selection.Copy Range(H4:H46).Select Selection.SpecialCells(xlCellTypeVisible).Select ActiveSheet.Paste Range(A1).Select Application.CutCopyMode = False End Sub Thanks, Rekha On Fri, Jun 28, 2013 at 11:57 AM, अनिल नारायण गवली gawlianil8...@gmail.comwrote: Dear Rekha, Pl see the attached workbook. Warm Regards, Gawli Anil On Fri, Jun 28, 2013 at 10:36 AM, rekha siri rekha.siri2...@gmail.comwrote: Hi Experts, Please help in this concern i am attaching sample data spread from Column A TO H in H Column i want to update Status as per below criteria 1) Filter Reference column -- custom filter -- Begins with ROD OR Begins with ROY Update the Status as Excluded for visible cells in Column H 2) Filter Reference column -- custom filter -- Begins with ROD OR Begins with ROY andapply filter in G column as select values greater than 0 Update the Status as Defined for visible cells in Column H . I am placing sample data for around 100 line items , data may have more than 1lac records. Thanks, Rekha -- 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. -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- 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.
Re: $$Excel-Macros$$ SAVE As file name
Hi, Paste the code in a module and try to execute again. I will attach the working excel if possible. Thanks -- 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.
Re: $$Excel-Macros$$ i want fix the given value in the rows
Thanks sir it working what i am expecting . Thanks with mothilal On Sat, Jul 6, 2013 at 2:50 PM, ravinder negi ravi_colw...@yahoo.comwrote: PFA,...please advise if any changes needed. --- On *Sat, 7/6/13, jmothilal gjmothi...@gmail.com* wrote: From: jmothilal gjmothi...@gmail.com Subject: Re: $$Excel-Macros$$ i want fix the given value in the rows To: excel-macros@googlegroups.com Date: Saturday, July 6, 2013, 10:18 AM already file attached , anyway again i attached once again Thanks with Mothilal On Fri, Jul 5, 2013 at 9:38 PM, ashish koul koul.ash...@gmail.comhttp://mc/compose?to=koul.ash...@gmail.com wrote: is working days linked with any sheet. what will be the source for working days On Fri, Jul 5, 2013 at 5:32 PM, jmothilal gjmothi...@gmail.comhttp://mc/compose?to=gjmothi...@gmail.com wrote: Dear Any one, i want fix the given value in the rows ( i am changing working days based on month) file attached -- *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex :Otteri, Vellore-2* -- 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.comhttp://mc/compose?to=excel-macros%2bunsubscr...@googlegroups.com . To post to this group, send email to excel-macros@googlegroups.comhttp://mc/compose?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. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.comhttp://mc/compose?to=excel-macros%2bunsubscr...@googlegroups.com . To post to this group, send email to excel-macros@googlegroups.comhttp://mc/compose?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. -- *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex :Otteri, Vellore-2* -- 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