Lori Worthington
New Member
- Joined
- Jun 24, 2008
- Messages
- 5
I would like to copy rows from a sheet called "June" in the Assessment_RMHC Physician Coverage.xls workbook into the sheet called "June" in the MASTER_RMHC Physician Coverage System.xls
So say I need to copy the range E8:AI8 and row 10, E10:AI10 from the workbook Assessment_RMHC Physician Coverage.xls (sheet "June") into the range E8:AI8 and row 10, E10:AI10 (range could be on another row but for simplicity sake) into the sheet called "June" in the MASTER_RMHC Physician Coverage System.xls how can I do this with a macro?
The Assessment_RMHC Physician Coverage.xls will be open and be the updated live document, which I need to populate the closed MASTER_RMHC Physician Coverage System.xls that will only be used for an "at a glance" occassionally.
Please advise - thanks so much!
So say I need to copy the range E8:AI8 and row 10, E10:AI10 from the workbook Assessment_RMHC Physician Coverage.xls (sheet "June") into the range E8:AI8 and row 10, E10:AI10 (range could be on another row but for simplicity sake) into the sheet called "June" in the MASTER_RMHC Physician Coverage System.xls how can I do this with a macro?
The Assessment_RMHC Physician Coverage.xls will be open and be the updated live document, which I need to populate the closed MASTER_RMHC Physician Coverage System.xls that will only be used for an "at a glance" occassionally.
Please advise - thanks so much!