Excel Macro Help needed urgently

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

AttachmentSize
Need Macro help.xlsx11.55 KB
Nick's picture

Michael - try recording a

Michael - try recording a macro..

some tips here:

 

Learn VBA Step By Step