LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
NetMax
 
Posts: n/a
Default selecting different cell ranges across sheets, to display on summary page

Each workbook sheet has payroll records per individual for the entire
year (regular hours, overtime, holiday etc).

I want a summary sheet to display the relevant data (ie: sums of regular
hours, sick days etc) of the payperiod entered (1 of 26) for each
employee.

So the clerk (me) enters a payroll period, and sees that data for each
employee.

Seems simply enough, and there is probably more than one way to do it,
but the help files have only frustrated me so far.


TIA
--
NetMax


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Number of worksheet tabs as cell value? ie 4 work sheets = 4 cell value [email protected] Excel Discussion (Misc queries) 2 November 22nd 05 05:17 PM
Why does Custom Format not control Cell Display? Dennis Excel Discussion (Misc queries) 1 June 11th 05 12:28 AM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
Linking sheets to a summary sheet in workbook gambinijr Excel Discussion (Misc queries) 4 December 16th 04 08:13 PM
linking multiple sheets to a summary sheet greg g Excel Discussion (Misc queries) 1 December 16th 04 07:43 AM


All times are GMT +1. The time now is 03:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"