paulked,

You have been so helpful!! Now I understand what you mean by the # sign. Thank you so I can continue to participate on this forum as I am new.

As far as the macro. My intention was delete the row in the ""PO Accrual Data" worksheet if there was a match in the other worksheets column A. Not the other tabs. What would I code to make that happen? So for example if I find a match with column A in "PO Accrual Data" worksheet with any other worksheet, how would I delete that row in the "PO Accrual Data" worksheet? I need all other tabs to remain as is.

Your skills are amazing.

Thanks.
Steve