Prev: Is IF the right way to combine these?
Next: Keep cell colour when linking
From: hala on 3 Mar 2010 05:32
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
From: Bob Phillips on 3 Mar 2010 06:27
Do you really mean folders (directories) or are you really referring to
other worksheets or tables?

--

HTH

Bob

"hala" <hala(a)discussions.microsoft.com> wrote in message
news:648123F3-21CC-4579-9054-37638A0EE9CF(a)microsoft.com...
>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


 | 
Pages: 1
Prev: Is IF the right way to combine these?
Next: Keep cell colour when linking