| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell referencing between differnt worksheets
There are 2 worksheets. Say I want cell A2 in sheet2 ALWAYS to equal cell A2
in sheet1. The data in sheet1 is cut and pasted quite a lot due to the way we work and when this happens the link is corrupted. I think I could use INDIRECT but there are quite a lot of links and if I used this method what is the best way to set it up - does every cell have to be set up individually? A lot of work!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Naming Cell on differnt worksheet | Excel Worksheet Functions | |||
| Referencing worksheets | Excel Discussion (Misc queries) | |||
| referencing same cell in several worksheets | Excel Discussion (Misc queries) | |||
| in excel how do you quote a differnt cell | Excel Discussion (Misc queries) | |||
| Referencing worksheets | Excel Worksheet Functions | |||
Threaded Mode
