VBA Data Pull based on cell value

[Kaladin]

Hey everybody. I feel like this should be super simple, but I have the flu so I can't think straight.

I can do this with a vlookup + offset, but I am going to implement a data push so users can overwrite the data they've looked up.

Basically, I want to use find or vlookup in vba to locate the value of a range, let's say Sheet1.Range("A1"), in sheet2, then offset... 3 columns to the right and 1 column down, copy that, and paste it to Sheet1.Range("C1").

Any help on how to do this would be greatly appreciated. Thanks a ton.

 

[L. Howard]

Hi Kaladin,

This may be a place to start, you may want to adjust things a bit after using.

https://www.dropbox.com/s/z16xpibqml5h2hg/Sheet 2 to Sheet 1 Copy.xlsm?dl=0

Select a value in the A1 drop down and the offset from sheet 2 is copied to C1 on sheet 1.

Regards,
Howard

 

[Kaladin]

Brilliant. You've done it.

 

[L. Howard]

Glad it works for you.

I notice a typo on sheet 1

"x to clear data in Col A"

Should be Col C.

And if you want a list of the values returned to C, use the commented out line instead.


'c.Offset(1, 3).Copy Sheets("Sheet1").Range("C" & Rows.Count).End(xlUp)(2)

Regards,
Howard