Hi Friends,
I need a help and want to do this with macro could anyone of you please help me
• 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”
• 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 template
Thank You in Advance.
Bookmarks