P
PS
Hi,
Let me preface this by saying I have limited experience with formulas (and,
frankly, Excel).
I've got two workbooks - ONE logs in time spent on a task for each day of
the year, TWO is a weekly timesheet.
I want TWO to retrieve the data from ONE where the dates match and there is
a time entry for the date & task -- filling in the task & time spent in the
appropriate column. (As the year progresses the tasks list will grow longer
and they may not be performed every day.)
ONE (task list) is like this:
US Sales Task 6/11/07 6/12/07 6/13/07
6/14/07 etc-yr end
Disk Cleanup
File Correction 0.25
0.75
Sys144 2.00
Foreign 2067-F 0.25 0.5
1728-F
3.00
Canadian 1821-X
2153-X 0.25
TWO (timesheet) is like this:
US Sales
Task 6/11/07 6/12/07 6/13/07 6/14/07 6/15/07
TotalWeeklyHours
(Task1)
(Task2)
(Task3)
TotalUSDaily
Foreign
(Task1)
(Task2)
(Task3)
TotalForeignDaily
Canadian
(Task1)
(Task2)
(Task3)
TotalCanadianDaily
Totals Daily
(TotalWeeklyHours)
I've tried a few different formulas that use INDEX, MATCH, LOOKUP, etc. but
I cannot get it work.
Can anyone provide some assistance?
Thanks, Pat
Let me preface this by saying I have limited experience with formulas (and,
frankly, Excel).
I've got two workbooks - ONE logs in time spent on a task for each day of
the year, TWO is a weekly timesheet.
I want TWO to retrieve the data from ONE where the dates match and there is
a time entry for the date & task -- filling in the task & time spent in the
appropriate column. (As the year progresses the tasks list will grow longer
and they may not be performed every day.)
ONE (task list) is like this:
US Sales Task 6/11/07 6/12/07 6/13/07
6/14/07 etc-yr end
Disk Cleanup
File Correction 0.25
0.75
Sys144 2.00
Foreign 2067-F 0.25 0.5
1728-F
3.00
Canadian 1821-X
2153-X 0.25
TWO (timesheet) is like this:
US Sales
Task 6/11/07 6/12/07 6/13/07 6/14/07 6/15/07
TotalWeeklyHours
(Task1)
(Task2)
(Task3)
TotalUSDaily
Foreign
(Task1)
(Task2)
(Task3)
TotalForeignDaily
Canadian
(Task1)
(Task2)
(Task3)
TotalCanadianDaily
Totals Daily
(TotalWeeklyHours)
I've tried a few different formulas that use INDEX, MATCH, LOOKUP, etc. but
I cannot get it work.
Can anyone provide some assistance?
Thanks, Pat