Putting correct values in cells

N

Nick

I have a document that has 2 worksheets. i want to pull
information from one to the other e.g. i want to pull the
first record that has "cdt" as a reference into a
specific cell on the read worksheet. If cdt is not in the
information worksheet then no record will be shown

Thanks

Nick
 
T

Tom Ogilvy

set rng = somerangeonsheet1.find("cdt")
if not rng is nothing then
rng.entirerow.copy Destination:= _
somespecificrangeinsheet2incolumnA
End if
 
Top