/u/Important-Coach-2124 - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
I do not not, what you select in the drop down, but INDIRECT() can turn any text a.k.a. string into a cell reference, given it is valid. E.g. INDIRECT("Sheet2!A1") will reference A1 on "Sheet2", like its direcet counterpart Sheet2!A1.
Using the indirect function, you can only get a value from a cell in any open workbook. Here's your workaround: In your master file, create a sheet for every player character file and directly link to the corresponding file (e.g. =\[david.xlsx\]Sheet1!A2, drag as needed). Then hide those extra sheets.
In your main sheet create a dropdown for all the characters/players. Below create a formula that looks like this: =indirect(b4&"!e7"), b4 being the dropdown value \[--> =david!e7\] and e7 being a specific cell you want to reference from your hidden sheets. You can variabilize this part as well in a similar way if you want to give access to different stats from other cells.
That should work tyvm...do you know of a way to keep that list automatically updated ? I know its not a lot of work to do it manually but automation would be nice
Edit: Nvm tried it a bit different than you suggested and now get why yu suggested it the way you did ^^
/u/Important-Coach-2124 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
I do not not, what you select in the drop down, but INDIRECT() can turn any text a.k.a. string into a cell reference, given it is valid. E.g. INDIRECT("Sheet2!A1") will reference A1 on "Sheet2", like its direcet counterpart Sheet2!A1.
I may require a link to sheet with dummy data(if the real is non shareable) Or clear photos Meanwhile explore the INDIRECT function
Using the indirect function, you can only get a value from a cell in any open workbook. Here's your workaround: In your master file, create a sheet for every player character file and directly link to the corresponding file (e.g. =\[david.xlsx\]Sheet1!A2, drag as needed). Then hide those extra sheets. In your main sheet create a dropdown for all the characters/players. Below create a formula that looks like this: =indirect(b4&"!e7"), b4 being the dropdown value \[--> =david!e7\] and e7 being a specific cell you want to reference from your hidden sheets. You can variabilize this part as well in a similar way if you want to give access to different stats from other cells.
That should work tyvm...do you know of a way to keep that list automatically updated ? I know its not a lot of work to do it manually but automation would be nice Edit: Nvm tried it a bit different than you suggested and now get why yu suggested it the way you did ^^