I'm new to the forums and have done some searching with no luck, so if I have missed this solution in another post, please forgive the error.
I have a series of numbers listed in a single cell ("Submitted"), separated by spaces. The series can be any combination of numbers from 1-32 and will be entered by the user. I want this cell to be the baseline of possible values that can be entered in 3 other cells labeled "Approved", "Disapproved" and "Discrepancy".
The values listed in "Submitted" can only be used once, so "1" should never be entered in "Approved" and "Disapproved" at the same time. Numbers not listed in "Submitted" should not appear in "Approved", "Disapproved" or "Discrepancy."
Please see attached file for examples.
Bookmarks