$$Excel-Macros$$ Excel calculating repayment and interest
To Whom It May Concern, May I ask how do you calculate the table that show per-attachment especially on the principle repayment and interest? We hope to hear from you soon. Thanks. Regards, Falina -- 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$$ Calculating Number of Context Changes in a Series
Thank you so much, Paul! That worked perfectly! I very much appreciate your quick help! On Thursday, October 9, 2014 1:51:57 PM UTC-5, Paul Schreiner wrote: > > I'm sure there are LOTS of approaches to this, > but using simple Excel functions, I went with this approach: > > Assuming: > From: time is in row 1 > To: time is in row 2 > Data begins in row 3 > > I added a blank column at column B to show that that at the start of the > day, no task is being worked on. > > I added in cell K3, the formula: > =IF(C3<>B3,IF(C3="X","Start","Stop"),"") > > The logic is: > If the previous cell is not the same as the current cell, then a task was > started or stopped. > > If the current cell has an "X", then the task was started, if it is blank, > then it was stopped. > > copying this formula across and down, you get: > Start Stop Start Stop Start blank blank > blank Start Stop blank blank Start Stop > Start blank blank blank Stop blank blank > > ( inserted the word "blank" to show where empty cells would show) > > Next, in Cell J3 I inserted: > =COUNTIF(K3:Q3,"start")-1 > and copied it down. > > This counts the number of tims a task was STARTED, then subtracts 1 to > count the number of starts except for the first. > > > *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:* "jlobr...@gmail.com " > > *To:* excel-...@googlegroups.com > *Sent:* Thursday, October 9, 2014 1:44 PM > *Subject:* $$Excel-Macros$$ Calculating Number of Context Changes in a > Series > > Hello! > > I have a spreadsheet of time tracking data. Each row is a different > activity and members are tracking time to that activity by entering an "x" > for each 15 minute interval that they completed that activity. I would > like to calculate per task, how many times they started and stopped that > activity. > > For example, Task A had 2 switches because they started the task, switched > to another, came back again, switched to another task and came back a third > time. > Task B had one 1 switch > Task C had 0 switches, because once they started, they completed and then > didn't come back to it again. > > Is there a calculation that could automatically count the number of gaps > once a series has started? > > From 7:00 7:15 7:30 7:45 8:00 8:15 8:30 To 7:15 7:30 7:45 8:00 8:15 > 8:30 8:45 Task A x x x x x Task B x xTask C x x x x > > Thank you in advance for any help you can provide! > Jaime > -- > 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...@googlegroups.com . > To post to this group, send email to excel-...@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 r
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 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, Vaibha
Re: $$Excel-Macros$$ Calculating Number of Context Changes in a Series
I'm sure there are LOTS of approaches to this, but using simple Excel functions, I went with this approach: Assuming: From: time is in row 1 To: time is in row 2 Data begins in row 3 I added a blank column at column B to show that that at the start of the day, no task is being worked on. I added in cell K3, the formula: =IF(C3<>B3,IF(C3="X","Start","Stop"),"") The logic is: If the previous cell is not the same as the current cell, then a task was started or stopped. If the current cell has an "X", then the task was started, if it is blank, then it was stopped. copying this formula across and down, you get: Start Stop Start Stop Start blank blank blank Start Stop blank blank Start Stop Start blank blank blank Stop blank blank ( inserted the word "blank" to show where empty cells would show) Next, in Cell J3 I inserted: =COUNTIF(K3:Q3,"start")-1 and copied it down. This counts the number of tims a task was STARTED, then subtracts 1 to count the number of starts except for the first. 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: "jlobrien...@gmail.com" >To: excel-macros@googlegroups.com >Sent: Thursday, October 9, 2014 1:44 PM >Subject: $$Excel-Macros$$ Calculating Number of Context Changes in a Series > > > >Hello! > > >I have a spreadsheet of time tracking data. Each row is a different activity >and members are tracking time to that activity by entering an "x" for each 15 >minute interval that they completed that activity. I would like to calculate >per task, how many times they started and stopped that activity. > > >For example, Task A had 2 switches because they started the task, switched to >another, came back again, switched to another task and came back a third time. > >Task B had one 1 switch >Task C had 0 switches, because once they started, they completed and then >didn't come back to it again. > > >Is there a calculation that could automatically count the number of gaps once >a series has started? > > > >From 7:00 7:15 7:30 7:45 8:00 8:15 8:30 >To 7:15 7:30 7:45 8:00 8:15 8:30 8:45 >Task A x x x x x >Task B x x >Task C x x x x > >Thank you in advance for any help you can provide! >Jaime -- >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
$$Excel-Macros$$ Calculating Number of Context Changes in a Series
Hello! I have a spreadsheet of time tracking data. Each row is a different activity and members are tracking time to that activity by entering an "x" for each 15 minute interval that they completed that activity. I would like to calculate per task, how many times they started and stopped that activity. For example, Task A had 2 switches because they started the task, switched to another, came back again, switched to another task and came back a third time. Task B had one 1 switch Task C had 0 switches, because once they started, they completed and then didn't come back to it again. Is there a calculation that could automatically count the number of gaps once a series has started? From 7:00 7:15 7:30 7:45 8:00 8:15 8:30 To 7:15 7:30 7:45 8:00 8:15 8:30 8:45 Task A x x x x x Task B x xTask C x x x x Thank you in advance for any help you can provide! Jaime -- 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$$ FINDING THE MAXIMUM VALUE IN A NON NUMBERIC COLUMN
Have a Look ! I hope you are aware of how to enter an Array Formula ! On Thu, Oct 9, 2014 at 9:07 PM, Sundarvelan N wrote: > Friends. > > I tried all your suggestions i did not got the answer > > Thanks > N.Sundarvelan > 9600160150 > > On Thu, Oct 9, 2014 at 8:14 PM, Kanwaljit Singh Dhunna < > kanwal...@gmail.com> wrote: > >> Hi, >> >> Assuming yours values are in range A1:A10, you need to enter the >> following as an Array Formula >> >> =MAX(--RIGHT(A1:A10,8)) >> >> To enter the same as an Array Formula, you need to press Ctrl+Shift+Enter >> after entering the formula in the Cell. >> >> On Thu, Oct 9, 2014 at 6:34 PM, manu kashyap >> wrote: >> >>> Hi Frd, >>> >>> =max(substitute(cellvalue ya cell reference,"IT","",1)) >>> >>> Try kro bhai >>> On Oct 9, 2014 6:25 PM, "Sundarvelan N" wrote: >>> Dear Friends, Please help me in finding the maximum value in a non numeric column, example below Answer needed is IT20140010 IT20140001 IT20140002 IT20140003 IT20140004 IT20140005 IT20140006 IT20140007 IT20140008 IT20140009 IT20140010 Thanks N.Sundarvelan 9600160150 -- 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. >>> >> >> >> >> -- >> Sincere Regards >> CA Kanwaljit Singh Dhunna >> +91-987 6739 911 >> +91-950 1031 007 >> P*Please don't print this e-mail unless you really need to.* >> *IF U LOSE, DON'T LOSE THE LESSON.* >> >> -- >> 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
Re: $$Excel-Macros$$ FINDING THE MAXIMUM VALUE IN A NON NUMBERIC COLUMN
Friends. I tried all your suggestions i did not got the answer Thanks N.Sundarvelan 9600160150 On Thu, Oct 9, 2014 at 8:14 PM, Kanwaljit Singh Dhunna wrote: > Hi, > > Assuming yours values are in range A1:A10, you need to enter the following > as an Array Formula > > =MAX(--RIGHT(A1:A10,8)) > > To enter the same as an Array Formula, you need to press Ctrl+Shift+Enter > after entering the formula in the Cell. > > On Thu, Oct 9, 2014 at 6:34 PM, manu kashyap > wrote: > >> Hi Frd, >> >> =max(substitute(cellvalue ya cell reference,"IT","",1)) >> >> Try kro bhai >> On Oct 9, 2014 6:25 PM, "Sundarvelan N" wrote: >> >>> Dear Friends, >>> >>> Please help me in finding the maximum value in a non numeric column, >>> example below >>> >>> Answer needed is IT20140010 >>> >>> >>> IT20140001 IT20140002 IT20140003 IT20140004 IT20140005 IT20140006 >>> IT20140007 IT20140008 IT20140009 IT20140010 >>> >>> >>> Thanks >>> N.Sundarvelan >>> 9600160150 >>> >>> -- >>> 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. >> > > > > -- > Sincere Regards > CA Kanwaljit Singh Dhunna > +91-987 6739 911 > +91-950 1031 007 > P*Please don't print this e-mail unless you really need to.* > *IF U LOSE, DON'T LOSE THE LESSON.* > > -- > 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/gr
Re: $$Excel-Macros$$ FINDING THE MAXIMUM VALUE IN A NON NUMBERIC COLUMN
Hi, Assuming yours values are in range A1:A10, you need to enter the following as an Array Formula =MAX(--RIGHT(A1:A10,8)) To enter the same as an Array Formula, you need to press Ctrl+Shift+Enter after entering the formula in the Cell. On Thu, Oct 9, 2014 at 6:34 PM, manu kashyap wrote: > Hi Frd, > > =max(substitute(cellvalue ya cell reference,"IT","",1)) > > Try kro bhai > On Oct 9, 2014 6:25 PM, "Sundarvelan N" wrote: > >> Dear Friends, >> >> Please help me in finding the maximum value in a non numeric column, >> example below >> >> Answer needed is IT20140010 >> >> >> IT20140001 IT20140002 IT20140003 IT20140004 IT20140005 IT20140006 >> IT20140007 IT20140008 IT20140009 IT20140010 >> >> >> Thanks >> N.Sundarvelan >> 9600160150 >> >> -- >> 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. > -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 P*Please don't print this e-mail unless you really need to.* *IF U LOSE, DON'T LOSE THE LESSON.* -- 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$$ FINDING THE MAXIMUM VALUE IN A NON NUMBERIC COLUMN
Hi Frd, =max(substitute(cellvalue ya cell reference,"IT","",1)) Try kro bhai On Oct 9, 2014 6:25 PM, "Sundarvelan N" wrote: > Dear Friends, > > Please help me in finding the maximum value in a non numeric column, > example below > > Answer needed is IT20140010 > > > IT20140001 IT20140002 IT20140003 IT20140004 IT20140005 IT20140006 > IT20140007 IT20140008 IT20140009 IT20140010 > > > Thanks > N.Sundarvelan > 9600160150 > > -- > 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$$ FINDING THE MAXIMUM VALUE IN A NON NUMBERIC COLUMN
use a helper column to convert the data (to numeric) and then apply Max formula you shall get the answer.. Hope this helps On Thu, Oct 9, 2014 at 3:54 PM, Sundarvelan N wrote: > Dear Friends, > > Please help me in finding the maximum value in a non numeric column, > example below > > Answer needed is IT20140010 > > > IT20140001 IT20140002 IT20140003 IT20140004 IT20140005 IT20140006 > IT20140007 IT20140008 IT20140009 IT20140010 > > > Thanks > N.Sundarvelan > 9600160150 > > -- > 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. > -- *Ahmed Bawazir* *احمد باوزير* -- 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.
$$Excel-Macros$$ FINDING THE MAXIMUM VALUE IN A NON NUMBERIC COLUMN
Dear Friends, Please help me in finding the maximum value in a non numeric column, example below Answer needed is IT20140010 IT20140001 IT20140002 IT20140003 IT20140004 IT20140005 IT20140006 IT20140007 IT20140008 IT20140009 IT20140010 Thanks N.Sundarvelan 9600160150 -- 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 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$$ Sort VBA required
Hi amar, PFA. Regards, Ganesh N On Thu, Oct 9, 2014 at 11:52 AM, amar takale wrote: > Dear Sir > > Pls find attached another sheet for detailed clarification.Here I show > how to look output will show.Bos there are same one stock are under > different category. > > Like BHEL it show under both 3 categary so if l hit any button > (BSE,Nifty,PSU) it must show that under category.So if I hit button as > per my requirement then stocks will show as per that under > category.(note that one stock are under different 2 or 3 category) > > Regards > Amar > > On Tue, Oct 7, 2014 at 7:49 PM, Paul Schreiner > wrote: > > As I said, what you describe can be accomplished with the use of Filters. > > > > In the attached filters, I enabled filters on your data. > > > > I then recorded a macro (called Button_Nifty50) > > in which I filtered on the "Nifty 50" column, > > and hid the BSE column. > > > > I then recorded a macro (called Button_ShowAll) in which I unhid all > columns > > and removed the filters. > > > > I then recorded a macro (called Button_BSE30) > > in which I filtered on the "BSE 30" column > > and hid the Nifty 50 column. > > > > I ran the Button_ShowAll macro and recorded a macro called Button_Other > > in which I filtered the Nifty 50 column for a value of "Other" > > (your example seemed to suggest that "Other" was in the BSE column, but > you > > data has it in the Nifty50 column) > > > > Once I had these recorded macros, I cleaned them up a bit (by adding an > IF() > > test to the showall macro, and others) > > > > then assigned the macros to the buttons. > > > > It SEEMS to do what you're asking. > > > > > > 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: amar takale > > To: excel-macros@googlegroups.com > > Sent: Tuesday, October 7, 2014 9:57 AM > > Subject: Re: $$Excel-Macros$$ Sort VBA required > > > > Dear sir > > > > Pls find attached sheet where I show how to look output.Actually I > > want after hit specific tab (like nifty,bse & other) will show that > > under category Stocks thats it. > > > > I hope clarify my issue > > > > Regards > > amar > > > > On Mon, Oct 6, 2014 at 7:14 PM, Paul Schreiner > > wrote: > >> I'm not sure about your requirement. > >> > >> You SAY you want to sort, but what you're describing is a filter. > >> > >> Sorting implies a change in sequence, > >> Filter implies hiding rows that do not meet specific criteria. > >> > >> And... why would it matter if a stock appears in both categories? > >> Even if you were sorting, if you sort on column D, it doesn't matter > what > >> is > >> is column E. > >> > >> as I said, I'm not sure about your requirement. > >> > >> Could you clarifiy by showing examples of what you'd expect to see > >> displayed > >> if you hit the "Nifty 50" button, and what you'd see displayed when you > >> hit > >> the "BSE 30" button? > >> > >> > >> > >> 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: amar takale > >> To: excel-macros@googlegroups.com > >> Sent: Monday, October 6, 2014 9:25 AM > >> Subject: $$Excel-Macros$$ Sort VBA required > >> > >> Dear all experts > >> > >> I required VBA code for sorting.pls see with detailed in excel. > >> > >> Regards > >> Amar > >> > >> -- > >> 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@googl
Re: $$Excel-Macros$$ Port VBA code to VB.net
Dear Rupesh, Pls share the file. Warm Regards, Gawli Anil. On Thu, Oct 9, 2014 at 1:50 PM, Rupesh Patil wrote: > Hello Expert, > > In my organization we have developed VBA Application for doctors. now we > want to create .exe file of this application > so as per my knowledge we can't create .exe file of VBA application. so we > need to port this code to .net. Could please assist me how to do this. > > > -- > Thanks & Regards, > Rupesh Patil, > (9970196189), > Ayushman Pvt. Ltd. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will > not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/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.
$$Excel-Macros$$ Port VBA code to VB.net
Hello Expert, In my organization we have developed VBA Application for doctors. now we want to create .exe file of this application so as per my knowledge we can't create .exe file of VBA application. so we need to port this code to .net. Could please assist me how to do this. -- Thanks & Regards, Rupesh Patil, (9970196189), Ayushman Pvt. Ltd. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Job Opening for MIS profile.
Hi Pramod! Would you please help to send the venue with JD (Job Discretion)? *Suman Kumar* On Wed, Oct 8, 2014 at 10:34 AM, Pramod Singh wrote: > Hi All. > > I have also one Opning in my company. As MIS profile. > > Salary 19 k and pickup and drop and also meals . > > Regards > Pramod > > Pramod > On 8 Oct 2014 09:51, "Ashish Kumar" wrote: > >> Hi Friends >> >> We have 2 Openings for MIS profile. >> >> Experience - 1 to 2 Yrs >> Salary - 10 K (Take Home) + ESI + PF + Gratuity >> Job Location - Gurgaon. >> Freshers are Welcome but have Good Hands on Excel. >> >> 1 Vacancy is for Gurgaon and 1 for Mundka (New Delhi). [Peeragarhi - >> Rohtak Road] >> >> Interested Candidates please send your resumes. >> >> >> 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.
