Hi All

In a workbook I have a worksheet 1 that looks something like this

A B C
Code Name Position
1 Smith MD
2 Jones Sales
3 Brown R & D
4 Bloggs Driver
etc etc etc

Worksheet 2 is an individual form as below that where I type in the code,
the rest is automatically populated with name and position. There are more
details underneath but the heading of the form is automatically filled!

A B C D
Code Name Position Signature

What I would like to do is be able to click the code number on worksheet 1,
and be taken to worksheet 2 with all the fields populated.

Now I understand how to make a macro for each row on ws1 from a button, that
will copy the code from the A column on ws1, and paste into the code field
on ws2. How can I, if It is possible, be able to click on the code number in
ws1, and do the same task?

Many thanks in advance

Matty

posted in misc


--
Don Guillett
SalesAid Software
Granite Shoals, TX

"Matty" wrote in message
...
Hi All

In a workbook I have a worksheet 1 that looks something like this

A B C
Code Name Position
1 Smith MD
2 Jones Sales
3 Brown R & D
4 Bloggs Driver
etc etc etc

Worksheet 2 is an individual form as below that where I type in the code,
the rest is automatically populated with name and position. There are more
details underneath but the heading of the form is automatically filled!

A B C D
Code Name Position Signature

What I would like to do is be able to click the code number on worksheet
1,
and be taken to worksheet 2 with all the fields populated.

Now I understand how to make a macro for each row on ws1 from a button,
that
will copy the code from the A column on ws1, and paste into the code field
on ws2. How can I, if It is possible, be able to click on the code number
in
ws1, and do the same task?

Many thanks in advance

Matty