Forum Discussion
Solved
using = to get data from a sheet based on a cell name
Hi. I am using =HYPERLINK("#'"&A5&"'!A1",A5) to make a link to a sheet with the sheet name in cell A5. This works very whell and save me doing a link for every new sheet. What I would lik...
Fatdave42 , the solution HansVogelaar gave will do that. More specifically the
INDIRECT("'" & A5 & "'!F1")portion will return the value from cell F1 on the sheet named in cell A5.
Note: I did find a typo in the formula missing a quote so that might have been part of your problem.
Fatdave42 , the solution HansVogelaar gave will do that. More specifically the
INDIRECT("'" & A5 & "'!F1")portion will return the value from cell F1 on the sheet named in cell A5.
Note: I did find a typo in the formula missing a quote so that might have been part of your problem.
Thank you for pointing out my mistake! I have corrected it.
