Place the code in Module1
Sheet Module which contain data
Sheet Output is Paste Data
Code:
Sub Extractdata()
Sheets("Module").Select
Range("A2:P66").Select
Selection.Copy
Sheets("Output").Select
Range("A2").Select
ActiveSheet.Paste
Range("A1").Select
End Sub
2013/3/2
Hello Experts,
i tried using recorded marco but still having slight chanllenges, it can
pick the worksheet unless the particular worksheet is active. kindly amend
this macro for me. thanks
Sub Extractdata()
With Worksheets("Module").Range("B2").Value
Range("C3:C66").Select
Selection.Copy
