Convert cell data into a worksheet name via a formula

G

Guest

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
 
G

Guest

Thanks so much, Tom ;-))))

Tom Ogilvy said:
=indirect("'" & c11 & "'!G3")

--
Regards,
Tom Ogilvy

Sandy said:
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
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Count If Formula Question 1
Changing name of worksheet based on data in cell of another worksheet 14
Referencing a Worksheet Name in Formula 2
Assigning a worksheet name to a variable 3
Excel VBA 1
Excel 2003 VBA In directory Open Spreadsheets Extract data 1
Possible to refer to a sheet's object name ? 10
Excel 2013 Merge Data 2

Top