seamus99
asked on
excel question
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?
Requirements-Traceability.xls
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?
Requirements-Traceability.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.