I have been looking everywhere for a formula that will help me do this:
When I type the word "PREC" into a cell on rows 26-42 I would like row 14 to automatically populate with the initials of the person scheduled.
I cannot have the formula be in row 14 or anywhere else on the schedule really because I have to manually enter data and that will erase my formula.
I have been thinking about this for days! Please help
Bookmarks