| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas That Reference ADJACENT Sheet
I am creating a form in Excel 2003 where I need the formulas in the sheet to
reference the adjacent sheet. i.e. I have 3 sheets called 'May 19', 'May 18' & 'May 17'. Formulas in 'May 19' reference cells in 'May 18', formulas in 'May 18' references cells in 'May 17' and so on. The problem occurs when I copy a sheet. If I copy sheet 'May 19' and rename it 'May 20' I want 'May 20' formulas to reference sheet 'May 19' but they instead reference sheet 'May 18' because I copied the 'May 19' sheet. Is there anyway to reference the adjacent sheet automatically without having to change the formulas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to map cells to a reference then copy adjacent ones | Excel Discussion (Misc queries) | |||
| Graph data series formulas: How to global-change all sheet reference to formula | Excel Discussion (Misc queries) | |||
| Automate adding in a reference number if the adjacent cell contains text... | Excel Worksheet Functions | |||
| Need reference in adjacent column returned | Excel Worksheet Functions | |||
| How can I autofill a series to reference non adjacent cells? | Excel Discussion (Misc queries) | |||
Threaded Mode
