2D reference range to activate a cell

  • I've tried on another board with no luck. I have a userform that has a combobox18 with names of employees. There is also a textbox that you enter the date. I need to reference the employee name, then go to the cell that has the same date as what's entered (preferably via a combobox as well, but it isn't set up like that yet, still have to figure that out). Where the two intersect, i need to populate that cell with the number of points that the user has selected from another combobox. I've attached a sample.Sample attendance tracker


    Any help would be so appreciated. I've been battling with this for like a week! It's probably simple, but I haven't been able to find a solution online anywhere. A few close ones, but nothing that worked.

  • Hello,


    Your workbook does not seem to be structured to simplify your life ...


    1. Why do you have so many different sheets ... when the date is ... by design ... enough to determine the quarter ?


    2. Why is your UserForm totally empty in terms of code ?


    3. What is your exact definition of all your occurrences ...?

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

  • Once you have tested the formulas ... feel free to share your comments

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

  • You are welcome

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!