Reference Multiple Excel Workbooks at the same time
up vote
3
down vote
favorite
I am trying to compile data from multiple workbooks into a single one. So far I had the idea of referencing cells from other workbooks, something like using
='C:UsersmeDocuments[sample.xlsx]Sheet1'!A1
However typing in each individual workbook this way would be very tedious. Is there away to do something like
='C:UsersmeDocuments[B2]Sheet1'!A1
Where B2 would have the value of "sample.xlsx".
microsoft-excel-2013
edited Jun 30 at 16:49
DavidPostill♦
102k25216252
asked Jun 29 at 21:01
austinw
161
add a comment |
up vote
3
down vote
favorite
I am trying to compile data from multiple workbooks into a single one. So far I had the idea of referencing cells from other workbooks, something like using
='C:UsersmeDocuments[sample.xlsx]Sheet1'!A1
However typing in each individual workbook this way would be very tedious. Is there away to do something like
='C:UsersmeDocuments[B2]Sheet1'!A1
Where B2 would have the value of "sample.xlsx".
microsoft-excel-2013
edited Jun 30 at 16:49
DavidPostill♦
102k25216252
asked Jun 29 at 21:01
austinw
161
Try INDIRECT function.
– Lee
Jul 3 at 6:52
add a comment |
up vote
3
down vote
favorite
up vote
3
down vote
favorite
I am trying to compile data from multiple workbooks into a single one. So far I had the idea of referencing cells from other workbooks, something like using
='C:UsersmeDocuments[sample.xlsx]Sheet1'!A1
However typing in each individual workbook this way would be very tedious. Is there away to do something like
='C:UsersmeDocuments[B2]Sheet1'!A1
Where B2 would have the value of "sample.xlsx".
microsoft-excel-2013
edited Jun 30 at 16:49
DavidPostill♦
102k25216252
asked Jun 29 at 21:01
austinw
161
I am trying to compile data from multiple workbooks into a single one. So far I had the idea of referencing cells from other workbooks, something like using
='C:UsersmeDocuments[sample.xlsx]Sheet1'!A1
However typing in each individual workbook this way would be very tedious. Is there away to do something like
='C:UsersmeDocuments[B2]Sheet1'!A1
Where B2 would have the value of "sample.xlsx".
microsoft-excel-2013
microsoft-excel-2013
edited Jun 30 at 16:49
DavidPostill♦
102k25216252
asked Jun 29 at 21:01
austinw
161
edited Jun 30 at 16:49
DavidPostill♦
102k25216252
asked Jun 29 at 21:01
austinw
161
edited Jun 30 at 16:49
DavidPostill♦
102k25216252
edited Jun 30 at 16:49
DavidPostill♦
102k25216252
edited Jun 30 at 16:49
DavidPostill♦
102k25216252
102k25216252
asked Jun 29 at 21:01
austinw
161
asked Jun 29 at 21:01
austinw
161
asked Jun 29 at 21:01
austinw
161
161
Try INDIRECT function.
– Lee
Jul 3 at 6:52
add a comment |
Try INDIRECT function.
– Lee
Jul 3 at 6:52
Try INDIRECT function.
– Lee
Jul 3 at 6:52
Try INDIRECT function.
– Lee
Jul 3 at 6:52
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
You could try the following. "REF" is the cell reference containing the target filename.
This file needs to be open for this to work, or it will give you a #REF error.
INDIRECT( "'C:UsersmeDocuments[" & REF & "]Sheet1'!A1" )
edited Nov 16 at 14:30
Twisty Impersonator
17.1k126293
answered Nov 16 at 14:02
JPKowal
217
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
You could try the following. "REF" is the cell reference containing the target filename.
This file needs to be open for this to work, or it will give you a #REF error.
INDIRECT( "'C:UsersmeDocuments[" & REF & "]Sheet1'!A1" )
edited Nov 16 at 14:30
Twisty Impersonator
17.1k126293
answered Nov 16 at 14:02
JPKowal
217
add a comment |
up vote
0
down vote
You could try the following. "REF" is the cell reference containing the target filename.
This file needs to be open for this to work, or it will give you a #REF error.
INDIRECT( "'C:UsersmeDocuments[" & REF & "]Sheet1'!A1" )
edited Nov 16 at 14:30
Twisty Impersonator
17.1k126293
answered Nov 16 at 14:02
JPKowal
217
add a comment |
up vote
0
down vote
up vote
0
down vote
You could try the following. "REF" is the cell reference containing the target filename.
This file needs to be open for this to work, or it will give you a #REF error.
INDIRECT( "'C:UsersmeDocuments[" & REF & "]Sheet1'!A1" )
edited Nov 16 at 14:30
Twisty Impersonator
17.1k126293
answered Nov 16 at 14:02
JPKowal
217
You could try the following. "REF" is the cell reference containing the target filename.
This file needs to be open for this to work, or it will give you a #REF error.
INDIRECT( "'C:UsersmeDocuments[" & REF & "]Sheet1'!A1" )
edited Nov 16 at 14:30
Twisty Impersonator
17.1k126293
answered Nov 16 at 14:02
JPKowal
217
edited Nov 16 at 14:30
Twisty Impersonator
17.1k126293
edited Nov 16 at 14:30
Twisty Impersonator
17.1k126293
edited Nov 16 at 14:30
Twisty Impersonator
17.1k126293
17.1k126293
answered Nov 16 at 14:02
JPKowal
217
answered Nov 16 at 14:02
JPKowal
217
answered Nov 16 at 14:02
JPKowal
217
217
add a comment |
add a comment |
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1335386%2freference-multiple-excel-workbooks-at-the-same-time%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Try INDIRECT function.
– Lee
Jul 3 at 6:52