Click on a cell in column H, go to the Data menu and choose ‘Data Validation’. From the window that appears on the right, click the rule for column H. The Criteria range should be ='Linked Transfers'!$O$2:$O. Of course this assumes you still have the Linked Transfers sheet, and that you didn’t rename it.
1 Like