I have a spreadsheet when you type a value in column a, a corresponding calculated field gets triggered in column b.
so... I type 5 in field a2 and 6 (=a2+1)appears in column b2. The problem is that this spreadsheet was created 7 years ago, and I cant find or remember where the event handler code lives. When I look in macros/vba no modules exist. when I copy and paste both columns into a new worksheet/workbook the calculated field still works.
If I click into fields a3 or b3 no data exists. If I type a value in a3 and hit enter, the calculated field in b3 appears. Can someone help me find the code or where the event trigger exists?