Previous Topic Next Topic

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
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 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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.
0

Similar discussions

Code for macro that conditionally inserts rows
bfleming -
bfleming -

4 responses
Execute Macro On Calculated Cell change
Notar -
rizvisa1 -

5 responses
Automatically Run Macro from a calculated cell value change
smiller -
TrowaD -

1 response
copy a row from one worksheet to another, based on criteria
wy -
vcoolio -

15 responses
Excel make cell flash red
hugrl -
Rjc -

13 responses