Re: $$Excel-Macros$$ Report
welcome bro.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 13, 2014 at 3:23 PM, joseph camill joseph.cam...@gmail.com wrote: Thank you Vaibhav On Sun, Oct 12, 2014 at 7:04 PM, Vaibhav Joshi v...@vabs.in wrote: Thanks bro... On Oct 12, 2014 6:05 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Vaibhav Bhai, Nice Solution. Sheet is working Great. Regards 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. -- 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. -- 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
Re: $$Excel-Macros$$ Report
Thank you Vaibhav On Sun, Oct 12, 2014 at 7:04 PM, Vaibhav Joshi v...@vabs.in wrote: Thanks bro... On Oct 12, 2014 6:05 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Vaibhav Bhai, Nice Solution. Sheet is working Great. Regards 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. -- 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.
Re: $$Excel-Macros$$ Report
hi you can use, indirect function in that case in combination with vlookup.. + *I did not do this for you. God is here working through me for you.* On Sat, Oct 11, 2014 at 12:26 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Can you suggest a formula or a code that updates the formula in final sheet based on STD. Right now i need to manually change formula in every new Final sheet. i.e. VLOOKUP range. On Sat, Oct 11, 2014 at 12:22 AM, Vaibhav Joshi v...@vabs.in wrote: Ok. .Cheers On Oct 10, 2014 1:27 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Yes, I tried this, and it is working great. I have made one modification. Instead of right click to the workbook, I added a Form control button and have assigned to it. Need to add more sheets and do a final check. On Fri, Oct 10, 2014 at 12:48 AM, Vaibhav Joshi v...@vabs.in wrote: Joseph Did you tried this. . -- Forwarded message -- From: Vaibhav Joshi v...@vabs.in Date: Oct 7, 2014 10:51 AM Subject: Re: $$Excel-Macros$$ Report To: excel-macros@googlegroups.com excel-macros@googlegroups.com Cc: JC check this, there is sheet name C, in that mention InputSheet Names in col A OutPutsheet name in ColB repsectively std wise in ascending order.. Also check all output sheet fits in one page, i have done it here for you.. Thats it, just right click on any sheet, you will get your dialer, select std there you go. In same folder where this macro file resides you will get folder name output which will contain your PDF files... Also macro will open folder after file is created... Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Oct 7, 2014 at 10:19 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, In addition, the format for Std IX and X will change in terms of marks display. Regards, Joseph On Oct 7, 2014 10:15 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Output format remains the same but there is addition / subtraction of subjects and off course student name will change. Thanks, Joseph On Oct 7, 2014 9:53 AM, Vaibhav Joshi v...@vabs.in wrote: Are output for individual Std is diff? + *I did not do this for you. God is here working through me for you.* On Tue, Oct 7, 2014 at 12:37 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, To clarify further, I will have multiple RAW sheets, the current example shows STD IV, so I will have 10 such sheets from STD I to STD 10. So instead of giving the Sheet name RAW, I may have the sheet name as STD_I, STD_II, etc. until STD_X and similarly 10 Final sheets. So instead of having 10 excel workbooks, we have just 1 excel workbook with 20 sheets - 10 for input and 10 for output. The Generate PDF, click will not have Final and Main, it will just have RAW as in the current example or STD_I, STD_II, etc until STD_10. So If i select STD_1, it will print Final_STD_I, or if I select STD_II it will print Final_STD_II. Thanks, Joseph Camill On Mon, Oct 6, 2014 at 8:26 PM, joseph camill joseph.cam...@gmail.com wrote: Excellent Vaibhav, Will have a micro level look at it later. Thank you. Joseph On Mon, Oct 6, 2014 at 8:16 PM, Vaibhav Joshi v...@vabs.in wrote: chk this... Goto main sheet press button to run macro! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 7:46 PM, joseph camill joseph.cam...@gmail.com wrote: Thank you Vaibhav. Yes it is clear per your earlier email. On Mon, Oct 6, 2014 at 6:48 PM, Vaibhav Joshi v...@vabs.in wrote: For X=3 is not counting sheets!! It is begining selecting sheets from sheet #3 onwards..Check module PDFActiveSheet_Consol() will share dynamic code which can enable you to select sheet names adapt further changes as mentioned by you!! Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 5:24 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, I think the end loop i.e. For x = 3 … is counting the number of worksheets in the workbook, if it is less than 3 than it proceeds to execute the code. Is there a way to make Sheet Name dynamic in code. Now we are specifying RAW and Final in the code. This works if there are only 2 sheets i.e. input and Final. What if we have more than one input and Final Sheet. For e.g. Now we have STD III, but if I have to add STD IV or STD V as well, then I need to add so many modules. Can we have one code that checks the STD and then execute. May be a pop-up that asks for the STD and then picks that sheet. NOTE: there will be slight variation in the RAW / Final sheet for various STD and that would be addition/subtraction of subjects and change in Name. On Mon, Oct 6, 2014 at 1:44 PM, Vaibhav Joshi v...@vabs.in wrote: what other requests
Re: $$Excel-Macros$$ Report
Hi Vaibhav Bhai, Nice Solution. Sheet is working Great. Regards 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$$ Report
Thanks bro... On Oct 12, 2014 6:05 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Vaibhav Bhai, Nice Solution. Sheet is working Great. Regards 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. -- 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$$ Report
Ok. .Cheers On Oct 10, 2014 1:27 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Yes, I tried this, and it is working great. I have made one modification. Instead of right click to the workbook, I added a Form control button and have assigned to it. Need to add more sheets and do a final check. On Fri, Oct 10, 2014 at 12:48 AM, Vaibhav Joshi v...@vabs.in wrote: Joseph Did you tried this. . -- Forwarded message -- From: Vaibhav Joshi v...@vabs.in Date: Oct 7, 2014 10:51 AM Subject: Re: $$Excel-Macros$$ Report To: excel-macros@googlegroups.com excel-macros@googlegroups.com Cc: JC check this, there is sheet name C, in that mention InputSheet Names in col A OutPutsheet name in ColB repsectively std wise in ascending order.. Also check all output sheet fits in one page, i have done it here for you.. Thats it, just right click on any sheet, you will get your dialer, select std there you go. In same folder where this macro file resides you will get folder name output which will contain your PDF files... Also macro will open folder after file is created... Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Oct 7, 2014 at 10:19 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, In addition, the format for Std IX and X will change in terms of marks display. Regards, Joseph On Oct 7, 2014 10:15 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Output format remains the same but there is addition / subtraction of subjects and off course student name will change. Thanks, Joseph On Oct 7, 2014 9:53 AM, Vaibhav Joshi v...@vabs.in wrote: Are output for individual Std is diff? + *I did not do this for you. God is here working through me for you.* On Tue, Oct 7, 2014 at 12:37 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, To clarify further, I will have multiple RAW sheets, the current example shows STD IV, so I will have 10 such sheets from STD I to STD 10. So instead of giving the Sheet name RAW, I may have the sheet name as STD_I, STD_II, etc. until STD_X and similarly 10 Final sheets. So instead of having 10 excel workbooks, we have just 1 excel workbook with 20 sheets - 10 for input and 10 for output. The Generate PDF, click will not have Final and Main, it will just have RAW as in the current example or STD_I, STD_II, etc until STD_10. So If i select STD_1, it will print Final_STD_I, or if I select STD_II it will print Final_STD_II. Thanks, Joseph Camill On Mon, Oct 6, 2014 at 8:26 PM, joseph camill joseph.cam...@gmail.com wrote: Excellent Vaibhav, Will have a micro level look at it later. Thank you. Joseph On Mon, Oct 6, 2014 at 8:16 PM, Vaibhav Joshi v...@vabs.in wrote: chk this... Goto main sheet press button to run macro! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 7:46 PM, joseph camill joseph.cam...@gmail.com wrote: Thank you Vaibhav. Yes it is clear per your earlier email. On Mon, Oct 6, 2014 at 6:48 PM, Vaibhav Joshi v...@vabs.in wrote: For X=3 is not counting sheets!! It is begining selecting sheets from sheet #3 onwards..Check module PDFActiveSheet_Consol() will share dynamic code which can enable you to select sheet names adapt further changes as mentioned by you!! Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 5:24 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, I think the end loop i.e. For x = 3 … is counting the number of worksheets in the workbook, if it is less than 3 than it proceeds to execute the code. Is there a way to make Sheet Name dynamic in code. Now we are specifying RAW and Final in the code. This works if there are only 2 sheets i.e. input and Final. What if we have more than one input and Final Sheet. For e.g. Now we have STD III, but if I have to add STD IV or STD V as well, then I need to add so many modules. Can we have one code that checks the STD and then execute. May be a pop-up that asks for the STD and then picks that sheet. NOTE: there will be slight variation in the RAW / Final sheet for various STD and that would be addition/subtraction of subjects and change in Name. On Mon, Oct 6, 2014 at 1:44 PM, Vaibhav Joshi v...@vabs.in wrote: what other requests? + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 1:20 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the clarification. Is there any chance to get the other request, if possible. Thanks, Joseph On Mon, Oct 6, 2014 at 12:04 PM, Vaibhav Joshi v...@vabs.in wrote: Hi, You have 2 sheets in this excel workbook, I am creating new sheets after sheet 2 for each students, once all sheet is created i am selecting all
Re: $$Excel-Macros$$ Report
Hi Vaibhav, Can you suggest a formula or a code that updates the formula in final sheet based on STD. Right now i need to manually change formula in every new Final sheet. i.e. VLOOKUP range. On Sat, Oct 11, 2014 at 12:22 AM, Vaibhav Joshi v...@vabs.in wrote: Ok. .Cheers On Oct 10, 2014 1:27 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Yes, I tried this, and it is working great. I have made one modification. Instead of right click to the workbook, I added a Form control button and have assigned to it. Need to add more sheets and do a final check. On Fri, Oct 10, 2014 at 12:48 AM, Vaibhav Joshi v...@vabs.in wrote: Joseph Did you tried this. . -- Forwarded message -- From: Vaibhav Joshi v...@vabs.in Date: Oct 7, 2014 10:51 AM Subject: Re: $$Excel-Macros$$ Report To: excel-macros@googlegroups.com excel-macros@googlegroups.com Cc: JC check this, there is sheet name C, in that mention InputSheet Names in col A OutPutsheet name in ColB repsectively std wise in ascending order.. Also check all output sheet fits in one page, i have done it here for you.. Thats it, just right click on any sheet, you will get your dialer, select std there you go. In same folder where this macro file resides you will get folder name output which will contain your PDF files... Also macro will open folder after file is created... Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Oct 7, 2014 at 10:19 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, In addition, the format for Std IX and X will change in terms of marks display. Regards, Joseph On Oct 7, 2014 10:15 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Output format remains the same but there is addition / subtraction of subjects and off course student name will change. Thanks, Joseph On Oct 7, 2014 9:53 AM, Vaibhav Joshi v...@vabs.in wrote: Are output for individual Std is diff? + *I did not do this for you. God is here working through me for you.* On Tue, Oct 7, 2014 at 12:37 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, To clarify further, I will have multiple RAW sheets, the current example shows STD IV, so I will have 10 such sheets from STD I to STD 10. So instead of giving the Sheet name RAW, I may have the sheet name as STD_I, STD_II, etc. until STD_X and similarly 10 Final sheets. So instead of having 10 excel workbooks, we have just 1 excel workbook with 20 sheets - 10 for input and 10 for output. The Generate PDF, click will not have Final and Main, it will just have RAW as in the current example or STD_I, STD_II, etc until STD_10. So If i select STD_1, it will print Final_STD_I, or if I select STD_II it will print Final_STD_II. Thanks, Joseph Camill On Mon, Oct 6, 2014 at 8:26 PM, joseph camill joseph.cam...@gmail.com wrote: Excellent Vaibhav, Will have a micro level look at it later. Thank you. Joseph On Mon, Oct 6, 2014 at 8:16 PM, Vaibhav Joshi v...@vabs.in wrote: chk this... Goto main sheet press button to run macro! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 7:46 PM, joseph camill joseph.cam...@gmail.com wrote: Thank you Vaibhav. Yes it is clear per your earlier email. On Mon, Oct 6, 2014 at 6:48 PM, Vaibhav Joshi v...@vabs.in wrote: For X=3 is not counting sheets!! It is begining selecting sheets from sheet #3 onwards..Check module PDFActiveSheet_Consol() will share dynamic code which can enable you to select sheet names adapt further changes as mentioned by you!! Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 5:24 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, I think the end loop i.e. For x = 3 … is counting the number of worksheets in the workbook, if it is less than 3 than it proceeds to execute the code. Is there a way to make Sheet Name dynamic in code. Now we are specifying RAW and Final in the code. This works if there are only 2 sheets i.e. input and Final. What if we have more than one input and Final Sheet. For e.g. Now we have STD III, but if I have to add STD IV or STD V as well, then I need to add so many modules. Can we have one code that checks the STD and then execute. May be a pop-up that asks for the STD and then picks that sheet. NOTE: there will be slight variation in the RAW / Final sheet for various STD and that would be addition/subtraction of subjects and change in Name. On Mon, Oct 6, 2014 at 1:44 PM, Vaibhav Joshi v...@vabs.in wrote: what other requests? + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 1:20 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the clarification. Is there any chance to get the other
Re: $$Excel-Macros$$ Report
Hi Vaibhav, Thank you for the file and apologies for the late response. It is working great. Thanks and regards, Joseph Camill On Tue, Oct 7, 2014 at 10:51 AM, Vaibhav Joshi v...@vabs.in wrote: JC check this, there is sheet name C, in that mention InputSheet Names in col A OutPutsheet name in ColB repsectively std wise in ascending order.. Also check all output sheet fits in one page, i have done it here for you.. Thats it, just right click on any sheet, you will get your dialer, select std there you go. In same folder where this macro file resides you will get folder name output which will contain your PDF files... Also macro will open folder after file is created... Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Oct 7, 2014 at 10:19 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, In addition, the format for Std IX and X will change in terms of marks display. Regards, Joseph On Oct 7, 2014 10:15 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Output format remains the same but there is addition / subtraction of subjects and off course student name will change. Thanks, Joseph On Oct 7, 2014 9:53 AM, Vaibhav Joshi v...@vabs.in wrote: Are output for individual Std is diff? + *I did not do this for you. God is here working through me for you.* On Tue, Oct 7, 2014 at 12:37 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, To clarify further, I will have multiple RAW sheets, the current example shows STD IV, so I will have 10 such sheets from STD I to STD 10. So instead of giving the Sheet name RAW, I may have the sheet name as STD_I, STD_II, etc. until STD_X and similarly 10 Final sheets. So instead of having 10 excel workbooks, we have just 1 excel workbook with 20 sheets - 10 for input and 10 for output. The Generate PDF, click will not have Final and Main, it will just have RAW as in the current example or STD_I, STD_II, etc until STD_10. So If i select STD_1, it will print Final_STD_I, or if I select STD_II it will print Final_STD_II. Thanks, Joseph Camill On Mon, Oct 6, 2014 at 8:26 PM, joseph camill joseph.cam...@gmail.com wrote: Excellent Vaibhav, Will have a micro level look at it later. Thank you. Joseph On Mon, Oct 6, 2014 at 8:16 PM, Vaibhav Joshi v...@vabs.in wrote: chk this... Goto main sheet press button to run macro! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 7:46 PM, joseph camill joseph.cam...@gmail.com wrote: Thank you Vaibhav. Yes it is clear per your earlier email. On Mon, Oct 6, 2014 at 6:48 PM, Vaibhav Joshi v...@vabs.in wrote: For X=3 is not counting sheets!! It is begining selecting sheets from sheet #3 onwards..Check module PDFActiveSheet_Consol() will share dynamic code which can enable you to select sheet names adapt further changes as mentioned by you!! Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 5:24 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, I think the end loop i.e. For x = 3 … is counting the number of worksheets in the workbook, if it is less than 3 than it proceeds to execute the code. Is there a way to make Sheet Name dynamic in code. Now we are specifying RAW and Final in the code. This works if there are only 2 sheets i.e. input and Final. What if we have more than one input and Final Sheet. For e.g. Now we have STD III, but if I have to add STD IV or STD V as well, then I need to add so many modules. Can we have one code that checks the STD and then execute. May be a pop-up that asks for the STD and then picks that sheet. NOTE: there will be slight variation in the RAW / Final sheet for various STD and that would be addition/subtraction of subjects and change in Name. On Mon, Oct 6, 2014 at 1:44 PM, Vaibhav Joshi v...@vabs.in wrote: what other requests? + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 1:20 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the clarification. Is there any chance to get the other request, if possible. Thanks, Joseph On Mon, Oct 6, 2014 at 12:04 PM, Vaibhav Joshi v...@vabs.in wrote: Hi, You have 2 sheets in this excel workbook, I am creating new sheets after sheet 2 for each students, once all sheet is created i am selecting all sheets and sending it to PDF for publishing in to one file. Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 12:15 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Can you please explain the last loop in the code For x = 3 … part. On Tue, Sep 30, 2014 at 4:04 PM, Vaibhav Joshi v...@vabs.in wrote: Cheers!! + *I did not do this for you. God
Re: $$Excel-Macros$$ Report
Hi, You have 2 sheets in this excel workbook, I am creating new sheets after sheet 2 for each students, once all sheet is created i am selecting all sheets and sending it to PDF for publishing in to one file. Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 12:15 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Can you please explain the last loop in the code For x = 3 … part. On Tue, Sep 30, 2014 at 4:04 PM, Vaibhav Joshi v...@vabs.in wrote: Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Sep 30, 2014 at 4:44 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, It is working perfect, as per my requirement. Will email if incase I need any further updates. Thank you very much, you made my work easy. On Mon, Sep 29, 2014 at 11:23 PM, Vaibhav Joshi v...@vabs.in wrote: Cheers On Sep 29, 2014 9:58 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file and working on suggested changes. It is very helpful. Will have a look in detail and will revert. It is really a great one. On Mon, Sep 29, 2014 at 2:32 PM, Vaibhav Joshi v...@vabs.in wrote: 1. Create folder name based on STD - Ok 2. Have just one pdf with all the reports. - Chk attachments 3. Right now it is generating the name using Offset i suppose, Can we do a search for Name and then generate. - Do you want for few employees? then paste employee name in range U then report for only those employee will be generated. If you want report for all employees then keep Column U as blank. Cheers!! + *I did not do this for you. God is here working through me for you.* On Sun, Sep 28, 2014 at 9:02 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file. It is very helpful. Is it possible to make three changes. 1. Create folder name based on STD 2. Have just one pdf with all the reports. 3. Right now it is generating the name using Offset i suppose, Can we do a search for Name and then generate. On Sun, Sep 28, 2014 at 8:58 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file. It is very helpful. It creates various PDF as per the Name, Is it possible to have just one pdf with all the mark sheet. On Sun, Sep 28, 2014 at 7:06 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the solution. I will check it and get back to you. Thanks and regards, Joseph On Sep 27, 2014 3:43 PM, Vaibhav Joshi v...@vabs.in wrote: Hey Chek attachment, just click on blue button folder name Test will be created on desktop report card will be saved name wise in PDF file.. if you get error getting pdf file ensure you have installed extension from this link: http://www.microsoft.com/en-in/download/details.aspx?id=9943 Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Sep 27, 2014 at 4:10 AM, joseph camill joseph.cam...@gmail.com wrote: Hi, I am working on a project where I need to print 100 report card at a time either directly to a printer or as PDF. Attached is the example workbook. All my data will be entered in sheet named Raw and my output should look like sheet named Final. Is it possible to print it to PDF / printer without having to create number of sheets? Thank you in advance. Regards, Joseph -- 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
Re: $$Excel-Macros$$ Report
Hi Vaibhav, Thank you for the clarification. Is there any chance to get the other request, if possible. Thanks, Joseph On Mon, Oct 6, 2014 at 12:04 PM, Vaibhav Joshi v...@vabs.in wrote: Hi, You have 2 sheets in this excel workbook, I am creating new sheets after sheet 2 for each students, once all sheet is created i am selecting all sheets and sending it to PDF for publishing in to one file. Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 12:15 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Can you please explain the last loop in the code For x = 3 … part. On Tue, Sep 30, 2014 at 4:04 PM, Vaibhav Joshi v...@vabs.in wrote: Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Sep 30, 2014 at 4:44 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, It is working perfect, as per my requirement. Will email if incase I need any further updates. Thank you very much, you made my work easy. On Mon, Sep 29, 2014 at 11:23 PM, Vaibhav Joshi v...@vabs.in wrote: Cheers On Sep 29, 2014 9:58 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file and working on suggested changes. It is very helpful. Will have a look in detail and will revert. It is really a great one. On Mon, Sep 29, 2014 at 2:32 PM, Vaibhav Joshi v...@vabs.in wrote: 1. Create folder name based on STD - Ok 2. Have just one pdf with all the reports. - Chk attachments 3. Right now it is generating the name using Offset i suppose, Can we do a search for Name and then generate. - Do you want for few employees? then paste employee name in range U then report for only those employee will be generated. If you want report for all employees then keep Column U as blank. Cheers!! + *I did not do this for you. God is here working through me for you.* On Sun, Sep 28, 2014 at 9:02 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file. It is very helpful. Is it possible to make three changes. 1. Create folder name based on STD 2. Have just one pdf with all the reports. 3. Right now it is generating the name using Offset i suppose, Can we do a search for Name and then generate. On Sun, Sep 28, 2014 at 8:58 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file. It is very helpful. It creates various PDF as per the Name, Is it possible to have just one pdf with all the mark sheet. On Sun, Sep 28, 2014 at 7:06 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the solution. I will check it and get back to you. Thanks and regards, Joseph On Sep 27, 2014 3:43 PM, Vaibhav Joshi v...@vabs.in wrote: Hey Chek attachment, just click on blue button folder name Test will be created on desktop report card will be saved name wise in PDF file.. if you get error getting pdf file ensure you have installed extension from this link: http://www.microsoft.com/en-in/download/details.aspx?id=9943 Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Sep 27, 2014 at 4:10 AM, joseph camill joseph.cam...@gmail.com wrote: Hi, I am working on a project where I need to print 100 report card at a time either directly to a printer or as PDF. Attached is the example workbook. All my data will be entered in sheet named Raw and my output should look like sheet named Final. Is it possible to print it to PDF / printer without having to create number of sheets? Thank you in advance. Regards, Joseph -- 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?
Re: $$Excel-Macros$$ Report
what other requests? + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 1:20 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the clarification. Is there any chance to get the other request, if possible. Thanks, Joseph On Mon, Oct 6, 2014 at 12:04 PM, Vaibhav Joshi v...@vabs.in wrote: Hi, You have 2 sheets in this excel workbook, I am creating new sheets after sheet 2 for each students, once all sheet is created i am selecting all sheets and sending it to PDF for publishing in to one file. Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 12:15 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Can you please explain the last loop in the code For x = 3 … part. On Tue, Sep 30, 2014 at 4:04 PM, Vaibhav Joshi v...@vabs.in wrote: Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Sep 30, 2014 at 4:44 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, It is working perfect, as per my requirement. Will email if incase I need any further updates. Thank you very much, you made my work easy. On Mon, Sep 29, 2014 at 11:23 PM, Vaibhav Joshi v...@vabs.in wrote: Cheers On Sep 29, 2014 9:58 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file and working on suggested changes. It is very helpful. Will have a look in detail and will revert. It is really a great one. On Mon, Sep 29, 2014 at 2:32 PM, Vaibhav Joshi v...@vabs.in wrote: 1. Create folder name based on STD - Ok 2. Have just one pdf with all the reports. - Chk attachments 3. Right now it is generating the name using Offset i suppose, Can we do a search for Name and then generate. - Do you want for few employees? then paste employee name in range U then report for only those employee will be generated. If you want report for all employees then keep Column U as blank. Cheers!! + *I did not do this for you. God is here working through me for you.* On Sun, Sep 28, 2014 at 9:02 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file. It is very helpful. Is it possible to make three changes. 1. Create folder name based on STD 2. Have just one pdf with all the reports. 3. Right now it is generating the name using Offset i suppose, Can we do a search for Name and then generate. On Sun, Sep 28, 2014 at 8:58 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file. It is very helpful. It creates various PDF as per the Name, Is it possible to have just one pdf with all the mark sheet. On Sun, Sep 28, 2014 at 7:06 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the solution. I will check it and get back to you. Thanks and regards, Joseph On Sep 27, 2014 3:43 PM, Vaibhav Joshi v...@vabs.in wrote: Hey Chek attachment, just click on blue button folder name Test will be created on desktop report card will be saved name wise in PDF file.. if you get error getting pdf file ensure you have installed extension from this link: http://www.microsoft.com/en-in/download/details.aspx?id=9943 Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Sep 27, 2014 at 4:10 AM, joseph camill joseph.cam...@gmail.com wrote: Hi, I am working on a project where I need to print 100 report card at a time either directly to a printer or as PDF. Attached is the example workbook. All my data will be entered in sheet named Raw and my output should look like sheet named Final. Is it possible to print it to PDF / printer without having to create number of sheets? Thank you in advance. Regards, Joseph -- 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
Re: $$Excel-Macros$$ Report
Hi Vaibhav, I think the end loop i.e. For x = 3 … is counting the number of worksheets in the workbook, if it is less than 3 than it proceeds to execute the code. Is there a way to make Sheet Name dynamic in code. Now we are specifying RAW and Final in the code. This works if there are only 2 sheets i.e. input and Final. What if we have more than one input and Final Sheet. For e.g. Now we have STD III, but if I have to add STD IV or STD V as well, then I need to add so many modules. Can we have one code that checks the STD and then execute. May be a pop-up that asks for the STD and then picks that sheet. NOTE: there will be slight variation in the RAW / Final sheet for various STD and that would be addition/subtraction of subjects and change in Name. On Mon, Oct 6, 2014 at 1:44 PM, Vaibhav Joshi v...@vabs.in wrote: what other requests? + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 1:20 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the clarification. Is there any chance to get the other request, if possible. Thanks, Joseph On Mon, Oct 6, 2014 at 12:04 PM, Vaibhav Joshi v...@vabs.in wrote: Hi, You have 2 sheets in this excel workbook, I am creating new sheets after sheet 2 for each students, once all sheet is created i am selecting all sheets and sending it to PDF for publishing in to one file. Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 12:15 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Can you please explain the last loop in the code For x = 3 … part. On Tue, Sep 30, 2014 at 4:04 PM, Vaibhav Joshi v...@vabs.in wrote: Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Sep 30, 2014 at 4:44 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, It is working perfect, as per my requirement. Will email if incase I need any further updates. Thank you very much, you made my work easy. On Mon, Sep 29, 2014 at 11:23 PM, Vaibhav Joshi v...@vabs.in wrote: Cheers On Sep 29, 2014 9:58 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file and working on suggested changes. It is very helpful. Will have a look in detail and will revert. It is really a great one. On Mon, Sep 29, 2014 at 2:32 PM, Vaibhav Joshi v...@vabs.in wrote: 1. Create folder name based on STD - Ok 2. Have just one pdf with all the reports. - Chk attachments 3. Right now it is generating the name using Offset i suppose, Can we do a search for Name and then generate. - Do you want for few employees? then paste employee name in range U then report for only those employee will be generated. If you want report for all employees then keep Column U as blank. Cheers!! + *I did not do this for you. God is here working through me for you.* On Sun, Sep 28, 2014 at 9:02 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file. It is very helpful. Is it possible to make three changes. 1. Create folder name based on STD 2. Have just one pdf with all the reports. 3. Right now it is generating the name using Offset i suppose, Can we do a search for Name and then generate. On Sun, Sep 28, 2014 at 8:58 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file. It is very helpful. It creates various PDF as per the Name, Is it possible to have just one pdf with all the mark sheet. On Sun, Sep 28, 2014 at 7:06 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the solution. I will check it and get back to you. Thanks and regards, Joseph On Sep 27, 2014 3:43 PM, Vaibhav Joshi v...@vabs.in wrote: Hey Chek attachment, just click on blue button folder name Test will be created on desktop report card will be saved name wise in PDF file.. if you get error getting pdf file ensure you have installed extension from this link: http://www.microsoft.com/en-in/download/details.aspx?id=9943 Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Sep 27, 2014 at 4:10 AM, joseph camill joseph.cam...@gmail.com wrote: Hi, I am working on a project where I need to print 100 report card at a time either directly to a printer or as PDF. Attached is the example workbook. All my data will be entered in sheet named Raw and my output should look like sheet named Final. Is it possible to print it to PDF / printer without having to create number of sheets? Thank you in advance. Regards, Joseph -- 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,
Re: $$Excel-Macros$$ Report
For X=3 is not counting sheets!! It is begining selecting sheets from sheet #3 onwards..Check module PDFActiveSheet_Consol() will share dynamic code which can enable you to select sheet names adapt further changes as mentioned by you!! Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 5:24 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, I think the end loop i.e. For x = 3 … is counting the number of worksheets in the workbook, if it is less than 3 than it proceeds to execute the code. Is there a way to make Sheet Name dynamic in code. Now we are specifying RAW and Final in the code. This works if there are only 2 sheets i.e. input and Final. What if we have more than one input and Final Sheet. For e.g. Now we have STD III, but if I have to add STD IV or STD V as well, then I need to add so many modules. Can we have one code that checks the STD and then execute. May be a pop-up that asks for the STD and then picks that sheet. NOTE: there will be slight variation in the RAW / Final sheet for various STD and that would be addition/subtraction of subjects and change in Name. On Mon, Oct 6, 2014 at 1:44 PM, Vaibhav Joshi v...@vabs.in wrote: what other requests? + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 1:20 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the clarification. Is there any chance to get the other request, if possible. Thanks, Joseph On Mon, Oct 6, 2014 at 12:04 PM, Vaibhav Joshi v...@vabs.in wrote: Hi, You have 2 sheets in this excel workbook, I am creating new sheets after sheet 2 for each students, once all sheet is created i am selecting all sheets and sending it to PDF for publishing in to one file. Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 12:15 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Can you please explain the last loop in the code For x = 3 … part. On Tue, Sep 30, 2014 at 4:04 PM, Vaibhav Joshi v...@vabs.in wrote: Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Sep 30, 2014 at 4:44 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, It is working perfect, as per my requirement. Will email if incase I need any further updates. Thank you very much, you made my work easy. On Mon, Sep 29, 2014 at 11:23 PM, Vaibhav Joshi v...@vabs.in wrote: Cheers On Sep 29, 2014 9:58 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file and working on suggested changes. It is very helpful. Will have a look in detail and will revert. It is really a great one. On Mon, Sep 29, 2014 at 2:32 PM, Vaibhav Joshi v...@vabs.in wrote: 1. Create folder name based on STD - Ok 2. Have just one pdf with all the reports. - Chk attachments 3. Right now it is generating the name using Offset i suppose, Can we do a search for Name and then generate. - Do you want for few employees? then paste employee name in range U then report for only those employee will be generated. If you want report for all employees then keep Column U as blank. Cheers!! + *I did not do this for you. God is here working through me for you.* On Sun, Sep 28, 2014 at 9:02 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file. It is very helpful. Is it possible to make three changes. 1. Create folder name based on STD 2. Have just one pdf with all the reports. 3. Right now it is generating the name using Offset i suppose, Can we do a search for Name and then generate. On Sun, Sep 28, 2014 at 8:58 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file. It is very helpful. It creates various PDF as per the Name, Is it possible to have just one pdf with all the mark sheet. On Sun, Sep 28, 2014 at 7:06 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the solution. I will check it and get back to you. Thanks and regards, Joseph On Sep 27, 2014 3:43 PM, Vaibhav Joshi v...@vabs.in wrote: Hey Chek attachment, just click on blue button folder name Test will be created on desktop report card will be saved name wise in PDF file.. if you get error getting pdf file ensure you have installed extension from this link: http://www.microsoft.com/en-in/download/details.aspx?id=9943 Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Sep 27, 2014 at 4:10 AM, joseph camill joseph.cam...@gmail.com wrote: Hi, I am working on a project where I need to print 100 report card at a time either directly to a printer or as PDF. Attached is the example workbook. All my data will be entered in sheet named Raw and my output should look like sheet named
Re: $$Excel-Macros$$ Report
Thank you Vaibhav. Yes it is clear per your earlier email. On Mon, Oct 6, 2014 at 6:48 PM, Vaibhav Joshi v...@vabs.in wrote: For X=3 is not counting sheets!! It is begining selecting sheets from sheet #3 onwards..Check module PDFActiveSheet_Consol() will share dynamic code which can enable you to select sheet names adapt further changes as mentioned by you!! Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 5:24 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, I think the end loop i.e. For x = 3 … is counting the number of worksheets in the workbook, if it is less than 3 than it proceeds to execute the code. Is there a way to make Sheet Name dynamic in code. Now we are specifying RAW and Final in the code. This works if there are only 2 sheets i.e. input and Final. What if we have more than one input and Final Sheet. For e.g. Now we have STD III, but if I have to add STD IV or STD V as well, then I need to add so many modules. Can we have one code that checks the STD and then execute. May be a pop-up that asks for the STD and then picks that sheet. NOTE: there will be slight variation in the RAW / Final sheet for various STD and that would be addition/subtraction of subjects and change in Name. On Mon, Oct 6, 2014 at 1:44 PM, Vaibhav Joshi v...@vabs.in wrote: what other requests? + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 1:20 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the clarification. Is there any chance to get the other request, if possible. Thanks, Joseph On Mon, Oct 6, 2014 at 12:04 PM, Vaibhav Joshi v...@vabs.in wrote: Hi, You have 2 sheets in this excel workbook, I am creating new sheets after sheet 2 for each students, once all sheet is created i am selecting all sheets and sending it to PDF for publishing in to one file. Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 12:15 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Can you please explain the last loop in the code For x = 3 … part. On Tue, Sep 30, 2014 at 4:04 PM, Vaibhav Joshi v...@vabs.in wrote: Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Sep 30, 2014 at 4:44 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, It is working perfect, as per my requirement. Will email if incase I need any further updates. Thank you very much, you made my work easy. On Mon, Sep 29, 2014 at 11:23 PM, Vaibhav Joshi v...@vabs.in wrote: Cheers On Sep 29, 2014 9:58 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file and working on suggested changes. It is very helpful. Will have a look in detail and will revert. It is really a great one. On Mon, Sep 29, 2014 at 2:32 PM, Vaibhav Joshi v...@vabs.in wrote: 1. Create folder name based on STD - Ok 2. Have just one pdf with all the reports. - Chk attachments 3. Right now it is generating the name using Offset i suppose, Can we do a search for Name and then generate. - Do you want for few employees? then paste employee name in range U then report for only those employee will be generated. If you want report for all employees then keep Column U as blank. Cheers!! + *I did not do this for you. God is here working through me for you.* On Sun, Sep 28, 2014 at 9:02 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file. It is very helpful. Is it possible to make three changes. 1. Create folder name based on STD 2. Have just one pdf with all the reports. 3. Right now it is generating the name using Offset i suppose, Can we do a search for Name and then generate. On Sun, Sep 28, 2014 at 8:58 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file. It is very helpful. It creates various PDF as per the Name, Is it possible to have just one pdf with all the mark sheet. On Sun, Sep 28, 2014 at 7:06 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the solution. I will check it and get back to you. Thanks and regards, Joseph On Sep 27, 2014 3:43 PM, Vaibhav Joshi v...@vabs.in wrote: Hey Chek attachment, just click on blue button folder name Test will be created on desktop report card will be saved name wise in PDF file.. if you get error getting pdf file ensure you have installed extension from this link: http://www.microsoft.com/en-in/download/details.aspx?id=9943 Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Sep 27, 2014 at 4:10 AM, joseph camill joseph.cam...@gmail.com wrote: Hi, I am working on a project where I need to print 100 report card at a time either directly to a printer or as
Re: $$Excel-Macros$$ Report
Excellent Vaibhav, Will have a micro level look at it later. Thank you. Joseph On Mon, Oct 6, 2014 at 8:16 PM, Vaibhav Joshi v...@vabs.in wrote: chk this... Goto main sheet press button to run macro! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 7:46 PM, joseph camill joseph.cam...@gmail.com wrote: Thank you Vaibhav. Yes it is clear per your earlier email. On Mon, Oct 6, 2014 at 6:48 PM, Vaibhav Joshi v...@vabs.in wrote: For X=3 is not counting sheets!! It is begining selecting sheets from sheet #3 onwards..Check module PDFActiveSheet_Consol() will share dynamic code which can enable you to select sheet names adapt further changes as mentioned by you!! Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 5:24 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, I think the end loop i.e. For x = 3 … is counting the number of worksheets in the workbook, if it is less than 3 than it proceeds to execute the code. Is there a way to make Sheet Name dynamic in code. Now we are specifying RAW and Final in the code. This works if there are only 2 sheets i.e. input and Final. What if we have more than one input and Final Sheet. For e.g. Now we have STD III, but if I have to add STD IV or STD V as well, then I need to add so many modules. Can we have one code that checks the STD and then execute. May be a pop-up that asks for the STD and then picks that sheet. NOTE: there will be slight variation in the RAW / Final sheet for various STD and that would be addition/subtraction of subjects and change in Name. On Mon, Oct 6, 2014 at 1:44 PM, Vaibhav Joshi v...@vabs.in wrote: what other requests? + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 1:20 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the clarification. Is there any chance to get the other request, if possible. Thanks, Joseph On Mon, Oct 6, 2014 at 12:04 PM, Vaibhav Joshi v...@vabs.in wrote: Hi, You have 2 sheets in this excel workbook, I am creating new sheets after sheet 2 for each students, once all sheet is created i am selecting all sheets and sending it to PDF for publishing in to one file. Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 12:15 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Can you please explain the last loop in the code For x = 3 … part. On Tue, Sep 30, 2014 at 4:04 PM, Vaibhav Joshi v...@vabs.in wrote: Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Sep 30, 2014 at 4:44 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, It is working perfect, as per my requirement. Will email if incase I need any further updates. Thank you very much, you made my work easy. On Mon, Sep 29, 2014 at 11:23 PM, Vaibhav Joshi v...@vabs.in wrote: Cheers On Sep 29, 2014 9:58 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file and working on suggested changes. It is very helpful. Will have a look in detail and will revert. It is really a great one. On Mon, Sep 29, 2014 at 2:32 PM, Vaibhav Joshi v...@vabs.in wrote: 1. Create folder name based on STD - Ok 2. Have just one pdf with all the reports. - Chk attachments 3. Right now it is generating the name using Offset i suppose, Can we do a search for Name and then generate. - Do you want for few employees? then paste employee name in range U then report for only those employee will be generated. If you want report for all employees then keep Column U as blank. Cheers!! + *I did not do this for you. God is here working through me for you.* On Sun, Sep 28, 2014 at 9:02 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file. It is very helpful. Is it possible to make three changes. 1. Create folder name based on STD 2. Have just one pdf with all the reports. 3. Right now it is generating the name using Offset i suppose, Can we do a search for Name and then generate. On Sun, Sep 28, 2014 at 8:58 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file. It is very helpful. It creates various PDF as per the Name, Is it possible to have just one pdf with all the mark sheet. On Sun, Sep 28, 2014 at 7:06 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the solution. I will check it and get back to you. Thanks and regards, Joseph On Sep 27, 2014 3:43 PM, Vaibhav Joshi v...@vabs.in wrote: Hey Chek attachment, just click on blue button folder name Test will be created on desktop report card will be saved name wise in PDF file.. if you get error getting pdf file ensure you have installed
Re: $$Excel-Macros$$ Report
Hi Vaibhav, To clarify further, I will have multiple RAW sheets, the current example shows STD IV, so I will have 10 such sheets from STD I to STD 10. So instead of giving the Sheet name RAW, I may have the sheet name as STD_I, STD_II, etc. until STD_X and similarly 10 Final sheets. So instead of having 10 excel workbooks, we have just 1 excel workbook with 20 sheets - 10 for input and 10 for output. The Generate PDF, click will not have Final and Main, it will just have RAW as in the current example or STD_I, STD_II, etc until STD_10. So If i select STD_1, it will print Final_STD_I, or if I select STD_II it will print Final_STD_II. Thanks, Joseph Camill On Mon, Oct 6, 2014 at 8:26 PM, joseph camill joseph.cam...@gmail.com wrote: Excellent Vaibhav, Will have a micro level look at it later. Thank you. Joseph On Mon, Oct 6, 2014 at 8:16 PM, Vaibhav Joshi v...@vabs.in wrote: chk this... Goto main sheet press button to run macro! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 7:46 PM, joseph camill joseph.cam...@gmail.com wrote: Thank you Vaibhav. Yes it is clear per your earlier email. On Mon, Oct 6, 2014 at 6:48 PM, Vaibhav Joshi v...@vabs.in wrote: For X=3 is not counting sheets!! It is begining selecting sheets from sheet #3 onwards..Check module PDFActiveSheet_Consol() will share dynamic code which can enable you to select sheet names adapt further changes as mentioned by you!! Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 5:24 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, I think the end loop i.e. For x = 3 … is counting the number of worksheets in the workbook, if it is less than 3 than it proceeds to execute the code. Is there a way to make Sheet Name dynamic in code. Now we are specifying RAW and Final in the code. This works if there are only 2 sheets i.e. input and Final. What if we have more than one input and Final Sheet. For e.g. Now we have STD III, but if I have to add STD IV or STD V as well, then I need to add so many modules. Can we have one code that checks the STD and then execute. May be a pop-up that asks for the STD and then picks that sheet. NOTE: there will be slight variation in the RAW / Final sheet for various STD and that would be addition/subtraction of subjects and change in Name. On Mon, Oct 6, 2014 at 1:44 PM, Vaibhav Joshi v...@vabs.in wrote: what other requests? + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 1:20 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the clarification. Is there any chance to get the other request, if possible. Thanks, Joseph On Mon, Oct 6, 2014 at 12:04 PM, Vaibhav Joshi v...@vabs.in wrote: Hi, You have 2 sheets in this excel workbook, I am creating new sheets after sheet 2 for each students, once all sheet is created i am selecting all sheets and sending it to PDF for publishing in to one file. Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 12:15 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Can you please explain the last loop in the code For x = 3 … part. On Tue, Sep 30, 2014 at 4:04 PM, Vaibhav Joshi v...@vabs.in wrote: Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Sep 30, 2014 at 4:44 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, It is working perfect, as per my requirement. Will email if incase I need any further updates. Thank you very much, you made my work easy. On Mon, Sep 29, 2014 at 11:23 PM, Vaibhav Joshi v...@vabs.in wrote: Cheers On Sep 29, 2014 9:58 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file and working on suggested changes. It is very helpful. Will have a look in detail and will revert. It is really a great one. On Mon, Sep 29, 2014 at 2:32 PM, Vaibhav Joshi v...@vabs.in wrote: 1. Create folder name based on STD - Ok 2. Have just one pdf with all the reports. - Chk attachments 3. Right now it is generating the name using Offset i suppose, Can we do a search for Name and then generate. - Do you want for few employees? then paste employee name in range U then report for only those employee will be generated. If you want report for all employees then keep Column U as blank. Cheers!! + *I did not do this for you. God is here working through me for you.* On Sun, Sep 28, 2014 at 9:02 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file. It is very helpful. Is it possible to make three changes. 1. Create folder name based on STD 2. Have just one pdf with all the reports. 3. Right now it is generating the name using Offset i suppose, Can we do a
Re: $$Excel-Macros$$ Report
Are output for individual Std is diff? + *I did not do this for you. God is here working through me for you.* On Tue, Oct 7, 2014 at 12:37 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, To clarify further, I will have multiple RAW sheets, the current example shows STD IV, so I will have 10 such sheets from STD I to STD 10. So instead of giving the Sheet name RAW, I may have the sheet name as STD_I, STD_II, etc. until STD_X and similarly 10 Final sheets. So instead of having 10 excel workbooks, we have just 1 excel workbook with 20 sheets - 10 for input and 10 for output. The Generate PDF, click will not have Final and Main, it will just have RAW as in the current example or STD_I, STD_II, etc until STD_10. So If i select STD_1, it will print Final_STD_I, or if I select STD_II it will print Final_STD_II. Thanks, Joseph Camill On Mon, Oct 6, 2014 at 8:26 PM, joseph camill joseph.cam...@gmail.com wrote: Excellent Vaibhav, Will have a micro level look at it later. Thank you. Joseph On Mon, Oct 6, 2014 at 8:16 PM, Vaibhav Joshi v...@vabs.in wrote: chk this... Goto main sheet press button to run macro! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 7:46 PM, joseph camill joseph.cam...@gmail.com wrote: Thank you Vaibhav. Yes it is clear per your earlier email. On Mon, Oct 6, 2014 at 6:48 PM, Vaibhav Joshi v...@vabs.in wrote: For X=3 is not counting sheets!! It is begining selecting sheets from sheet #3 onwards..Check module PDFActiveSheet_Consol() will share dynamic code which can enable you to select sheet names adapt further changes as mentioned by you!! Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 5:24 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, I think the end loop i.e. For x = 3 … is counting the number of worksheets in the workbook, if it is less than 3 than it proceeds to execute the code. Is there a way to make Sheet Name dynamic in code. Now we are specifying RAW and Final in the code. This works if there are only 2 sheets i.e. input and Final. What if we have more than one input and Final Sheet. For e.g. Now we have STD III, but if I have to add STD IV or STD V as well, then I need to add so many modules. Can we have one code that checks the STD and then execute. May be a pop-up that asks for the STD and then picks that sheet. NOTE: there will be slight variation in the RAW / Final sheet for various STD and that would be addition/subtraction of subjects and change in Name. On Mon, Oct 6, 2014 at 1:44 PM, Vaibhav Joshi v...@vabs.in wrote: what other requests? + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 1:20 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the clarification. Is there any chance to get the other request, if possible. Thanks, Joseph On Mon, Oct 6, 2014 at 12:04 PM, Vaibhav Joshi v...@vabs.in wrote: Hi, You have 2 sheets in this excel workbook, I am creating new sheets after sheet 2 for each students, once all sheet is created i am selecting all sheets and sending it to PDF for publishing in to one file. Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 12:15 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Can you please explain the last loop in the code For x = 3 … part. On Tue, Sep 30, 2014 at 4:04 PM, Vaibhav Joshi v...@vabs.in wrote: Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Sep 30, 2014 at 4:44 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, It is working perfect, as per my requirement. Will email if incase I need any further updates. Thank you very much, you made my work easy. On Mon, Sep 29, 2014 at 11:23 PM, Vaibhav Joshi v...@vabs.in wrote: Cheers On Sep 29, 2014 9:58 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file and working on suggested changes. It is very helpful. Will have a look in detail and will revert. It is really a great one. On Mon, Sep 29, 2014 at 2:32 PM, Vaibhav Joshi v...@vabs.in wrote: 1. Create folder name based on STD - Ok 2. Have just one pdf with all the reports. - Chk attachments 3. Right now it is generating the name using Offset i suppose, Can we do a search for Name and then generate. - Do you want for few employees? then paste employee name in range U then report for only those employee will be generated. If you want report for all employees then keep Column U as blank. Cheers!! + *I did not do this for you. God is here working through me for you.* On Sun, Sep 28, 2014 at 9:02 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file. It
Re: $$Excel-Macros$$ Report
Hi Vaibhav, Output format remains the same but there is addition / subtraction of subjects and off course student name will change. Thanks, Joseph On Oct 7, 2014 9:53 AM, Vaibhav Joshi v...@vabs.in wrote: Are output for individual Std is diff? + *I did not do this for you. God is here working through me for you.* On Tue, Oct 7, 2014 at 12:37 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, To clarify further, I will have multiple RAW sheets, the current example shows STD IV, so I will have 10 such sheets from STD I to STD 10. So instead of giving the Sheet name RAW, I may have the sheet name as STD_I, STD_II, etc. until STD_X and similarly 10 Final sheets. So instead of having 10 excel workbooks, we have just 1 excel workbook with 20 sheets - 10 for input and 10 for output. The Generate PDF, click will not have Final and Main, it will just have RAW as in the current example or STD_I, STD_II, etc until STD_10. So If i select STD_1, it will print Final_STD_I, or if I select STD_II it will print Final_STD_II. Thanks, Joseph Camill On Mon, Oct 6, 2014 at 8:26 PM, joseph camill joseph.cam...@gmail.com wrote: Excellent Vaibhav, Will have a micro level look at it later. Thank you. Joseph On Mon, Oct 6, 2014 at 8:16 PM, Vaibhav Joshi v...@vabs.in wrote: chk this... Goto main sheet press button to run macro! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 7:46 PM, joseph camill joseph.cam...@gmail.com wrote: Thank you Vaibhav. Yes it is clear per your earlier email. On Mon, Oct 6, 2014 at 6:48 PM, Vaibhav Joshi v...@vabs.in wrote: For X=3 is not counting sheets!! It is begining selecting sheets from sheet #3 onwards..Check module PDFActiveSheet_Consol() will share dynamic code which can enable you to select sheet names adapt further changes as mentioned by you!! Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 5:24 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, I think the end loop i.e. For x = 3 … is counting the number of worksheets in the workbook, if it is less than 3 than it proceeds to execute the code. Is there a way to make Sheet Name dynamic in code. Now we are specifying RAW and Final in the code. This works if there are only 2 sheets i.e. input and Final. What if we have more than one input and Final Sheet. For e.g. Now we have STD III, but if I have to add STD IV or STD V as well, then I need to add so many modules. Can we have one code that checks the STD and then execute. May be a pop-up that asks for the STD and then picks that sheet. NOTE: there will be slight variation in the RAW / Final sheet for various STD and that would be addition/subtraction of subjects and change in Name. On Mon, Oct 6, 2014 at 1:44 PM, Vaibhav Joshi v...@vabs.in wrote: what other requests? + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 1:20 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the clarification. Is there any chance to get the other request, if possible. Thanks, Joseph On Mon, Oct 6, 2014 at 12:04 PM, Vaibhav Joshi v...@vabs.in wrote: Hi, You have 2 sheets in this excel workbook, I am creating new sheets after sheet 2 for each students, once all sheet is created i am selecting all sheets and sending it to PDF for publishing in to one file. Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 12:15 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Can you please explain the last loop in the code For x = 3 … part. On Tue, Sep 30, 2014 at 4:04 PM, Vaibhav Joshi v...@vabs.in wrote: Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Sep 30, 2014 at 4:44 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, It is working perfect, as per my requirement. Will email if incase I need any further updates. Thank you very much, you made my work easy. On Mon, Sep 29, 2014 at 11:23 PM, Vaibhav Joshi v...@vabs.in wrote: Cheers On Sep 29, 2014 9:58 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file and working on suggested changes. It is very helpful. Will have a look in detail and will revert. It is really a great one. On Mon, Sep 29, 2014 at 2:32 PM, Vaibhav Joshi v...@vabs.in wrote: 1. Create folder name based on STD - Ok 2. Have just one pdf with all the reports. - Chk attachments 3. Right now it is generating the name using Offset i suppose, Can we do a search for Name and then generate. - Do you want for few employees? then paste employee name in range U then report for only those employee will be generated. If you want report for all employees then keep Column U as
Re: $$Excel-Macros$$ Report
Hi Vaibhav, In addition, the format for Std IX and X will change in terms of marks display. Regards, Joseph On Oct 7, 2014 10:15 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Output format remains the same but there is addition / subtraction of subjects and off course student name will change. Thanks, Joseph On Oct 7, 2014 9:53 AM, Vaibhav Joshi v...@vabs.in wrote: Are output for individual Std is diff? + *I did not do this for you. God is here working through me for you.* On Tue, Oct 7, 2014 at 12:37 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, To clarify further, I will have multiple RAW sheets, the current example shows STD IV, so I will have 10 such sheets from STD I to STD 10. So instead of giving the Sheet name RAW, I may have the sheet name as STD_I, STD_II, etc. until STD_X and similarly 10 Final sheets. So instead of having 10 excel workbooks, we have just 1 excel workbook with 20 sheets - 10 for input and 10 for output. The Generate PDF, click will not have Final and Main, it will just have RAW as in the current example or STD_I, STD_II, etc until STD_10. So If i select STD_1, it will print Final_STD_I, or if I select STD_II it will print Final_STD_II. Thanks, Joseph Camill On Mon, Oct 6, 2014 at 8:26 PM, joseph camill joseph.cam...@gmail.com wrote: Excellent Vaibhav, Will have a micro level look at it later. Thank you. Joseph On Mon, Oct 6, 2014 at 8:16 PM, Vaibhav Joshi v...@vabs.in wrote: chk this... Goto main sheet press button to run macro! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 7:46 PM, joseph camill joseph.cam...@gmail.com wrote: Thank you Vaibhav. Yes it is clear per your earlier email. On Mon, Oct 6, 2014 at 6:48 PM, Vaibhav Joshi v...@vabs.in wrote: For X=3 is not counting sheets!! It is begining selecting sheets from sheet #3 onwards..Check module PDFActiveSheet_Consol() will share dynamic code which can enable you to select sheet names adapt further changes as mentioned by you!! Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 5:24 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, I think the end loop i.e. For x = 3 … is counting the number of worksheets in the workbook, if it is less than 3 than it proceeds to execute the code. Is there a way to make Sheet Name dynamic in code. Now we are specifying RAW and Final in the code. This works if there are only 2 sheets i.e. input and Final. What if we have more than one input and Final Sheet. For e.g. Now we have STD III, but if I have to add STD IV or STD V as well, then I need to add so many modules. Can we have one code that checks the STD and then execute. May be a pop-up that asks for the STD and then picks that sheet. NOTE: there will be slight variation in the RAW / Final sheet for various STD and that would be addition/subtraction of subjects and change in Name. On Mon, Oct 6, 2014 at 1:44 PM, Vaibhav Joshi v...@vabs.in wrote: what other requests? + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 1:20 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the clarification. Is there any chance to get the other request, if possible. Thanks, Joseph On Mon, Oct 6, 2014 at 12:04 PM, Vaibhav Joshi v...@vabs.in wrote: Hi, You have 2 sheets in this excel workbook, I am creating new sheets after sheet 2 for each students, once all sheet is created i am selecting all sheets and sending it to PDF for publishing in to one file. Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 12:15 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Can you please explain the last loop in the code For x = 3 … part. On Tue, Sep 30, 2014 at 4:04 PM, Vaibhav Joshi v...@vabs.in wrote: Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Sep 30, 2014 at 4:44 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, It is working perfect, as per my requirement. Will email if incase I need any further updates. Thank you very much, you made my work easy. On Mon, Sep 29, 2014 at 11:23 PM, Vaibhav Joshi v...@vabs.in wrote: Cheers On Sep 29, 2014 9:58 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file and working on suggested changes. It is very helpful. Will have a look in detail and will revert. It is really a great one. On Mon, Sep 29, 2014 at 2:32 PM, Vaibhav Joshi v...@vabs.in wrote: 1. Create folder name based on STD - Ok 2. Have just one pdf with all the reports. - Chk attachments 3. Right now it is generating the name using Offset i suppose, Can we do a search for Name and then generate. -
Re: $$Excel-Macros$$ Report
Hi Vaibhav, Can you please explain the last loop in the code For x = 3 … part. On Tue, Sep 30, 2014 at 4:04 PM, Vaibhav Joshi v...@vabs.in wrote: Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Sep 30, 2014 at 4:44 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, It is working perfect, as per my requirement. Will email if incase I need any further updates. Thank you very much, you made my work easy. On Mon, Sep 29, 2014 at 11:23 PM, Vaibhav Joshi v...@vabs.in wrote: Cheers On Sep 29, 2014 9:58 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file and working on suggested changes. It is very helpful. Will have a look in detail and will revert. It is really a great one. On Mon, Sep 29, 2014 at 2:32 PM, Vaibhav Joshi v...@vabs.in wrote: 1. Create folder name based on STD - Ok 2. Have just one pdf with all the reports. - Chk attachments 3. Right now it is generating the name using Offset i suppose, Can we do a search for Name and then generate. - Do you want for few employees? then paste employee name in range U then report for only those employee will be generated. If you want report for all employees then keep Column U as blank. Cheers!! + *I did not do this for you. God is here working through me for you.* On Sun, Sep 28, 2014 at 9:02 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file. It is very helpful. Is it possible to make three changes. 1. Create folder name based on STD 2. Have just one pdf with all the reports. 3. Right now it is generating the name using Offset i suppose, Can we do a search for Name and then generate. On Sun, Sep 28, 2014 at 8:58 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file. It is very helpful. It creates various PDF as per the Name, Is it possible to have just one pdf with all the mark sheet. On Sun, Sep 28, 2014 at 7:06 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the solution. I will check it and get back to you. Thanks and regards, Joseph On Sep 27, 2014 3:43 PM, Vaibhav Joshi v...@vabs.in wrote: Hey Chek attachment, just click on blue button folder name Test will be created on desktop report card will be saved name wise in PDF file.. if you get error getting pdf file ensure you have installed extension from this link: http://www.microsoft.com/en-in/download/details.aspx?id=9943 Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Sep 27, 2014 at 4:10 AM, joseph camill joseph.cam...@gmail.com wrote: Hi, I am working on a project where I need to print 100 report card at a time either directly to a printer or as PDF. Attached is the example workbook. All my data will be entered in sheet named Raw and my output should look like sheet named Final. Is it possible to print it to PDF / printer without having to create number of sheets? Thank you in advance. Regards, Joseph -- 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
Re: $$Excel-Macros$$ Report
Hi Vaibhav, I think the end loop i.e. For x = 3 … is counting the number of worksheets in the workbook, if it is less than 3 than it proceeds to execute the code. Is there a way to make Sheet Name dynamic in code. Now we are specifying RAW and Final in the code. This works if there are only 2 sheets i.e. input and Final. What if we have more than one input and Final Sheet. For e.g. Now we have STD III, but if I have to add STD IV or STD V as well, then I need to add so many modules. Can we have one code that checks the STD and then execute. May be a pop-up that asks for the STD and then picks that sheet. NOTE: there will be slight variation in the RAW / Final sheet for various STD and that would be addition/subtraction of subjects and change in Name. On Mon, Oct 6, 2014 at 12:15 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Can you please explain the last loop in the code For x = 3 … part. On Tue, Sep 30, 2014 at 4:04 PM, Vaibhav Joshi v...@vabs.in wrote: Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Sep 30, 2014 at 4:44 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, It is working perfect, as per my requirement. Will email if incase I need any further updates. Thank you very much, you made my work easy. On Mon, Sep 29, 2014 at 11:23 PM, Vaibhav Joshi v...@vabs.in wrote: Cheers On Sep 29, 2014 9:58 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file and working on suggested changes. It is very helpful. Will have a look in detail and will revert. It is really a great one. On Mon, Sep 29, 2014 at 2:32 PM, Vaibhav Joshi v...@vabs.in wrote: 1. Create folder name based on STD - Ok 2. Have just one pdf with all the reports. - Chk attachments 3. Right now it is generating the name using Offset i suppose, Can we do a search for Name and then generate. - Do you want for few employees? then paste employee name in range U then report for only those employee will be generated. If you want report for all employees then keep Column U as blank. Cheers!! + *I did not do this for you. God is here working through me for you.* On Sun, Sep 28, 2014 at 9:02 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file. It is very helpful. Is it possible to make three changes. 1. Create folder name based on STD 2. Have just one pdf with all the reports. 3. Right now it is generating the name using Offset i suppose, Can we do a search for Name and then generate. On Sun, Sep 28, 2014 at 8:58 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file. It is very helpful. It creates various PDF as per the Name, Is it possible to have just one pdf with all the mark sheet. On Sun, Sep 28, 2014 at 7:06 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the solution. I will check it and get back to you. Thanks and regards, Joseph On Sep 27, 2014 3:43 PM, Vaibhav Joshi v...@vabs.in wrote: Hey Chek attachment, just click on blue button folder name Test will be created on desktop report card will be saved name wise in PDF file.. if you get error getting pdf file ensure you have installed extension from this link: http://www.microsoft.com/en-in/download/details.aspx?id=9943 Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Sep 27, 2014 at 4:10 AM, joseph camill joseph.cam...@gmail.com wrote: Hi, I am working on a project where I need to print 100 report card at a time either directly to a printer or as PDF. Attached is the example workbook. All my data will be entered in sheet named Raw and my output should look like sheet named Final. Is it possible to print it to PDF / printer without having to create number of sheets? Thank you in advance. Regards, Joseph -- 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
Re: $$Excel-Macros$$ Report
Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Sep 30, 2014 at 4:44 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, It is working perfect, as per my requirement. Will email if incase I need any further updates. Thank you very much, you made my work easy. On Mon, Sep 29, 2014 at 11:23 PM, Vaibhav Joshi v...@vabs.in wrote: Cheers On Sep 29, 2014 9:58 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file and working on suggested changes. It is very helpful. Will have a look in detail and will revert. It is really a great one. On Mon, Sep 29, 2014 at 2:32 PM, Vaibhav Joshi v...@vabs.in wrote: 1. Create folder name based on STD - Ok 2. Have just one pdf with all the reports. - Chk attachments 3. Right now it is generating the name using Offset i suppose, Can we do a search for Name and then generate. - Do you want for few employees? then paste employee name in range U then report for only those employee will be generated. If you want report for all employees then keep Column U as blank. Cheers!! + *I did not do this for you. God is here working through me for you.* On Sun, Sep 28, 2014 at 9:02 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file. It is very helpful. Is it possible to make three changes. 1. Create folder name based on STD 2. Have just one pdf with all the reports. 3. Right now it is generating the name using Offset i suppose, Can we do a search for Name and then generate. On Sun, Sep 28, 2014 at 8:58 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file. It is very helpful. It creates various PDF as per the Name, Is it possible to have just one pdf with all the mark sheet. On Sun, Sep 28, 2014 at 7:06 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the solution. I will check it and get back to you. Thanks and regards, Joseph On Sep 27, 2014 3:43 PM, Vaibhav Joshi v...@vabs.in wrote: Hey Chek attachment, just click on blue button folder name Test will be created on desktop report card will be saved name wise in PDF file.. if you get error getting pdf file ensure you have installed extension from this link: http://www.microsoft.com/en-in/download/details.aspx?id=9943 Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Sep 27, 2014 at 4:10 AM, joseph camill joseph.cam...@gmail.com wrote: Hi, I am working on a project where I need to print 100 report card at a time either directly to a printer or as PDF. Attached is the example workbook. All my data will be entered in sheet named Raw and my output should look like sheet named Final. Is it possible to print it to PDF / printer without having to create number of sheets? Thank you in advance. Regards, Joseph -- 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
Re: $$Excel-Macros$$ Report
1. Create folder name based on STD - Ok 2. Have just one pdf with all the reports. - Chk attachments 3. Right now it is generating the name using Offset i suppose, Can we do a search for Name and then generate. - Do you want for few employees? then paste employee name in range U then report for only those employee will be generated. If you want report for all employees then keep Column U as blank. Cheers!! + *I did not do this for you. God is here working through me for you.* On Sun, Sep 28, 2014 at 9:02 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file. It is very helpful. Is it possible to make three changes. 1. Create folder name based on STD 2. Have just one pdf with all the reports. 3. Right now it is generating the name using Offset i suppose, Can we do a search for Name and then generate. On Sun, Sep 28, 2014 at 8:58 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file. It is very helpful. It creates various PDF as per the Name, Is it possible to have just one pdf with all the mark sheet. On Sun, Sep 28, 2014 at 7:06 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the solution. I will check it and get back to you. Thanks and regards, Joseph On Sep 27, 2014 3:43 PM, Vaibhav Joshi v...@vabs.in wrote: Hey Chek attachment, just click on blue button folder name Test will be created on desktop report card will be saved name wise in PDF file.. if you get error getting pdf file ensure you have installed extension from this link: http://www.microsoft.com/en-in/download/details.aspx?id=9943 Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Sep 27, 2014 at 4:10 AM, joseph camill joseph.cam...@gmail.com wrote: Hi, I am working on a project where I need to print 100 report card at a time either directly to a printer or as PDF. Attached is the example workbook. All my data will be entered in sheet named Raw and my output should look like sheet named Final. Is it possible to print it to PDF / printer without having to create number of sheets? Thank you in advance. Regards, Joseph -- 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. -- 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,
Re: $$Excel-Macros$$ Report
Thank you Ashish bro.. + *I did not do this for you. God is here working through me for you.* On Sun, Sep 28, 2014 at 9:13 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Vaibhav Bhai, It's superb. Regards 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. -- 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$$ Report
Absolutely this is possible. it looks like a fun exercise. do you have any experience with VBA? I'll take a look this morning and try to get back with you. 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: joseph camill joseph.cam...@gmail.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Friday, September 26, 2014 6:40 PM Subject: $$Excel-Macros$$ Report Hi, I am working on a project where I need to print 100 report card at a time either directly to a printer or as PDF. Attached is the example workbook. All my data will be entered in sheet named Raw and my output should look like sheet named Final. Is it possible to print it to PDF / printer without having to create number of sheets? Thank you in advance. Regards, Joseph -- 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.
Re: $$Excel-Macros$$ Report
I threw it together a couple of ways. Since I don't know how comfortable you are with VBA, I modified your file to use mostly vlookups based on the student name. then, the macro simply loops through the student names, puts them on the template and generates a pdf. It was about 7% faster to do the whole thing in VBA (without using VLookups) but, since it only takes a minute and 15 seconds, 7% wasn't enough to worry about. I wasn't sure how you wanted to run the macro (called Create_GradeSheets) 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: joseph camill joseph.cam...@gmail.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Friday, September 26, 2014 6:40 PM Subject: $$Excel-Macros$$ Report Hi, I am working on a project where I need to print 100 report card at a time either directly to a printer or as PDF. Attached is the example workbook. All my data will be entered in sheet named Raw and my output should look like sheet named Final. Is it possible to print it to PDF / printer without having to create number of sheets? Thank you in advance. Regards, Joseph -- 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. Grade_Print.xlsb Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
Re: $$Excel-Macros$$ Report
Hi Vaibhav, Thank you for the file and working on suggested changes. It is very helpful. Will have a look in detail and will revert. It is really a great one. On Mon, Sep 29, 2014 at 2:32 PM, Vaibhav Joshi v...@vabs.in wrote: 1. Create folder name based on STD - Ok 2. Have just one pdf with all the reports. - Chk attachments 3. Right now it is generating the name using Offset i suppose, Can we do a search for Name and then generate. - Do you want for few employees? then paste employee name in range U then report for only those employee will be generated. If you want report for all employees then keep Column U as blank. Cheers!! + *I did not do this for you. God is here working through me for you.* On Sun, Sep 28, 2014 at 9:02 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file. It is very helpful. Is it possible to make three changes. 1. Create folder name based on STD 2. Have just one pdf with all the reports. 3. Right now it is generating the name using Offset i suppose, Can we do a search for Name and then generate. On Sun, Sep 28, 2014 at 8:58 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file. It is very helpful. It creates various PDF as per the Name, Is it possible to have just one pdf with all the mark sheet. On Sun, Sep 28, 2014 at 7:06 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the solution. I will check it and get back to you. Thanks and regards, Joseph On Sep 27, 2014 3:43 PM, Vaibhav Joshi v...@vabs.in wrote: Hey Chek attachment, just click on blue button folder name Test will be created on desktop report card will be saved name wise in PDF file.. if you get error getting pdf file ensure you have installed extension from this link: http://www.microsoft.com/en-in/download/details.aspx?id=9943 Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Sep 27, 2014 at 4:10 AM, joseph camill joseph.cam...@gmail.com wrote: Hi, I am working on a project where I need to print 100 report card at a time either directly to a printer or as PDF. Attached is the example workbook. All my data will be entered in sheet named Raw and my output should look like sheet named Final. Is it possible to print it to PDF / printer without having to create number of sheets? Thank you in advance. Regards, Joseph -- 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. -- Are you =EXP(E:RT) or
Re: $$Excel-Macros$$ Report
Cheers On Sep 29, 2014 9:58 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file and working on suggested changes. It is very helpful. Will have a look in detail and will revert. It is really a great one. On Mon, Sep 29, 2014 at 2:32 PM, Vaibhav Joshi v...@vabs.in wrote: 1. Create folder name based on STD - Ok 2. Have just one pdf with all the reports. - Chk attachments 3. Right now it is generating the name using Offset i suppose, Can we do a search for Name and then generate. - Do you want for few employees? then paste employee name in range U then report for only those employee will be generated. If you want report for all employees then keep Column U as blank. Cheers!! + *I did not do this for you. God is here working through me for you.* On Sun, Sep 28, 2014 at 9:02 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file. It is very helpful. Is it possible to make three changes. 1. Create folder name based on STD 2. Have just one pdf with all the reports. 3. Right now it is generating the name using Offset i suppose, Can we do a search for Name and then generate. On Sun, Sep 28, 2014 at 8:58 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file. It is very helpful. It creates various PDF as per the Name, Is it possible to have just one pdf with all the mark sheet. On Sun, Sep 28, 2014 at 7:06 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the solution. I will check it and get back to you. Thanks and regards, Joseph On Sep 27, 2014 3:43 PM, Vaibhav Joshi v...@vabs.in wrote: Hey Chek attachment, just click on blue button folder name Test will be created on desktop report card will be saved name wise in PDF file.. if you get error getting pdf file ensure you have installed extension from this link: http://www.microsoft.com/en-in/download/details.aspx?id=9943 Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Sep 27, 2014 at 4:10 AM, joseph camill joseph.cam...@gmail.com wrote: Hi, I am working on a project where I need to print 100 report card at a time either directly to a printer or as PDF. Attached is the example workbook. All my data will be entered in sheet named Raw and my output should look like sheet named Final. Is it possible to print it to PDF / printer without having to create number of sheets? Thank you in advance. Regards, Joseph -- 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,
Re: $$Excel-Macros$$ Report
Hi Vaibhav, It is working perfect, as per my requirement. Will email if incase I need any further updates. Thank you very much, you made my work easy. On Mon, Sep 29, 2014 at 11:23 PM, Vaibhav Joshi v...@vabs.in wrote: Cheers On Sep 29, 2014 9:58 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file and working on suggested changes. It is very helpful. Will have a look in detail and will revert. It is really a great one. On Mon, Sep 29, 2014 at 2:32 PM, Vaibhav Joshi v...@vabs.in wrote: 1. Create folder name based on STD - Ok 2. Have just one pdf with all the reports. - Chk attachments 3. Right now it is generating the name using Offset i suppose, Can we do a search for Name and then generate. - Do you want for few employees? then paste employee name in range U then report for only those employee will be generated. If you want report for all employees then keep Column U as blank. Cheers!! + *I did not do this for you. God is here working through me for you.* On Sun, Sep 28, 2014 at 9:02 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file. It is very helpful. Is it possible to make three changes. 1. Create folder name based on STD 2. Have just one pdf with all the reports. 3. Right now it is generating the name using Offset i suppose, Can we do a search for Name and then generate. On Sun, Sep 28, 2014 at 8:58 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file. It is very helpful. It creates various PDF as per the Name, Is it possible to have just one pdf with all the mark sheet. On Sun, Sep 28, 2014 at 7:06 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the solution. I will check it and get back to you. Thanks and regards, Joseph On Sep 27, 2014 3:43 PM, Vaibhav Joshi v...@vabs.in wrote: Hey Chek attachment, just click on blue button folder name Test will be created on desktop report card will be saved name wise in PDF file.. if you get error getting pdf file ensure you have installed extension from this link: http://www.microsoft.com/en-in/download/details.aspx?id=9943 Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Sep 27, 2014 at 4:10 AM, joseph camill joseph.cam...@gmail.com wrote: Hi, I am working on a project where I need to print 100 report card at a time either directly to a printer or as PDF. Attached is the example workbook. All my data will be entered in sheet named Raw and my output should look like sheet named Final. Is it possible to print it to PDF / printer without having to create number of sheets? Thank you in advance. Regards, Joseph -- 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
Re: $$Excel-Macros$$ Report
Hi Paul, Thank you for the effort. The solution provided by Vaibhav has worked per my requirement, Also, your solution on Vlookup is helpful. Thank you Paul. On Mon, Sep 29, 2014 at 5:48 PM, Paul Schreiner schreiner_p...@att.net wrote: I threw it together a couple of ways. Since I don't know how comfortable you are with VBA, I modified your file to use mostly vlookups based on the student name. then, the macro simply loops through the student names, puts them on the template and generates a pdf. It was about 7% faster to do the whole thing in VBA (without using VLookups) but, since it only takes a minute and 15 seconds, 7% wasn't enough to worry about. I wasn't sure how you wanted to run the macro (called Create_GradeSheets) *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:* joseph camill joseph.cam...@gmail.com *To:* excel-macros@googlegroups.com excel-macros@googlegroups.com *Sent:* Friday, September 26, 2014 6:40 PM *Subject:* $$Excel-Macros$$ Report Hi, I am working on a project where I need to print 100 report card at a time either directly to a printer or as PDF. Attached is the example workbook. All my data will be entered in sheet named Raw and my output should look like sheet named Final. Is it possible to print it to PDF / printer without having to create number of sheets? Thank you in advance. Regards, Joseph -- 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. -- 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$$ Report
Hi Vaibhav, Thank you for the solution. I will check it and get back to you. Thanks and regards, Joseph On Sep 27, 2014 3:43 PM, Vaibhav Joshi v...@vabs.in wrote: Hey Chek attachment, just click on blue button folder name Test will be created on desktop report card will be saved name wise in PDF file.. if you get error getting pdf file ensure you have installed extension from this link: http://www.microsoft.com/en-in/download/details.aspx?id=9943 Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Sep 27, 2014 at 4:10 AM, joseph camill joseph.cam...@gmail.com wrote: Hi, I am working on a project where I need to print 100 report card at a time either directly to a printer or as PDF. Attached is the example workbook. All my data will be entered in sheet named Raw and my output should look like sheet named Final. Is it possible to print it to PDF / printer without having to create number of sheets? Thank you in advance. Regards, Joseph -- 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. -- 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$$ Report
Hi Vaibhav, Thank you for the file. It is very helpful. It creates various PDF as per the Name, Is it possible to have just one pdf with all the mark sheet. On Sun, Sep 28, 2014 at 7:06 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the solution. I will check it and get back to you. Thanks and regards, Joseph On Sep 27, 2014 3:43 PM, Vaibhav Joshi v...@vabs.in wrote: Hey Chek attachment, just click on blue button folder name Test will be created on desktop report card will be saved name wise in PDF file.. if you get error getting pdf file ensure you have installed extension from this link: http://www.microsoft.com/en-in/download/details.aspx?id=9943 Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Sep 27, 2014 at 4:10 AM, joseph camill joseph.cam...@gmail.com wrote: Hi, I am working on a project where I need to print 100 report card at a time either directly to a printer or as PDF. Attached is the example workbook. All my data will be entered in sheet named Raw and my output should look like sheet named Final. Is it possible to print it to PDF / printer without having to create number of sheets? Thank you in advance. Regards, Joseph -- 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. -- 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$$ Report
Hi Vaibhav, Thank you for the file. It is very helpful. Is it possible to make three changes. 1. Create folder name based on STD 2. Have just one pdf with all the reports. 3. Right now it is generating the name using Offset i suppose, Can we do a search for Name and then generate. On Sun, Sep 28, 2014 at 8:58 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file. It is very helpful. It creates various PDF as per the Name, Is it possible to have just one pdf with all the mark sheet. On Sun, Sep 28, 2014 at 7:06 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the solution. I will check it and get back to you. Thanks and regards, Joseph On Sep 27, 2014 3:43 PM, Vaibhav Joshi v...@vabs.in wrote: Hey Chek attachment, just click on blue button folder name Test will be created on desktop report card will be saved name wise in PDF file.. if you get error getting pdf file ensure you have installed extension from this link: http://www.microsoft.com/en-in/download/details.aspx?id=9943 Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Sep 27, 2014 at 4:10 AM, joseph camill joseph.cam...@gmail.com wrote: Hi, I am working on a project where I need to print 100 report card at a time either directly to a printer or as PDF. Attached is the example workbook. All my data will be entered in sheet named Raw and my output should look like sheet named Final. Is it possible to print it to PDF / printer without having to create number of sheets? Thank you in advance. Regards, Joseph -- 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. -- 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$$ Report
Hi Vaibhav Bhai, It's superb. Regards 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$$ Report
Hey Chek attachment, just click on blue button folder name Test will be created on desktop report card will be saved name wise in PDF file.. if you get error getting pdf file ensure you have installed extension from this link: http://www.microsoft.com/en-in/download/details.aspx?id=9943 Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Sep 27, 2014 at 4:10 AM, joseph camill joseph.cam...@gmail.com wrote: Hi, I am working on a project where I need to print 100 report card at a time either directly to a printer or as PDF. Attached is the example workbook. All my data will be entered in sheet named Raw and my output should look like sheet named Final. Is it possible to print it to PDF / printer without having to create number of sheets? Thank you in advance. Regards, Joseph -- 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. generate multiple pdf.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Report (needs to be formatted)
little more explanation would be great to give answer quickly, do you need data validation or formula, can you explain last point specially ? On Thu, Jun 13, 2013 at 1:16 PM, Manjunath Narayanappa manjunath.narayana...@aon.co.uk wrote: Dear Experts, Can someone help me on the below. Thanks Manjunath *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Manjunath Narayanappa *Sent:* 12 June 2013 16:13 *To:* 'excel-macros@googlegroups.com' *Subject:* $$Excel-Macros$$ Report (needs to be formatted) Hi Experts, Please help me on the below conditions Please advise can I use IF function for the below requirement 1. Column W (Equiv Ccy Payable Amount - STG) should be More than 250,000.00 2. Column X Should be Zero (Uncollected Amount - Calculation 3. Column D (Account Name) Contains Aon Greig or Norway And Aon Germany. Thanks Manjunath -- PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL Aon UK Limited Registered Office: 8 Devonshire Square, London EC2M 4PL Registered in London No. 210725 . VAT Registration No. 480 8401 48 Aon UK Limited is authorised and regulated by the Financial Conduct Authority. -- 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. -- PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL Aon UK Limited Registered Office: 8 Devonshire Square, London EC2M 4PL Registered in London No. 210725 . VAT Registration No. 480 8401 48 Aon UK Limited is authorised and regulated by the Financial Conduct Authority. -- 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
RE: $$Excel-Macros$$ Report (needs to be formatted)
Dear Priti, I required formula , so that when these 3 criteria appears the column should highlight with colour 1. Column W (Equiv Ccy Payable Amount - STG) should be More than 250,000.00 2. Column X Should be Zero (Uncollected Amount - Calculation 3. Column D (Account Name) Contains Aon Greig or Norway And Aon Germany. Thanks Manjunath From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of priti verma Sent: 13 June 2013 08:50 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Report (needs to be formatted) little more explanation would be great to give answer quickly, do you need data validation or formula, can you explain last point specially ? On Thu, Jun 13, 2013 at 1:16 PM, Manjunath Narayanappa manjunath.narayana...@aon.co.ukmailto:manjunath.narayana...@aon.co.uk wrote: Dear Experts, Can someone help me on the below. Thanks Manjunath From: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.commailto:excel-macros@googlegroups.com] On Behalf Of Manjunath Narayanappa Sent: 12 June 2013 16:13 To: 'excel-macros@googlegroups.commailto:excel-macros@googlegroups.com' Subject: $$Excel-Macros$$ Report (needs to be formatted) Hi Experts, Please help me on the below conditions Please advise can I use IF function for the below requirement 1. Column W (Equiv Ccy Payable Amount - STG) should be More than 250,000.00 2. Column X Should be Zero (Uncollected Amount - Calculation 3. Column D (Account Name) Contains Aon Greig or Norway And Aon Germany. Thanks Manjunath PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL Aon UK Limited Registered Office: 8 Devonshire Square, London EC2M 4PL Registered in London No. 210725 . VAT Registration No. 480 8401 48 Aon UK Limited is authorised and regulated by the Financial Conduct Authority. -- 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.commailto:excel-macros%2bunsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.commailto: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. PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL Aon UK Limited Registered Office: 8 Devonshire Square, London EC2M 4PL Registered in London No. 210725 . VAT Registration No. 480 8401 48 Aon UK Limited is authorised and regulated by the Financial Conduct Authority. -- 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.commailto:excel-macros%2bunsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.commailto: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
RE: $$Excel-Macros$$ Report (needs to be formatted)
Dear Priti, Can we use conditional formatting for this Thanks Manjunath From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Manjunath Narayanappa Sent: 13 June 2013 11:00 To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Report (needs to be formatted) Dear Priti, I required formula , so that when these 3 criteria appears the column should highlight with colour 1. Column W (Equiv Ccy Payable Amount - STG) should be More than 250,000.00 2. Column X Should be Zero (Uncollected Amount - Calculation 3. Column D (Account Name) Contains Aon Greig or Norway And Aon Germany. Thanks Manjunath From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of priti verma Sent: 13 June 2013 08:50 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Report (needs to be formatted) little more explanation would be great to give answer quickly, do you need data validation or formula, can you explain last point specially ? On Thu, Jun 13, 2013 at 1:16 PM, Manjunath Narayanappa manjunath.narayana...@aon.co.ukmailto:manjunath.narayana...@aon.co.uk wrote: Dear Experts, Can someone help me on the below. Thanks Manjunath From: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.commailto:excel-macros@googlegroups.com] On Behalf Of Manjunath Narayanappa Sent: 12 June 2013 16:13 To: 'excel-macros@googlegroups.commailto:excel-macros@googlegroups.com' Subject: $$Excel-Macros$$ Report (needs to be formatted) Hi Experts, Please help me on the below conditions Please advise can I use IF function for the below requirement 1. Column W (Equiv Ccy Payable Amount - STG) should be More than 250,000.00 2. Column X Should be Zero (Uncollected Amount - Calculation 3. Column D (Account Name) Contains Aon Greig or Norway And Aon Germany. Thanks Manjunath PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL Aon UK Limited Registered Office: 8 Devonshire Square, London EC2M 4PL Registered in London No. 210725 . VAT Registration No. 480 8401 48 Aon UK Limited is authorised and regulated by the Financial Conduct Authority. -- 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.commailto:excel-macros%2bunsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.commailto: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. PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL Aon UK Limited Registered Office: 8 Devonshire Square, London EC2M 4PL Registered in London No. 210725 . VAT Registration No. 480 8401 48 Aon UK Limited is authorised and regulated by the Financial Conduct Authority. -- 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.commailto:excel-macros%2bunsubscr
Re: $$Excel-Macros$$ Report (needs to be formatted)
Yes. a) Excel will color the cell in a column whenever the value meets your criteria, irrespective of what is happening in the other two columns. b) Excel will color all three columns only when values in all three columns meet the criteria. Which one do you want? Also, whenever you're posting a file with a problem, try to give only sample data (10-20 rows) to keep its size small. Nobody wants to download a 5 MB file just to have a look at your problem and it reduces chances of getting more responses. No offense, just saying. Regards, Abhishek On Thu, Jun 13, 2013 at 3:33 PM, Manjunath Narayanappa manjunath.narayana...@aon.co.uk wrote: Dear Priti, Can we use conditional formatting for this Thanks Manjunath *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Manjunath Narayanappa *Sent:* 13 June 2013 11:00 *To:* 'excel-macros@googlegroups.com' *Subject:* RE: $$Excel-Macros$$ Report (needs to be formatted) Dear Priti, I required formula , so that when these 3 criteria appears the column should highlight with colour 1. Column W (Equiv Ccy Payable Amount - STG) should be More than 250,000.00 2. Column X Should be Zero (Uncollected Amount - Calculation 3. Column D (Account Name) Contains Aon Greig or Norway And Aon Germany. Thanks Manjunath *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *priti verma *Sent:* 13 June 2013 08:50 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Report (needs to be formatted) little more explanation would be great to give answer quickly, do you need data validation or formula, can you explain last point specially ? On Thu, Jun 13, 2013 at 1:16 PM, Manjunath Narayanappa manjunath.narayana...@aon.co.uk wrote: Dear Experts, Can someone help me on the below. Thanks Manjunath *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Manjunath Narayanappa *Sent:* 12 June 2013 16:13 *To:* 'excel-macros@googlegroups.com' *Subject:* $$Excel-Macros$$ Report (needs to be formatted) Hi Experts, Please help me on the below conditions Please advise can I use IF function for the below requirement 1. Column W (Equiv Ccy Payable Amount - STG) should be More than 250,000.00 2. Column X Should be Zero (Uncollected Amount - Calculation 3. Column D (Account Name) Contains Aon Greig or Norway And Aon Germany. Thanks Manjunath -- PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL Aon UK Limited Registered Office: 8 Devonshire Square, London EC2M 4PL Registered in London No. 210725 . VAT Registration No. 480 8401 48 Aon UK Limited is authorised and regulated by the Financial Conduct Authority. -- 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. -- PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL Aon UK Limited Registered Office: 8 Devonshire Square, London EC2M 4PL Registered in London No. 210725 . VAT Registration No. 480 8401 48 Aon UK Limited is authorised and regulated by the Financial Conduct Authority. -- 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
RE: $$Excel-Macros$$ Report (needs to be formatted)
Dear Abhishek, I will make sure that this will not happens in future request. I want three columns to get highlight when value meets. Thanks Manjunath From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Abhishek Jain Sent: 13 June 2013 12:10 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Report (needs to be formatted) Yes. a) Excel will color the cell in a column whenever the value meets your criteria, irrespective of what is happening in the other two columns. b) Excel will color all three columns only when values in all three columns meet the criteria. Which one do you want? Also, whenever you're posting a file with a problem, try to give only sample data (10-20 rows) to keep its size small. Nobody wants to download a 5 MB file just to have a look at your problem and it reduces chances of getting more responses. No offense, just saying. Regards, Abhishek On Thu, Jun 13, 2013 at 3:33 PM, Manjunath Narayanappa manjunath.narayana...@aon.co.ukmailto:manjunath.narayana...@aon.co.uk wrote: Dear Priti, Can we use conditional formatting for this Thanks Manjunath From: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.commailto:excel-macros@googlegroups.com] On Behalf Of Manjunath Narayanappa Sent: 13 June 2013 11:00 To: 'excel-macros@googlegroups.commailto:excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Report (needs to be formatted) Dear Priti, I required formula , so that when these 3 criteria appears the column should highlight with colour 1. Column W (Equiv Ccy Payable Amount - STG) should be More than 250,000.00 2. Column X Should be Zero (Uncollected Amount - Calculation 3. Column D (Account Name) Contains Aon Greig or Norway And Aon Germany. Thanks Manjunath From: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.commailto:excel-macros@googlegroups.com] On Behalf Of priti verma Sent: 13 June 2013 08:50 To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Report (needs to be formatted) little more explanation would be great to give answer quickly, do you need data validation or formula, can you explain last point specially ? On Thu, Jun 13, 2013 at 1:16 PM, Manjunath Narayanappa manjunath.narayana...@aon.co.ukmailto:manjunath.narayana...@aon.co.uk wrote: Dear Experts, Can someone help me on the below. Thanks Manjunath From: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.commailto:excel-macros@googlegroups.com] On Behalf Of Manjunath Narayanappa Sent: 12 June 2013 16:13 To: 'excel-macros@googlegroups.commailto:excel-macros@googlegroups.com' Subject: $$Excel-Macros$$ Report (needs to be formatted) Hi Experts, Please help me on the below conditions Please advise can I use IF function for the below requirement 1. Column W (Equiv Ccy Payable Amount - STG) should be More than 250,000.00 2. Column X Should be Zero (Uncollected Amount - Calculation 3. Column D (Account Name) Contains Aon Greig or Norway And Aon Germany. Thanks Manjunath PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL Aon UK Limited Registered Office: 8 Devonshire Square, London EC2M 4PL Registered in London No. 210725 . VAT Registration No. 480 8401 48 Aon UK Limited is authorised and regulated by the Financial Conduct Authority. -- 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.commailto:excel-macros%2bunsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.commailto: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. PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL
Re: $$Excel-Macros$$ Report generation for Excel 2003
hi, what type of report do you need to create, which is your database.. please provide description about that.. On Mon, Sep 5, 2011 at 4:13 PM, Bheema Shankar shankar.n...@gmail.comwrote: Hai all gurus. Good evening. I heard that excel is having Report generation option for its database. May I have the add-in to build report for my database ? Hope your kind support for me. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Rajan verma +91 9158998701 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Report generation for Excel 2003
You could maybe use a macro or a simple vlookup formula From: Shankar Bheema Sent: Monday, September 05, 2011 8:13 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Report generation for Excel 2003 I am attaching the VBA project and a sample spreadsheet form. I want build a report as attached spreadsheet. On Mon, Sep 5, 2011 at 6:32 PM, rajan verma rajanverma1...@gmail.com wrote: hi, what type of report do you need to create, which is your database.. please provide description about that.. On Mon, Sep 5, 2011 at 4:13 PM, Bheema Shankar shankar.n...@gmail.com wrote: Hai all gurus. Good evening. I heard that excel is having Report generation option for its database. May I have the add-in to build report for my database ? Hope your kind support for me. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Rajan verma +91 9158998701 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel