Delete entry upon meeting condition

[petergoodm]

Hello,

We have a macro that works in the following manner:

I have 2 workbooks. One gets updated based on a change on the other.

Workbook '1' contains rows of testing results
Workbook '2' contains columns of specfic testing results referenced from Workbook '1'

We use a button in Workbook '2' to browse a list and open Workbook '1'.
When Workbook '1' is opened we look to see if there is an entry in the first row in column 'A'. If there is, data from the row
is copied to Workbook '2'.

This works!

What I need to do now is add a component to this macro that removes the entry from Workbook '2' if a row is deleted in Workbook '1'.

Any ideas would be greatly appreciated!

Thanks,

Peter