hi all,
I want to take the data account number of the sheets next to it in accordance with their respective names using a specific formula .
I have more than 50 sheets , is there a formula to directly copy the account ???.
Please kindly help, thank you in advance
formula from another sheets.xlsx
Regard
dolphino
Try
in D3
=INDIRECT("'"&B3&"'!B2")
and copy down
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Try below formula in C3 and copy towards down
=INDIRECT(ADDRESS(2,2,,,$B3))or
=INDIRECT(ADDRESS(2,2,,,$B3))
=INDIRECT("'"&B3&"'!B2")=INDIRECT("'"&B3&"'!B2")
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Woow,,, that perfect...
thank you Special-K and nflsales
regard
dolphino
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks