Update Cell in WKBook 1 From WkBook 2
In Workbook1 €śInflows: Sheet 1€ť €śJOBID€ť is found in Column A and
€śHoursToDate€ť in Col O
A O
JobId Hours ToDate
266 3,380
263 6,753
264 18,249
In Workbook2 €śAddLabor:Sheet:Labor€ť the €śJOBID€ť is found in Columns B -H
And €śHoursToDate" is found in the last row for each column ..
B C D E F G
H
JobID 266 276 263 273 264 282 268
Week
Ending............................................ ....................................-
Week
Ending............................................ ..............................-
HoursToDate 1780 2725 8705 24757 32 3799 2833
I a macro that will add the HoursToDate from Workbook 2
to the HoursToDate in Workbook1 based on
JobID
Would appreciate any help... Regards, Patt
|