Greetings all. I have a general question, so I don't think anyone will need to see the code. I have two cells, I'll call them cell1 and cell2. Cell1 is a date, and cell2 is a number. If someone changes the date in cell1, the change event references another sheet and populates the datediff in days in cell 2. This is working 100%. My problem is that I would like to put the same logic for changes to cell2, i.e. if someone changes the number, it will reference the same date in another sheet, and return the date that results from a date calculation, and populate that in cell1. I had this working 100% also. The problem is that I cannot have them both working, because it causes an unending loop of updates. Any ideas. I'm hoping someone knows something easy, if not I will post the code. Thank you.
Greg
Greg