| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Defined name Relative to sheets
Hi there,
I would like to create a Defined NAME: eg. a1:a10 =sige which is relative to the sheet. So when having the formula sum(sige) on sheet1 it will give me the result of Sheet1!a1:a10 & on sheet2 it will return me the result of sheet2!a1:a10 Creating the name as: !a1:a10 (without the sheet name) is not a solution is it? Thanks for your insights, Sige |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert Rows with Formulas in Place on Multiple Sheets? | Excel Discussion (Misc queries) | |||
| Averaging using relative references across sheets | Excel Discussion (Misc queries) | |||
| In 3 active sheets in wkbk, determine& display the # of sheets that have data | Excel Discussion (Misc queries) | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| how to copy sheets keeping defined column widths | Excel Worksheet Functions | |||
Threaded Mode
