finding row number in other workbook meeting 2 criteria

I have x number of workbooks that all communicate with one master workbook.
I am using beforeclose event to trigger a macro that will check each entry of the current workbook (through a loop, unless there is a faster option) and verify if that entry is already in the master. There are two criterias to match: the project number and the changeorder number - if so, it will update the data on that row (hence the need to find the row number I believe) with the information from the current workbook. The information in the master workbook should be sorted by project number, but the changeorder number is text and numbers.

Please Login or Register  to view this content.

Any help would be appriciated.

Thank you for the code. I have been working on understanding how to work with autofilters. In general, it looks like the solution. I just need to tweak a few things to make it work exactly how I need it too. I will post the code once finished.