So I have the spreadsheet that I have attached.
What I want to do is populate sheet "Orphans" from Sheet "RTM" when a blank is found in Column T.
So lets look at row 18. column T is blank I want to copy that ID number to the cooresponding cell in the Orphaned Sheet. So ID 1.1.17 (RTM) would relate to ID 1.1.1 (Orphaned" I have manually done this as an example. Is there a way to programitically do this?