Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you reference another worksheet without using its name
The standard way to reference a cell on another worksheet within the same
file is =Sheet2!A1. How can I create a reference that basically says A1 in the next worksheet irregardless of its name (i.e., current worksheet + 1). -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200904/1 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you reference another worksheet without using its name
"dallen917 via OfficeKB.com" <u51503@uwe wrote...
The standard way to reference a cell on another worksheet within the same file is =Sheet2!A1. *How can I create a reference that basically says A1 in the next worksheet irregardless of its name *(i.e., current worksheet + 1). No way to do this without either using names defined using XLM functions or using user-defined functions written in VBA. Both trigger warnings when the workbook opens when macro security is set to Medium and would be disabled when macro security is set to High or Very High unless you provide certificates for the VBA project. Actually, if your worksheet names NEVER change and you use workBOOK protection to prevent users reordering worksheets, you could put an ordered list of worksheet names into a range named WSLST, define a name like WS referring to the formula =MID(CELL("Filename",INDIRECT("RC",0)), FIND("]",CELL("Filename",INDIRECT("RC",0)))+1,32) then you could use a formula like =INDIRECT("'"&INDEX(WSLST,MATCH(WS,WSLST,0)+1)&"'! "& CELL("Address",INDIRECT("RC",0))) to refer to the cell at the same address in the next worksheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summary worksheet reference to detail worksheet | New Users to Excel | |||
I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
Reference the worksheet from a multiple worksheet range function ( | Excel Worksheet Functions | |||
Can the offset worksheet function reference another worksheet | Excel Worksheet Functions | |||
Worksheet reference (i.e placing worksheet name in a cell) | Excel Worksheet Functions |