troubleshooting Question

vba find cell match then copy data

Avatar of mike637
mike637Flag for United States of America asked on
Microsoft ExcelVB Script
2 Comments1 Solution543 ViewsLast Modified:
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.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros