Excel macro Closed

Question

Hello, 

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)



System Configuration: Windows / Chrome 60.0.3112.101

ac3mark · Answer

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!

Excel macro

1 response

Similar discussions

Subscribe To Our Newsletter!