Link to home
Start Free TrialLog in
Avatar of mike637
mike637Flag 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.
ASKER CERTIFIED SOLUTION
Avatar of Arno Koster
Arno Koster
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mike637

ASKER

Awesome!!

Thank you!