Update Cell in WKBook 1 From WkBook 2

[pattlee]

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

 

[Prashant Runwal]

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]

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