MrExcel
.
- Joined
- Feb 8, 2002
- Messages
- 3,417
- Office Version
- 365
- Platform
- Windows
Has anyone ever actually tried to consolidate ranges from multiple workbooks using that Browse button in the Consolidate dialog?
I have four workbooks, Q1 through Q4.
Each workbook has a single sheet named Data.
I want to consolidate B5:E13 in each workbook.
When the four worksheets are in one workbook, Consolidate works fine.
Today, I tried using the Browse... button. After choosing Q1, it returns a re reference of
'C:\Data\Q1.xlsm'!
(The exclamation point is sitting there outside of the parentheses. I didn't type it as an editorial comment).
What do they expect you to type in that reference? Excel Help is no help, saying to click the Browse button, but then explaining nothing after that.
Solution 1: Create a named range in each workbook, then type the named range after the reference:
'C:\Data\Q1.xlsm'!MyData
Solution 2: Edit the text returned by the Browse button into:
'C:\Data\[Q1.xlsm]Data'!B5:E13
It just seems bizarre that this is so poorly documented. As anyone else ever used this? Is there a better way?
Bill
I have four workbooks, Q1 through Q4.
Each workbook has a single sheet named Data.
I want to consolidate B5:E13 in each workbook.
When the four worksheets are in one workbook, Consolidate works fine.
Today, I tried using the Browse... button. After choosing Q1, it returns a re reference of
'C:\Data\Q1.xlsm'!
(The exclamation point is sitting there outside of the parentheses. I didn't type it as an editorial comment).
What do they expect you to type in that reference? Excel Help is no help, saying to click the Browse button, but then explaining nothing after that.
Solution 1: Create a named range in each workbook, then type the named range after the reference:
'C:\Data\Q1.xlsm'!MyData
Solution 2: Edit the text returned by the Browse button into:
'C:\Data\[Q1.xlsm]Data'!B5:E13
It just seems bizarre that this is so poorly documented. As anyone else ever used this? Is there a better way?
Bill
