Re: Assign Values from a range to a range

"Diana" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi all
>
> I'm hoping someone can help me out here, I'm not used to using excel
> and was hoping there is a quick easy solution to my problem.
>
> I have 2 tables in an Excel worksheet, one above the other, one is a
> cumulative total, and the other is a weekly total, both the tables
> will have corresponding rows and columns in the other table.  They are
> basically an exact copy of eachother.
>
> What I want to do is add the values in the weekly cells to the values
> in the cumulative cells, such that each time I update the values in
> the weekly cells the values in the cumulcative cells are incremented,
> and I don't lose the previous weeks' increment.
>
> Does anyone have any smart ideas, I'm quite happy to use VB, I just
> don't know where to start.

The real problem is that if you do what you propose to do, i,e, updating the
cells every week, there is no account trail to prove the cumulative totals
are correct. If the data for two successive weeks are the same, the
cumulative data are not updated, and if the data of a week must be
corrected, they are added twice. So the best way to proceed is to use a
separate worksheet for every week and write a VBA macro to compute the
totals. An additional advatage is that you can write additional macros to
compute such things as best and worst week


--
Rommert J. Casimir
Room B725
Tilburg University
P.O. Box 90153
5000 LE Tilburg, The Netherlands
tel 3113 4662016 fax 3113 4663377
http://infolab.uvt.nl/people/casimir/BIKA/RC_HOME.HTM

This message was sent from home,
De Zegge 7
5591 TT Heeze The Netherlands
tel 040-2060959/2060966

Computing was more fun when nobody got rich from it