Find matches, copy and paste adjacent cell

[amein]

Hi, i found this VBA from here https://support.microsoft.com/en-us/kb/213367

Please Login or Register  to view this content.

Find match in column F in column A
This VBA only get result, what i want code that can copy from adjacent cell next to results.

1.png

2.png

Book2.xlsx

[kadeo]

Try replacing this line

Please Login or Register  to view this content.

with this line

Please Login or Register  to view this content.

Does that help?

[millz]

Please Login or Register  to view this content.

[bakerman2]

Please Login or Register  to view this content.

[amein]

Try replacing this line

Please Login or Register  to view this content.

with this line

Please Login or Register  to view this content.

Does that help?

errr.... doesnt work..

Please Login or Register  to view this content.

Compile error: Next without for

Please Login or Register  to view this content.

WORKING GREAT!!!
THANK YOU!

Btw, possible if run without selection first? Code will scan column till end and do "find match" and stop at last row

Many thanks!

[bakerman2]

If there are no empty rows between values then due to CurrentRegion code goes all the way to the end of both ranges.

[millz]

Compile error: Next without for :

It means you replaced your code wrongly. The code fragment I posted did not consist of any For loops. You accidentally removed a Next statement.

[amein]

If there are no empty rows between values then due to CurrentRegion code goes all the way to the end of both ranges.

Hi again bakerman2,

Just 1 last question... Is it possible if data come from different worksheet...

How to modify the code so that will work between 2 different worksheet.

thank you in advance..

[amein]

it means you replaced your code wrongly. The code fragment i posted did not consist of any for loops. You accidentally removed a next statement.

yeah thanks!!!!

Now working

[bakerman2]

How to modify the code so that will work between 2 different worksheet.

Just put the relevant sheetnames in front of cells. f.i.

Please Login or Register  to view this content.

[amein]

Thank you so much for your help.

Fyi, try to run with 20k row data.. With 11 column.. Macro running with no problem.

[bakerman2]

You're welcome.