Forum Discussion
using tab names to get cells copied
I have a spreadsheet with several tabs from 1-100. In tab 1 I have created a JE. tab 2-100 are identical templates with different numbers in key cells. I would like to put the tab name say '2' in...
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))