Archive of Mr Excel Message Board
Back to Dates in Excel archive index
Back to archive home
Referencing sheet names in a formulaPosted 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 formulaPosted 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
That way you can change A1 and still get the "appropiate" result to show.
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.