Macro to repeat same process on successive rows and record answers on successive rows

[QPRMinty]

Hello all.

I want to take data from a list and place it into another part of the spreadsheet to be used in a calculation, then to record the answer in another part of the sheet.

Then repeat the process for the next row of data and to record that answer on the next row of the recorded answers.

I've uploaded a simple version of what I need.

Data to be taken from row 2 of columns K & L, and put it into row 2 of columns A & B, and record the answer in row 2 of column C and record that answer in row 2 of column F.

Then repeat this for each successive row of data in columns K & L.

Thanks for your help.


===================================

Here's the code I have so far....

Sub Macro1()
'
' Macro1 Macro
'
' Keyboard Shortcut: Ctrl+q
'
Range("K2").Select
Selection.Copy
Range("A2").Select
ActiveSheet.Paste
Range("L2").Select
Application.CutCopyMode = False
Selection.Copy
Columns("B:B").Select
Range("B2").Activate
Range("B2").Select
ActiveSheet.Paste
Range("C2").Select
Application.CutCopyMode = False
Selection.Copy
Range("F2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub

[Sintek]

Hi QPRMinty

In future please view the forum rules before posting. Your post does not comply with rule #3.

3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the [#] button at the top of the post window.

Here's one way

Please Login or Register  to view this content.