VBA for Vlookup for 2 Sheets

[Rev12]

Hello Everyone!

I want to use VBA instead of a vlookup formula to over 4000 cells of a record, it's slowing my worksheet.

I have 2 sheets in a my spreadsheet i used to place the data in 2sheets to compare on my 1sheet thru a vlookup.

Maybe I can create a button that on click it will display a records on my 1sheet that are equal in my 2sheets would it be possible??

Please any kind of help is much appreciated.

Thanks in advance,
Rev12

[xladept]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Rev12]

Thank you for your kindness of trying to help me, but I tried using INDEX MATCH over VLOOKUP it looks my excel were not slowing.

Thanks again..