Macro to Compare and check two rows

I have a question that I have two rows from D77 TO D132 which is column D
and I have column B with rows B77 till B132.

I want to check that if a user fill anything in D77 or any row from D77 to D132 he needs to fill row against B Column.
As an example some one put data in row D77 and didnt feed any data in B77 against that it will ask the user to put the data in B77 before saving and wont let the user save the file until he enters data against D77 row in B77.

Can anyone help me with the macro. I am pretty new so I am not sure how to make it.

Its basically a conditional macro that it checks the rows against D to B and verifies if D row is filled B is also filled but if B row is not filled it ask the user to fill in the data in row B before saving.

Hi

Try this sheet event macro. Select the sheet tab, right click, select view code, then paste in the code.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  On Error GoTo errhand
  Application.EnableEvents = False
  For Each ce In Range("D77:D132")
    If Not IsEmpty(ce) And IsEmpty(ce.Offset(0, -2)) Then
      ce.Offset(0, -2).Select
      MsgBox "Must fill this cell"
      Exit For
    End If
  Next ce
errhand:
  Application.EnableEvents = True
End Sub

If you have data in column D for the relevant range, and there is nothing in column B, then it will prompt for input.


rylo