Copy and Paste Loop between two sheets

DrDrainage

New Member
Joined
Apr 17, 2019
Messages
1
Thanks in advance for the help.

The calculation sheet has several API keys that determine distances between multiple start points compared to one end point. The data dump sheet list all my end points that I want to know the optimum distance. Instead of manually going line by line, I would like to automate this as much as possible.

Below is what I recorded. What I need help on is modifying my current script. I want to keep the columns the same for the initial copying, pasting into the same 3 cells on Calculation, and copying the same 2 cells on Calculation. Then pasting the 2 cells in column K & L on Data Dump for the same row the initial copying values came from. Then go down one more row, repeat the process, until the last row.

Sub Test()
'
' Test Macro
'


'
Range("G2:I2").Select
Selection.Copy
Sheets("Calculation").Select
Range("E5").Select
ActiveSheet.Paste
Range("H5:I5").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Data Dump").Select
Range("K2" ).Select
Selection.PasteSpecial Paste:=xlPasteAllUsingSourceTheme, Operation:=xlNone _
, SkipBlanks:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

End Sub
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Forum statistics

Threads
1,215,680
Messages
6,126,188
Members
449,296
Latest member
tinneytwin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top