Archive of Mr Excel Message Board

Back to Dates in Excel archive index
Back to archive home

Referencing sheet names in a formula

Posted by mark on October 29, 2001 6:12 AM

I have a model that has numerous datasheets supporting it. I would like to be able to have a cell that was referenced in the formula that would allow me to just type in the name of a datasheet and the formula would change.

Any help would be greatly appreciated.

Re: Referencing sheet names in a formula

Posted by Juan Pablo on October 29, 2001 6:15 AM

For example you want A2 to show Cell E4 of the specific sheet you want to. To do this put in A1 the name of the sheet, and in A2 put

=INDIRECT("'"&A1&"'!E4")

That way you can change A1 and still get the "appropiate" result to show.

Juan Pablo

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.