Insert Data when hyperlink is clicked

C

Chuck N

I have a set of reciept numbers on one worksheet and i want you to be
able to click on the reciept number and it will put that reciept number
in cell J1 on the other worksheet. Is there a way to do this?
 
J

Juan Pablo González

You could do it using the FollowHyperlink event of the worksheet which is
available, if I remember correctly, in Excel XP and above.
 
C

Chuck N

John Peltier definetly helped me out with this! Here is the code i
anyone is interested


Code
 
Top