| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to create a 'name' which is not worksheet spcific
Hello,
I need to refer to a range of cells in a function. Same function is used in different worksheets of same workbook. The name when used in a specific page should refer to the cells from that page. ie., I have defined a name as myname =a1:d5 when used in sheet sheet1, myname should give = 'sheet1'!a1:d5 when used in sheet sheet2, myname should give = 'sheet2'!a1:d5 like that... Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I create a worksheet menu to select each other worksheet | Excel Discussion (Misc queries) | |||
| create a list base on another worksheet | Excel Discussion (Misc queries) | |||
| How do I create an Excel worksheet with a limited no. of rows? | Excel Discussion (Misc queries) | |||
| quickly create extra copies of a worksheet template in a workbook | Excel Worksheet Functions | |||
| Create a "recap" worksheet that includes all info from all worksh. | Excel Worksheet Functions | |||
Threaded Mode
