Wheatly
04-08-2017, 05:10 AM
Hi, so I have a list of countries and their populations. I have been able to macro 3 lines thus far through excel. My question is, is there a way to repeat this process for the remaining Countries? I’ve attached my excel and included my macro code below.
'
' Macro2actual Macro
'
'
Range("A2").Select
Selection.Copy
Range("H2").Select
ActiveSheet.Paste
Range("B3").Select
Application.CutCopyMode = False
Selection.Copy
Range("I2").Select
ActiveSheet.Paste
Range("A5").Select
Application.CutCopyMode = False
Selection.Copy
Range("H3").Select
ActiveSheet.Paste
Range("B6").Select
Application.CutCopyMode = False
Selection.Copy
Range("I3").Select
ActiveSheet.Paste
Range("A8").Select
Application.CutCopyMode = False
Selection.Copy
Range("H4").Select
ActiveSheet.Paste
Range("B9").Select
Application.CutCopyMode = False
Selection.Copy
Range("I4").Select
ActiveSheet.Paste
End Sub
So how can I edit this code to continue on this rule for remaining Countries? Thanks in advance!
'
' Macro2actual Macro
'
'
Range("A2").Select
Selection.Copy
Range("H2").Select
ActiveSheet.Paste
Range("B3").Select
Application.CutCopyMode = False
Selection.Copy
Range("I2").Select
ActiveSheet.Paste
Range("A5").Select
Application.CutCopyMode = False
Selection.Copy
Range("H3").Select
ActiveSheet.Paste
Range("B6").Select
Application.CutCopyMode = False
Selection.Copy
Range("I3").Select
ActiveSheet.Paste
Range("A8").Select
Application.CutCopyMode = False
Selection.Copy
Range("H4").Select
ActiveSheet.Paste
Range("B9").Select
Application.CutCopyMode = False
Selection.Copy
Range("I4").Select
ActiveSheet.Paste
End Sub
So how can I edit this code to continue on this rule for remaining Countries? Thanks in advance!