Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Connecting Worksheets
Hello!
I have an excel document that calculates vacation hours. Each pay period, employees accumulate (how much depends on how long they have been employed here) their: Earned hours, Used hours, and finally Total hours left. The worksheet is set up: 4/20/06 4/20/06 4/20/06 5/5/06 5/5/06 5/5/06 Earned Used Total Earned Used Total Name Name Name Employees would like another excel sheet to show them thier current Total. (It doesn't matter if all employees are on the same sheet) I am wondering how on another sheet I can ensure that it always shows the current total (not from previous pay periods). I know how to connect worksheets, but what formula do I use to show the most current data? Any suggestions would be very much appreciated :) Thanks, Carla |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Worksheets from one Workbook to Another | Excel Worksheet Functions | |||
Changing a Link Mid-way Across Worksheets | Excel Worksheet Functions | |||
Connecting multiple worksheets | Excel Discussion (Misc queries) | |||
connecting multiple worksheets | Excel Worksheet Functions | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |