formula in Excel
 

I would like to know how to put in a formula into a worksheet that contains
info from another worksheet. Example: I am keeping track of vacation hours
for employees and on the last worksheet I have the total vacation hours
available in one spreadsheet for all employees. Is this something that can
be done and how?

formula in Excel
 

Use a linking formula. For example:
=Sheet3!G28
will get a value from Sheet3 cell G28
--
Gary''s Student - gsnu200817

formula in Excel
 

Click in the destination cell on your destination sheet, and type the =
sign.
Go to your source sheet and click in the source cell.
The formula in the destination cell will now look something like ='Sheet
2'!B2
If you want more in the formula, add further operators and continue, so you
could have ='Sheet 2'!B2+Sheet3!C3 and so on.
Accept the formula when you are finished.
--
David Biddulph

"Patty" wrote in message
...
I would like to know how to put in a formula into a worksheet that contains
info from another worksheet. Example: I am keeping track of vacation
hours
for employees and on the last worksheet I have the total vacation hours
available in one spreadsheet for all employees. Is this something that
can
be done and how?

formula in Excel
 

All I get is a #REF! error.

"Gary''s Student" wrote:

Use a linking formula. For example:
=Sheet3!G28
will get a value from Sheet3 cell G28
--
Gary''s Student - gsnu200817

formula in Excel
 

Make sure Sheet3 exists!
--
Gary''s Student - gsnu200817


"Patty" wrote:

All I get is a #REF! error.

"Gary''s Student" wrote:

Use a linking formula. For example:
=Sheet3!G28
will get a value from Sheet3 cell G28
--
Gary''s Student - gsnu200817

formula in Excel
 

If you get a #REF! error you presumably don't have a sheet called Sheet3.
If your sheet name includes spaces, you need to surround the sheet name with
single quotes, such as:
='First sheet'!G28
--
David Biddulph

"Patty" wrote in message
...
All I get is a #REF! error.

"Gary''s Student" wrote:

Use a linking formula. For example:
=Sheet3!G28
will get a value from Sheet3 cell G28
--
Gary''s Student - gsnu200817