dynamic defined name

  • Thread starter Thread starter hala
  • Start date Start date
H

hala

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
 
Do you really mean folders (directories) or are you really referring to
other worksheets or tables?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mapping strings to integers 5
How do I have a cell value define a dynamic named range? 15
Dynamic sheet reference in Name formula 1
MS Excel, Location: Defined Names 1
Refer to other tabs in formula 2
Excel problem - sumif with multiple parameters 2
Table_array lookup through a define list 10
Define Names 4

Back
Top