If the dropdown says "January" go to the cell that says "January"

  • Hello All!


    I wonder if you can help me!


    I am creating a spreadsheet called holiday record, where I store all the data of the department for holiday, sickness, maternity leave, etc, and I have a continuous sheet with all the months in it. I have a dropdown with all the months in it, and I would like to choose a month from the dropdown and the cursor go to the month on the spreadsheet. Is this something that can be done on vba?


    Thanks in advance for your help!


    Linda.

Participate now!

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