Timesheet consolidation

Microsoft Excel 2007
October 15, 2009 at 18:48:41
Specs: Windows XP
I have 10 excel workbooks in a folder each work book has one worksheet which has hours worked for each day for 1week
Eg:
Mon Tues Wed Thur Frid
10/5 10/6 10/7 10/8 10/9

PO# 123 6 4 7 8 2
PO#234 2 4 1 0 6

There may be multiple PO# and Hours worked per each day This is sample input file

My Output file should be as shown below

WK1 WK2 Wk3 Wk4 Wk5
PO# 123 0 27 0 0 0

PO#234 0 13 0 0 0

as here i shown only for 1 week i will have many sheets each for one week so my VBA Macro should ask start date and end date based on this it should select hours worked and sum it and place it underparticular week as shown in output excel sheet






See More: Timesheet consolidation

Report •


#1
October 15, 2009 at 21:30:50
Please post this to the correct (Office Software) forum...

Report •


Ask Question