I have data validation configured gathering from list of data from Sheet 2 and displaying information using Data Validation on Sheet 1.
However, my goal is: When the object is already listed using data validation on Sheet 1's cell A2 for example, selections for cell A3 becomes limited and information provided on cell A2 should no longer appear
on the selection for other cells (e.g. A4) and moving forward.
Is this something possible?
Thanks a lot! Really poor excel skills here and trying to fix that up and couldn't help but to reach some experts out there.