dynamic defined name

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
 
B

Bob Phillips

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

Top