Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reference Previous Worksheet Built-in Function
I would like to make a reference to previous worksheets so when
additional worksheets are inserted the reference is automatically moved. I know this can be accomplished with a macro (VBA). Is there a built-in function or notation in either 2003 or 2007 to accomplish this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reference Previous Worksheet Built-in Function
You can see a related discussion in:
http://tinyurl.com/2z6chj HTH Kostis Vezerides On Jul 6, 5:52 pm, wrote: I would like to make a reference to previous worksheets so when additional worksheets are inserted the reference is automatically moved. I know this can be accomplished with a macro (VBA). Is there a built-in function or notation in either 2003 or 2007 to accomplish this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need formula to reference a cell in previous worksheet | Excel Worksheet Functions | |||
I made a chart on worksheet because not built in | Charts and Charting in Excel | |||
How to reference to the previous worksheet regardless of title? | Excel Worksheet Functions | |||
Reference the worksheet from a multiple worksheet range function ( | Excel Worksheet Functions | |||
Can the offset worksheet function reference another worksheet | Excel Worksheet Functions |