Hi im trying to copy a line of data from 12 different worksheets each with
difference cell refs to one seperate worksheet so that I can add all the data
to get the difference between them... but I just cant seem to do it, Please
can anyone help... fanx Laura

I guess there may be some formula already so you should copy the data from
various sheets and then paste special 'values' and then do your calculations.

Regards

"Lauralou" wrote:

Hi im trying to copy a line of data from 12 different worksheets each with
difference cell refs to one seperate worksheet so that I can add all the data
to get the difference between them... but I just cant seem to do it, Please
can anyone help... fanx Laura

A "line" is an entire row or what?

The different cell refs from 12 sheets should make this task difficult
unless there is some type of pattern to it.

More details may provide some workable replies.


Gord Dibben MS Excel MVP


On Mon, 15 Sep 2008 06:26:11 -0700, Lauralou
wrote:

Hi im trying to copy a line of data from 12 different worksheets each with
difference cell refs to one seperate worksheet so that I can add all the data
to get the difference between them... but I just cant seem to do it, Please
can anyone help... fanx Laura