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

Update Cell in WKBook 1 From WkBook 2
 

Instead of doing this from a macro can you do it through simple formulas like
vlookup? (I wont suggest sumif since if other workbook is closed your result
will not be displayed)
"pattlee" wrote:

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

Update Cell in WKBook 1 From WkBook 2
 

Thank you for responding.. and your suggestion.. but Since this process for
adding hours from workbook2 to existing hours in Workbook1 will be weekly
event really prefer a macro... (tried sumif) no go..... Please advise...
Thanks in Advance Patt
"Prashant Runwal" wrote:

Instead of doing this from a macro can you do it through simple formulas like
vlookup? (I wont suggest sumif since if other workbook is closed your result
will not be displayed)
"pattlee" wrote:

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