| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I reference the same cell in all previous sheets?
I want to refence a cell in all previous sheets in a workbook. The problem is
that I'd like to paste the formula to other sheets and still have it refernce all previous sheets to that sheet. For example, on sheet 5 the formula would refence cell A1 in sheets 1, 2, 3, and 4. When I copy and paste the formula to a cell in sheet 9, I want it to automatically expand the sheet range to now reference A1 in sheets 1, 2, 3, 4, 5, 6, 7, and 8. Is this possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I reference a cell on a previous worksheet | Excel Discussion (Misc queries) | |||
| formula to reference cell on previous worksheet | Excel Worksheet Functions | |||
| reference to previous cell (always) | Excel Discussion (Misc queries) | |||
| need formula to reference a cell in previous worksheet | Excel Worksheet Functions | |||
| Relative reference to a cell on a previous sheet | Excel Discussion (Misc queries) | |||
![Joe Lewis[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
