Re: $$Excel-Macros$$ Same conditional formatting is required in other sheets of the same file
Nice Solution Vaibhav Sir. Regaards 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/d/optout.
Re: $$Excel-Macros$$ Same conditional formatting is required in other sheets of the same file
Hi Vabs Set rng = Application.InputBox(Select cell/range for which you want to update chq no., Type:=8) For the above function can we make following cells by default: *C4 to C21* *F4 to F21* *I4 to I21* *O4 to O15* Because I want the result to be come in these cells only. Regards Pravin Gunjal On Wed, Jan 14, 2015 at 1:39 PM, Vaibhav Joshi v...@vabs.in wrote: Pravin, Chek this...Logic for fetching data remains same.. Also i have added one more functionality, just doubl click on chq. count to see it.. Cheers!! ᐧ On Wed, Jan 14, 2015 at 12:20 PM, Pravin Gunjal isk1...@gmail.com wrote: Dear Vabs Thank you for looking in to my query. I have checked the file given by you and it's giving the cheque details in main sheet, instead I want only *no. of cheques (how many cheques are not utilized) *available in main sheet. Also I want conditional format to be copied in other sheets too from sheet Mahavir. Could you please check it once again. Thank you, Regards Pravin Gunjal On Sat, Jan 10, 2015 at 10:12 PM, Vaibhav Joshi v...@vabs.in wrote: Hi Pravin, Check this...hope you must have handled conditional formatting, i worked on part for updating chq no.. Click on CHQ button select range from A4 to anything, or just single cell with customer name ..rest macro will take care.. Cheers!! On Sat, Jan 10, 2015 at 3:06 PM, Vaibhav Joshi v...@vabs.in wrote: is this resolved at your end or still pending? ᐧ On Fri, Jan 9, 2015 at 1:14 PM, Pravin Gunjal isk1...@gmail.com wrote: Hello Friends, I have an excel file with many sheets which is attached for your reference. In this file there is a sheet called: Mahavir ( you may go to this sheet by clicking on cell: *D18 *) in which I have set one conditional formatting which I wanted for all other sheets except Main Sheet - Sheet No.1 Could anybody help me to do this. Thank you, *Also one more help is required in the same file. **There is columns heading with CHQ in main sheet.* *For Example please go to sheet Ambika here whatever Cheque Dates are blank against Cheque No. those no. of entries I erquired in Main Sheet under CHQ filed before Ambika Agencies. So the No. will come as 1 in main sheet in cell : C5.* *I hope it is possible. Kindly help me out on this subject. It can be very very helpful for me in day to day activities. Thanks a lot in advance.* Regards Pravin Gunjal -- 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/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/Tn0p8fYTBVg/unsubscribe. To unsubscribe from this group and all its topics, 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$$ Same conditional formatting is required in other sheets of the same file
Replace with this line.. Set rng = Application.Union(Range(A4:A21), Range(D4:D21), Range(G4:G21), Range(J4:J21), Range(M4:M15)) ᐧ On Wed, Jan 14, 2015 at 5:44 PM, Pravin Gunjal isk1...@gmail.com wrote: Hi Vabs Set rng = Application.InputBox(Select cell/range for which you want to update chq no., Type:=8) For the above function can we make following cells by default: *C4 to C21* *F4 to F21* *I4 to I21* *O4 to O15* Because I want the result to be come in these cells only. Regards Pravin Gunjal On Wed, Jan 14, 2015 at 1:39 PM, Vaibhav Joshi v...@vabs.in wrote: Pravin, Chek this...Logic for fetching data remains same.. Also i have added one more functionality, just doubl click on chq. count to see it.. Cheers!! ᐧ On Wed, Jan 14, 2015 at 12:20 PM, Pravin Gunjal isk1...@gmail.com wrote: Dear Vabs Thank you for looking in to my query. I have checked the file given by you and it's giving the cheque details in main sheet, instead I want only *no. of cheques (how many cheques are not utilized) *available in main sheet. Also I want conditional format to be copied in other sheets too from sheet Mahavir. Could you please check it once again. Thank you, Regards Pravin Gunjal On Sat, Jan 10, 2015 at 10:12 PM, Vaibhav Joshi v...@vabs.in wrote: Hi Pravin, Check this...hope you must have handled conditional formatting, i worked on part for updating chq no.. Click on CHQ button select range from A4 to anything, or just single cell with customer name ..rest macro will take care.. Cheers!! On Sat, Jan 10, 2015 at 3:06 PM, Vaibhav Joshi v...@vabs.in wrote: is this resolved at your end or still pending? ᐧ On Fri, Jan 9, 2015 at 1:14 PM, Pravin Gunjal isk1...@gmail.com wrote: Hello Friends, I have an excel file with many sheets which is attached for your reference. In this file there is a sheet called: Mahavir ( you may go to this sheet by clicking on cell: *D18 *) in which I have set one conditional formatting which I wanted for all other sheets except Main Sheet - Sheet No.1 Could anybody help me to do this. Thank you, *Also one more help is required in the same file. **There is columns heading with CHQ in main sheet.* *For Example please go to sheet Ambika here whatever Cheque Dates are blank against Cheque No. those no. of entries I erquired in Main Sheet under CHQ filed before Ambika Agencies. So the No. will come as 1 in main sheet in cell : C5.* *I hope it is possible. Kindly help me out on this subject. It can be very very helpful for me in day to day activities. Thanks a lot in advance.* Regards Pravin Gunjal -- 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/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/Tn0p8fYTBVg/unsubscribe. To unsubscribe from this group and all its topics,
Re: $$Excel-Macros$$ Same conditional formatting is required in other sheets of the same file
*Very nice, thank you for the same. And the functionality you have added is awesome.* Also let me know the conditional formatting asked in my original mail. On Wed, Jan 14, 2015 at 5:56 PM, Vaibhav Joshi v...@vabs.in wrote: Replace with this line.. Set rng = Application.Union(Range(A4:A21), Range(D4:D21), Range(G4:G21), Range(J4:J21), Range(M4:M15)) ᐧ On Wed, Jan 14, 2015 at 5:44 PM, Pravin Gunjal isk1...@gmail.com wrote: Hi Vabs Set rng = Application.InputBox(Select cell/range for which you want to update chq no., Type:=8) For the above function can we make following cells by default: *C4 to C21* *F4 to F21* *I4 to I21* *O4 to O15* Because I want the result to be come in these cells only. Regards Pravin Gunjal On Wed, Jan 14, 2015 at 1:39 PM, Vaibhav Joshi v...@vabs.in wrote: Pravin, Chek this...Logic for fetching data remains same.. Also i have added one more functionality, just doubl click on chq. count to see it.. Cheers!! ᐧ On Wed, Jan 14, 2015 at 12:20 PM, Pravin Gunjal isk1...@gmail.com wrote: Dear Vabs Thank you for looking in to my query. I have checked the file given by you and it's giving the cheque details in main sheet, instead I want only *no. of cheques (how many cheques are not utilized) *available in main sheet. Also I want conditional format to be copied in other sheets too from sheet Mahavir. Could you please check it once again. Thank you, Regards Pravin Gunjal On Sat, Jan 10, 2015 at 10:12 PM, Vaibhav Joshi v...@vabs.in wrote: Hi Pravin, Check this...hope you must have handled conditional formatting, i worked on part for updating chq no.. Click on CHQ button select range from A4 to anything, or just single cell with customer name ..rest macro will take care.. Cheers!! On Sat, Jan 10, 2015 at 3:06 PM, Vaibhav Joshi v...@vabs.in wrote: is this resolved at your end or still pending? ᐧ On Fri, Jan 9, 2015 at 1:14 PM, Pravin Gunjal isk1...@gmail.com wrote: Hello Friends, I have an excel file with many sheets which is attached for your reference. In this file there is a sheet called: Mahavir ( you may go to this sheet by clicking on cell: *D18 *) in which I have set one conditional formatting which I wanted for all other sheets except Main Sheet - Sheet No.1 Could anybody help me to do this. Thank you, *Also one more help is required in the same file. **There is columns heading with CHQ in main sheet.* *For Example please go to sheet Ambika here whatever Cheque Dates are blank against Cheque No. those no. of entries I erquired in Main Sheet under CHQ filed before Ambika Agencies. So the No. will come as 1 in main sheet in cell : C5.* *I hope it is possible. Kindly help me out on this subject. It can be very very helpful for me in day to day activities. Thanks a lot in advance.* Regards Pravin Gunjal -- 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/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are
Re: $$Excel-Macros$$ Same conditional formatting is required in other sheets of the same file
is this resolved at your end or still pending? ᐧ On Fri, Jan 9, 2015 at 1:14 PM, Pravin Gunjal isk1...@gmail.com wrote: Hello Friends, I have an excel file with many sheets which is attached for your reference. In this file there is a sheet called: Mahavir ( you may go to this sheet by clicking on cell: *D18 *) in which I have set one conditional formatting which I wanted for all other sheets except Main Sheet - Sheet No.1 Could anybody help me to do this. Thank you, *Also one more help is required in the same file. **There is columns heading with CHQ in main sheet.* *For Example please go to sheet Ambika here whatever Cheque Dates are blank against Cheque No. those no. of entries I erquired in Main Sheet under CHQ filed before Ambika Agencies. So the No. will come as 1 in main sheet in cell : C5.* *I hope it is possible. Kindly help me out on this subject. It can be very very helpful for me in day to day activities. Thanks a lot in advance.* Regards Pravin Gunjal -- 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/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.