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 wrote: > Thank you Vaibhav > > On Sun, Oct 12, 2014 at 7:04 PM, Vaibhav Joshi wrote: > >> Thanks bro... >> On Oct 12, 2014 6:05 PM, "Ashish Kumar" >> 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
Re: $$Excel-Macros$$ Report
Thank you Vaibhav On Sun, Oct 12, 2014 at 7:04 PM, Vaibhav Joshi wrote: > Thanks bro... > On Oct 12, 2014 6:05 PM, "Ashish Kumar" 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
Thanks bro... On Oct 12, 2014 6:05 PM, "Ashish Kumar" 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
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
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 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 wrote: > >> Ok. .Cheers >> On Oct 10, 2014 1:27 AM, "joseph camill" 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 wrote: >>> >>>> Joseph >>>> >>>> Did you tried this. . >>>> -- Forwarded message -- >>>> From: "Vaibhav Joshi" >>>> Date: Oct 7, 2014 10:51 AM >>>> Subject: Re: $$Excel-Macros$$ Report >>>> To: "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 >>> > 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" >>>>> 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" 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
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 wrote: > Ok. .Cheers > On Oct 10, 2014 1:27 AM, "joseph camill" 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 wrote: >> >>> Joseph >>> >>> Did you tried this. . >>> ------ Forwarded message -- >>> From: "Vaibhav Joshi" >>> Date: Oct 7, 2014 10:51 AM >>> Subject: Re: $$Excel-Macros$$ Report >>> To: "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 >>> 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" >>>> 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" 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. >>>>>&g
Re: $$Excel-Macros$$ Report
Ok. .Cheers On Oct 10, 2014 1:27 AM, "joseph camill" 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 wrote: > >> Joseph >> >> Did you tried this. . >> -- Forwarded message -- >> From: "Vaibhav Joshi" >> Date: Oct 7, 2014 10:51 AM >> Subject: Re: $$Excel-Macros$$ Report >> To: "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 >> 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" >>> 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" 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 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 < >>>>>>
Re: $$Excel-Macros$$ Report
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 wrote: > Joseph > > Did you tried this. . > -- Forwarded message -- > From: "Vaibhav Joshi" > Date: Oct 7, 2014 10:51 AM > Subject: Re: $$Excel-Macros$$ Report > To: "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 > 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" >> 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" 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 >>> > 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 >>>> > 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 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 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 ca
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 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 > 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" >> 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" 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 >>> > 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 > 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 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 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 >> 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:
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" 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" 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 >> 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 >>> 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 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 > wrote: > >> Thank you Vaibhav. Yes it is clear per your earlier email. >> >> On Mon, Oct 6, 2014 at 6:48 PM, Vaibhav Joshi 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 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 >> 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 wrote: > Cheers!! > >>
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" 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 > 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 >> 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 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 wrote: > Thank you Vaibhav. Yes it is clear per your earlier email. > > On Mon, Oct 6, 2014 at 6:48 PM, Vaibhav Joshi 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 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 > 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 >>> 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 requiremen
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 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 > 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 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 >>> wrote: >>> Thank you Vaibhav. Yes it is clear per your earlier email. On Mon, Oct 6, 2014 at 6:48 PM, Vaibhav Joshi 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 > 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 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 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 >> 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 wrote: > Cheers > On Sep 29, 2014 9:58 PM, "joseph camill" < > joseph.cam...@gmail.com> wrote: > >>
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 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 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 >> wrote: >> >>> Thank you Vaibhav. Yes it is clear per your earlier email. >>> >>> On Mon, Oct 6, 2014 at 6:48 PM, Vaibhav Joshi 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 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 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 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 > 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 >>> 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 > wrote: >
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 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 > wrote: > >> Thank you Vaibhav. Yes it is clear per your earlier email. >> >> On Mon, Oct 6, 2014 at 6:48 PM, Vaibhav Joshi 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 >>> 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 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 > 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 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 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 >> 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 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
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 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 > 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 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 >>> 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 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 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 wrote: > Cheers > On Sep 29, 2014 9:58 PM, "joseph camill" > 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 >> 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 w
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 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 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 >> 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 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 >>> > 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 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 wrote: >>> Cheers On Sep 29, 2014 9:58 PM, "joseph camill" 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 > 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 >
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 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 > 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 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 >>> 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 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 wrote: >> >>> Cheers >>> On Sep 29, 2014 9:58 PM, "joseph camill" >>> 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 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" 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.a
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 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 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 >> 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 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 >>> > 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 wrote: > >> Cheers >> On Sep 29, 2014 9:58 PM, "joseph camill" >> 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 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" 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
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 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 > 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 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 >>> 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 wrote: > Cheers > On Sep 29, 2014 9:58 PM, "joseph camill" > 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 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" 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, Urge
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 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 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 >> 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 wrote: >>> Cheers On Sep 29, 2014 9:58 PM, "joseph camill" 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 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" 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 respo
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 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 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 >> 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 wrote: >>> Cheers On Sep 29, 2014 9:58 PM, "joseph camill" 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 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" 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 >>> >>
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 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 > 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 wrote: >> >>> Cheers >>> On Sep 29, 2014 9:58 PM, "joseph camill" >>> 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 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" 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, >
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 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 wrote: > >> Cheers >> On Sep 29, 2014 9:58 PM, "joseph camill" 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 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 >>> > 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" 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. > >>>
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 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 > *To:* "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 rece
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 wrote: > Cheers > On Sep 29, 2014 9:58 PM, "joseph camill" 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 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 >>> 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 >>> > 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" 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,
Re: $$Excel-Macros$$ Report
Cheers On Sep 29, 2014 9:58 PM, "joseph camill" 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 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 >> 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 >>> 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 >>> > 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" 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. >>
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 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 > 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 >> 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 >>> 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" 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
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 >To: "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
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 >To: "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
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 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 > 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 >> 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" 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 >>> > 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.c
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 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
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
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 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 > 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" 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 >>> 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 o
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 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" 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 >> 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
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" 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 > 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
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 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)
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 mailto: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> [mailto: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<mailto: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> [mailto: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<mailto: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 mailto: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> [mailto: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<mailto: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<mailto:excel-macros%2bunsubscr...@googlegroups.com>. To post to this group, send email to excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ 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. > > > > > -- > >
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 mailto: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> [mailto: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<mailto: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<mailto:excel-macros%2bunsubscr...@googlegroups.com>. To post to this group, send email to excel-macros@googlegroups.com<mailto: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 r
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 mailto: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> [mailto: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<mailto: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<mailto:excel-macros%2bunsubscr...@googlegroups.com>. To post to this group, send email to excel-macros@googlegroups.com<mailto: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<mailto:excel-macros%2bunsubscr...@googlegroups.com>. To post to this group, send email to excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For m
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 ev
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 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 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
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 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
