| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Linking from several cells of 1 spreadsheet to fewer of another?
I am trying to link some payroll info. Specifically, I have Sheet 1 with the
employees' totaled regular hours and totaled OT hours, for 2-week time periods. I want to link the totals of those totals into specific cells in another spreadsheet (Sheet 2). Help? |
|
#2
|
|||
|
|||
|
In whatever specific cell you want on Sheet2, enter:
=SUM( then use the mouse to select the appropriate range of cells on Sheet1, close the parenthesis, and hit Enter.. -- Vasant "wildsngrny" wrote in message ... I am trying to link some payroll info. Specifically, I have Sheet 1 with the employees' totaled regular hours and totaled OT hours, for 2-week time periods. I want to link the totals of those totals into specific cells in another spreadsheet (Sheet 2). Help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Hyperlinks into different cells | Excel Discussion (Misc queries) | |||
| Heavily linked spreadsheet freezes with "calculating cells 0%" - . | Excel Worksheet Functions | |||
| Scan and copy cells from one spreadsheet to another. | Excel Discussion (Misc queries) | |||
| To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
| linking cells colors | Excel Worksheet Functions | |||
Linear Mode
