How do I get data from a cell on another worksheet?
 

New user question. I have several worksheets in one workbook. On worksheet
is called 'vehicles'. Ho do I get a total which is in a cell in my
'vehicles' worksheet to appear in my 'summary' worksheet?
I used to enter ...
vehicles:F22
....in my last speadsheet software. How's it does in Excell?
Hank

How do I get data from a cell on another worksheet?
 

Hi!

Try this:

=vehicles!F22

Biff

"Familyman" wrote in message
news:1151284929.495626@ftpsrv1...
New user question. I have several worksheets in one workbook. On worksheet
is called 'vehicles'. Ho do I get a total which is in a cell in my
'vehicles' worksheet to appear in my 'summary' worksheet?
I used to enter ...
vehicles:F22
...in my last speadsheet software. How's it does in Excell?
Hank

How do I get data from a cell on another worksheet?
 

In your 'summary' worksheet,
the link formula would look like this in say, B2: =vehicles!F22
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Familyman" wrote:
New user question. I have several worksheets in one workbook. On worksheet
is called 'vehicles'. Ho do I get a total which is in a cell in my
'vehicles' worksheet to appear in my 'summary' worksheet?
I used to enter ...
vehicles:F22
....in my last speadsheet software. How's it does in Excell?
Hank

How do I get data from a cell on another worksheet?
 

.. in say, B2: =vehicles!F22

Alternatively, for a neat clean look (avoid extraneous zeros),
we could use instead in B2: =IF(vehicles!F22="","",vehicles!F22)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---