Why not use vlookup commands on sheet1 as well?

--
Regards,
Tom Ogilvy

"briank" wrote in message
...
I am entering parameters in worksheet 1 (i.e. Jones) and corresponding
data
in worksheet 2 is based, through vlookup commands on these parameters. I
would like to enter code (preferably at the click of a button on worksheet
1)
to go to worksheet 2, look down Column A for the number 1 (there will only
be
one) and copy paste values that data on that row only and then return back
to
worksheet 1. This automation would certainly speed up this lengthy
process.
Any thoughts?

Worksheet 2
0 Smith 9.98 5.67 4.35
1 Jones 6.57 3.21 8.65
0 Ranz 2.98 7.57 2.22