Search Excel Sheets Against Each other then copy rows

[muddawg19]

I've been working on this for hours all day today and really need some help.

In sheet1, columnA is empty. I want to use columnB to find a match in sheet2 columnB. When it finds a match, it will copy the data from columnA in sheet2 over to columnA in sheet1. Or if it is easier, I can copy the entire row.

[stnkynts]

Don't need a macro. Put this formula in sheet1 cell A1 and fill down

Please Login or Register  to view this content.

[xladept]

Hi Dawg,

Try this:

Please Login or Register  to view this content.

Directions for running the routine(s) just supplied

Copy the code to the clipboard

Press ALT + F11 to open the Visual Basic Editor.

Open a macro-enabled Workbook or save your Workbook As Macro-Enabled

Select “Module” from the Insert menu

Type "Option Explicit" then paste the code under it

And, you should be ready to go

With the cursor between Sub and End Sub press F5 (F8 to Single Step)

OR

Press ALT + Q to close the code window.

Press ALT + F8 then double click on the macro name

[muddawg19]

Thank you for the help!

I'm trying to run the script and I'm getting the following error:

Please Login or Register  to view this content.

When I run Debug it shows this line highlighted in yellow:

Please Login or Register  to view this content.

[xladept]

Try:

Please Login or Register  to view this content.

I edited my first post, the mistake should have never been made - Sorry!