Hello, I need some expert help please .... I have below Macro code.. It only looks for CDH.. I want it to find sheetname from range r2:r19 in sheet 'instructions' .. Copy that active cell row T:AE and transpose pastevalue into found sheet (CDH in this case) in range 'D4:D15'
Sub...