How do I link to other worksheets
 

I have 2 worksheets...I want to link those worksheets together. Worksheet
number 1 has some program codes in them and I would like to be able to click
on a certain cell in worksheet 2 and have it refer back to the program codes
in worksheet one. Also in worksheet 2 I have some totals for the month that I
would like to link to a certain code in worksheet 1. How do I do this?

Try Copy, then go to the destination worksheet and hit Edit--Paste special
and choose Paste link.
************
Anne Troy
www.OfficeArticles.com

"ParalegalInTraining" wrote
in message ...
I have 2 worksheets...I want to link those worksheets together. Worksheet
number 1 has some program codes in them and I would like to be able to
click
on a certain cell in worksheet 2 and have it refer back to the program
codes
in worksheet one. Also in worksheet 2 I have some totals for the month
that I
would like to link to a certain code in worksheet 1. How do I do this?