Home |
Search |
Today's Posts |
#1
|
|||
|
|||
collabarating spreadsheets
Hi i don't know if this can be done but i work in payroll and a lot of my
timesheets are on excell. Recently i have been told to keep a running total of all employyes hours. Is there a way to make a new spreadsheet that will gather the info off the others and update every week |
#3
|
|||
|
|||
Thanks kassie, well i have about 6 sheets(different factorys, same company)
and what i would like is in the summary sheet is to have employee number(column a) and name(column b) and then a formula of some sort that will see that will find employee number on each sheet and then take their total hours from say column h. My problem seems to be that although the same employees are on different sheets they are not in the same order and also each employee takes 3 rows but total hours is only on one cell "Kassie" wrote: Hi Yes there is, but you will have to give some detail! -- ve_2nd_at. Randburg, Gauteng, South Africa "blummincars" wrote: Hi i don't know if this can be done but i work in payroll and a lot of my timesheets are on excell. Recently i have been told to keep a running total of all employyes hours. Is there a way to make a new spreadsheet that will gather the info off the others and update every week |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Charts Linked to Spreadsheets | Charts and Charting in Excel | |||
How to create a default footer for all my spreadsheets? | Excel Discussion (Misc queries) | |||
Problem with link cells between 2 spreadsheets | Excel Discussion (Misc queries) | |||
Linking between spreadsheets does not work unless I have both spr. | Excel Discussion (Misc queries) | |||
Compare two spreadsheets to find differences. | Excel Discussion (Misc queries) |