Display data from a cell, of a sheet, of a book, whose file name is spelt out in a cell.

Topher

Topher

New Member
Joined
Sep 14, 2010
Messages
29
Display data from a cell, of a sheet, of a book, whose file name is spelt out in a cell. ...

Scenario,

B2 reads ORANGEJUICE.XLS
B3 READS LYRICS.XLS
B4 READS TRAVELINGINFO.XLS
B5 READS COLLECTION OF ESSAYS.XLS


How can I write a formula, in cell C2, that will allow me to display the data of cell "AL327,SHEET2,(book listed in B2)"?????
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Sort by date Sort by votes
Topher,


For the below to work will you need to download the free MOREFUNC add-in available here:
http://xcell05.free.fr/morefunc/english/


Sample worksheets that are closed:


Excel Workbook
AL
327Topher
Sheet2




Excel Workbook
AL
327hiker95
Sheet2





Excel Workbook
AL
327345.78
Sheet2





Excel Workbook
AL
327Essay for Topher: Display data from a cell, of a sheet, of a book, whose file name is spelt out in a cell.
Sheet2





Excel Workbook
BC
2ORANGEJUICE.XLSTopher
3LYRICS.XLShiker95
4TRAVELINGINFO.XLS345.78
5COLLECTION OF ESSAYS.XLSEssay for Topher: Display data from a cell, of a sheet, of a book, whose file name is spelt out in a cell.
6
Sheet1




The Function in cell C2 copied down:

=INDIRECT.EXT("'C:\TestData\[" & B2 & "]Sheet2'!AL327")
 
Upvote 0
Topher,


Excel Workbook
ABC
2'C:\TestData\[ORANGEJUICE.XLSTopher
3]Sheet2'!LYRICS.XLShiker95
4AL327TRAVELINGINFO.XLS345.78
5COLLECTION OF ESSAYS.XLSEssay for Topher: Display data from a cell, of a sheet, of a book, whose file name is spelt out in a cell.
6
Sheet1




The formula/function in cell C2 copied down:

=INDIRECT.EXT($A$2&B2&$A$3&$A$4)





The data in cell A2 begins with two ' characters:

''C:\TestData\[
 
Upvote 0
Thanks a million!
I got all of it operating properly. life is good now, until the next issue arises of course
 
Upvote 0
You must log in or register to reply here.

Similar threads

K
  • Question Question
Averageif of cells from three sheets
Replies
7
Views
313
Fluff
Fluff
M
  • Question Question
Data Transfer from Excel to PowerPoint and getting PDF file of PPT
Replies
1
Views
99
Sequoyah
Sequoyah
D
  • Solved
VBA to paste table into Outlook
Replies
5
Views
814
Dani_LobP
D
kevinb11
  • Solved
Pull data from another sheet based on reference in cell
Replies
3
Views
339
Snakehips
Snakehips
C
  • Question Question
Use Row Data to Create New Sheet from Template and Reference Data
Replies
0
Views
642
ChrisMas92
C

Forum statistics

Threads
1,224,507
Messages
6,179,176
Members
452,893
Latest member
denay

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top