| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking cells from the previous sheet
Is it possible to link a cell from the "Previous Sheet" without giving it a
name. I need to link about 400 cells on a sheet and need to copy it to another 30 sheets. In Using the Name of the sheet I can not copy to the next sheet without having to change the sheet name for each link. I would like to do the following: In Sheet1 cell C105 link to sheet 2 C5. So in sheet2 C5 I would like to use something like "PrevSheet:C105" -- Thank You in Advance Ed Davis |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking cell A in sheet 1 with several cells in sheet 2 | Excel Worksheet Functions | |||
| Linking Cells to different sheet | Excel Discussion (Misc queries) | |||
| Protect Sheet: clicking in cells removes all previous text | Excel Discussion (Misc queries) | |||
| Protect Sheet: clicking in cells removes all previous text | Excel Discussion (Misc queries) | |||
| How do I make a 5th sheet to total cells from previous sheets in . | Excel Worksheet Functions | |||
![Ed Davis[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
