Copy Row Downwards every time a cell value changes

[wnottidge]

Hello,

I'm very new to VBA and basically all I can do is take peoples advice, copy their code and see if it works. So please help me out!

I've been trying to find a solution to my problem online but I can't seem to find the exact solution.

I've got a spreadsheet which has a feed to a betting exchange. Every time a certain cell value changes, I want an entire row to be copied below on the same spreadsheet.

Specifically, when the cell T2 changes, I want the range A2:T2 to be copied down to the next available row below.

Can anybody help me out?

Cheers

Will

 

[My Aswer Is This]

Try this:
Not knowing exactly how the value in "T2" changes.

This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 2 And Target.Column = 20 Then
Dim Lastrow As Long
Lastrow = Cells(Rows.Count, "A").End(xlUp).Row + 1
Range(Cells(Target.Row, 1), Cells(Target.Row, 20)).Copy Cells(Lastrow, 1)
End If
End Sub