Sum Across multiple worksheet in VBA

  • Thread starter Thread starter celia
  • Start date Start date
C

celia

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

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

eg. The data are something like this, so need to sum item 1, item
from row 1, row 2, until row 30 for Month Jan-December which are i
different worksheet in different folder.

Item1 Item2 ...... Item 10
row1. 2 3
row2. 3 5
row . .
row . .
row . .
row 30. 20 18

Total

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

Thanks and appreaciated for any help !

Thanks,
celi
 
celia > said:
Hi,
How can I write a macro that will take values from different worksheets
and sum them in a particular cell in another worksheet?
Click to expand...

This is non answer since I am clueless! (Just wanted to say that as a
disclaimer!) :)

Anyway, look at my thread a couple of posts back, we have similar
problems... I think. My question is to you, what made you think we need to
use a macro as opposed to just some sort of formula? Just curious.
 
Back
Top