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

[Familyman]

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

[Max]

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
>
>
>

[Biff]

Hi!

Try this:

=vehicles!F22

Biff

"Familyman" <[email protected]> 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
>

[Max]

> .. 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
---