If data appears on one sheet delete it from another

[pleiadeez7]

I have a workbook with mulitple sheets. The first sheet (All CCN) is all of my invoice data. The remaining sheets contain invoice data for specific companies.

If I enter a payment date on the All CCN sheet is there a way for Excel to find the invoice on the company sheets and delete the row?

A copy of my workbook is attached.

Thanks

[noexcel=badwork]

hi
I think to delete a row you need a macro
but here is one approach (attached the file)
first thing I used vlookup formula in sheet dell
column m (hidden) the formula is:

Please Login or Register  to view this content.

then I use conditional format, I selected all data in sheet dell
and I use this formula:

Please Login or Register  to view this content.

I make the format for the cell to be filled red
and the font white (with strikethrough)
by this way, the cells with payment date
will come in red and it will be distinguished from other cells
hopefully that helps you