Hi all, I have 3 different work books...All 3 are formatted exactly the same. I have one in a network drive at one location, #2 is on a different network drive at a different location and #3 is on the same network/drive as #2. Each workbook is broken down into 28 sheets (1 for each shift days and 1 for graves...for each day of the pay period (14 days). What I need to do is take information from book 1 and dynamically link the same range of cells on each sheet ($A$17:$R$26) Into those same cells in book 3 which will have tabs the same name as both the other books but "combined" added. Then I need to dynamically link 2 different ranges ($B$5:$R$16 and $B$27:$R$43) From book #2 also into book 3. Essentially book 3 becomes a combination of book 1 and book 2. Book 1 is at: sharecvd$\\rsocvd\G:\Coachella Dispatch\lineups and schedules\2015 lineups and schedules\lineups\lineups 2015\and then each payperiod name.
Book 2 is at: sharedisp$\\rsodisp\J:+schedules\+2015 schedules\riverside lineups 2015\and then each pay period name
and Book 3 is at : sharedisp$\\rsodisp\J:+schedules\+2015 schedules\riverside desert combined lineups 2015\ and then each pay period name
There are 26 pay periods all together with 28 sheets in each which is why I'm looking for a quick easy way to have the 2 workbooks link/combine into the 3rd.
I'm also not sure if this is going to be an issue, but our IT personnel did something weird on the naming convention of our drives. When I am working in desert, my "home" drive is "G" and the Riverside drive is "J"...if I go to work in Riverside, THEIR home drive is "G" and desert is "J".
I really hate that they did that lol and not sure how this will work for linking purposes.
It needs to be dynamic that if I add something into my lineup in desert it will automatically enter it the file in Riverside, which may or may not be open. Our systems run Office 2010.
Book 2 is at: sharedisp$\\rsodisp\J:+schedules\+2015 schedules\riverside lineups 2015\and then each pay period name
and Book 3 is at : sharedisp$\\rsodisp\J:+schedules\+2015 schedules\riverside desert combined lineups 2015\ and then each pay period name
There are 26 pay periods all together with 28 sheets in each which is why I'm looking for a quick easy way to have the 2 workbooks link/combine into the 3rd.
I'm also not sure if this is going to be an issue, but our IT personnel did something weird on the naming convention of our drives. When I am working in desert, my "home" drive is "G" and the Riverside drive is "J"...if I go to work in Riverside, THEIR home drive is "G" and desert is "J".
I really hate that they did that lol and not sure how this will work for linking purposes.
It needs to be dynamic that if I add something into my lineup in desert it will automatically enter it the file in Riverside, which may or may not be open. Our systems run Office 2010.
