formula to link to other tabs
i am trying to use the contents of a couple of cells to build the name of the
tab to pull the cell contents from
ColumnA ColumnB
row1 6 1
need to combine the above cell contents to get the contents from cell C2 of
the tab 6-1 (i.e. results into =+'6-1'!C2)
"Gord Dibben" wrote:
Need much more detail in order to help with specifics.
Example of using indirect function with default sheetnames Sheet1, Sheet2
etc.
=INDIRECT("Sheet" & (ROW()) & "!E3")
Entered in summary sheet A1 and copied down to pull E3 from all sheets.
Gord Dibben MS Excel MVP
On Tue, 2 Jun 2009 15:33:01 -0700, CLGonline
wrote:
need assistance to build formula so i can use cell contents to create links
to other tabs within spreadsheet
|