I have (2) worksheets, each have a cell in them that say 'Month:' with a dropdown validation list of the months available. I would like to be able to do the following:
Sheet 1, Cell A2: Hit dropdown and change to 'November'
- Update Sheet 2, Cell A2 to say 'November'
Sheet 2, Cell A2: Hit dropdown and change to 'December'
- Update Sheet 1, Cell A2 to say 'December'
As you can see, I would like to have each cell be updatable, but when you update one of the cells, it will automatically update the other. I had some VBA that was doing something similar, but when I ran it I was basically running into an infinite loop problem.
Any suggestions?
Sheet 1, Cell A2: Hit dropdown and change to 'November'
- Update Sheet 2, Cell A2 to say 'November'
Sheet 2, Cell A2: Hit dropdown and change to 'December'
- Update Sheet 1, Cell A2 to say 'December'
As you can see, I would like to have each cell be updatable, but when you update one of the cells, it will automatically update the other. I had some VBA that was doing something similar, but when I ran it I was basically running into an infinite loop problem.
Any suggestions?