Hi friend,

I need a help and want to do this with macro

• From the “Functional Sheet” Go to “Description column and Copy first “SIS Line 2”.
• Go to tab “Data Element” Search for it in “Description column” and in which so ever row the match is found
• “Traceability Tracefrom” column of Data element sheet gets populated with functional sheet “ID” column corresponding to “SIS Line 2” which we copied that is “UW-F1” with Alt + Enter if more than one are there in one row
• Similarly for rest of the rows that is SIS Line 2,3,4 etc SS line 1,2,3 etc, O line 1,2 etc

Please find attached excel sheet and kindly help me out