Excel macro [Closed]

 Blocked Profile -

I'm also very new to macro, so I don't know what I'm supposed to be adjusting!

My main sheet is titled "Project Timeline" and my other sheets are "Marketing", "Training" etc. the column in "Project Timeline" i've used is G, not H, so I adjusted that. But I'm not sure what else I'm supposed to adjust!

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Columns("H:H")) Is Nothing Then Exit Sub

If Target.Value = "General" Then
Range(Range("C" & Target.Row), Range("H" & Target.Row)).Copy _
Sheets("General").Range("C" & Rows.Count).End(xlUp).Offset(1, 0)

1 reply

Well, there really isn't enough details to assist you in what you are asking.

You basically have told us that you have adjusted G, to use H.

If the above code doesn't run, it is not formed correctly. You need an END sub, and an END IF!