Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula in Excel
Use a linking formula. For example:
=Sheet3!G28 will get a value from Sheet3 cell G28 -- Gary''s Student - gsnu200817 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When I enter a formula, Excel shows the formula not the results | Excel Worksheet Functions | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) |