A place to start is with an event macro in the sheet module or in the
Thisworkbook module.
Replace the MsgBox with code or a call to a macro...

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 And UCase(Target).Value = "X" Then
MsgBox "What to do with this row"
End If
End Sub

This one allows anything in column B

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 And len(Target) 0 Then
MsgBox "What to do with this row"
End If
End Sub

--
steveB

Remove "AYN" from email to respond
"Maggie" wrote in message
...
On sheets 1 through 6, I have a list of items in col A and a description
in
column C. If column B contains an X or checkmark, I want to list the
descriptions from column C on a sheet called Summary. (Can update sheet 7
once sheets 1 thorugh 6 have been filled out by the user.) I need to be
able
to easily add and remove items from sheets 1-6 without having to modify
the
code.
--
Thank you,
Maggie