Previous Topic Next Topic

Excel macro

Closed
ns56 - Updated on Aug 21, 2017 at 04:37 PM
 Blocked Profile - Aug 21, 2017 at 04:40 PM
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)



Related:

1 response

Answer 1 / 1
Blocked Profile
Aug 21, 2017 at 04:40 PM
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!
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses