M
Matty
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
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