| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing a Link Mid-way Across Worksheets | Excel Worksheet Functions | |||
| how do i link a list of items in a workbook to worksheets in the . | Excel Discussion (Misc queries) | |||
| how do i link a number of worksheets to one master worksheet? | Excel Worksheet Functions | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
| What formula do I use to link worksheets together within one spre. | Excel Worksheet Functions | |||
Linear Mode
