Help creating a Macro

NanduB 1 Posts Tuesday July 24, 2018Registration date July 24, 2018 Last seen - Jul 24, 2018 at 01:00 PM - Latest reply: ac3mark 10668 Posts Monday June 3, 2013Registration dateModeratorStatus October 17, 2018 Last seen
- Jul 24, 2018 at 04:29 PM
Hi,

I am trying to create a Macro to copy paste the particular range of row in the same sheet based on the cell value in the previous sheet

Scenario Description:

In sheet2 I have to copy the rows from A13 : 20 based on the list of values in Column S in Sheet1
See more 

Your reply

1 reply

ac3mark 10668 Posts Monday June 3, 2013Registration dateModeratorStatus October 17, 2018 Last seen - Jul 24, 2018 at 04:29 PM
0
Thank you
You shouldn't need help making a macro, you can literally RECORD ONE! Press record Macro, and do the job, then press stop. There you go, a macro!

It should look like this:

Sub Macro1()
'
' Macro1 Macro
'

'
Sheets.Add After:=ActiveSheet
Sheets("Sheet2").Select
Sheets("Sheet2").Name = "thissheet"
Sheets("Sheet1").Select
Rows("2:12").Select
Selection.Copy
Sheets("thissheet").Select
Rows("6:6").Select
ActiveSheet.Paste
End Sub



After you have recorded it, then you can start to introduce the variables!

Respond to ac3mark