Making a change in column blanks out the entry for a corresponding cell in another column

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.

-----------------------------------------------------------------

Please Login or Register  to view this content.

Hi Medimatt
Welcome to the Forum.
In future please view the forum rules before posting. Your post does not comply with rule #3.

3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the [#] button at the top of the post window.

Try this

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Glad we could help:

If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember......Mark Thread as Solved.

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.