Hi everyone in the forum, I’m Vannarath. I have some problems need for help. I had a lot of sheets in one excel file which defined one sheet(Main Sheet) to find data from other sheets just click dropdown list as attachment file. Thank for your help.Test to find data.xlsx
cell A10 =indirect("'"&a1&"'!d5")
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Try this....
In B5
In C5
Please Login or Register to view this content.
In A10Please Login or Register to view this content.
In B10Please Login or Register to view this content.
In C10Please Login or Register to view this content.
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Since I notice you want your codes parsed as well I used a bit of a different approach. The file is attached.
In B5In C5 and filled acrossFormula:
Please Login or Register to view this content.In A10 and filled acrossFormula:Please Login or Register to view this content.Formula:Please Login or Register to view this content.
Last edited by FlameRetired; 03-03-2015 at 05:24 AM.
I want Code column for other sheets link to main sheet in five columns ex. 60011 for one column to main sheet 5 columns 6 0 0 1 1. sorry I am not good at English.
Since the code is equal to the sheetname, you can also refer to cell a1 and avoid the indirect formula for those cells.
Then why not only this for code on Main Sheet.
Since code is same which is selected from the drop down list in A1, so no need to reference the other sheets......
In C5
and then copy across.Please Login or Register to view this content.
@ FlameRetired
No need to use the $ sign for absolute reference inside the Indirect, since Indirect treats them absolute automatically.
@ sktneer
Thanks for that. I struggle with INDIRECT. Still learning.@ FlameRetired
No need to use the $ sign for absolute reference inside the Indirect, since Indirect treats them absolute automatically.
@ oeldere
Good point. It never occurred to me to parse what was right in front of my face. LOLSince the code is equal to the sheetname, you can also refer to cell a1 and avoid the indirect formula for those cells.
Thank so much. It works nice
We all learn new things everyday.Originally Posted by FlameRetired
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks