Macro doubt: look for a specific value
Closed
KayKay
-
Mar 14, 2011 at 09:10 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 14, 2011 at 09:31 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 14, 2011 at 09:31 AM
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!
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!
Related:
- Macro doubt: look for a specific value
- Spell number in excel without macro - Guide
- Excel macro download - Download - Spreadsheets
- Online macro excel - Guide
- Excel run macro on open - Guide
- Excel macro to create new sheet based on value in cells - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 14, 2011 at 09:31 AM
Mar 14, 2011 at 09:31 AM
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.
