Macro help: vlookup

Hi there,

Hope you can help. I want to create a macro that will be activated via a button on a sheet ("Display tool"), but will be executed on another sheet ("Data").

I want to copy data present on B3 to CJ3 and have it overwrite the appropriate row in a pre-populated table that exists between B7:CJ1500. The row will be determined based on a lookup of the text in B3 in B7:B1500.

Some things to note:
1. The macro should run in the background once the button is clicked - i.e. sheet should not change from "Display tool" (where the macro button exists) to "Data" (where the macro will be executed).
2. Data should be pasted as values

I have no knowledge of macros to speak of, but this is what I was able to put together using the record macro function and the some google searches. Appreciate any input you can provide!!

Please Login or Register  to view this content.

Hi Amotto11,

Thanks for your help. I actually got a "400" error when I tried to run the code.

The lookup was intended to find the appropriate row (in the table that spans B7:CJ1500) in which the data that exists in B3:CJ3 should be pasted. I apologize if the nomenclature wasn't clear.

A colleague actually helped me out with my problem. For anyone who is interested, please see below:

Please Login or Register  to view this content.