VBA search and delete entire row in DataCapture VBA code - HELP

Hi,

My Datacapture code is not deleting existing entries, so when I come to re-populate previous entries code gets confused with old. Before dumping data i need to search for existing entries that match Sheets("LoanSummary).range("B1") and delete entire row before dumping new data.

I am unable to get to work - please can someone help?

Please Login or Register  to view this content.

I have code to delete entire row, just don't know how to/where to insert in the Sub Dump procedure?

Please Login or Register  to view this content.