Vba, arrays and dictionaries: how to compare two columns with other two columns

[Nelson78]

Hello everybody.

I have two lists:
- in Sheet1, five columns (A:E)
- in Sheet2, four columns (A:B)

I have to check:
for each combination in Sheet1 of columns A&E, checks if it exists in Sheet2 columns combination B&C
if yes: copy Sheets1 columns A:E in Sheets3 columns A:E


I know I can create a key combining the two columns with "&", but I'm looking for a speeder solution.

Thank's in advance.

 

[mumps]

It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach screenshots (not pictures) of your two sheets. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).

in Sheet2, four columns (A:B)

Columns A:B are two columns not four. Please clarify in detail.