Go To Value as Copied

J

Jasper

I tried to do this one myself numerous times without results. I wanted to go
to the cell containing the same value or text in collumn B Sheet 2, as is
pasted or filled in, in A1 Sheet 1. How can I do so using Macro?

Thanks In Advance!
 
E

Earl Kiosterud

Jasper,

If you want to know which row it was in, use MATCH
If you want to retrieve data from there, look at VLOOKUP

If you want to actually go there:

Dim SearchArg As String
SearchArg = Sheets("Sheet1").Range("A1").Value
Sheets("Sheet2").Select
Range("B1:B5").Find(SearchArg).Select
 
Top