UserForm selected data; to edit multiple worksheets(& specific rows)

[anonfish]

Hello All,

First thanks to all for all the input posted here, it has been a great inspiration and help. My current "code block" has come and I have truly no idea how to resolve the code.

Explanation:
I have a Userform(frmTally) that is used to input data into the worksheets. It places portions of the datafields into a General Log and then places info into the specific Vendor Worksheets.
I also have a second Userform(frmEditData) that is SUPPOSED to allow me to search for a vendor and an invoice number and then input payment info to both the general log and also to the vendor sheet.

Status:
All the code works great EXCEPT; i can't make the code search the vendor worksheet, compare the userform selected info, vendor, invoice, & the date of the entry. confirm the data matches and then insert the payment info into the vendor sheet.

I have tried the "FIND" function but am not sure it is actually the right function to use.

Submitted Project:
I have attached a sample of this project, parts of it that pertain only to this problem. Thank you for any solutions.

[royUK]

I can't see the need for individual vendor sheets

[anonfish]

Part of the original excel workbook. I never argue with "Finance"

[anonfish]

so no ideas?