I have daily data all on different worksheets (31 in total) and I would
like to add up all of the data in these worksheets in a monthly
compilation
I have so far been using the =sum('jan. 1'!B6, 'jan. 2'!B6 ... etc.)
which although is effective is very time consuming
is there an easier way to sum up all of the b6 cells without entering
them individually?
Thanks
--
mark_vi_
------------------------------------------------------------------------
mark_vi_'s Profile:
http://www.excelforum.com/member.php...o&userid=24507
View this thread:
http://www.excelforum.com/showthread...hreadid=381020