in column b, i have a list of days the employee in column a has for vacation (8 days,7,etc.) . in column c there are notes such as in year 1, the employee has off 8 days, but in year 2, the employee has off 10 days. when this happens, the cell in b contains "SEE NOTES" instead of the number of vacation days. is there a way to create an input box that pops up for every cell in column b that says "SEE NOTES" and allows you to enter a value that will overwrite what is in the box (or put the value in another column)? also, is it possible the input box populates with the notes from column c?
Bookmarks