formula in Excel

P

Patty

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

Gary''s Student

Use a linking formula. For example:
=Sheet3!G28
will get a value from Sheet3 cell G28
 
D

David Biddulph

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vacation Accrual formula 1
Time Keeping Spreadsheet (Need not to Exceed Formula & subtracting 1
Payroll verification hrs and time off 6
Is there a way to use labels and 3-D references in a formala? 2
Help with IF function 3
Excel Byte Calculation 2
Creating a formula in Excel 1
"formula for tracking days off " 1

Top