Update Cell in WKBook 1 From WkBook 2

  • Thread starter Thread starter pattlee
  • Start date Start date
P

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
 
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)
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update values in WkBk1 from WkBk2 1
find first empty cell in range and copy information from another workbook 19
find first empty cell in range and then copy from another workbook 1
Rank a Column + 1 cell from 2nd Col 5
Searching in another workbook for a string and returning with the contents of the cell next to it. 1
Add from multiple criteria in a range 5
Copy Data from Sheet 1 to Empty Cell in Sheet 2 2
Cell Reference from 2 lookups 10

Back
Top