Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time Sheet
I have a monthly time sheet on which I post hours for a number of different
projects. On Sheet 1 the columns from left to right are Date, Project, Activity, From, To and Total Hours. On Sheet2 I want to automatically seperate each project (from Sheet1) with that projects corresponding invoice total. Any thoughts on how to do this would be greatly appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time Sheet
Think an index/match would do it for you
Assume source data* in sheet: x, from row2 down with key col = col B (Project) with unique project ids *Date, Project, Activity, From, To and Total Hours in cols A to F In your invoice sheet, assume project ids are also listed in B2 down Put in say, D2: =IF(ISNA(MATCH($B2,x!$B:$B,0)),"",INDEX(x!C:C,MATC H($B2,x!$B:$B,0))) Copy D2 across to G2, fill down as far as required to populate. Cols D to G will return the corresponding Activity, From, To and Total Hours in x's cols C to F which match the project ids in col B. Unmatched ids, if any, will return blanks: "". -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "David" wrote: I have a monthly time sheet on which I post hours for a number of different projects. On Sheet 1 the columns from left to right are Date, Project, Activity, From, To and Total Hours. On Sheet2 I want to automatically seperate each project (from Sheet1) with that projects corresponding invoice total. Any thoughts on how to do this would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Detailed Time Sheet (overtime, comp time, vacation used) | New Users to Excel | |||
how do I set up time sheet and items bought expense sheet | Excel Discussion (Misc queries) | |||
How do I time Hours & mins in excel - Time sheet | Excel Discussion (Misc queries) | |||
HOW DO I CALCULATE TIME IN A TIME SHEET FOR EXCEL | New Users to Excel | |||
I need a time sheet template that verifies time entered against sy | Excel Discussion (Misc queries) |