Dear Expert
Need your help, how to calling data from several sheets, only typing sheet name.
I attach the calling data sheet.xlsx sample
Dear Expert
Need your help, how to calling data from several sheets, only typing sheet name.
I attach the calling data sheet.xlsx sample
Last edited by azbi; 10-30-2015 at 04:37 AM.
use can use an indirect formula
Formula:Please Login or Register to view this content.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
the result done, but how to make the cell A1 become that?
you mean the Orange cell?
i used data validation
here's an intro on what it is
http://www.contextures.com/xlDataVal01.html
yes...how to make pick tool at the corner?
goto the link i provided
it will give you the run down on how to do it
the method used is "Use a Delimited List"
basically typed in Sheet1,Sheet2,Sheet3
is there any way? only by typing the name of the sheet?
I mean how about like this formula
=Sheet1!A1
how could we change "sheet" by cell?
you dont have to use the data validation
you can manually type it every time if you wish
i put it in to make it easier to change "sheet"s
If you have sheet name in A1 and Cell Address in B1 then try below formula
=INDIRECT("'"&A1&"'!"&B1)see attached filePlease Login or Register to view this content.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
dear expert
its work
thanks alot
Dear Expert
I'm still difficult applying in my case for formula above
Here's I send the sample of what I meant calling data sheet 1.xlsx
I just need change the name of the sheet in yellow cell, then the result in the bottom change correctly as per sheet that we need
see attached file
Dear Expert
Noted, its mean for Starting Column and Starting Row should be exist, right?
how about if we shouldn't put Starting Column and Starting Row, is the formula not running?
Then it will give error
okay....noted, I'll try for these formula
once again, how about if there're two column?its mean we should add Starting Column and Starting Row for another?
okay,....now its really really work
big thank expert
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks