Avatar of mike637
Flag for United States of America asked on

vba find cell match then copy data

Hello Experts,

I have a 2 digit value in Range("Y11") and I want to search Range("A1:U135") and find the exact cell.value match.  (Y11) will always be used, the Range(A1:U135) will always stay the same. There will never be more than 1 instance of a match since they are all varied.
It is a whole match.

After I find the match - I need to copy 3 cell values to corresponding cells of matched cell.  These 3 cells will never change. ("Z9"), ("AB9"), ("AD9")

For example:
If Range("Y11") = 25 and if finds the exact match at Range("A1") - it will:
Copy Range("Z9") to the cell that is 8 cells down and 1 cell to the right of match cell ("A1")
Copy Range("AB9") to the cell that is 8 cells down and 6 cells to the right of match cell ("A1")
Copy Range("AD9") to the cell that is 8 cells down and  4 cells to the right of match cell  ("A1")

I hope I explained it well enough.

Thanks for your assistance.
VB ScriptMicrosoft Excel

Avatar of undefined
Last Comment

8/22/2022 - Mon
Arno Koster

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question


Thank you!
Your help has saved me hundreds of hours of internet surfing.