Posts by psindelar

  • Multiple Criteria From Differing Rows

    Re: Multiple Criteria From Differing Rows


    Bill,
    That code worked amazingly! Thank you so much. I sent the report on to the state of Illinois. I would love to learn VBA. Do you have any suggestions on books I could look for?


    Thank you just doesn't seem enough for what you did for me. I hope you are around for my next excel formula.


    Patty
    :)

  • Multiple Criteria From Differing Rows

    Re: Multiple Criteria From Differing Rows


    Kris,
    Thank you for your VBA test. It ran in the spreadsheet, but there were many entries that it missed. The first Student ID in H2 also took Business Tech II and is in H57. The code did not pick up that student. Is there an adjustment to this code that I can make?


    Patty

  • Multiple Criteria From Differing Rows

    Re: Multiple Criteria From Differing Rows


    Bill,
    I was not able to run the sample you sent back. When I ran the code in the regular spreadsheet and got the error message, I did not have any 3s in K. I was able to run the test. That worked beautifully!


    Patty
    :)

  • Multiple Criteria From Differing Rows

    Re: Multiple Criteria From Differing Rows


    Bill,
    Your test DID work. It was very exciting! I took out the two lines of test codes to see if the original code would work and it didn't. Now what? I am so excited that this might actually work!! Thank you Thank you


    Patty
    :)

  • Multiple Criteria From Differing Rows

    Re: Multiple Criteria From Differing Rows


    Brad,
    The data was retreived from our student information system. It is a web-based program. The list of courses that you have are the titles of the courses. Thank you for your help on this.


    Patty

  • Multiple Criteria From Differing Rows

    Re: Multiple Criteria From Differing Rows


    Bill,
    I was not able to run the code from your sample. I got the same error message. Yes, my 1s and 2s are in columns I and J. I did not get any data to enter in the spreadsheet when the error message was received. I did your test; it did not work. I got the same error 9 message. I feel so bad that you are spending so much time on this and I can't get it to work. Do you think it could be my computer? I hope you have some more tricks up your sleeve.


    Patty
    :)

  • Multiple Criteria From Differing Rows

    Re: Multiple Criteria From Differing Rows


    Bill,
    Am I running the code wrong? After I paste your code in, I go to the run tab and click runsub/user form. Is this right? As soon as I click that I get that error 9 message and no records run. Is there something wrong with my program or computer. I see how wonderful this function is by the way it works for you. I want it to work for me! Is there a problem with cut and pasting it in? Should I retype the code instead of pasting? I am going out for awhile, too. Whatever you suggest I do, I will do it then. I really appreciate this.


    Patty
    :)

  • Multiple Criteria From Differing Rows

    Re: Multiple Criteria From Differing Rows


    Bill,
    Here are the first 500 rows. I wanted you to see all the headers. I cleared the contents of student name and staff name - I didn't think you needed that info; however, I needed to make the file smaller to send. Thank you so much for your tenacity.


    Patty
    :)


    I don't think the last one got sent - too big. I hope this one works.

  • Multiple Criteria From Differing Rows

    Re: Multiple Criteria From Differing Rows


    Bill,
    Thank you for sticking with me on this. I added it just as you said. I changed the sheet name to List_Frame_1. When I hit the F5 key, I got the same error 9 message on Ln 46, Col 9. I don't know how to fix that. What should I try?


    Patty
    :)

  • Multiple Criteria From Differing Rows

    Re: Multiple Criteria From Differing Rows


    Bill,
    This is a message I got


    Invalid outside procedure


    The statement must occur within a Sub or Function, or a property procedure (Property Get, Property Let, Property Set). This error has the following cause and solution:


    An executable statement, Static or ReDim, appears at module level.
    Static is unnecessary at module level, since all module-level variables are static. Use Dim instead of ReDim at module level. To create a dynamic array at module level, declare it with Dim using empty parentheses.


    Note At module level, you can use only comments and declarative statements, such as Const, Declare, Deftype, Dim, Option Base, Option Compare, Option Explicit, Option Private, Private, Public, and Type. The Sub, Function, and Property statements occur outside the body of their procedures, but within the procedure declaration.


    For additional information, select the item in question and press F1 (in Windows) or HELP (on the Macintosh).

  • Multiple Criteria From Differing Rows

    Re: Multiple Criteria From Differing Rows


    Bill,
    Yes, semester 1 courses are listed in column I with a 1 and semester 2 courses are always right after listed in column J with a 2. There are no spaces. I do not know VBA very well. I use alt F11 to open VBA and insert a module. I cut and paste your function in the project area. When I put =MatchCourseSemesters2 () in K2, I get an error message that there is an error in my function. What am I doing wrong?

  • Multiple Criteria From Differing Rows

    Re: Multiple Criterion From Differing Rows


    I wish I could send you the whole file but it is too big. All the courses listed have 2 semesters. Some courses do not have the exact same name, such as: marketing and retail marketing. Would it be easier if I took the time to separate each pair of courses? I tried putting the VBA in the original spreadsheet and I got a message that said that the name did not exist. What did I do wrong. I also got an error 9 message when I hit the run button.

  • Multiple Criteria From Differing Rows

    Re: Multiple Criterion From Differing Rows


    Thank you for your help!


    I work at a school and am getting a report ready for the state of Illinois. I have 2,438 rows of student information. What I am attempting to do is add a "3" if a student took both semesters of a specified course. Semester 1 is listed in one column and row by the number "1." Semester 2 is listed in a separate column and row by the number "2." The unique qualifier is the student ID. I need to have Excel match student ID with both the semester 1 and semester 2 as well as the course. I have attached a sampling of the file I am working on. In FY column, I need a "3" next to those matching student IDs that took the same course for both semester I and 2.