| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How to reference to the previous worksheet regardless of title?
Hello. I am trying to create a weekly history by creating a new worksheet
each week. I name the new worksheet by using the current range of dates covered. I then copy all cells from the previous worksheet into the new one. The I update a couple numbers and I should be done. However my formula -- =I10+'27JUN-02JUL'!I14 <-- stays the same in those cells that refer to the previous sheet. instead of using the name of the previous sheet, can I refer to the previous sheet another way? Thank fo helping. Jay - USN |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
| How can you reference a picture from a worksheet cell? | Excel Discussion (Misc queries) | |||
| Cell Reference Math | Excel Worksheet Functions | |||
| Worksheet reference (i.e placing worksheet name in a cell) | Excel Worksheet Functions | |||
| Worksheet name and Backward compatibility | Excel Discussion (Misc queries) | |||
Hybrid Mode
