I need the above code to work in column C and Column K how do i write that![]()
If Not Intersect(Target, Range("C:C")) Is Nothing Then If Target = "Maintenance" Then
so currently when Column C gets maintenance selected the reason goes in column D which is great but now that I need column K to work like columb C in when columb K is has maintence selected then I need the reason to go to Column L![]()
Sws.Cells(tRow, "D") = Reason
New Compressed (zipped) Folder.zip
Bookmarks