Georgoboy\p45Cal

The PQ.xlsx shows exactly what I am currently doing with VBA (95% of the time). So my first step is to figure out how to do Georgboy's steps 1 through 6 using VBA.

95% of the time the conditions are:
a. Return only the first match in Sheet 1 and b. Discard all Sheet 1 rows where match is not found
The other 5% of the time, there are some conditionals.
a. For any second or subsequent match, create new row in Sheet 3
b. For any second or subsequent match, concatenate any second or subsequent match data in existing Sheet 3 row
c. If a match is not found for any row in Sheet 1, cancel and exit process
d. If a match for any row in Sheet 1, create a new row in Sheet 3 showing only Sheet 1 column 1 data
e. If a match is not found for any row in Sheet 2, cancel and exit process

So, before trying to climb the mountain and learn how to perform georgiboy's steps, do you feel these objectives could also be meet?

I'll try to put together some sanitized examples and post.

Thank you so much!!!