View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] meh2030@gmail.com is offline
external usenet poster
 
Posts: 135
Default find/replace macro

On Jul 11, 9:03 am, wrote:
I need a macro that would take a value from worksheet A, switch to
worksheet B, find the value, go back to worksheet A, move over two
columns, take the value in that column, switch back to worksheet B and
paste. repeat until at the end of the column in worksheet A. Is this
possible in VB?

I haven't coded in a while, and have never used VB, so I'm not really
sure where to start.


Try using a VLOOKUP first. The function will look something like the
following:

=VLOOKUP(B2,[WorksheetA]Sheet1!$A$2:$C$8,3,FALSE)

Matt