Help on sum in Macro !

[celia]

How can I write a macro that will take values from different worksheets
and sum them in a particular cell in another worksheet?

The formula is a basic sum formulu but the files are save in different
folders which makes the formula really long when they are not opened.
For example the formula would be =sum(C:\My\Qtr1\Jan\totaltime.xls This
path would be in the formula 14 different times with the folder name
(above is Jan (12 months together)) changing each time.


Thanks for any help!

 

[celia]

Does any one know how to solve my problem?

How to write the macro as I need to sum the value from 12 differrent
worksheet and the sum are from column D (more than 30) row 10 to row
50.

eg. The data are something like this, so need to sum item 1, item 2
from row 1 until row 30 for Month Jan-December which are in different
worksheet in different folder.
Item1 Item2
row1. 2 3
row2. 3 5
row . .
row . .
row . .
row 30. 20 18

Thanks,
celia