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? |
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? |
All times are GMT +1. The time now is 01:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com