Sep 26 2019 12:50 PM
How can I do that?
Thanks
Sep 26 2019 11:36 PM
Sep 27 2019 09:13 AM
It depends on formulas you use, but, if without VBA, INDIRECT() will be as the basis. If, for example, you'd like to pick-up the value in cell C2 from another tab, it could be
=INDIRECT("'"&A1&"'!C2")
or, the same but with more flexibility
=INDIRECT("'"&A1&"'!"&ADDRESS(ROW(C2),COLUMN(C2),4,1))