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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
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 |