I am trying to put together some code that will search a specific
workbook for data, and if that data is not present in that workbook to
delete the data in the current workbook.

Can anyone help with this?