Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
dynamic defined name
i have 12 defined names correspond to year monthes (represented in 12 folders)
in each folder i have workbook with the same name and structure but sure different data; i want in new workbook (same structure) to sum same cells from different monthes (different difined names) due to user choise; for example : if user entered from 5 to 9; this means that i need to sum cells from defined names for folders (May, June, July, August, September) Please dont help with code, only excel functions |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
dynamic defined name
Do you really mean folders (directories) or are you really referring to
other worksheets or tables? -- HTH Bob "hala" wrote in message ... i have 12 defined names correspond to year monthes (represented in 12 folders) in each folder i have workbook with the same name and structure but sure different data; i want in new workbook (same structure) to sum same cells from different monthes (different difined names) due to user choise; for example : if user entered from 5 to 9; this means that i need to sum cells from defined names for folders (May, June, July, August, September) Please dont help with code, only excel functions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range Defined by Value of Cell | Excel Worksheet Functions | |||
Dynamic Chart with Defined names | Charts and Charting in Excel | |||
Dynamic Chart with OFFSET defined name not working | Charts and Charting in Excel | |||
Dynamic Defined name formula | Excel Discussion (Misc queries) | |||
dynamic defined ranges | Excel Worksheet Functions |