Re: $$Excel-Macros$$ Finding student whose marks are improving over three consecutive tests
Vaibhav this is easy, you first filter the list, and you will be able to see whether the student is doing well or not. there is no need for a macro. Just use DATA, filter and filter on the student. Thanks Rajesh 932-304-5443, Mumbai On Thu, Oct 21, 2010 at 8:34 AM, Vaaibhav wrote: > Hello > > I have got sample data as follows: > > > Marks in a single subject > Student Class Marks Test > A X 20 First > B XI 25 First > C V 12 First > A X 25 Second > B XI 23 Second > C V 12 Second > D VII 34 Second > A X 75 Third > B XI 34 Third > C V 87 Third > D VII 12 Third > > Now I want some ability that I am able to find the list of all > students who have got higher marks continuously i.e. Third Test > Marks>Second Test>First Test. > > Further I want a functionality that when I add marks of Fourth Test in > the sheet above then I shall need names of students whose marks are > increasing from last 3 tests i.e. Fourth Test>Third Test>Second Test. > In this case First test marks are irrelevant and so on for fifth, > sixth, seventh tests... > > -- > > -- > 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- -- 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Re: $$Excel-Macros$$ Finding student whose marks are improving over three consecutive tests
Yes this solved the case. Can you please give me your email id so that i can communicate directly? I have a long database now. On Oct 21, 6:10 pm, Dave Bonallack wrote: > Hi, > Have a look at the attached to see if it does what you need. > Regards - Dave. > > > > > Date: Wed, 20 Oct 2010 20:04:57 -0700 > > Subject: $$Excel-Macros$$ Finding student whose marks are improving over > > three consecutive tests > > From: vaaibhavjhav...@gmail.com > > To: excel-macros@googlegroups.com > > > Hello > > > I have got sample data as follows: > > > Marks in a single subject > > Student Class Marks Test > > A X 20 First > > B XI 25 First > > C V 12 First > > A X 25 Second > > B XI 23 Second > > C V 12 Second > > D VII 34 Second > > A X 75 Third > > B XI 34 Third > > C V 87 Third > > D VII 12 Third > > > Now I want some ability that I am able to find the list of all > > students who have got higher marks continuously i.e. Third Test > > Marks>Second Test>First Test. > > > Further I want a functionality that when I add marks of Fourth Test in > > the sheet above then I shall need names of students whose marks are > > increasing from last 3 tests i.e. Fourth Test>Third Test>Second Test. > > In this case First test marks are irrelevant and so on for fifth, > > sixth, seventh tests... > > > -- > > --- > > --- > > 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 athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://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/pages/discussexcelcom/160307843985936?v=wall&;... > > > > Students.xls > 29KViewDownload -- -- 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Re: $$Excel-Macros$$ VBA Help
refer attachment On Sat, Oct 23, 2010 at 9:35 AM, C.G.Kumar wrote: > You can use EDATE if using Excel 2007. Rest you can define in Macro. > > > Regards, > > C.G.Kumar > > > On Sat, Oct 23, 2010 at 12:07 AM, halpie97 wrote: > >> I'm a beginner with VBA and looking for some guidance in how to >> establish what I'm trying to do. >> >> Column A Column B Column C Column D >> 1/15/2010 6/30/2009 >> 3/2/2010 4/15/2008 >> >> I'm trying to create a VBA formula that will do the following in >> columns C and D: >> Column C should just be one year from Column A and insert the new >> date. >> Column D should be 180 days from Column B only if the date in Column A >> is less than 180 days and column B is greater than Column B. >> (Bascially trying to create a schedule for a date stamp of one year >> from Column A and then 180 dats from Column B but not if Column A >> happened within the 180 days). >> >> I'm looking for the function to insert the calcuated date value in >> both columns C and D for future reference. >> >> Thanks in advance for the help. >> >> -- >> >> -- >> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts >> > > > > -- > Regards, > > C.G.Kumar > > -- > > -- > 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- Srinivasan Ethirajalu, +919840544295 -- -- 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts dates.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Annoying popup for with Cancel button when opening workbooks
buddy, i'm mean the file i send u is excel 2003 (i.e .xls). but still you can use it and u can convert to .xlsx as well On Oct 22, 6:57 pm, simonl wrote: > So do you suggest I un-install and re-install Office? > > On 22 Oct, 15:20, Ashish Jain wrote: > > > > > Hi Simon, > > > Application.DisplayAlerts = False still works ! > > It works in all versions of excels i.e.2003, 2007 & 2010. > > > Take Care of these points: > > 1. Use new event macro - Private Sub Workbook_Open() > > 2. Enable the Macros(Right below Formula Bar) whenever you open the > > workbook. > > > Regards > > Ashish Jain > > McKinsey India Knowledge Center > > (Microsoft Certified Application Specialist) > > (Microsoft Certified > > Professional)http://www.excelitems.comhttp://www.openexcel.com > > > On Oct 22, 6:05 pm, simonl wrote: > > > > We recently upgraded to Excel 2007 from Excel 2000. I have a VB6 app > > > that uses Automation to start Excel, loop thru a lot of workbooks > > > opening each of them and then check various things in the workbook. It > > > worked fine in Excel 2000 and uses Application.Visible = False and > > > Application.DisplayAlerts = False. I now find that Excel 2007 pops up > > > a "progress bar" form with a Cancel button when opening some of the > > > files (maybe where the size of the file exceeds some value). The files > > > are in the "old" XLS format. Does anyone know of how to stop this form > > > from appearing? > > > > Have tried googling but could only find the DisplayAlerts = False > > > which I am already using. > > > > Thanks > > > > Simon- Hide quoted text - > > - Show quoted text - -- -- 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Re: $$Excel-Macros$$ VBA Help
You can use EDATE if using Excel 2007. Rest you can define in Macro. Regards, C.G.Kumar On Sat, Oct 23, 2010 at 12:07 AM, halpie97 wrote: > I'm a beginner with VBA and looking for some guidance in how to > establish what I'm trying to do. > > Column A Column B Column C Column D > 1/15/2010 6/30/2009 > 3/2/2010 4/15/2008 > > I'm trying to create a VBA formula that will do the following in > columns C and D: > Column C should just be one year from Column A and insert the new > date. > Column D should be 180 days from Column B only if the date in Column A > is less than 180 days and column B is greater than Column B. > (Bascially trying to create a schedule for a date stamp of one year > from Column A and then 180 dats from Column B but not if Column A > happened within the 180 days). > > I'm looking for the function to insert the calcuated date value in > both columns C and D for future reference. > > Thanks in advance for the help. > > -- > > -- > 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- Regards, C.G.Kumar -- -- 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
$$Excel-Macros$$ Protection of User forms in Excel
Greetings all I wish to be able to protect just one user form in an Excel VBA project but still allow users of the workbook to create macros and write code in the module section. Is this possible. When I have added a password to the user form it protect the entire project. Any assistance would be greatly appreciated. regards Hugo Phong -- -- 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
