Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.
Dear Noorain, Can you please elaborate the funtion! Thanks in advance. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: NOORAIN ANSARI noorain.ans...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 16 Jul 2013 17:37:03 To: excel-macros@googlegroups.comexcel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ. Dear Ashish, Please try it.. =VLOOKUP(I2,CHOOSE(*{1,2,3,4,5,6}* ,$A$2:$A$7,$B$2:$B$7,$C$2:$C$7,$D$2:$D$7,$E$2:$E$7),*{2,4,5,3,6}*,0) with CSE Note : Red Color is use for Index No. of Choose Function and green Color is Columns Index no. of data On Tue, Jul 16, 2013 at 5:20 PM, Ashish Kumar kumar.ashish...@gmail.comwrote: Dear Seniors, kindly find attached vlookup query, I want get output thru vlookup choose function. please help me on this query and please explain me why we use {1,2,3,4,} in formula. Thanks in advance. Thanks Ashish -- 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, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/ -- 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
Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.
Dear All, My question is also the same why we are using choose funtion here! If any one please explain the same then will be very thankful. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Kanwaljit Singh Dhunna kanwal...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 16 Jul 2013 19:46:02 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ. Dear Ashish, Still Curious to know why do you use Choose here ? On Tue, Jul 16, 2013 at 7:40 PM, Ashish Kumar kumar.ashish...@gmail.comwrote: Dear Seniors, Formula is working fine. Thanks for your help and support specially Noorain Sir, Kuldeep Sir and kanwaljit sir. Thanks Ashish On Tuesday, July 16, 2013 7:26:49 PM UTC+5:30, kanwal_no1 wrote: As told by Kuldeep Ji with a small change, which might be causing trouble for you. First : Select 4 Rows like : J, K, L, M Paste this formula *=VLOOKUP(** $**I2,CHOOSE({1,2,3,4,5,6},$A$2:$A$7,$B$2:$B$7,$C$2:$C$7,$D$2:$D$7,$E$2:$E$7),{2,4,5,3,6},0) Press Ctrl + Shift + Enter then select J2:M20 **Drag formula like Ctrl + D. It's working fine.* BTW what is the issue in choosing simple Vlookup here ? On Tue, Jul 16, 2013 at 7:10 PM, Ashish Kumar kumar.a...@gmail.comwrote: Dear Seniors, Thanks for your help, but again i'hve geting same error. querry attached please find. and help me to crack the query. I'hve getting wrigh output when i put the formula in Name Column, but when i paste the same formula in rest of fields like address, process, salary...!! the formula is not working and I'hve use this formula with CSE. Please suggest me, how i am resolve this. Thanks Ashish On Tuesday, July 16, 2013 6:49:40 PM UTC+5:30, Kuldeep Singh wrote: Hi Ashish, Formula is working fine. Please find the attachment. *Use formula with Ctrl + Shift + Enter (Select All Rows Press Ctrl + Shift + Enter).* Regards, Kuldeep Singh Assistant Manager Quality Game Zone India Limited Phone.: +91-9716615535 || naukri...@gmail.com || *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Tue, Jul 16, 2013 at 6:42 PM, Ashish Kumar kumar.a...@gmail.comwrote: Dear Seniors, Data Getting Error..please find the attached sheet for refrence. Thanks Ashish On Tuesday, July 16, 2013 5:37:03 PM UTC+5:30, NOORAIN ANSARI wrote: Dear Ashish, Please try it.. =VLOOKUP(I2,CHOOSE(*{1,2,3,4,5,6}*,$A$2:$A$7,$B$2:$B$7,$C$2:$**C $7,$D$2:$D$7,$E$2:$E$7),*{2,4,5,3,6}*,0) with CSE Note : Red Color is use for Index No. of Choose Function and green Color is Columns Index no. of data On Tue, Jul 16, 2013 at 5:20 PM, Ashish Kumar kumar.a...@gmail.comwrote: Dear Seniors, kindly find attached vlookup query, I want get output thru vlookup choose function. please help me on this query and please explain me why we use {1,2,3,4,} in formula. Thanks in advance. Thanks Ashish -- 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/**discussexcelhttps://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...@**googlegroups.**c**om. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/**group /excel-macros http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/**grou ps/opt_out https://groups.google.com/groups/opt_out. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/ -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/**discu**ssexcelhttps://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread
Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.
Thanks Noorain Bhai and Kuldeep Bhai for the explanation. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: NOORAIN ANSARI noorain.ans...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 16 Jul 2013 20:08:00 To: excel-macros@googlegroups.comexcel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ. Dear Sandeep, Your question is correct, why we are using choose function, because it is possible through only vlookup Function, no need to using choose Function. But As per Question of Mr. Ashish Kumar, He want to use Choose function with Vlookup. We often use Choose function with vlookup to extract left side value, although it is also Possible through.. Index, Offset, Lookup and Indirect function. Hope you will understand, we used Choose function as per user requirement. On Tue, Jul 16, 2013 at 7:51 PM, chhajersand...@gmail.com wrote: ** Dear All, My question is also the same why we are using choose funtion here! If any one please explain the same then will be very thankful. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- *From: * Kanwaljit Singh Dhunna kanwal...@gmail.com *Sender: * excel-macros@googlegroups.com *Date: *Tue, 16 Jul 2013 19:46:02 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ. Dear Ashish, Still Curious to know why do you use Choose here ? On Tue, Jul 16, 2013 at 7:40 PM, Ashish Kumar kumar.ashish...@gmail.comwrote: Dear Seniors, Formula is working fine. Thanks for your help and support specially Noorain Sir, Kuldeep Sir and kanwaljit sir. Thanks Ashish On Tuesday, July 16, 2013 7:26:49 PM UTC+5:30, kanwal_no1 wrote: As told by Kuldeep Ji with a small change, which might be causing trouble for you. First : Select 4 Rows like : J, K, L, M Paste this formula *=VLOOKUP(* *$**I2,CHOOSE({1,2,3,4,5,6},$A$2:$A$7,$B$2:$ B$7,$C$2:$C$7,$D$2:$D$7,$E$2:$E$7),{2,4,5,3,6},0) Press Ctrl + Shift + Enter then select J2:M20 **Drag formula like Ctrl + D. It's working fine.* BTW what is the issue in choosing simple Vlookup here ? On Tue, Jul 16, 2013 at 7:10 PM, Ashish Kumar kumar.a...@gmail.comwrote: Dear Seniors, Thanks for your help, but again i'hve geting same error. querry attached please find. and help me to crack the query. I'hve getting wrigh output when i put the formula in Name Column, but when i paste the same formula in rest of fields like address, process, salary...!! the formula is not working and I'hve use this formula with CSE. Please suggest me, how i am resolve this. Thanks Ashish On Tuesday, July 16, 2013 6:49:40 PM UTC+5:30, Kuldeep Singh wrote: Hi Ashish, Formula is working fine. Please find the attachment. *Use formula with Ctrl + Shift + Enter (Select All Rows Press Ctrl + Shift + Enter).* Regards, Kuldeep Singh Assistant Manager Quality Game Zone India Limited Phone.: +91-9716615535 || naukri...@gmail.com || *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Tue, Jul 16, 2013 at 6:42 PM, Ashish Kumar kumar.a...@gmail.comwrote: Dear Seniors, Data Getting Error..please find the attached sheet for refrence. Thanks Ashish On Tuesday, July 16, 2013 5:37:03 PM UTC+5:30, NOORAIN ANSARI wrote: Dear Ashish, Please try it.. =VLOOKUP(I2,CHOOSE(*{1,2,3,4,5,6}*,$A$2:$A$7,$B$2:$B$7,$C$2:$**C $7,$D$2:$D$7,$E$2:$E$7),*{2,4,5,3,6}*,0) with CSE Note : Red Color is use for Index No. of Choose Function and green Color is Columns Index no. of data On Tue, Jul 16, 2013 at 5:20 PM, Ashish Kumar kumar.a...@gmail.comwrote: Dear Seniors, kindly find attached vlookup query, I want get output thru vlookup choose function. please help me on this query and please explain me why we use {1,2,3,4,} in formula. Thanks in advance. Thanks Ashish -- 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/**discussexcelhttps://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
Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range!
Please if any one know the reason and solution for this revert back!! Sandeep Sent on my BlackBerry® from Vodafone -Original Message- From: chhajersand...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 1 Jul 2013 04:37:25 To: excel-macrosexcel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Dependent Data validation with Dynamic name range! Dear Excel expert! I am stuck at a point! I have kept five dynamic name range using offset funtion viz Grouping which has a component like liabilities, asset, income and expenses. And also have created dynamic name range for all of the components! My name range are working perfectly when I am using it in data validation separately but it stops working when I am trying to make a dependent Data validation using indirect funtion! (though all is working perfectly when I am keeping all the dynamic name range into fixed range!!!) Pls help! Sandeep Sent on my BlackBerry® from Vodafone -- 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.
Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range!
Thanks Vabs. pls find the excel file! Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Vabs VBA v...@vabs.in Sender: excel-macros@googlegroups.com Date: Mon, 1 Jul 2013 12:52:50 To: excel-macros@googlegroups.comexcel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range! Hi Pl share youe excel file. Thanks On Mon, Jul 1, 2013 at 10:07 AM, chhajersand...@gmail.com wrote: Dear Excel expert! I am stuck at a point! I have kept five dynamic name range using offset funtion viz Grouping which has a component like liabilities, asset, income and expenses. And also have created dynamic name range for all of the components! My name range are working perfectly when I am using it in data validation separately but it stops working when I am trying to make a dependent Data validation using indirect funtion! (though all is working perfectly when I am keeping all the dynamic name range into fixed range!!!) Pls help! Sandeep Sent on my BlackBerry® from Vodafone -- 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. -- 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$$ Dependent Data validation with Dynamic name range!
Pls ignore the previous mail and find the attached file here! Sandeep. Sent on my BlackBerry® from Vodafone -Original Message- From: Vabs VBA v...@vabs.in Sender: excel-macros@googlegroups.com Date: Mon, 1 Jul 2013 12:52:50 To: excel-macros@googlegroups.comexcel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range! Hi Pl share youe excel file. Thanks On Mon, Jul 1, 2013 at 10:07 AM, chhajersand...@gmail.com wrote: Dear Excel expert! I am stuck at a point! I have kept five dynamic name range using offset funtion viz Grouping which has a component like liabilities, asset, income and expenses. And also have created dynamic name range for all of the components! My name range are working perfectly when I am using it in data validation separately but it stops working when I am trying to make a dependent Data validation using indirect funtion! (though all is working perfectly when I am keeping all the dynamic name range into fixed range!!!) Pls help! Sandeep Sent on my BlackBerry® from Vodafone -- 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. -- 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. Example.xlsx Description: Binary data
Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range!
Hi, Vabs, Actually I have created name range Assets with formula like =(Input!$B$2:$B:$6 ) and another name range i.e. Assets1 with formula =offset(input!$B$2,0,0,counta($B:$B)-1,1) So in second case I.e in Dataval dynamic sheet I have tried to use 'Assets1' as name range instead of 'Assets' as name range. As I wanted to use dependent dynamic Data validation. When I am using Asset (fixed name range) it is working but it stops working when I am using Assets1 (dynamic name range). I want it to be dynamic. Kindly suggest solution accordingly. Thanks. Sandeep. Sent on my BlackBerry® from Vodafone -Original Message- From: Vabs VBA v...@vabs.in Sender: excel-macros@googlegroups.com Date: Mon, 1 Jul 2013 15:24:40 To: excel-macros@googlegroups.comexcel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range! Hi PFA. Reason for not working: Defined names referred name had miss-match. EG. Name has been defined as Assests how ever you was referring to Assets1. Cheers!! On Mon, Jul 1, 2013 at 2:53 PM, chhajersand...@gmail.com wrote: ** Pls ignore the previous mail and find the attached file here! Sandeep. Sent on my BlackBerry® from Vodafone -- *From: * Vabs VBA v...@vabs.in *Sender: * excel-macros@googlegroups.com *Date: *Mon, 1 Jul 2013 12:52:50 +0530 *To: *excel-macros@googlegroups.comexcel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range! Hi Pl share youe excel file. Thanks On Mon, Jul 1, 2013 at 10:07 AM, chhajersand...@gmail.com wrote: Dear Excel expert! I am stuck at a point! I have kept five dynamic name range using offset funtion viz Grouping which has a component like liabilities, asset, income and expenses. And also have created dynamic name range for all of the components! My name range are working perfectly when I am using it in data validation separately but it stops working when I am trying to make a dependent Data validation using indirect funtion! (though all is working perfectly when I am keeping all the dynamic name range into fixed range!!!) Pls help! Sandeep Sent on my BlackBerry® from Vodafone -- 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. -- 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$$ Dependent Data validation with Dynamic name range!
Any Help in this regard! Any suggestion will be welcomed! Sandeep. Sent on my BlackBerry® from Vodafone -Original Message- From: chhajersand...@gmail.com Date: Mon, 1 Jul 2013 10:39:12 To: excel-macrosexcel-macros@googlegroups.com Reply-To: chhajersand...@gmail.com Subject: Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range! Hi, Vabs, Actually I have created name range Assets with formula like =(Input!$B$2:$B:$6 ) and another name range i.e. Assets1 with formula =offset(input!$B$2,0,0,counta($B:$B)-1,1) So in second case I.e in Dataval dynamic sheet I have tried to use 'Assets1' as name range instead of 'Assets' as name range. As I wanted to use dependent dynamic Data validation. When I am using Asset (fixed name range) it is working but it stops working when I am using Assets1 (dynamic name range). I want it to be dynamic. Kindly suggest solution accordingly. Thanks. Sandeep. Sent on my BlackBerry® from Vodafone -Original Message- From: Vabs VBA v...@vabs.in Sender: excel-macros@googlegroups.com Date: Mon, 1 Jul 2013 15:24:40 To: excel-macros@googlegroups.comexcel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range! Hi PFA. Reason for not working: Defined names referred name had miss-match. EG. Name has been defined as Assests how ever you was referring to Assets1. Cheers!! On Mon, Jul 1, 2013 at 2:53 PM, chhajersand...@gmail.com wrote: ** Pls ignore the previous mail and find the attached file here! Sandeep. Sent on my BlackBerry® from Vodafone -- *From: * Vabs VBA v...@vabs.in *Sender: * excel-macros@googlegroups.com *Date: *Mon, 1 Jul 2013 12:52:50 +0530 *To: *excel-macros@googlegroups.comexcel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range! Hi Pl share youe excel file. Thanks On Mon, Jul 1, 2013 at 10:07 AM, chhajersand...@gmail.com wrote: Dear Excel expert! I am stuck at a point! I have kept five dynamic name range using offset funtion viz Grouping which has a component like liabilities, asset, income and expenses. And also have created dynamic name range for all of the components! My name range are working perfectly when I am using it in data validation separately but it stops working when I am trying to make a dependent Data validation using indirect funtion! (though all is working perfectly when I am keeping all the dynamic name range into fixed range!!!) Pls help! Sandeep Sent on my BlackBerry® from Vodafone -- 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
Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range!
Thanks is there any other way out! Table not worked in lower version 97-2003. Sandeep Sent on my BlackBerry® from Vodafone -Original Message- From: Vabs VBA v...@vabs.in Sender: excel-macros@googlegroups.com Date: Mon, 1 Jul 2013 19:26:21 To: excel-macros@googlegroups.comexcel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range! Hi In data validation indirect function doesnt work when you you refer to volatile data. You can create a table to accommodate your data. PFA. Thanks On Mon, Jul 1, 2013 at 6:53 PM, chhajersand...@gmail.com wrote: ** Any Help in this regard! Any suggestion will be welcomed! Sandeep. Sent on my BlackBerry® from Vodafone -- *From: * chhajersand...@gmail.com *Date: *Mon, 1 Jul 2013 10:39:12 + *To: *excel-macrosexcel-macros@googlegroups.com *ReplyTo: * chhajersand...@gmail.com *Subject: *Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range! Hi, Vabs, Actually I have created name range Assets with formula like =(Input!$B$2:$B:$6 ) and another name range i.e. Assets1 with formula =offset(input!$B$2,0,0,counta($B:$B)-1,1) So in second case I.e in Dataval dynamic sheet I have tried to use 'Assets1' as name range instead of 'Assets' as name range. As I wanted to use dependent dynamic Data validation. When I am using Asset (fixed name range) it is working but it stops working when I am using Assets1 (dynamic name range). I want it to be dynamic. Kindly suggest solution accordingly. Thanks. Sandeep. Sent on my BlackBerry® from Vodafone -- *From: * Vabs VBA v...@vabs.in *Sender: * excel-macros@googlegroups.com *Date: *Mon, 1 Jul 2013 15:24:40 +0530 *To: *excel-macros@googlegroups.comexcel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range! Hi PFA. Reason for not working: Defined names referred name had miss-match. EG. Name has been defined as Assests how ever you was referring to Assets1. Cheers!! On Mon, Jul 1, 2013 at 2:53 PM, chhajersand...@gmail.com wrote: ** Pls ignore the previous mail and find the attached file here! Sandeep. Sent on my BlackBerry® from Vodafone -- *From: * Vabs VBA v...@vabs.in *Sender: * excel-macros@googlegroups.com *Date: *Mon, 1 Jul 2013 12:52:50 +0530 *To: *excel-macros@googlegroups.comexcel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range! Hi Pl share youe excel file. Thanks On Mon, Jul 1, 2013 at 10:07 AM, chhajersand...@gmail.com wrote: Dear Excel expert! I am stuck at a point! I have kept five dynamic name range using offset funtion viz Grouping which has a component like liabilities, asset, income and expenses. And also have created dynamic name range for all of the components! My name range are working perfectly when I am using it in data validation separately but it stops working when I am trying to make a dependent Data validation using indirect funtion! (though all is working perfectly when I am keeping all the dynamic name range into fixed range!!!) Pls help! Sandeep Sent on my BlackBerry® from Vodafone -- 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,
Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range!
Okay! I am not very proficient with VBA. If you pls help me out in this regard! Thanks Sandeep Sent on my BlackBerry® from Vodafone -Original Message- From: Vabs VBA v...@vabs.in Sender: excel-macros@googlegroups.com Date: Mon, 1 Jul 2013 21:12:36 To: excel-macros@googlegroups.comexcel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range! Pl ignore earlier try this Soln thru VBA. Thanks On Mon, Jul 1, 2013 at 8:41 PM, Vabs VBA v...@vabs.in wrote: Hi Weird but its working now. Thanks On Mon, Jul 1, 2013 at 7:30 PM, chhajersand...@gmail.com wrote: ** Thanks is there any other way out! Table not worked in lower version 97-2003. Sandeep Sent on my BlackBerry® from Vodafone -- *From: * Vabs VBA v...@vabs.in *Sender: * excel-macros@googlegroups.com *Date: *Mon, 1 Jul 2013 19:26:21 +0530 *To: *excel-macros@googlegroups.comexcel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range! Hi In data validation indirect function doesnt work when you you refer to volatile data. You can create a table to accommodate your data. PFA. Thanks On Mon, Jul 1, 2013 at 6:53 PM, chhajersand...@gmail.com wrote: ** Any Help in this regard! Any suggestion will be welcomed! Sandeep. Sent on my BlackBerry® from Vodafone -- *From: * chhajersand...@gmail.com *Date: *Mon, 1 Jul 2013 10:39:12 + *To: *excel-macrosexcel-macros@googlegroups.com *ReplyTo: * chhajersand...@gmail.com *Subject: *Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range! Hi, Vabs, Actually I have created name range Assets with formula like =(Input!$B$2:$B:$6 ) and another name range i.e. Assets1 with formula =offset(input!$B$2,0,0,counta($B:$B)-1,1) So in second case I.e in Dataval dynamic sheet I have tried to use 'Assets1' as name range instead of 'Assets' as name range. As I wanted to use dependent dynamic Data validation. When I am using Asset (fixed name range) it is working but it stops working when I am using Assets1 (dynamic name range). I want it to be dynamic. Kindly suggest solution accordingly. Thanks. Sandeep. Sent on my BlackBerry® from Vodafone -- *From: * Vabs VBA v...@vabs.in *Sender: * excel-macros@googlegroups.com *Date: *Mon, 1 Jul 2013 15:24:40 +0530 *To: *excel-macros@googlegroups.comexcel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range! Hi PFA. Reason for not working: Defined names referred name had miss-match. EG. Name has been defined as Assests how ever you was referring to Assets1. Cheers!! On Mon, Jul 1, 2013 at 2:53 PM, chhajersand...@gmail.com wrote: ** Pls ignore the previous mail and find the attached file here! Sandeep. Sent on my BlackBerry® from Vodafone -- *From: * Vabs VBA v...@vabs.in *Sender: * excel-macros@googlegroups.com *Date: *Mon, 1 Jul 2013 12:52:50 +0530 *To: *excel-macros@googlegroups.comexcel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range! Hi Pl share youe excel file. Thanks On Mon, Jul 1, 2013 at 10:07 AM, chhajersand...@gmail.com wrote: Dear Excel expert! I am stuck at a point! I have kept five dynamic name range using offset funtion viz Grouping which has a component like liabilities, asset, income and expenses. And also have created dynamic name range for all of the components! My name range are working perfectly when I am using it in data validation separately but it stops working when I am trying to make a dependent Data validation using indirect funtion! (though all is working perfectly when I am keeping all the dynamic name range into fixed range!!!) Pls help! Sandeep Sent on my BlackBerry® from Vodafone -- 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
$$Excel-Macros$$ Dependent Data validation with Dynamic name range!
Dear Excel expert! I am stuck at a point! I have kept five dynamic name range using offset funtion viz Grouping which has a component like liabilities, asset, income and expenses. And also have created dynamic name range for all of the components! My name range are working perfectly when I am using it in data validation separately but it stops working when I am trying to make a dependent Data validation using indirect funtion! (though all is working perfectly when I am keeping all the dynamic name range into fixed range!!!) Pls help! Sandeep Sent on my BlackBerry® from Vodafone -- 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$$ Want to add every third row or coloumn!
Dear Noorain, Thanks for the reply but can we do it by using function. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: NOORAIN ANSARI noorain.ans...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 4 Jun 2013 12:26:53 To: excel-macros@googlegroups.comexcel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Want to add every third row or coloumn! Dear Sandeep, Select required range and run this code... Sub InsertSpecificRows() Dim InsQuan As Integer On Error Resume Next InsQuan = InputBox(Enter number of rows to insert, Your Call) If InsQuan = 0 Then MsgBox Invalid number entered, vbCritical, Stop! Exit Sub End If Application.ScreenUpdating = False Do Until Selection.Value = ActiveCell.Offset(1, 0).Range(A1:A InsQuan).Select Selection.Insert Shift:=xlDown ActiveCell.Offset(InsQuan, 0).Select Loop [A1].Select Application.ScreenUpdating = True End Sub On Tue, Jun 4, 2013 at 9:51 AM, chhajersand...@gmail.com wrote: Dear expert, Many time I have to add every third or every forth or every second row or column etc...can you suggest a function which will ease my problem! Till now I am adding required cell one by one! Kindly help! Sandeep Sent on my BlackBerry® from Vodafone -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/ -- 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?hl=en. 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
$$Excel-Macros$$ Want to add every third row or coloumn!
Dear expert, Many time I have to add every third or every forth or every second row or column etc...can you suggest a function which will ease my problem! Till now I am adding required cell one by one! Kindly help! Sandeep Sent on my BlackBerry® from Vodafone -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$
How many alphabets are there? are there always 4 alphabets grouped together? And are always the alphabets in capital letter? Sandeep Sent on my BlackBerry® from Vodafone -Original Message- From: Vikas Bhosale vikin...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 3 Jun 2013 05:32:34 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Hi experts , I am beginner of excel. And I want to convert alphabet in number . Like. ABCD = 1234 A=1 B=2 C=3 D=4 E=5 F=6 G=7 H=8 I=9 J=0 In excel one cell there is ABCD I want to convert this alphabet in number like 1234 Other example: GJIA then need to convert in 7091 Please help me to solve this problem I use if conditions then concatenate but not get Wright. Answer and this process is very lengthy. Plz plz help me to solve this problem. Sent from my BlackBerry® Smartphone on Loop Mobile. -- 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?hl=en. 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Round off in multiple of 25 paise!
Dear Expert, I want a formula where decimal will rounded off in multiple of 0.25 paise. Like if amount is between 100.00 to 100.24 it will show 100.00. if amount is between 100.25 to 100.49 it will show 100.25. if amount is between 100.50 to 100.74 it will show 100.50. if amount is between 100.75 to 100.99 it will show 100.75. Thanks and regards, Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Round off in multiple of 25 paise!
Thank you very much Paul, Kanwaljit and Sam for your quick response. :) Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Sam Mathai Chacko samde...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 18 Apr 2013 00:13:35 To: MS EXCEL AND VBA MACROSexcel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Round off in multiple of 25 paise! And this one too =MROUND(A1-0.25/2,0.25) Regards, Sam Mathai Chacko On Wed, Apr 17, 2013 at 10:28 PM, Kanwaljit Singh kanwal...@gmail.comwrote: Much Better Paul :) On Wed, Apr 17, 2013 at 10:24 PM, Paul Schreiner schreiner_p...@att.netwrote: since you're rounding to .25, then you can simply multiply your number by 4, round it down to the lower integer, then multiply by 4.. =ROUNDDOWN(A1*4,0)/4 *Paul* - *“Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley *- -- *From:* chhajersand...@gmail.com chhajersand...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Wed, April 17, 2013 12:26:39 PM *Subject:* $$Excel-Macros$$ Round off in multiple of 25 paise! Dear Expert, I want a formula where decimal will rounded off in multiple of 0.25 paise. Like if amount is between 100.00 to 100.24 it will show 100.00. if amount is between 100.25 to 100.49 it will show 100.25. if amount is between 100.50 to 100.74 it will show 100.50. if amount is between 100.75 to 100.99 it will show 100.75. Thanks and regards, Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- 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?hl=en. 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 -- 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,
$$Excel-Macros$$ Date hour value problem!
Dear excel guru, I have a problem...I want my hour to be written as 4:45. But I entered 2 data as 4.45. Now if I am changing it to [h]:mm format through custom format I am getting 10:48 AM please help how can I convert it to 4.45 to 4:45. Thanking you. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Date hour value problem!
Thanks for quick suggestion but it is not full proof where there is only 8 is written it is not working. Again for strange reason where 2.30 was written after converting it become 2:03. Don't know why! Pls suggest! Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: The Viper viper@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 22 Feb 2013 15:48:08 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Date hour value problem! select the data and press ctrl+h put .(dot) in Find what and put : in Replace with click Replace all On Fri, Feb 22, 2013 at 3:41 PM, chhajersand...@gmail.com wrote: Dear excel guru, I have a problem...I want my hour to be written as 4:45. But I entered 2 data as 4.45. Now if I am changing it to [h]:mm format through custom format I am getting 10:48 AM please help how can I convert it to 4.45 to 4:45. Thanking you. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- 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?hl=en. 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?hl=en. 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Date hour value problem!
Thanks David its working correctly. Can you please explain ! :) Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: David Grugeon da...@grugeon.com.au Sender: excel-macros@googlegroups.com Date: Fri, 22 Feb 2013 21:30:49 To: excel-macros@googlegroups.comexcel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Date hour value problem! try this If the value is in B3 use then formula =(int(B3)+mod(B3,1)/.6)/24 then format as h:mm Regards David Grugeon On 22 February 2013 20:36, The Viper viper@gmail.com wrote: excel will not hold a value as 2.30 with full decimal(2). We can derive the desired result by formula if you intend. share us a sample file for more assistance On Fri, Feb 22, 2013 at 3:53 PM, chhajersand...@gmail.com wrote: ** Thanks for quick suggestion but it is not full proof where there is only 8 is written it is not working. Again for strange reason where 2.30 was written after converting it become 2:03. Don't know why! Pls suggest! Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- *From: * The Viper viper@gmail.com *Sender: * excel-macros@googlegroups.com *Date: *Fri, 22 Feb 2013 15:48:08 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Date hour value problem! select the data and press ctrl+h put .(dot) in Find what and put : in Replace with click Replace all On Fri, Feb 22, 2013 at 3:41 PM, chhajersand...@gmail.com wrote: Dear excel guru, I have a problem...I want my hour to be written as 4:45. But I entered 2 data as 4.45. Now if I am changing it to [h]:mm format through custom format I am getting 10:48 AM please help how can I convert it to 4.45 to 4:45. Thanking you. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- 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?hl=en. 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?hl=en. 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
Re: $$Excel-Macros$$ Date hour value problem!
Hey Paul, David thanks for your clarification. :) Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Paul Schreiner schreiner_p...@att.net Sender: excel-macros@googlegroups.com Date: Fri, 22 Feb 2013 04:59:54 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Date hour value problem! your explanation is CLOSE!! Excel date is the number of days since 1/1/1900 (or SINCE 31/12/1899, since 1/1/1900 is day (1) ) So, December 31, 1900 is actually day 366 (1900 was a Leap Year) And... I suppose if it was actually taken as the number of days since the beginning of TIME, We'd probably have to use an XLong Integer or even XXLong Integer when doing calculations! ;o) Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: David Grugeon da...@grugeon.com.au To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Fri, February 22, 2013 7:23:40 AM Subject: Re: $$Excel-Macros$$ Date hour value problem! OK A date/time value is a number of days since the beginning of time (31/12/1900 I think) Time is a fraction of a day. so i hour is 1/24 My formula was =(int(B3)+mod(B3,1)/.6)/24 Lets take a value entered as 4.15 which we want to represent as 4:15 or 4 hours and 15 minutes. Int(B3) gives us the 4 Mod(B3,1) gives us the 0.15 part this is equivalent to 15/100. However we want 15/60 so we divide it by 0.6 This gives 0.25. Add them together and we have 4.25 or 4 1/4 hours. Now divide by 24 to convert to days. So 4 hours 15 minutes since the beginning of time is expressed by the number. 0.1770833 or thereabouts. When we apply a time format h:mm to this it displays as 4:15. QED RegardsDavid Grugeon On 22 February 2013 21:30, David Grugeon da...@grugeon.com.au wrote: try this If the value is in B3 use then formula =(int(B3)+mod(B3,1)/.6)/24 then format as h:mm RegardsDavid Grugeon On 22 February 2013 20:36, The Viper viper@gmail.com wrote: excel will not hold a value as 2.30 with full decimal(2). We can derive the desired result by formula if you intend. share us a sample file for more assistance On Fri, Feb 22, 2013 at 3:53 PM, chhajersand...@gmail.com wrote: Thanks for quick suggestion but it is not full proof where there is only 8 is written it is not working. Again for strange reason where 2.30 was written after converting it become 2:03. Don't know why! Pls suggest! Sandeep Chhajer. Sent on my BlackBerry® from Vodafone From: The Viper viper@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 22 Feb 2013 15:48:08 +0530 To: excel-macros@googlegroups.com ReplyTo: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Date hour value problem! select the data and press ctrl+h put .(dot) in Find what and put : in Replace with click Replace all On Fri, Feb 22, 2013 at 3:41 PM, chhajersand...@gmail.com wrote: Dear excel guru, I have a problem...I want my hour to be written as 4:45. But I entered 2 data as 4.45. Now if I am changing it to [h]:mm format through custom format I am getting 10:48 AM please help how can I convert it to 4.45 to 4:45. Thanking you. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- 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?hl=en. 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
$$Excel-Macros$$ Want to copy 2nd sheet of all workbook in a particular folder
Dear excel guru, I want to copy only the 2nd sheet of the all workbooks from a particular folder. Please accordingly rectify the below mentioned code which I also got this forum. Option Explicit '32-bit API declarations DeclareFunction SHGetPathFromIDList Lib shell32.dll _Alias SHGetPathFromIDListA (ByVal pidl AsLong, ByVal _pszpath AsString) AsLong DeclareFunction SHBrowseForFolder Lib shell32.dll _Alias SHBrowseForFolderA (lpBrowseInfo AsBrowseInfo) _AsLong Public Type BrowseInfo hOwner AsLong pIDLRoot AsLong pszDisplayName AsString lpszTitle AsString ulFlags AsLong lpfn AsLong lParam AsLong iImage AsLongEnd Type FunctionGetDirectory(Optional msg) AsStringOn Error Resume Next Dim bInfo As BrowseInfoDim path AsStringDim r AsLong, x AsLong, pos AsInteger 'Root folder = Desktop bInfo.pIDLRoot = 0 'Title in the dialog IfIsMissing(msg) Then bInfo.lpszTitle = Please select the folder of the excel files to copy. Else bInfo.lpszTitle = msg EndIf 'Type of directory to return bInfo.ulFlags = H1 'Display the dialog x = SHBrowseForFolder(bInfo) 'Parse the result path = Space$(512) r = SHGetPathFromIDList(ByVal x, ByVal path)If r Then pos = InStr(path, Chr$(0)) GetDirectory = Left(path, pos - 1) Else GetDirectory = EndIf End Function SubCombineFiles()Dim path AsStringDimFileName AsStringDimLastCell As RangeDim Wkb As WorkbookDim WS As WorksheetDimThisWB AsString ThisWB = ThisWorkbook.Name Application.EnableEvents = False Application.ScreenUpdating = False path = GetDirectory FileName = Dir(path \*.xls, vbNormal) Do UntilFileName = If FileName ThisWB ThenSet Wkb = Workbooks.Open(FileName:=path \ FileName)For Each WS InWkb.WorksheetsSet LastCell = WS.Cells.SpecialCells(xlCellTypeLastCell) IfLastCell.Value = And LastCell.Address = Range($A$1).Address ThenElse WS.Copy After:=ThisWorkbook.Sheetst(ThisWorkbook.Sheets.Count) EndIf Next WS Wkb.Close FalseEndIf FileName = Dir() Loop Application.EnableEvents = True Application.ScreenUpdating = True Set Wkb = NothingSet LastCell = NothingEnd Sub Sent on my BlackBerry® from Vodafone -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: Merry Christmas Happy New Year *
Wish you all Merry Christmas!! Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: ashish koul koul.ash...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 25 Dec 2012 11:45:53 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Merry Christmas Happy New Year * *May joy and happiness snow on you, may the bells jingle for you and may Santa be extra good to you! Merry Christmas Everyone! * Regards Ashish On Tue, Dec 25, 2012 at 11:32 AM, resp...@gmail.com wrote: ** Merry Christmas Sent from my BlackBerry® smartphone from Airtel Ghana -- *From: * Lalit Mohan Pandey mohan.pande...@gmail.com *Sender: * excel-macros@googlegroups.com *Date: *Mon, 24 Dec 2012 22:00:48 -0800 (PST) *To: *excel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *$$Excel-Macros$$ Re: Merry Christmas Happy New Year * [image: Boxbe] https://www.boxbe.com/overview Automatic Cleanup: keep last 1 emails (mohan.pande...@gmail.com) Edit rulehttps://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DB69qPqG7RgIY9J5xfcyMGbV790l1bit8nq%252BFK5%252F%252F77j%252B5gKhcReTQy8vB2rNiAj337g212mcFA7m07d%252BWICIanQp%252Bdv0PAGAUC6hWpHcM3qFw9yi9AWBM9ip6sBLMuzQ0Ck4CuivGBvis%252BXGvXacIg%253D%253D%26key%3DZNQhiDQ1DYt%252FCpKNnQKwxvsJUgOvW0Tz3Tg3hfbjNGg%253Dtc=13201634953_1016389061| Delete rulehttps://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DB69qPqG7RgIY9J5xfcyMGbV790l1bit8nq%252BFK5%252F%252F77j%252B5gKhcReTQy8vB2rNiAj337g212mcFA7m07d%252BWICIanQp%252Bdv0PAGAUC6hWpHcM3qFw9yi9AWBM9ip6sBLMuzQ0Ck4CuivGBvis%252BXGvXacIg%253D%253D%26key%3DZNQhiDQ1DYt%252FCpKNnQKwxvsJUgOvW0Tz3Tg3hfbjNGg%253Dtc=13201634953_1016389061| Mark importanthttps://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DB69qPqG7RgIY9J5xfcyMGbV790l1bit8nq%252BFK5%252F%252F77j%252B5gKhcReTQy8vB2rNiAj337g212mcFA7m07d%252BWICIanQp%252Bdv0PAGAUC6hWpHcM3qFw9yi9AWBM9ip6sBLMuzQ0Ck4CuivGBvis%252BXGvXacIg%253D%253D%26key%3DZNQhiDQ1DYt%252FCpKNnQKwxvsJUgOvW0Tz3Tg3hfbjNGg%253D%26emlId%3D27910203524%26important%3Dtruetc=13201634953_1016389061 -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- 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
$$Excel-Macros$$ A token of Appreciation and gratitude!!!
Dear all, Since the day I have been to this group I am amazed with one thing what you guys are made of !!! Any time, from any where, we are sending you our daily problems; sometimes its out of real issues; some times it is out of our fantasy, but you people are always on your feet to help us!! This token of appreciation is for all who are solving our daily problems restlessly and relentlessly to make our life more simpler, organised and efficient!! I can't help but to appreciate those also whose simple or complex; real or fancy problems get the best out of our experts! I would like to thank Ayush bhai for giving such a wonderful group with bunch of experts and followers as a gift to the whole excel community! With special Thanks Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Fw: Fwd: $$Excel-Macros$$ Capture both the action check and uncheck
Sent on my BlackBerry® from Vodafone -Original Message- From: chhajersand...@gmail.com Date: Sat, 15 Dec 2012 07:12:15 To: excel-macros@googlegroups.com Reply-To: chhajersand...@gmail.com Subject: Re: Fwd: $$Excel-Macros$$ Capture both the action check and uncheck Dear Praveen, Thanks for the reply. Actually frankly speaking I don't have any file right now with me. But I can discuss the problem. I want to hide two rows with a click in check box. So by recording macro I am able to do that!! But now I want to unhide this two row when it uncheck the Check box which I am not able to do due to very minimal knowledge of macro. Hope I am able to explain my problem to you. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Pravin Gunjal isk1...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 15 Dec 2012 10:48:38 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Fwd: $$Excel-Macros$$ Capture both the action check and uncheck *Dear Sandeep* * * *Pl post the file...* * * *Regards* *Pravin Gunjal.* -- Forwarded message -- From: chhajersand...@gmail.com Date: Sat, Dec 15, 2012 at 10:43 AM Subject: $$Excel-Macros$$ Capture both the action check and uncheck To: excel-macros@googlegroups.com Dear Excel guru, I want to capture check box uncheck procedure! I have assigned a macro to check box! So when I click it, it works perfectly but now I want that when I untick it, it works differently from that! Please help! Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Capture both the action check and uncheck
Dear Excel guru, I want to capture check box uncheck procedure! I have assigned a macro to check box! So when I click it, it works perfectly but now I want that when I untick it, it works differently from that! Please help! Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: Fwd: $$Excel-Macros$$ Capture both the action check and uncheck
Dear Praveen, Thanks for the reply. Actually frankly speaking I don't have any file right now with me. But I can discuss the problem. I want to hide two rows with a click in check box. So by recording macro I am able to do that!! But now I want to unhide this two row when it uncheck the Check box which I am not able to do due to very minimal knowledge of macro. Hope I am able to explain my problem to you. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Pravin Gunjal isk1...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 15 Dec 2012 10:48:38 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Fwd: $$Excel-Macros$$ Capture both the action check and uncheck *Dear Sandeep* * * *Pl post the file...* * * *Regards* *Pravin Gunjal.* -- Forwarded message -- From: chhajersand...@gmail.com Date: Sat, Dec 15, 2012 at 10:43 AM Subject: $$Excel-Macros$$ Capture both the action check and uncheck To: excel-macros@googlegroups.com Dear Excel guru, I want to capture check box uncheck procedure! I have assigned a macro to check box! So when I click it, it works perfectly but now I want that when I untick it, it works differently from that! Please help! Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Fw: Data validation to stop copy from above or any where!!
Dear excel guru is there any way to make data validation effective in case the source data is copied from other source! (As I have observed that data validation would not work in case some data is copied from other source!!! Please help! Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: chhajersand...@gmail.com Date: Thu, 13 Dec 2012 06:31:01 To: Princeprince141...@gmail.com Reply-To: chhajersand...@gmail.com Subject: Re: Data validation to stop copy from above or any where!! Thanks prince for your quick reply but my problem is some here else. I want to insert IMEI number in e column. Now people have a tendency to copy the above if first 9 digit or more is equal in this way the some time due to unavoidable reason they forget to make the require change. Please help in this regard. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Prince prince141...@gmail.com Date: Wed, 12 Dec 2012 22:20:22 To: excel-macros@googlegroups.com Cc: chhajersand...@gmail.com Subject: Re: Data validation to stop copy from above or any where!! Hi Sandeep, whenever we copy any data from any source we are not sure about the spaces into the value. So i feel there may be the data item that you want not duplicate contain any space and making it another explicit value. So for avoiding above problem use Trim() fuction to remove the spaces. Regards Prince On Thursday, December 13, 2012 11:29:58 AM UTC+5:30, sandeep chhajer wrote: Dear Excel guru, I have tried this data validation to stop duplicate entry as well as : =and(countif($e$3:$e$500,e3)=1,len(e3)=15) Though when some is making manual entry its working fine but it stops working if someone copy from above or somewhere else. Can I do something to stop this!! Please help. Sent on my BlackBerry® from Vodafone -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Data validation to stop copy from above or any where!!
Dear Excel guru, I have tried this data validation to stop duplicate entry as well as : =and(countif($e$3:$e$500,e3)=1,len(e3)=15) Though when some is making manual entry its working fine but it stops working if someone copy from above or somewhere else. Can I do something to stop this!! Please help. Sent on my BlackBerry® from Vodafone -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Excell Sheet
I am also agree with paul. But for the 3rd question I want to add one sentence that you can select all the sheet using ctrl key that you want to hide and then use hide key to hide all the selected sheet together. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Paul Schreiner schreiner_p...@att.net Sender: excel-macros@googlegroups.com Date: Fri, 30 Nov 2012 04:32:25 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excell Sheet Here's the answers to your questions: 1.Can I sort the sheet in a A to Z order? (Without Macro) No, you cannot. There is no Excel function or menu selection for sorting sheets. It can only be done with a macro. 2.Can I unhide many sheet at one go.(Without Macro) No, you cannot. It can only be done with a macro. 3.Can I sort the sheet on colour base?(Without Macro) No, you cannot. Sheets can only be sorted with a macro. 4.How to clear the circular reference?(Without Macro) Actually, I don't know of any way to do this WITH a macro! Usually, when you get the Circular Reference message, the cells involved are highlighted. This should give you a clue as to which cells are causing the circular reference. Any menu-based assistance will depend on the version of Excel you are using. To start, from the warning message, click Help. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Shrinivas Shevde shrinivas...@gmail.com To: excel-macros@googlegroups.com Sent: Fri, November 30, 2012 6:29:25 AM Subject: $$Excel-Macros$$ Excell Sheet Dear All Can anyone answer following question? 1.I have a work book ahich is having many sheet and I am keep on adding sheet every month .Can I sort the sheet in a A to Z order? (Without Macro) 2.Can I unhide many sheet at one go.(Without Macro) 3.Can I sort the sheet on colour base?(Without Macro) 4How to clear the circular reference?(Without Macro) -- Shrini -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- 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$$ Re: Split a cell into multiple cells in Excel 2010
Dear Rakesh, Do you want a text to be divided into different column based on some operators? Then you can use Text to column to split a cell (read a cell containing text) to many cells (i.e. Columns). If this help is not sufficient then please share workbook with us as Anil bhai has suggested. Sandeep Kumar Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Rakesh Kumar Sharma rakeshks@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 21 Nov 2012 12:21:11 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Split a cell into multiple cells in Excel 2010 Hi Anil, Pls find the attached sample sheet. On Wed, Nov 21, 2012 at 11:53 AM, अनिल नारायण गवली gawlianil8...@gmail.comwrote: dear Rakesh, Pl specify you query to understand better.Or share a sample workbook with us Regards, Gawli Anil On Wed, Nov 21, 2012 at 11:47 AM, Prince prince141...@gmail.com wrote: Hi Rakesh, Do you want to split data of a cell into multiple cell or somthing else ??? Regards Prince. On Wednesday, November 21, 2012 11:43:59 AM UTC+5:30, rakesh sharma wrote: Hi experts, I want to split a cell to multiple cells. Pls help me. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- 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
Re: $$Excel-Macros$$ Required tutorials to learn Basics of DashBoards.
Thank you sir. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: NOORAIN ANSARI noorain.ans...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 8 Nov 2012 11:27:38 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Required tutorials to learn Basics of DashBoards. Dear Sandeep, Please find attached Dashboard tutorial pdf. Hope it will help to you. On Thu, Nov 8, 2012 at 10:23 AM, chhajersand...@gmail.com wrote: Dear Excel Gurus, Recently I have came to know about excel dashboard and its potential while presenting reports. Can any one send me some tutorials for the beginners like me. Thanking you in advance. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/ -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Required tutorials to learn Basics of DashBoards.
Dear Excel Gurus, Recently I have came to know about excel dashboard and its potential while presenting reports. Can any one send me some tutorials for the beginners like me. Thanking you in advance. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Change all the destination cell
Dear All, Suppose I have column of data which is linked with column d of another sheet. Like 'Sheet1!D5 'Sheet1!D6 'Sheet1!D7 'Sheet1!D8 'Sheet1!D9so on. Now I want the destination column of entire linked column to be changed to e like 'Sheet1!e5 'Sheet1!e6 'Sheet1!e7 'Sheet1!e8 'Sheet1!e9so on. Please help to change all this in one function. Sandeep Chhajer. 'Sheet1!e5 Sent on my BlackBerry® from Vodafone -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Macro for Insert and delete worksheets according the list in sheet1
Sent on my BlackBerry® from Vodafone -Original Message- From: ashish koul koul.ash...@gmail.com Sender: excel-macros@googlegroups.com Date: Sun, 7 Oct 2012 11:23:29 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Macro for Insert and delete worksheets according the list in sheet1 share the sample file On Sun, Oct 7, 2012 at 11:22 AM, chhajersand...@gmail.com wrote: Dear all, Good Morning. I want a macro which can create/ insert/ or delete worksheet according to the list prepared in sheet1. Like if I delete a name from the list the corresponding sheet will be deleted or if I insert a name in the list it will create a sheet with the same name. It will be better for me if the arrangement of the sheets are in the same arrangement the list is. Thanking you in advance. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. PLANNING.xlsx Description: Binary data
Re: $$Excel-Macros$$ Macro for Insert and delete worksheets according the list in sheet1
Thanks Swapnil. Its working fine. It will be beneficial to us if you may try to explain the code. :) Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Swapnil Palande palande.swapni...@gmail.com Sender: excel-macros@googlegroups.com Date: Sun, 7 Oct 2012 13:25:41 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Macro for Insert and delete worksheets according the list in sheet1 Hi, Attached is the solution excel. Hope this is what u want. Regards, Swapnil. On Sun, Oct 7, 2012 at 12:06 PM, chhajersand...@gmail.com wrote: ** Sent on my BlackBerry® from Vodafone -- *From: * ashish koul koul.ash...@gmail.com *Sender: * excel-macros@googlegroups.com *Date: *Sun, 7 Oct 2012 11:23:29 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Macro for Insert and delete worksheets according the list in sheet1 share the sample file On Sun, Oct 7, 2012 at 11:22 AM, chhajersand...@gmail.com wrote: Dear all, Good Morning. I want a macro which can create/ insert/ or delete worksheet according to the list prepared in sheet1. Like if I delete a name from the list the corresponding sheet will be deleted or if I insert a name in the list it will create a sheet with the same name. It will be better for me if the arrangement of the sheets are in the same arrangement the list is. Thanking you in advance. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message
Re: $$Excel-Macros$$ Macro for Insert and delete worksheets according the list in sheet1
Swapnil I am getting a problem when ever I am trying to change any of the sheet it is saying run time error 9 code out of range. Can it be fixed? Thanks in advance. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: chhajersand...@gmail.com Date: Sun, 7 Oct 2012 08:24:29 To: excel-macros@googlegroups.com Reply-To: chhajersand...@gmail.com Subject: Re: $$Excel-Macros$$ Macro for Insert and delete worksheets according the list in sheet1 Thanks Swapnil. Its working fine. It will be beneficial to us if you may try to explain the code. :) Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Swapnil Palande palande.swapni...@gmail.com Sender: excel-macros@googlegroups.com Date: Sun, 7 Oct 2012 13:25:41 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Macro for Insert and delete worksheets according the list in sheet1 Hi, Attached is the solution excel. Hope this is what u want. Regards, Swapnil. On Sun, Oct 7, 2012 at 12:06 PM, chhajersand...@gmail.com wrote: ** Sent on my BlackBerry® from Vodafone -- *From: * ashish koul koul.ash...@gmail.com *Sender: * excel-macros@googlegroups.com *Date: *Sun, 7 Oct 2012 11:23:29 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Macro for Insert and delete worksheets according the list in sheet1 share the sample file On Sun, Oct 7, 2012 at 11:22 AM, chhajersand...@gmail.com wrote: Dear all, Good Morning. I want a macro which can create/ insert/ or delete worksheet according to the list prepared in sheet1. Like if I delete a name from the list the corresponding sheet will be deleted or if I insert a name in the list it will create a sheet with the same name. It will be better for me if the arrangement of the sheets are in the same arrangement the list is. Thanking you in advance. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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
$$Excel-Macros$$ Macro for Insert and delete worksheets according the list in sheet1
Dear all, Good Morning. I want a macro which can create/ insert/ or delete worksheet according to the list prepared in sheet1. Like if I delete a name from the list the corresponding sheet will be deleted or if I insert a name in the list it will create a sheet with the same name. It will be better for me if the arrangement of the sheets are in the same arrangement the list is. Thanking you in advance. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Re: Introduce Yourself !!
My self Sandeep Chhajer from Mumbai. I am a Chartered Accountant by profession. This group has changed my perception of workingwith excel. I am really thankful to this group and its wonderful members. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Ayush Jain jainayus...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 2 Oct 2012 08:06:04 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Introduce Yourself !! Aamir, Amol, Johnson Vabs. Welcome to this group, I wish you great journey and lots of learning in this group. Keep posting ! Thanks. On Tuesday, 2 October 2012 10:17:17 UTC+5:30, Vabz wrote: Hey hii.. My self Vaibhav Joshi and online people call me vabz/vabs.. I am extremely lover of system automation.. MS Excel is one of my area of meditation love to help people because i love to feel that smile relief on the face when problem is solved... It gives me smile on my face when i see Macro running on my colleagues made by me which makes them go home early.. By profession I am commerce graduate In my early days of Work when I have been introduced to Excel, i tried learning excel function through F1(MS Office Help) option.. All my knowledge in to MS Excel is through online communities group help. One of my early day wish was to be MVP and definitely with the help of this group i will be able to achieve it.. See you then ...n keep Excelling Rocking... Cheerz.. Rgds//Vabs On Saturday, September 29, 2012 5:02:43 PM UTC+5:30, johnson wrote: Hellow Guys I am Johnson, Chartered Accountant working currently as a Finance Controller of a SChneider Group company. I am thankful to individual memberrs of this group as they helped me a lot in learning various advanced tricks of Excel which will help me in my day to day job. Thank you guys once again. You are smart!!! thanks Johnson On Sat, Sep 29, 2012 at 3:06 PM, Amol Shrivastava shri...@gmail.comwrote: Amol Shrivastava From Mumbai...!! On Sat, Sep 29, 2012 at 2:51 PM, Aamir Shahzad aamirsh...@gmail.comwrote: Hi Group, this is Aamir Shahzad from Karachi Pakistan, currently working as MIS Officer in a Bank. Love Excel learning. Aamir Shahzad On Sat, Sep 29, 2012 at 11:43 AM, Ayush Jain jaina...@gmail.comwrote: Good to know you all from this post, please keep this thread alive by introducing yourself. cheers. On Friday, 28 September 2012 06:45:07 UTC+5:30, reshma shri wrote: Hi I am Reshma, new to this group. i was looking to find a macro or a tool to list wav file name and duration in a excel, thats when i found about this group and instantly joined. I would like to know if that's possible at all. if u have a tool for that, kindly lemme know. that would be of gr8 help coz i am doing it manually now. Regards Reshma -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-...@googlegroups.com. To unsubscribe from this group, send email to excel-macros...@googlegroups.com. -- Regards, Aamir Shahzad -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in
$$Excel-Macros$$
Sent on my BlackBerry® from Vodafone -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ Benford's Laws in excel
Good morning to all, Do any one have macros or aad-in on Benford's law. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$
Sorry to all, wrongly pressed send button. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Rajan_Verma rajanverma1...@gmail.com Sender: excel-macros@googlegroups.com Date: Sun, 30 Sep 2012 08:50:52 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Any Query?? Regards Rajan verma +91 7838100659 [IM-Gtalk] -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of chhajersand...@gmail.com Sent: 30 September 2012 8:49 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Sent on my BlackBerryR from Vodafone -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ UDF for all worksheets
Dear all, I have made a UDF (formula) in personal.xls file. Though it is working when I am working @ personal file but when ever I am trying to use it in my other worksheet the formula is not working. Please help. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Re: UDF for all worksheets
Thanks Prince. I have made it public. Though I don't know the basic difference between the scope to be private or pubic. So will send you the work sheet. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Prince Dubey prince141...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 6 Sep 2012 04:23:22 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Cc: chhajersand...@gmail.com Subject: $$Excel-Macros$$ Re: UDF for all worksheets Hi sandeep, i hope scope of ur function or sub is private, so please make it public. If it does not work then pls share the ur workbook with us. regards Prince On Thursday, September 6, 2012 4:15:13 PM UTC+5:30, sandeep chhajer wrote: Dear all, I have made a UDF (formula) in personal.xls file. Though it is working when I am working @ personal file but when ever I am trying to use it in my other worksheet the formula is not working. Please help. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Moving Excel worksheet information in VBA memory
Dear Ruchir, If you share your work with us it would be an immense help for us also. Thanks, Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Sam Mathai Chacko samde...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 4 Sep 2012 22:32:36 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Moving Excel worksheet information in VBA memory No it won't. Try using var = Worksheets(Name).UsedRange.Formula Regards, Sam Mathai Chacko On Tue, Sep 4, 2012 at 9:56 PM, rjoshi88 ruchirjo...@gmail.com wrote: Hi sam, Thanks for the reply, but this would not give me information about other cell parameters like dependents. Ruchir On Tuesday, September 4, 2012 9:46:15 PM UTC+5:30, Sam Mathai Chacko wrote: Try taking all the values of the used range to a variant variable. Example Sub T() Dim var As Variant var = Worksheets(Name).UsedRange.**Value End Sub Regards, Sam Mathai Chacko On Tue, Sep 4, 2012 at 9:43 PM, Ruchir Joshi ruchi...@gmail.com wrote: Hello everyone, I am designing a tool to identify whether a cell has inter or intra sheet dependents using VBA. The problem is the extremely slow speed due to interaction with worksheet and use of 'showarrows' and 'hidearrows' function. Can the entire sheet information be copied into VBA memory, so that execution time reduces. ? I am looking forward for any code / supporting link. Regards Ruchir Joshi -- Join official facebook page of this forum @ https://www.facebook.com/** discussexcel https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-...@googlegroups.com. To unsubscribe from this group, send email to excel-macros...@** googlegroups.com. -- Sam Mathai Chacko -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Sam Mathai Chacko -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this
Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!--Add
Pankaj then check your filter settings of mails. Sent on my BlackBerry® from Vodafone -Original Message- From: pankaj gmail account pankaji...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 5 Jul 2012 13:19:17 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ MVP AwardCongratulations Ashish Koul and Dilip Pandey !!--Add Dear Moderator, i appreciate if any one gets award. Four types of mails are filling my mailbox *1. MVP Award* *2. Introduce Yourself* *3. Five Year Completion* *4. Help ful Member* Then why *Not Job posting* also this will help forum members too. Regards, Pankaj On Thu, Jul 5, 2012 at 10:04 AM, joseph.cam...@gmail.com wrote: ** Hi Pankaj, Its an appreciation given to group members for helping. Correct me Ayush if I am wrong. Thanks, Joseph Sent on my BlackBerry® from Vodafone -- *From: * pankaj gmail account pankaji...@gmail.com *Sender: * excel-macros@googlegroups.com *Date: *Thu, 5 Jul 2012 09:37:17 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ MVP AwardCongratulations Ashish Koul and Dilip Pandey !!--Add These kind of Congratulating etc Regards Pankaj On Wed, Jul 4, 2012 at 10:20 PM, Bé Trần Văn betnmtdongna...@gmail.comwrote: I just want to congratulate Ashish and Dilip. and contributions that you want two more forums. 2012/7/4 Ayush Jain jainayus...@gmail.com Pankaj, Please let me know which advertisements you are referring to. Thanks, On Tuesday, 3 July 2012 11:25:02 UTC+5:30, panky wrote: Dear Moderator, Please also Ban these kinds of Promotional/Advertisements in this forum. They are not related to Excel Help. Please advice Thanks and Regads, Pankaj Michael On Sun, Jul 1, 2012 at 9:54 PM, Ayush Jain jainayus...@gmail.comwrote: Dear members, I am extremely happy to inform you that two members of the group are awarded Microsoft Most Valuable Professional Award. My heartiest congratulations to *Ashish koul* and *Dilip Pandey* and thanks for their big support to this forum. Keep posting ! Best regards, Ayush Jain Group Manager Microsoft MVP -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --**--** --** To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscribe@** googlegroups.com excel-macros%2bunsubscr...@googlegroups.com -- Pankaj Kumar -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss.
Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!
Congratulation Ashish and Dilip. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Sam Mathai Chacko samde...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 2 Jul 2012 21:01:24 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Cc: Dilip Pandeydilipan...@gmail.com Subject: Re: $$Excel-Macros$$ MVP AwardCongratulations Ashish Koul and Dilip Pandey !! Excellent achievement once again by Ashish and Dilip. Kuddos to both. Regards, Sam Mathai Chacko On Mon, Jul 2, 2012 at 7:32 PM, ashish koul koul.ash...@gmail.com wrote: Thank you all... On Mon, Jul 2, 2012 at 4:39 PM, Amol Shrivastava shri.a...@gmail.comwrote: *Congratulations Ashish and Dilip...!!* -- Thanks Regards, Amol Shrivastava +91 99671 18180 On Mon, Jul 2, 2012 at 4:35 PM, Aindril De aind...@gmail.com wrote: Congratulations Ashish and Dilip!! Your Contributions have always been an asset to our group.. Hard Luck Don...!! Your contributions have always been really helpful in our group.. Better luck next time!! Cheers Andy On Sun, Jul 1, 2012 at 9:54 PM, Ayush Jain jainayus...@gmail.comwrote: Dear members, I am extremely happy to inform you that two members of the group are awarded Microsoft Most Valuable Professional Award. My heartiest congratulations to *Ashish koul* and *Dilip Pandey* and thanks for their big support to this forum. Keep posting ! Best regards, Ayush Jain Group Manager Microsoft MVP -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Warm Regards, Aindril De Ph: 9811300157 -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks Regards, Amol Shrivastava +91 99671 18180 -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment. -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ members already BANNED for violation) 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
Re: $$Excel-Macros$$ I want to learn macro from basic level
Please send me also @ chhajersand...@gmail.com Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Rakesh Kumar Sharma rakeshks@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 12 Jun 2012 19:03:51 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ I want to learn macro from basic level Hi Rajan, Plz send me on my email id rakeshks@gmail.com if possible On Tue, Jun 12, 2012 at 6:15 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Excel Power programming with VBA J ** ** Either you can download from internet its free or I will send you on your email id .. Really nice book to start from scratch. * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Rakesh Kumar Sharma *Sent:* 12 June 2012 3:00 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ I want to learn macro from basic level ** ** Hi Masters, If you have any attachment which can help me to learn excel macro from starting point, plz share. -- *Regards, **Rakesh Kumar Sharma** **Contact: +91-9971024741** * -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- *Regards, Rakesh Kumar Sharma Contact: +91-9971024741 * -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email
$$Excel-Macros$$ Name a table
Dear Mentors, I want to create tables in Excel 2010 as following My data in excel is Column 1.Column 2 Reserve_surplus Other_exp Capital Reserve. Salary Securities Premium. Printing Revaluation reserve. Insurance General Reserve.Transport Housekeeping Now I want the macro to create a table for each column which will be starting from 2nd row of the column to last row non black row with the table name being the first row of the respective column. In my case table will be created for A2: A5 and name of the table = Reserve_surplus And so on. Thanking you inn advance. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Fw: $$Excel-Macros$$ Name a table
Dear all, Please try to find out any solution! Sandeep Chhajer Sent on my BlackBerry® from Vodafone -Original Message- From: chhajersand...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 11 Jun 2012 10:59:23 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Name a table Dear Mentors, I want to create tables in Excel 2010 as following My data in excel is Column 1.Column 2 Reserve_surplus Other_exp Capital Reserve. Salary Securities Premium. Printing Revaluation reserve. Insurance General Reserve.Transport Housekeeping Now I want the macro to create a table for each column which will be starting from 2nd row of the column to last row non black row with the table name being the first row of the respective column. In my case table will be created for A2: A5 and name of the table = Reserve_surplus And so on. Thanking you inn advance. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Introduce Yourself !!
Hi all, I am Sandeep Chhajer, a Chartered Accountants by profession from Mumbai. I am also an excel enthusiastic like you all. Apart from that I also like to watch all sorts of out door sports. I am really thankful to the group which makes me amazed every time with its innovative formulas,UDF,Macros etc. With ℓσνє Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Ayush Jain jainayus...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 8 Jun 2012 12:21:59 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Introduce Yourself !! Hey all new and current posters, Welcome to excel group,one of the largest online community of excel Fans! I hope you enjoy your time here find this forum to be a friendly and knowledgeable community. Please feel free to post a small introduction, a friendly hello or tell us a bit about yourself. Why not tell us where are you from, what you do, what your interests are, how old you are, which is your favourite excel site or blog is or anything else that comes to mind! Thanks for your time Ayush Jain Group Manager Microsoft MVP -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ RE: FW: hi there...
Hi Ayush, Noorain and all mentor, You all are the best mind in the field of Information Technology. So please do needful to stop this type of cross advertising and abuses.(Happened on today morning by Viktorija Zukauskiene ). We have an esteemed group so I am urging every true member of this group please try to find out a way by which we can stop any such future incidents. Sent on my BlackBerry® from Vodafone -Original Message- From: OfficeVba Trainer officevbatrai...@yahoo.com Sender: excel-macros@googlegroups.com Date: Fri, 8 Jun 2012 08:48:16 To: andredwal...@gmail.comandredwal...@gmail.com; itforan...@yahoo.comitforan...@yahoo.com; ankurpande...@gmail.comankurpande...@gmail.com; arindam_bhowm...@hotmail.comarindam_bhowm...@hotmail.com; bhaskarsharm...@yahoo.combhaskarsharm...@yahoo.com; biswendu@ebusinessware.combiswendu@ebusinessware.com; aggarwalche...@hotmail.comaggarwalche...@hotmail.com; chira...@yahoo.comchira...@yahoo.com; daniel@fortemall.comdaniel@fortemall.com; dhana...@gmail.comdhana...@gmail.com; buntys.din...@gmail.combuntys.din...@gmail.com; divyasnap...@gmail.comdivyasnap...@gmail.com; exce...@groups.ittoolbox.comexce...@groups.ittoolbox.com; excel-macros@googlegroups.comexcel-macros@googlegroups.com; willy_n...@rediffmail.comwilly_n...@rediffmail.com; govindke...@gmail.comgovindke...@gmail.com; harpreetguj...@gmail.comharpreetguj...@gmail.com; harpreetsinghguj...@hsbc.co.inharpreetsinghguj...@hsbc.co.in; intermediatec...@googlemail.comintermediatec...@googlemail.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ RE: FW: hi there... pThanks to Bed Defense! They saved my sister and I from our buildings bedbug infestation!!bra href=http://socjologia.c0.pl/lastnews/94RichardAlien/;http://socjologia.c0.pl/lastnews/94RichardAlien//a/p -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ MACRO
Dear all, I also want the e-book on excel 2007. Given that the demand and hectic schedule of Mr. Noorain, I urge those members (who already have received the book from Noorain) to send to us. My mail I'd is chhajersand...@gmail.com Thanks Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: son nguyen sonnguye...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 1 Jun 2012 11:29:49 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ MACRO Dear Mr Ansari Please send it to me . (My email : sonnguye...@gmail.com) Thanks a lot Son 2012/5/31 NOORAIN ANSARI noorain.ans...@gmail.com Dear Tarun, I have send Excel macro Ebook. Pls check On Thu, May 31, 2012 at 2:57 PM, Tarun Mondal tarunmondal1...@gmail.comwrote: Sir , Please sir send the ebook to my email id also...my email id is --- systemassistant2...@gmail.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Best Regards Son -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ macro to make unlocked cell value zero
Thanks Rajan I will try it! Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Rajan_Verma rajanverma1...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 28 May 2012 19:17:12 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ macro to make unlocked cell value zero Protect your sheet and Run this : Sub MTest() ActiveSheet.UsedRange.Value = 0 End Sub Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sandeep Chhajer Sent: 28 May 2012 6:37 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ macro to make unlocked cell value zero Dear Excel Guru, I have a protected sheet where some cells are unprotected. i want a macro which can make all unprotected cells to zero value. Thanking you in advance. -- Regards, Sandeep Kumar Chhajer. -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Data validation
Dear excel guru, Is there any way I can keep source data list in another sheet (other than where I want to put the data validation) for data validation list command. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Data validation
Thanks to all of you. Its working fine. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: dguillett1 dguille...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 28 May 2012 10:52:43 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Data validation use a define name for the dv list in the other sheet such as dvlist then in the dv list =dvlist Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: chhajersand...@gmail.com Sent: Monday, May 28, 2012 10:41 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Data validation Dear excel guru, Is there any way I can keep source data list in another sheet (other than where I want to put the data validation) for data validation list command. Sandeep Chhajer. Sent on my BlackBerryŽ from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Dynamic List range for Data validation
Thanks to all! I will try and revert back to you! Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: chhajersand...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 17 May 2012 04:21:51 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Dynamic List range for Data validation Dear all, I want to create a list in data validation which take a dynamic range in alphabetic order. Can it be possible I have tried to find it google but could not solve this though have got solutions! Please help like you help us with indirect function module! Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Dynamic List range for Data validation
Dear all, I want to create a list in data validation which take a dynamic range in alphabetic order. Can it be possible I have tried to find it google but could not solve this though have got solutions! Please help like you help us with indirect function module! Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Dynamic data validation
Dear sir, I want dynamic data validation(list) where my name range to be dynamic. Example: Group containing cell are in G2:dynamic range. For every group I have sub group. The range of subgroup is also should be dynamic. I can use fixed range with indirect function and name range but not dynamic so every time I include new data in group or sub group column I have to change range to include it. Your help in this regards will be highly appreciable. Thanks Regards, Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: Fwd: $$Excel-Macros$$ VBA Classes
Any one giving classes @ Borivali Mumbai? Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: LAKSHMAN PRASAD lakshman_...@yahoo.com Sender: excel-macros@googlegroups.com Date: Thu, 5 Apr 2012 02:38:25 To: excel-macros@googlegroups.comexcel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: Fwd: $$Excel-Macros$$ VBA Classes Delhi NCR From: Veeru TOC veerub...@gmail.com To: excel-macros@googlegroups.com Sent: Thursday, April 5, 2012 12:57 PM Subject: Re: Fwd: $$Excel-Macros$$ VBA Classes Venue,,, Plz,,, On Thu, Apr 5, 2012 at 12:30 PM, LAKSHMAN PRASAD lakshman_...@yahoo.com wrote: me tooo From: Lokesh Loki lokeshsmg2...@gmail.com To: excel-macros@googlegroups.com Sent: Wednesday, April 4, 2012 7:27 PM Subject: Fwd: $$Excel-Macros$$ VBA Classes Hi Experts, May i know that is there any Excel Power point Vba classes conducting in weekend through online on this group. Because i want to learn the lot of things. Please advice me Regards Lokesh.M -- Forwarded message -- From: NRao Mynampati ml.narasimha...@gmail.com Date: Wed, Apr 4, 2012 at 4:35 AM Subject: $$Excel-Macros$$ VBA Classes To: excel-macros@googlegroups.com HI Team, Gnanainfo will conducting Weekend VBA Classes at Hyderabad on 07-04-2012 08-04-2012 ,14-04-2012 15-04-2012. For more details you can reach : gnanainfo@gmail.com 09703091552. Thanks and Regards Simha -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- ThanksRegards Veerendra.Vanam TOC TEAM Bhagyanagar Electrical Contractors H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh 91-9177-444-840, -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a
$$Excel-Macros$$ Macro for 100 sheets
Dear excel guru, I want a macro to insert 100 sheets (all are same/smilar copy of sheet 1) o sheet will be named 2...3..4...and so on! Please help. Thanks Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Macro for 100 sheets
Thanks maries! I will check and send you the feed back. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Maries talk2mar...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 31 Mar 2012 10:51:58 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Macro for 100 sheets Hi, Try Below Code, Sub Sheet1Multiplecopy() Dim i As Integer i = 1 For i = 1 To 100 Sheets(Sheet1).Select Sheets(Sheet1).Copy After:=Sheets(i) ActiveSheet.Name = i Next End Sub Regards, MARIES. On Sat, Mar 31, 2012 at 10:11 AM, chhajersand...@gmail.com wrote: Dear excel guru, I want a macro to insert 100 sheets (all are same/smilar copy of sheet 1) o sheet will be named 2...3..4...and so on! Please help. Thanks Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ ****** FIVE YEARS COMPLETION******THANK YOU******
Dear All, I really want to share my experience...I still cherish the day when out of curiosity I joined the group 3 yrs back as a novice.and now a I can't say I am an expert but a full blown excel lover...can't stop a day also without seeing our posts and answers by our experts and also can't remember a single day when I haven't learn a new thing over here. No word can describe the joy of me the day I crack difficult array and complex solutions provided by our expert and use it in my work :) Thanks and my heartiest Congratulation to all of us...that our beloved forum has completed 5 yrs. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: The Viper viper@gmail.com Sender: excel-macros@googlegroups.com Date: Sun, 25 Mar 2012 12:29:02 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ ** FIVE YEARS COMPLETION**THANK YOU** this is great. keep on going ayush. On Thu, Mar 22, 2012 at 4:25 AM, Ayush Jain jainayus...@gmail.com wrote: Dear members,** I am proud to announce that the forum has completed 5 years today. This is really great milestone of the forum. My sincere thanks to each one of you who keep this forum alive by asking questions and helping others by providing solutions. Over the last five years, I have seen decent growth in the number of posts and quality of solutions provided by the experts here. I have learned many things from this forum and experts. In my view, Learning never stops and the discussion forum is the best place to learn and share the skills. I hardly get time to resolve the excel queries after office hours but I try my best to moderate the forum closely. I visit the forum 2-3 times daily to approve the messages and to check everything is ok. Please let me know the improvements and changes you want to see in the forum. I would be happy to hear your feedback. Some key achievements of this forum in numbers: 1) In last 1.5 years, we have seen three people receiving the Microsoft MVP award from this forum. This is itself a big achievement for forum and I hope to see more deserving people get this award in future. 2) This is spam free forum and we hardly get spam messages. In last 5 years, 1000 members are banned for sending spam messages 3) We are 8400+ members with diversity in expertise, experience and location. 4) Over 7600+ topics discussed in five years Once again many thanks and congratulations to all of you. Keep posting and together we will achieve more milestones. Regards, Ayush Jain Microsoft MVP Forum Owner jainayus...@gmail.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- *Great day,* *viper* -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5)
Re: $$Excel-Macros$$ कविता: अपने E xcel-Macro ग्रुप का उम्र,अब 5 स ाल हो गया.****** FIVE YEARS COMPLETION******TH ANK YOU******
After reading the translation I just want to say... 3 cheers for Excel macros group, Noorain for his original master piece and avishek for ur spellbound translation!! Hip Hip Hurrah!! Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Abhishek Jain abhishek@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 23 Mar 2012 19:15:27 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Cc: Don Guillettdguille...@gmail.com Subject: Re: $$Excel-Macros$$ कविता: अपने E xcel-Macro ग्रुप का उम्र,अब 5 स ाल हो गया.** FIVE YEARS COMPLETION**TH ANK YOU** Here, Don... Where the population of excel lovers is very high Where complete freedom is given to ask and reply Following the posts of which many careers were happily told That excel-macro group, my friends, is now 5 years old.. Be it dusk, dawn, day or night... Posts keep raining just right... This garden is decorated with flowers of talent... Here happens cold wars with formulas of excel... Logic is cultivated here in the fields of solutions... Here, competition is mainly for offering solutions... One got lucky be having which group's hold... That excel-macro group, my friends, is now 5 years old.. Legends like Haseed, Sam, Don, Ashish reside here... Man of BT Krishna give the world their pride here Asa, Rajan, Dilip, Maries are the solitares... Venkat and Sunny are the known volunteers Many more wonders are also a part of this prize This garden is nourished by Ayush's expertise The group which has now become excellent in *bold*... That excel-macro group, my friends, is now 5 years old.. Sorry for terrible translationits not easy to reproduce a masterpiece 2012/3/23 dguillett1 dguille...@gmail.com From the comments, I only wish I could read it.?? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* NOORAIN ANSARI noorain.ans...@gmail.com *Sent:* Thursday, March 22, 2012 1:42 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया.** FIVE YEARS COMPLETION**THANK YOU** जहाँ Excel के दीवानों की, है बहूत घनी आबादी. जहाँ Question,Answer करने की,है खूब आज़ादी. जहाँ के पोस्ट को follow कर-कर के,कितनो का Career खुशहाल हो गया. दोस्तों उस अपने Excel-Macro ग्रुप का उम्र, अब 5 साल हो गया. चाहे सुबह हो या शाम, चाहे दिन हो या रात. हर समय होती है यहाँ पोस्टिंग की बरसात. ये उपवन सजा है दोस्तों, कई Talented फूलों से. यहाँ शीत युद्ध चलती है अक्सर Excel के फर्मुलों से. Logic की खेती होती है यहाँ solutions के खलिहानों में. यहाँ मदद की होड़ मची रहती है EXCEL के दिवानो में.. जिसने पा लिया साथ इस ग्रुप का, समझो निहाल हो गया. दोस्तों अपने Excel-Macro ग्रुप का उम्र अब 5 साल हो गया. *Haseeb,SAM,DON,Ashish* जैसी हस्ती यहाँ पे बसती है. Man of BT *Krishna* के solution को दुनिया तरसती है. *ASA,Rajan,Dilip,Maries* सब के सब कोहिनूर है. *Venkat,Sunny,Abhishekh* भी कम नहीं मशहूर है. और भी यहाँ बहूत सारी शख्सियत है निराली. *Ayush* बाबू करते है इस बगीया की रखवाली. ये forum अब मिशाल नहीं रहा, बल्कि बेमिशाल हो गया. दोस्तों अपने Excel-Macro ग्रुप का उम्र अब 5 साल हो गया. -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal
Re: $$Excel-Macros$$ Re: Macro for Insert a line for missing serial numbers.
Dear Damimkader S. Meeran, Thanks for your reply. With ref to your question: I use office 2010 version. And I want to insert 3 column in between (I.e 4,5,6). Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Damimkader S. Meeran damim.ka...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 22 Mar 2012 03:57:16 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Macro for Insert a line for missing serial numbers. Hi Sandeep, Before I proceed to modify the code, could you let me know the following 1. Which version of excel are you using 2. Do you want the code to insert the rows equivalent to the missing serial numbers for e.g. if after number 3 you have 7, do you want the code to insert 4 rows in the middle of 3 and 7. Regards, Damimkader S. Meeran On Thursday, March 22, 2012 1:50:18 PM UTC+5:30, sandeep chhajer wrote: Dear Damimkader, while I am running this code I am getting the follwing error code run time error 13 type mismatch please help. My problem has been reproduced My current Data is like thisSr. No. S_DISNO S_DISC S_UNIT S_SELP Purchse quantity 495061 358 SILK DUPPATTA 0.90m 260.00 36.00 495062 359 SILK DUPPATTA 1.15m 385.00 33.00 495063 351 SILK DOTHI 8 cu 3.6 m 2645.00 4.00 495067 351 SILK DOTHI 8 cu 3.6 m 2745.00 3.00 495070 351 SILK DOTHI 8 cu 3.6 m 2965.00 3.00 I want my data as follows Sr. No. S_DISNO S_DISC S_UNIT S_SELP Purchse quantity 495061 358 SILK DUPPATTA 0.90m 260.00 36.00 495062 359 SILK DUPPATTA 1.15m 385.00 33.00 495063 351 SILK DOTHI 8 cu 3.6 m 2645.00 4.00 495064 351 SILK DOTHI 8 cu 3.6 m 2645.00 4.00 495065 351 SILK DOTHI 8 cu 3.6 m 2645.00 4.00 495066 351 SILK DOTHI 8 cu 3.6 m 2645.00 4.00 495067 351 SILK DOTHI 8 cu 3.6 m 2745.00 3.00 495068 351 SILK DOTHI 8 cu 3.6 m 2745.00 3.00 495069 351 SILK DOTHI 8 cu 3.6 m 2745.00 3.00 495070 351 SILK DOTHI 8 cu 3.6 m 2965.00 3.00 Copy the previous line only sr no has chamged by adding 1 On 22 March 2012 02:26, Damimkader S. Meeran damim.ka...@gmail.comwrote: Hi Sandeep, My code below assumes the following 1. The serial numbers are in column A 2. The Excel version you are using is 2007. 3. The code is good for 10,000 rows. Please modify if required. Sub Serial() Dim i As Long For i = 1 To 1 If Cells(i, 1) And Cells(i + 1, 1) Then If Cells(i + 1, 1) - Cells(i, 1) 1 Then Rows(i + 1 : i + 1).Select Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove i = i + 1 End If Else Exit For End If Next i End Sub On Wednesday, March 21, 2012 9:40:37 PM UTC+5:30, sandeep chhajer wrote: Dear all, Please find my attachment ( I know asking question in this way is a violation of our forum rule but sorry I don't have data card to copy the queries from excel) Thanking you in advance. Sandeep Chhajer. On Wednesday, March 21, 2012 9:40:37 PM UTC+5:30, sandeep chhajer wrote: Dear all, Please find my attachment ( I know asking question in this way is a violation of our forum rule but sorry I don't have data card to copy the queries from excel) Thanking you in advance. Sandeep Chhajer. -- Regards, Sandeep Kumar Chhajer. -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE
Re: $$Excel-Macros$$ Re: Macro for Insert a line for missing serial numbers.
Thanks Damimkader. I will try and let you know. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Damimkader S. Meeran damim.ka...@gmail.com Date: Thu, 22 Mar 2012 05:20:05 To: excel-macros@googlegroups.com Cc: chhajersand...@gmail.com Subject: Re: $$Excel-Macros$$ Re: Macro for Insert a line for missing serial numbers. Hi, I've modified the code to suit the needs. It has been worked upon in Excel 2007 i unfortunately do not have excel 2010. The code has the following assumptions 1. All serial numbers are in number format. The error message you were getting earlier is possibly because a serial number was a number stored in text format. You can be sure of this by checking if excel shows a green pointer next to the cell. Additionally I'm not sure if some of the VBA functions in 2007 would work on 2010. I tried to make the code universal so give it a try. Sub Serial() Dim i As Long, count As Long, j As Long, Diff As Long For i = 1 To 1 If Cells(i, 1) And Cells(i + 1, 1) Then Diff = Cells(i + 1, 1) - Cells(i, 1) If Diff 1 Then For j = 1 To (Diff - 1) Rows(i + 1 : i + 1).Select Selection.Insert Shift:=xlDown Rows(i : i).Select Selection.Copy Cells(i + 1, 1).Select ActiveCell.PasteSpecial xlPasteAll Cells(i + 1, 1) = Cells(i + 2, 1) - 1 Next j i = i + (Diff - 1) End If Else Exit For End If Next i End Sub Regards, Damimkader On Thursday, March 22, 2012 4:37:19 PM UTC+5:30, sandeep chhajer wrote: Dear Damimkader S. Meeran, Thanks for your reply. With ref to your question: I use office 2010 version. And I want to insert 3 column in between (I.e 4,5,6). Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- *From: * Damimkader S. Meeran damim.ka...@gmail.com *Sender: * excel-macros@googlegroups.com *Date: *Thu, 22 Mar 2012 03:57:16 -0700 (PDT) *To: *excel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *$$Excel-Macros$$ Re: Macro for Insert a line for missing serial numbers. Hi Sandeep, Before I proceed to modify the code, could you let me know the following 1. Which version of excel are you using 2. Do you want the code to insert the rows equivalent to the missing serial numbers for e.g. if after number 3 you have 7, do you want the code to insert 4 rows in the middle of 3 and 7. Regards, Damimkader S. Meeran On Thursday, March 22, 2012 1:50:18 PM UTC+5:30, sandeep chhajer wrote: Dear Damimkader, while I am running this code I am getting the follwing error code run time error 13 type mismatch please help. My problem has been reproduced My current Data is like thisSr. No. S_DISNO S_DISC S_UNIT S_SELP Purchse quantity 495061 358 SILK DUPPATTA 0.90m 260.00 36.00 495062 359 SILK DUPPATTA 1.15m 385.00 33.00 495063 351 SILK DOTHI 8 cu 3.6 m 2645.00 4.00 495067 351 SILK DOTHI 8 cu 3.6 m 2745.00 3.00 495070 351 SILK DOTHI 8 cu 3.6 m 2965.00 3.00 I want my data as follows Sr. No. S_DISNO S_DISC S_UNIT S_SELP Purchse quantity 495061 358 SILK DUPPATTA 0.90m 260.00 36.00 495062 359 SILK DUPPATTA 1.15m 385.00 33.00 495063 351 SILK DOTHI 8 cu 3.6 m 2645.00 4.00 495064 351 SILK DOTHI 8 cu 3.6 m 2645.00 4.00 495065 351 SILK DOTHI 8 cu 3.6 m 2645.00 4.00 495066 351 SILK DOTHI 8 cu 3.6 m 2645.00 4.00 495067 351 SILK DOTHI 8 cu 3.6 m 2745.00 3.00 495068 351 SILK DOTHI 8 cu 3.6 m 2745.00 3.00 495069 351 SILK DOTHI 8 cu 3.6 m 2745.00 3.00 495070 351 SILK DOTHI 8 cu 3.6 m 2965.00 3.00 Copy the previous line only sr no has chamged by adding 1 On 22 March 2012 02:26, Damimkader S. Meeran damim.ka...@gmail.comwrote: Hi Sandeep, My code below assumes the following 1. The serial numbers are in column A 2. The Excel version you are using is 2007. 3. The code is good for 10,000 rows. Please modify if required. Sub Serial() Dim i As Long For i = 1 To 1 If Cells(i, 1) And Cells(i + 1, 1) Then If Cells(i + 1, 1) - Cells(i, 1) 1 Then Rows(i + 1 : i + 1).Select Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove i = i + 1 End If Else Exit For End If Next i End Sub On Wednesday, March 21, 2012 9:40:37 PM UTC+5:30, sandeep chhajer wrote: Dear all, Please find my attachment ( I know asking question in this way is a violation of our forum rule but sorry I don't have data card to copy the queries from excel) Thanking you in advance. Sandeep Chhajer. On Wednesday, March 21, 2012 9:40:37 PM UTC+5:30, sandeep chhajer wrote: Dear all, Please find my attachment ( I know asking
$$Excel-Macros$$ Macro for Insert a line for missing serial numbers.
Dear all, Please find my attachment ( I know asking question in this way is a violation of our forum rule but sorry I don't have data card to copy the queries from excel) Thanking you in advance. Sandeep Chhajer. -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com FOR MACRO.xlsx Description: Binary data
$$Excel-Macros$$ link Excel files (Excel table) in MS-word with MS Excel files.
Dear Excel gurus, I want to link my excel table which is in MS WORD as table with other MS EXCEL file. Can it be possible with any macros. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Happy Holi
Dear all, Wish you Happy holi. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Unique problem
Dear Excel gurus, I am facing a unique problem. I have a file which has been filtered. Now when I am trying see all data..it is giving me a message saying..fixed objects will move. I am clicking okay...but getting no result as it is appearing again and again. I have closed the file forcefully and reopened it but no avail. Please help. Thanking you in advance. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Unique problem
Dear Rajan, I don't have any unhidden comment there because only 3 of my row is now visible out of 5175 rows but my numbers are in the next column is in text so the usual excel notification is there (upper left side with green mark). Don't know what to do. For data privacy also can't send the worksheet. Please advice. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Rajan_Verma rajanverma1...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 6 Mar 2012 19:24:04 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Unique problem Try to Find any Unhidden Comment and Hide them.? -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of chhajersand...@gmail.com Sent: Mar/Tue/2012 07:08 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Unique problem Dear Excel gurus, I am facing a unique problem. I have a file which has been filtered. Now when I am trying see all data..it is giving me a message saying..fixed objects will move. I am clicking okay...but getting no result as it is appearing again and again. I have closed the file forcefully and reopened it but no avail. Please help. Thanking you in advance. Sandeep Chhajer. Sent on my BlackBerryR from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Unique problem
No Joseph I have not applied freeze pane. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: joseph.cam...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 6 Mar 2012 16:41:15 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Unique problem Have you applied freeze panes? Sent on my BlackBerry® from Vodafone -Original Message- From: Abhishek Jain abhishek@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 6 Mar 2012 22:03:33 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Cc: chhajersand...@gmail.com Subject: Re: $$Excel-Macros$$ Unique problem I found this on another website. May be this can help - Sub CommentsMoveAndSize() '// Written by Greg Truby, July 2006 '// '// If a large worksheet has comments and you '// attempt to apply AutoFilter, sometimes Excel will '// start telling you Fixed objects will move. '// '// Per the kb article here: '// «« http://support.microsoft.com/default.aspx?id=211769 »» '// this routine fixes it. '// '// [Tested on a worksheet with 5,000 rows × 150 columns '// and 1,796 comments. Also tested on shared workbooks, '// and protected worksheets. Neither raised an error.] Dim cmtEach As Comment If ActiveSheet.Type XlSheetType.xlWorksheet Then MsgBox What are you? Daft? vbCr vbCr Pick a worksheet., _ vbExclamation, Bad Sheet Selection Exit Sub ElseIf ActiveSheet.Comments.Count = 0 Then MsgBox There are no comments on the active sheet., vbInformation, I Have No Comment Else '// Change each comment to move and size with cells For Each cmtEach In ActiveSheet.Comments cmtEach.Shape.Placement = xlMoveAndSize Next cmtEach End If End Sub On Tue, Mar 6, 2012 at 9:01 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Once I had also face this problem but it was just because of comment box .. can not say anything without looking at worksheet.. if you can send on personal mail.. Regards Rajan. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of chhajersand...@gmail.com Sent: Mar/Tue/2012 07:57 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Unique problem Dear Rajan, I don't have any unhidden comment there because only 3 of my row is now visible out of 5175 rows but my numbers are in the next column is in text so the usual excel notification is there (upper left side with green mark). Don't know what to do. For data privacy also can't send the worksheet. Please advice. Sandeep Chhajer. Sent on my BlackBerryR from Vodafone -Original Message- From: Rajan_Verma rajanverma1...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 6 Mar 2012 19:24:04 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Unique problem Try to Find any Unhidden Comment and Hide them.? -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of chhajersand...@gmail.com Sent: Mar/Tue/2012 07:08 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Unique problem Dear Excel gurus, I am facing a unique problem. I have a file which has been filtered. Now when I am trying see all data..it is giving me a message saying..fixed objects will move. I am clicking okay...but getting no result as it is appearing again and again. I have closed the file forcefully and reopened it but no avail. Please help. Thanking you in advance. Sandeep Chhajer. Sent on my BlackBerryR from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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
Re: $$Excel-Macros$$ Unique problem
Thanks Asa I have a column without heading. I will check and get back to you soon! Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Asa Rossoff a...@lovetour.info Sender: excel-macros@googlegroups.com Date: Tue, 6 Mar 2012 12:19:29 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Unique problem Dear Sandeep, My first thought was you may need to set objects on your worksheet to move and size with cells, or at least move with them (i.e. make your objects no longer fixed)... and I just did a web search (yes, google/yahoo/msn is your friend) and came up with several issues that can cause this error under certain circumstances: 1. Comments with fixed position/size 2. Window/Freeze panes enabled 3. There are columns without headers and not within the filter range that contain formatting or comments Things you can try for resolving the issue, based on http://support.microsoft.com/default.aspx?id=211769 and online comments: 1. Highlight all rows below your table to the max (65536 or 10 or whatever depending on Excel version) and right-click, delete. Same for all unused columns. 2. Turn off Window-Freeze panes. 3. In Excel 2007+ temporarily toggle the option from Nothing (hide objects) to All a. Office button b. Excel Options c. Advanced d. scroll down to Display options for this workbook section e. click All under For objects, show:. f. click OK. 4. Change the position property of comments/objects to Move and size with cells (or possibly just Move with cells may also work and give a better result in a filtered list or for if you resize rows columns later): a. Manual method for comments: see Method 2 in linked Microsoft KB article. b. Automatic method. Use a VBA macro; i. Change all objects on active sheet to move and size with cells (credit Microsoft KB): Sub Test() Dim s As Shape On Error Resume Next For Each s In ActiveSheet.Shapes s.Placement = xlMoveAndSize Next End Sub You could also try your luck at changing the s.Placement line to s.Placement = xlMove if some comments or other objects you wish to be fully visible are not due to adjacent hidden rows after running the above macro. ii. Change comments only on active sheet to move and size with cells (credit Greg Truby): Sub CommentsMoveAndSize() '// Written by Greg Truby, July 2006 '// '// If a large worksheet has comments and you '// attempt to apply AutoFilter, sometimes Excel will '// start telling you Fixed objects will move. '// '// Per the kb article here: '// «« http://support.microsoft.com/default.aspx?id=211769 »» '// this routine fixes it. '// '// [Tested on a worksheet with 5,000 rows × 150 columns '// and 1,796 comments. Also tested on shared workbooks, '// and protected worksheets. Neither raised an error.] Dim cmtEach As Comment If ActiveSheet.Type XlSheetType.xlWorksheet Then MsgBox What are you? Daft? vbCr vbCr Pick a worksheet., _ vbExclamation, Bad Sheet Selection Exit Sub ElseIf ActiveSheet.Comments.Count = 0 Then MsgBox There are no comments on the active sheet., vbInformation, I Have No Comment Else '// Change each comment to move and size with cells For Each cmtEach In ActiveSheet.Comments cmtEach.Shape.Placement = xlMoveAndSize Next cmtEach End If End Sub You could likewise in this procedure also try your luck at changing cmtEach.Shape.Placement = xlMoveAndSize to cmtEach.Shape.Placement = xlMove to ensure comments will always be showable even with adjacent hidden rows. Asa -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Asa Rossoff Sent: Tuesday, March 06, 2012 11:07 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Unique problem Hello Sandeep; Do you have any shapes, images, or controls on the worksheet? -Original Message- From: mailto:excel-macros@googlegroups.com excel-macros@googlegroups.com [ mailto:excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com] On Behalf Of mailto:chhajersand...@gmail.com chhajersand...@gmail.com Sent: Tuesday, March 06, 2012 5:38 AM To: mailto:excel-macros@googlegroups.com excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Unique problem Dear Excel gurus, I am facing a unique problem. I have a file which has been filtered. Now when I am trying see all data..it is giving me a message saying..fixed objects will move. I am clicking okay...but getting no result as it is appearing again and again. I have closed the file forcefully and reopened it but no avail. Please help. Thanking you in advance. Sandeep Chhajer. Sent on my BlackBerryR from Vodafone -- FORUM RULES (986+
$$Excel-Macros$$ Custom Format
Dear excel guru, Please tell me how to use custom format in excel. What does different symbol like #,;/ etc suggest. Thanking you in advance. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Custom Format
Dear Shaik, Thanks for the reply. I want to learn it. Actually I want to make a format for indian number format. 1,11,11,111 for +ve (1,11,11,111) -ve - for zero. Pls help. Sandeep. Sent on my BlackBerry® from Vodafone -Original Message- From: Shaik Waheed waheedb...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 28 Feb 2012 17:49:18 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Custom Format Hi, The attached file contains various custom formats its provided by Mr. Noorain Ansari. hope u will find it useful On Tue, Feb 28, 2012 at 5:09 PM, chhajersand...@gmail.com wrote: Dear excel guru, Please tell me how to use custom format in excel. What does different symbol like #,;/ etc suggest. Thanking you in advance. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ macro to sort excel data email to party
Dear Amit, Its mean that when ever you send your mail next time set your email priority to normal rather than urgent. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Amit Desai (MERU) amit.de...@merucabs.com Sender: excel-macros@googlegroups.com Date: Thu, 23 Feb 2012 07:01:40 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ macro to sort excel data email to party Dear All, I am not sure what are the rules to define high priority. I am not sure why this was taken other way round. Best Regards, Amit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: 22 February 2012 18:57 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ macro to sort excel data email to party Why is YOUR request more HIGH PRIORITY than others. Some of us take this differently than you might desire. DELETE. Don Guillett SalesAid Software dguille...@gmail.com From: Amit Desai (MERU)mailto:amit.de...@merucabs.com Sent: Tuesday, February 21, 2012 11:46 PM To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Subject: FW: $$Excel-Macros$$ macro to sort excel data email to party Dear All, Please find attached sample file. Following things needs to be done; 1) In first sheet there are data that needs to be sorted work shop wise. 2) In the second sheet email ids are mentioned where we need to send those sorted data per workshop. Please let me know if we have macro for that. Best Regards, Amit From: Amit Desai (MERU) [mailto:amit.de...@merucabs.com] Sent: 20 February 2012 21:31 To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ macro tort excel data email to party Dear All, Please find attached sample file. In first sheet there are data that needs to be sorted work shop wise. In the second sheet email ids are mentioned where we need to send those sorted data per workshop. Please let me know if we have macro for that. Best Regards, Amit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Maries Sent: 20 February 2012 21:05 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ macro for excel data to email Check these links... http://www.excelvbamacros.com/2010/07/vba-code-to-send-email-through-excel.html http://www.excelvbamacros.com/2011/06/send-emails-and-attach-filtered-data.html On Mon, Feb 20, 2012 at 7:30 PM, Amit Desai (MERU) amit.de...@merucabs.commailto:amit.de...@merucabs.com wrote: Dear Friends, Is there any macro for sending excel data to emails of different vendors? Best Regards, Amit Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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)
$$Excel-Macros$$ Round of numbers
Dear Excel gurus, I have a sheet with figures and formulas. I want a macro which can convert all the numbers in to round off up to two decimal but not the formulas. Like if in any cell value is 22.455 Macro should do +round(22.455,2) automatically. But if it is sum(a2:a9). It should remain same. Thanks in advance. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Round of numbers
Thanks Sam and Don both are working good. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: dguillett1 dguille...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 16 Feb 2012 08:42:20 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Round of numbers Or try this Sub RoundUpNonFormulasSAS() Cells.SpecialCells(xlCellTypeConstants, 1).NumberFormat = 0.00 End Sub Don Guillett SalesAid Software dguille...@gmail.com From: Sam Mathai Chacko Sent: Thursday, February 16, 2012 8:06 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Round of numbers Sub NumRoundTwo() Dim rng As Range With ActiveSheet.UsedRange If Not .SpecialCells(xlCellTypeConstants, 1) Is Nothing Then For Each rng In .SpecialCells(xlCellTypeConstants, 1) rng.Value = Round(rng.Value, 2) Next rng End If End With End Sub Regards, Sam Mathai Chacko On Thu, Feb 16, 2012 at 7:08 PM, chhajersand...@gmail.com wrote: Dear Excel gurus, I have a sheet with figures and formulas. I want a macro which can convert all the numbers in to round off up to two decimal but not the formulas. Like if in any cell value is 22.455 Macro should do +round(22.455,2) automatically. But if it is sum(a2:a9). It should remain same. Thanks in advance. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Round of numbers
Dear Excel Expert, I have a worksheet which is linked with a base file. Now I want a macro to automatically round up to 2 decimal all the formulas of worksheets. That is if a link is now showing +'sheet1!$C$9 or +sum(a1:b2)the macro will automatically convert it +round('sheet1!$C$9,2) or +round(sum(a1:b2),2).so on. Please help. Thanking you in advance. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Round of numbers
Thanks sam for so quick solution. I will use it and get back to you. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Sam Mathai Chacko samde...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 15 Feb 2012 23:53:53 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Round of numbers Sub FormulaRound() Dim rng As Range For Each rng In ActiveSheet.UsedRange.SpecialCells(xlCellTypeFormulas) rng.Formula = =ROUND( Right(rng.Formula, Len(rng.Formula) - 1) ,2) Next rng End Sub Regards, Sam Mathai Chacko On Wed, Feb 15, 2012 at 11:40 PM, chhajersand...@gmail.com wrote: Dear Excel Expert, I have a worksheet which is linked with a base file. Now I want a macro to automatically round up to 2 decimal all the formulas of worksheets. That is if a link is now showing +'sheet1!$C$9 or +sum(a1:b2)the macro will automatically convert it +round('sheet1!$C$9,2) or +round(sum(a1:b2),2).so on. Please help. Thanking you in advance. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Add in for compare work sheets
Thanks Be Tran Van. Its really nice of you. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Bé Trần Văn betnmtdongna...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 11 Feb 2012 21:20:17 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Add in for compare work sheets 2012/2/11 Bé Trần Văn betnmtdongna...@gmail.com 2012/2/11 Yahya Muhammad yahya...@gmail.com Please find it attached. On Sat, Feb 11, 2012 at 7:34 AM, chhajersand...@gmail.com wrote: Dear Excel Expert, I am a ardent follower of this group and I have seen that some one has posted in this forum a Add in to compare two worksheet. May I request the expert to repost the add in again. Thanking You, Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Compare column b with a similar if not then yes it is in column C. Using the function =IF(COUNTIF(A:A,B1)0,Yes,No) Use comparison function with Sheet2 Sheet3 =IF(COUNTIF(Sheet2!A1:A9,Sheet3!A4)0,YES,NO) See Attachment Use code: Open File KIEMTRA compare button to compare DS Sheet of NGUON files, the DICH sheet of the DICH file. Just open the File KIEMTRA and click Compare, compare the data in the blue area. Code: Option Explicit Private Sub CommandButton1_Click() Application.ScreenUpdating = False Dim data As Range, data1 As Range Dim Sh1 Dim wb As Workbooks Dim n As Integer, r As Integer Workbooks.Open ThisWorkbook.Path \NGUON.xls Workbooks.Open ThisWorkbook.Path \DICH.xls Set data = Workbooks(NGUON.xls).Sheets(DS).Range(a:c) Set Sh1 = Workbooks(DICH.xls).Sheets(DICH) [A2:D1].Clear Set data1 = Sh1.Range(Sh1.[A2], Sh1.[b6500].End(3)) data1.Copy [A2].PasteSpecial 3 n = [A65000].End(3).Row For r = 2 To n Cells(r, 3) = Application.VLookup(Cells(r, 1).Value, data, 2, 0) Cells(r, 3) = Application.Trim(Cells(r, 3)) Cells(r, 3).Replace #N/A, Cells(r, 2) = Application.Trim(Cells(r, 2)) Cells(r, 2) = UCase(Cells(r, 2)) If Cells(r, 2) = Cells(r, 3) Then Cells(r, 4) = Empty ElseIf Cells(r, 3) And Cells(r, 3) Cells(r, 2) Then Cells(r, 4) = wrong name Else Cells(r, 4) = No name End If Next Workbooks(NGUON.xls).Close False Workbooks(DICH.xls).Close False With [A1].CurrentRegion .AutoFilter Field:=4, Criteria1:= Rows(2:1).Delete .AutoFilter .HorizontalAlignment = xlCenter End With [A1].Select End Sub -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this
$$Excel-Macros$$ Add in for compare work sheets
Dear Excel Expert, I am a ardent follower of this group and I have seen that some one has posted in this forum a Add in to compare two worksheet. May I request the expert to repost the add in again. Thanking You, Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari
Congratulation Noorain. Hope you will keep helping us always in this fashion. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Vijayendra Rao vijayendrar...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 2 Feb 2012 09:48:00 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari Congratulations Noorain Ansari… keep the good work Regards, Vijayendra 2012/2/2 dhartiku...@gmail.com Congrets noorain Sent from BlackBerry® on Airtel -Original Message- From: Dilip Pandey dilipan...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 2 Feb 2012 09:28:46 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Cc: NOORAIN ANSARInoorain.ans...@gmail.com Subject: Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari Congratulations Noorain... Keep it up. Regards, DILIPandey On 2/1/12, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Noorain Ansari has been selected as 'Most Helpful Member' for the month of Jan'12 He has posted 175 posts in Jan'12 and helped many people through his expertise. He has been consistent contributor to this excel forum but has acheived this recognition for first time. *About Noorain Ansari :* [image: noorain.jpg] Noorain is a great poet and keep sharing his thoughts on different topics throgh cool poems. Professionally, he is a Excel aficionado and presently working as senior business analyst in One97 Communication Ltd. He is a MS excel - vba expert and keep sharing his thoughts with this forum. You can follow his blogs for Excel knowledge and cool poems : www.excel-macro.blogspot.com www.noorain-ansari.blogspot.com *Noorain, Many thanks for all your great support to group. Keep it up* *Thanks to Rajan Verma, Sam, Don Guillett, Kris, Bheema, Venkat, Chandru , Priyanka, Lokesh and other folks for helping excel enthusiasts voluntarily !! Keep it up !! ** *Keep posting. Regards Ayush Jain Group Manager Microsoft MVP -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks Regards, DILIP KUMAR PANDEY, mvp MBA,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- ಧನ್ಯವಾದಗಳು, ವಿಜಯೇಂದ್ರ, ೯೪೪೯೧ ೬೭೬೩೧
$$Excel-Macros$$ Formula for minimum no..
Dear Excel guru, I have a data like below Admin. 5 Household.7 Production.2 Stores. 3 Admin. 2 Household.3 Production.1 Stores. 5 Admin. 6 Household.1 Production.3 Stores. 2 Now I want here the minimum no of respective dept by formula..like Admin. 2 (min of 5,2,6) Household.1 Production.1 Stores. 2 Please help asap. With Thanks Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Formula for minimum no..
Thanks Noorain its working great! Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: NOORAIN ANSARI noorain.ans...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 31 Jan 2012 10:56:00 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Formula for minimum no.. Dear Sandeep, You can also use... =MIN(IF($A$1:$A$14=A17,$B$1:$B$14,)) with ctrl+shift+enter Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Tue, Jan 31, 2012 at 10:47 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Sandeep, Please try it,, =SMALL(IF($A$1:$A$14=A17,$B$1:$B$14,),1) with ctrl+Shift+enter(CSE) See attached sheet. On Tue, Jan 31, 2012 at 10:06 AM, chhajersand...@gmail.com wrote: Dear Excel guru, I have a data like below Admin. 5 Household.7 Production.2 Stores. 3 Admin. 2 Household.3 Production.1 Stores. 5 Admin. 6 Household.1 Production.3 Stores. 2 Now I want here the minimum no of respective dept by formula..like Admin. 2 (min of 5,2,6) Household.1 Production.1 Stores. 2 Please help asap. With Thanks Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Auto create of sheet with new name in a sheet
Dear excel advisor, I want a macro which create a sheet automatically if I add a new product name in a particular sheet with the name of the new product. And also want a condition validation which restrict user from inserting duplicate name where I insert the new product name. Thanking you in advance. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- FORUM RULES (934+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Fashion and you -- Get Enrolled and Win 1000 rs
I think Mr Aysush should ban him for this violation!! Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: garwads...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 1 Dec 2011 16:51:50 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Fashion and you -- Get Enrolled and Win 1000 rs Be surya in sky ,and don't come here to shine with cheap stuff around. Respect the motive of this forum and I hope Ayush doesn't vanish u with this cheap act, be careful !!! Cheers Rahul. Sent from BlackBerry® on Airtel -Original Message- From: Ashish Pradhan ashlyprad...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 01 Dec 2011 22:16:42 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Fashion and you -- Get Enrolled and Win 1000 rs Excel Forums now-a-days being used for marketing activities Ashish On 01/12/2011 20:39, Mr Excellent wrote: Hi, Join the Fashion Group and get 1000rs on intial enrollment and get waived off in the initial transaction Fashion Group : A Place with more discounts and less money incurred...join in and believe it Believe it with below link : http://www.fashionandyou.com/fashionandyou-client-http-shop/shop Thanks Surya -- FORUM RULES (934+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ What does -- suggest in formula.
Dear Excel gurus, I have noticed that many time you all use -- in a formula. Why is it been used and when it should be used? Sandeep Kumar Chhajer. Sent on my BlackBerry® from Vodafone -- FORUM RULES (934+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Convert Date to month
Dear all, I have a date written as 01/04/2011, 03/05/2011; I want a function in next column to show only April and May respectively. Thanking you in advance. Sandeep Chhajer. Sent on my BlackBerryŽ from Vodafone -- FORUM RULES (934+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Convert Date to month
Thanks for quick reply. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: NOORAIN ANSARI noorain.ans...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 15 Nov 2011 15:36:41 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Convert Date to month Dear Chhajer, Please try... =Text(A1,) On Tue, Nov 15, 2011 at 3:19 PM, chhajersand...@gmail.com wrote: Dear all, I have a date written as 01/04/2011, 03/05/2011; I want a function in next column to show only April and May respectively. Thanking you in advance. Sandeep Chhajer. Sent on my BlackBerryŽ from Vodafone -- FORUM RULES (934+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- FORUM RULES (934+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Pivot report with button
Dear all, I have to make many pivot report from same data...like one is LR wise... Other is Destination wise...Truck wise etc. What I want to assign a button for every report. Like if I click on button1 it will give me LR wise report if I click button 2 it will show me as Destination wise and so on I also don't want any where in the column name sum of would come. Can I do so with assigning macro. Thanks Regards, CA Sandeep Chhajer. Sent on my BlackBerryŽ from Vodafone -- FORUM RULES (934+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Pivot report with button
Thanks Noorain. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: NOORAIN ANSARI noorain.ans...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 16 Nov 2011 11:58:18 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Pivot report with button Dear Sandeep, Please find attached sheet with Pivot Table+Button. Hope it will help to u. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Wed, Nov 16, 2011 at 11:40 AM, chhajersand...@gmail.com wrote: Dear all, I have to make many pivot report from same data...like one is LR wise... Other is Destination wise...Truck wise etc. What I want to assign a button for every report. Like if I click on button1 it will give me LR wise report if I click button 2 it will show me as Destination wise and so on I also don't want any where in the column name sum of would come. Can I do so with assigning macro. Thanks Regards, CA Sandeep Chhajer. Sent on my BlackBerryŽ from Vodafone -- FORUM RULES (934+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ help me
Copy in a filter mode the desired data then use paste special (alt e s v ) and select skip blank option. Hope fully it will solve ur queries. Sandeep Chhajer. Sent on my BlackBerryŽ from Vodafone -Original Message- From: dguillett1 dguille...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 10 Nov 2011 07:25:57 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ help me Post your file Don Guillett SalesAid Software dguille...@gmail.com From: vijayajith VA Sent: Thursday, November 10, 2011 6:11 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ help me HI I have some datas in tab with coloumns(code and name) in one more tab with same datas but some names are missing .. so i need to filter the and paste the data. but if i paste the datas it will not paste completely .why i dont want to use vlookup is thr any shortcuts Thanks -- FORUM RULES (934+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ help me
Please Copy in a filter mode the desired data. Then select all (alt d f s) and in desired column use paste special (alt e s v ) and select skip blank option there. Hope fully it will solve ur queries. Sandeep Chhajer. Sent on my BlackBerryŽ from Vodafone -Original Message- From: vijayajith VA vijayajith...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 10 Nov 2011 17:41:09 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ help me HI I have some datas in tab with coloumns(code and name) in one more tab with same datas but some names are missing .. so i need to filter the and paste the data. but if i paste the datas it will not paste completely .why i dont want to use vlookup is thr any shortcuts Thanks -- FORUM RULES (934+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Seeking help small letters to capital letters
Use funtion Lower(text) Or Proper (text) Sandeep Chhajer Sent on my BlackBerry® from Vodafone -Original Message- From: .•:*¨¨*:•. .•:V.Kiran Kumar :•. .•:* ¨¨*:•. vadnalaki...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 10 Nov 2011 17:30:20 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Seeking help small letters to capital letters Hi Anybody can help me out how to make small letter to capital letter in Ms excel V.Kiran -- FORUM RULES (934+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Seeking help small letters to capital letters
Sorry Kiran it sud be upper(text) Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: .•:*¨¨*:•. .•:V.Kiran Kumar :•. .•:* ¨¨*:•. vadnalaki...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 10 Nov 2011 17:30:20 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Seeking help small letters to capital letters Hi Anybody can help me out how to make small letter to capital letter in Ms excel V.Kiran -- FORUM RULES (934+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ help me
Please after copy, paste special it in un filtered data...(Use shortcut alt d f s and then alt e s v tick @ skip blank) Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: vijayajith VA vijayajith...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 10 Nov 2011 19:41:37 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ help me hi I have tried using pastespecial but its working its copying only two cells can you help me ? Pleas find the attachment Thank you On Thu, Nov 10, 2011 at 7:01 PM, chhajersand...@gmail.com wrote: Copy in a filter mode the desired data then use paste special (alt e s v ) and select skip blank option. Hope fully it will solve ur queries. Sandeep Chhajer. Sent on my BlackBerryŽ from Vodafone -- *From: * dguillett1 dguille...@gmail.com *Sender: * excel-macros@googlegroups.com *Date: *Thu, 10 Nov 2011 07:25:57 -0600 *To: *excel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ help me Post your file Don Guillett SalesAid Software dguille...@gmail.com *From:* vijayajith VA vijayajith...@gmail.com *Sent:* Thursday, November 10, 2011 6:11 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ help me HI I have some datas in tab with coloumns(code and name) in one more tab with same datas but some names are missing .. so i need to filter the and paste the data. but if i paste the datas it will not paste completely .why i dont want to use vlookup is thr any shortcuts Thanks -- FORUM RULES (934+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss.
Re: $$Excel-Macros$$ remove a certain text from every sentence
Select the column...go to find and replace...(CTRL+F) type the technology company in space for find and keep blank in the space provided for replace...then replace all. Sandeep Chhajer. Sent on my BlackBerryŽ from Vodafone -Original Message- From: smitha.kumari smitha.kum...@speridian.com Sender: excel-macros@googlegroups.com Date: Thu, 10 Nov 2011 10:39:15 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ remove a certain text from every sentence Hi, I want to remove a certain text from every sentence Technology Company:David Technology Company:Arya Technology Company:Jose I need only the name, Technology Company: has to be removed from every cells. Please reply. Regards Smitha -- FORUM RULES (925+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (925+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Re: How to use Advance filter
Hi Rohan, I have tried now the same but it only giving me the column labels as output. Don't know what to do. Sandeep Kumar Chhajer. Sent on my BlackBerryŽ from Vodafone -Original Message- From: Rohan bittu.ro...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 5 Nov 2011 23:52:48 To: MS EXCEL AND VBA MACROSexcel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: How to use Advance filter Using advanced filter you can filter your data, as per a specific criteria. Advanced Filter: List Range: Select the range that you want to filter. Criteria Range: Select the range on the basis of which you want to filter the data. Unique Records only: You can select this, if you want your results to return unique records only in the output. I think you should try with an example to filter and see the results. Let me know, if you have any difficulty. Thank you ! -- FORUM RULES (925+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (925+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ How to use Advance filter
Dear all, Please help me to learn how to use advance filter. I have tried to google to learn it but could not get it correct. Please help me learn it in excel 2007 version. Sandeep Chhajer. Sent on my BlackBerryŽ from Vodafone -- FORUM RULES (925+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Need to copy of 1st sheet of every workbook in a single work book
My files are saved in .xls format. But I am working in .xlxs. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: ashish koul koul.ash...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 3 Nov 2011 13:04:02 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need to copy of 1st sheet of every workbook in a single work book in which format ur files are saved .xls or xlsx On Thu, Nov 3, 2011 at 11:56 AM, sandeep chhajer chhajersand...@gmail.comwrote: Dear Ashish, I have copied it but when i am running the code it showing error msg pls help. On 3 November 2011 10:53, ashish koul koul.ash...@gmail.com wrote: Sub copy_first_sheet_from_different_workbooks_to_single() Application.DisplayAlerts = False Application.ScreenUpdating = False Dim fld As Object, fil As Object Dim ask As Workbook, ask2 As Workbook With Application.FileDialog(msoFileDialogFolderPicker) .Title = Choose the folder .InitialFileName = c:\ .Show End With fldpath = Application.FileDialog(msoFileDialogFolderPicker).SelectedItems(1) \ Set fso = CreateObject(scripting.filesystemobject) Set fld = fso.getfolder(fldpath) Set ask = Workbooks.Add For Each fil In fld.Files If UCase(Right(fil.Path, 4)) = UCase(.xls) Or UCase(Right(fil.Path, 5)) = UCase(.xlsx) Then Set ask2 = Workbooks.Open(fil.Path) ask2.Sheets(1).Copy After:=ask.Sheets(Sheets.Count) ask2.Close End If Next fil Application.DisplayAlerts = True Application.ScreenUpdating = True End Sub On Wed, Nov 2, 2011 at 3:43 PM, mrinal saha mris...@gmail.com wrote: Hi Sandeep, Save this attachment in the folder where you have all the workbooks and try to run the macro (Button) on page 1 of this file. Hope this helps, Mrinal On Wed, Nov 2, 2011 at 2:08 PM, chhajersand...@gmail.com wrote: Dear all, I have many work book in a single folder. I need a macro which if I run will copy the 1st sheet of every workbook in a single workbook (though as separate sheet). Like if I have 2 workbook viz WB1 and WB2 then I want the 1st worksheet of WB1 as 1st worksheet in a new workbook (say WB3) and again 1st worksheet of WB2 as 2nd worksheet of WB3. Thanks in advance. Sandeep Chhajer. Sent on my BlackBerryŽ from Vodafone -- FORUM RULES (925+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (925+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- FORUM RULES (925+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to