[CLGonline]

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

[Gord Dibben]

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

[CLGonline]

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

[Shane Devenshire[_2_]]

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