I work with two spreadsheets, the question I have specifically relates to one sheet called 'Checklist' the other spreadsheet is "current work".
We work in two stages Submission and Delivery and each stage has a number of jobs associated with it. The only job that corresponds to BOTH submissions and deliveries is a cell in the 'checklist' spreadsheet that reminds us to update the current work spreadsheet. So when the submission stage is complete there will be text in the cell for column J (Update Current Work). When we then receive the delivery and change column A to received I want the entry in column J (for the same row) to be removed so the reminder to updated "Current work" becomes visable (I have conditional formatting set up to highlight incomplete cells)
So far (using google) I have only been able to get following which is row specific. The solution maybe simple, but I haven't been able to find it. I would like this to apply across the whole sheet so if any row in column B changes the same row in column J is emptied. I can only get the below wo work when specifying a specific row and column.
Thank you in advance for any help.
-----------------------------------------------------------------
Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count > 1 Then Exit Sub If Not Intersect(Target, Range("B2")) Is Nothing Then Range("J2").ClearContents End If End Sub
Bookmarks