Multiple worksheets

  • Thread starter Thread starter I'm lost
  • Start date Start date
I

I'm lost

I am trying to combine data between many worksheets in 1
book. I want to select specific cells in each sheet and
have them calculate on another sheet. I have done this a
long time ago and for the life of me I cant remember how.
 
Can't you just select the cell you want the calculations in and then
type in = then track to the cell you want to calculate and then the
next etc etc?
i.e. just adding the +/-= or * between them and ending up with
something like this: =Sheet1!A1+Sheet2!A1*Sheet3!A1
 
Dear I'm lost...

if your calculation is simple, such as adding the cell
from one worksheet to another: book one cell a1 = 5, book
two cell a1 = 6.

do the following:

assuming you are book one
- click on the cell you want the result to be in
- then type "="
- click on a1
- then type "+"
- then click on window
- then click on book two
- then click on a1


does this help?
 
-----Original Message-----
Can't you just select the cell you want the calculations in and then
type in = then track to the cell you want to calculate and then the
next etc etc?
i.e. just adding the +/-= or * between them and ending up with
something like this: =Sheet1!A1+Sheet2!A1*Sheet3!A1
Click to expand...
OK, got that...Now what if you need to do a range of
cells and a range of sheets. Without getting a very long
complicated argument in each cell, how would do that in a
more simplified way? Thanx
 
OK, got that...Now what if you need to do a range of
cells and a range of sheets. Without getting a very long
complicated argument in each cell, how would do that in a
more simplified way? Thanx
 
Back
Top