Convert cell data into a worksheet name via a formula
 

Hello -

I have a summary page that is pulling totals data from many worksheets. I
have the worksheet name [in this case a number] in column C on the summary
sheet .

I would like to be able to a build a simple formula that uses the data in
Column C and converts it into the worksheet name so I don't have to key in
the formula manually for each row.

In this example, the worksheet name is "1" and that name/number is located
at c11

='1'!G3

thanks!
Sandy

Convert cell data into a worksheet name via a formula
 

=indirect("'" & c11 & "'!G3")

--
Regards,
Tom Ogilvy

"Sandy" wrote in message
...
Hello -

I have a summary page that is pulling totals data from many worksheets. I
have the worksheet name [in this case a number] in column C on the summary
sheet .

I would like to be able to a build a simple formula that uses the data in
Column C and converts it into the worksheet name so I don't have to key in
the formula manually for each row.

In this example, the worksheet name is "1" and that name/number is located
at c11

='1'!G3

thanks!
Sandy

Convert cell data into a worksheet name via a formula
 

Thanks so much, Tom ;-))))

"Tom Ogilvy" wrote:

=indirect("'" & c11 & "'!G3")

--
Regards,
Tom Ogilvy

"Sandy" wrote in message
...
Hello -

I have a summary page that is pulling totals data from many worksheets. I
have the worksheet name [in this case a number] in column C on the summary
sheet .

I would like to be able to a build a simple formula that uses the data in
Column C and converts it into the worksheet name so I don't have to key in
the formula manually for each row.

In this example, the worksheet name is "1" and that name/number is located
at c11

='1'!G3

thanks!
Sandy