| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking data using 1-10 pages
is this what you are looking for ??
In sheet 1 Col A Names, Col B hours sheet 2 Col A names , in B2 put this formula =SUMIF(Sheet1!A2:B15,Sheet2! A2,Sheet1!B2:B15) the format the col B as [hh]:mm On Oct 20, 11:12*pm, edmar42 <Granma @discussions.microsoft.com wrote: A payroll that has several employees going to numerous places throughout a months time period and bills either in whole hrs or 1/2 increments. Master sheet has name of places with *employee name with billable hrs. *2nd sheet would have employee name. Is there a way for the 2nd sheet to pick up all hours for that employee? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| linking pages of a workbook | Excel Discussion (Misc queries) | |||
| linking worksheet pages | Links and Linking in Excel | |||
| linking excel pages | Excel Discussion (Misc queries) | |||
| Linking a column on One worksheet to Multiple Pages in Another Doc | Excel Discussion (Misc queries) | |||
| Linking multiple pages | Excel Discussion (Misc queries) | |||
Threaded Mode
