Hi friends
I hope you are okay
I have a data from sheet 2 to sheet 400.
I need a formula which will calling data in sheet 2 column D9 to sheet 400 column D9 in sheet 1 B4 to B404
Thanks much
Hi friends
I hope you are okay
I have a data from sheet 2 to sheet 400.
I need a formula which will calling data in sheet 2 column D9 to sheet 400 column D9 in sheet 1 B4 to B404
Thanks much
I mean it is a single name in each sheet not all things from another sheet
Before even attempting to answer this...you have 400 sheets?????
That is probably at least 390 too many. Why do you need so many sheets?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
You may use INDIRECT function to get what you want.
=INDIRECT( sheet_name ! address )
and you can also use helper cell to create list of sheet_name for use in INDIRECT function.
for sample from A4 contain Sheet2
in B4 you may use
=Indirect("'" & A4 &"'!D9")
Regards.
But.....400 sheets is a very large number :O
My English is very poor, so please be patient >_<"
My Dynamic Related Dropdown post:
https://www.excelforum.com/excel-for...ml#post5657376
https://www.excelforum.com/excel-for...ml#post5655711
https://www.excelforum.com/excel-for...ml#post5655762
It doesn't work
Can you show a picture of your desired result and let's saw some of your worksheet name? [in case you can't upload a small sample file]
Regards.
why do you even have 400 sheets??
400 sheets seems a bit excessive!!!
=INDIRECT("'"&A2&"'!D9")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thanks much for your contribution.
But i would like to ask more is it possible to call data as they way you did from d9 to p9 for all shets?
If possible it will make may work easier.
Thanks much i believe somebody will help me
Thanks much for your contribution.
But i would like to ask more is it possible to call data as they way you did from d9 to p9 for all shets? THOSE DATA TO COME IN SHEET ONE B2 TO N2.
If possible it will make may work easier.
Thanks much i believe somebody will help me
The contents of WHICH cell should be in C2?
The contents of WHICH cell should be in D2?
Okay thanks much
i attach sample file and you will see what i need in sheet 1, i decide to use green and yellow colour to represent output. And those output i put it manually now i think you will understand.
And i need all to be there in sheet one as the way you did to the b1 to b5
thanks much for you contribution
i believe you will understand what i need here
see the attachment of what i need
Try:
=INDIRECT("'"&$A3&"'!"&CELL("address",D$9))
copied across and down.
1. Will any of the target cells be empty?
2. Will the real data be text or numbers, or a bit of a mixture?
One way of dealing with empty cells is this:
=IF(INDIRECT("'"&$A3&"'!"&CELL("address",D$9))="","",INDIRECT("'"&$A3&"'!"&CELL("address",D$9)))
However, bear in mind that INDIRECT is volatile. It recalculates EVERY time ANYTHING changes. On big sheets, this CAN cause performance issues.
Thanks much
it works wonderfull be blessed
You're welcome.
It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.
Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks