Macro doubt: look for a specific value

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

Thank you for helping me with this!!

I am looking for help to write a macro that looks for a specific value in a given worksheet column, finds the match for that value in a different worksheet and gives out the corresponding values.

I would imagine that I need to be using a nest Vlookup of some sort in VBA. But I am an absolute beginner and any help would be appreciated!

Thanks!

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
first step would be to see if you could do it manually. If yes, then you can use macro recorder to record your actions as a macro. You can then edit that macro to make it more generic if so needed.