alderman
New member
- Joined
- Jan 23, 2014
- Messages
- 19
- Reaction score
- 0
- Points
- 0
I am creating a summary worksheet that needs to access several workbooks and I am wondering if there is a quick way to do this without having to create a formula going into each one. I have several workbooks, lets say one for each province and in each workbook I have several worksheets, which are identical from workbook to workbook. I want to make a master workbook that will summ across the workbooks.
Something similiar to adding the same cell across several worksheets (i.e =SUM(BC:QUE!B15)) which adds the cell B15 across all the worksheets, but for difefrent workbooks.
Any suggestions?
Something similiar to adding the same cell across several worksheets (i.e =SUM(BC:QUE!B15)) which adds the cell B15 across all the worksheets, but for difefrent workbooks.
Any suggestions?