| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make sure my Wkbook is accessible to users using earlier | Excel Discussion (Misc queries) | |||
| auto-hide rows, cell format (# and @), update cell refs, shade cel | Excel Discussion (Misc queries) | |||
| How to link to a single wksheet in a wkbook that has comments | Excel Discussion (Misc queries) | |||
| how do i create a dialog box to appear on opening an excel wkbook | Excel Discussion (Misc queries) | |||
| Can changes to a worksheet be applied to all wksheets in wkbook? | Excel Worksheet Functions | |||
Threaded Mode
