#1
|
|||
|
|||
How to Link Cells in workbooks with multiple sheets
I have 2 workbooks.
Each workbook contains 46 sheets and I call them week numbers 1 to 46 on both workbooks. Each workbook is unique however the 46 sheets are identical in each of their respective workbooks. So the first workbook I am trying to put a link formula into cell A3 say for week 1 . The information I am putting into that cell would be the data from G3 in week 1 of the other workbook. Once I put the formula into the first workbook in cell A3 I then will drag the formula from A3 to B17 which will then get the data from the 2nd workbook from cell G3 to H17. I can do that part quite easy as I just link the two cells straight away no problem. I then want to do the same with all of the other sheets in the work books for week 2 to week 46. I can do that easy enough but it is very time consuming. I then have an additional 25 workbooks in the same format as workbook 1 that I want to repeat the function as I have done with workbook 1. All the other workbooks would be linked to workbook 2. As I say I can do it ok but it is very time consuming and was hopeful I could take the workbook1 and select all sheets so that then I only have to do the link and drag once with the other workbooks 2 to 46 all having their own week number on it .E.G cell A3 ='[workbook1.xlsx]week 1'!G3 and then repeated for each sheet so the next sheet would say ='[workbook1.xlsx]week 2'!G3 and so on. https://youtu.be/qeacYk8XF4w Is there a quick workaround with this at all? |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
30 Day Running or Rolling total (Multiple Sheets/Workbooks) | HelicopterChick | Excel | 3 | 08-23-2016 04:52 AM |
Range COPY paste in workbooks sheets as variable | Fean | Excel Programming | 3 | 06-07-2016 06:51 AM |
Link multiple cells in drop-down lists | Trial4life | Excel | 0 | 09-08-2014 05:08 AM |
Link multiple excel workbooks to publisher | bandcsaravia | Publisher | 0 | 10-24-2011 09:14 AM |
Combining 2 workbooks into 1 workbook with TWO sheets | dguenther | Excel | 1 | 10-06-2011 03:25 AM |