How do I link to other worksheets

[ParalegalInTraining]

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?

 

[Anne Troy]

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