formula to link to other tabs
 

need assistance to build formula so i can use cell contents to create links
to other tabs within spreadsheet

formula to link to other tabs
 

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

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

formula to link to other tabs
 

Try this

=INDIRECT("'"&A1&"-"&B1&"'!C2")

where 6 is in A1 and 1 is in B1.

Drop the =+ signs from your formulas, all they do is waste space, memory and
typing time, just enter =

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"CLGonline" wrote:

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