Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cell reference - for the sheet name, can I use a variable?
For example, I know I can refer to another worksheet in a cell formula as such:
=Data!C6 However, Is there a way to refer to the name of the sheet based on the name of the sheet being a variable (ie. the contents of another cell?) THanks Matt Lawson |
#2
|
|||
|
|||
Hi
=INDIRECT("'" & A1 & "'!C6) where A1 stores your sheet name "Matt Lawson" wrote: For example, I know I can refer to another worksheet in a cell formula as such: =Data!C6 However, Is there a way to refer to the name of the sheet based on the name of the sheet being a variable (ie. the contents of another cell?) THanks Matt Lawson |
#3
|
|||
|
|||
Thanks again for the help Frank!
I get a "formula you typed contains an error".. I did replace A1 with the correct cell. I looked up the reference in help, and I'm not sure how you are using the INDIRECT function. Thanks Matt Lawson "Frank Kabel" wrote: Hi =INDIRECT("'" & A1 & "'!C6) where A1 stores your sheet name "Matt Lawson" wrote: For example, I know I can refer to another worksheet in a cell formula as such: =Data!C6 However, Is there a way to refer to the name of the sheet based on the name of the sheet being a variable (ie. the contents of another cell?) THanks Matt Lawson |
#4
|
|||
|
|||
Matt,
It should be =INDIRECT("'" & A1 & "'!C6") not the single quotes as well as the doubles. -- HTH RP (remove nothere from the email address if mailing direct) "Matt Lawson" wrote in message ... Thanks again for the help Frank! I get a "formula you typed contains an error".. I did replace A1 with the correct cell. I looked up the reference in help, and I'm not sure how you are using the INDIRECT function. Thanks Matt Lawson "Frank Kabel" wrote: Hi =INDIRECT("'" & A1 & "'!C6) where A1 stores your sheet name "Matt Lawson" wrote: For example, I know I can refer to another worksheet in a cell formula as such: =Data!C6 However, Is there a way to refer to the name of the sheet based on the name of the sheet being a variable (ie. the contents of another cell?) THanks Matt Lawson |
#5
|
|||
|
|||
Hi Bob
thanks for the correction :-) "Bob Phillips" wrote: Matt, It should be =INDIRECT("'" & A1 & "'!C6") not the single quotes as well as the doubles. -- HTH RP (remove nothere from the email address if mailing direct) "Matt Lawson" wrote in message ... Thanks again for the help Frank! I get a "formula you typed contains an error".. I did replace A1 with the correct cell. I looked up the reference in help, and I'm not sure how you are using the INDIRECT function. Thanks Matt Lawson "Frank Kabel" wrote: Hi =INDIRECT("'" & A1 & "'!C6) where A1 stores your sheet name "Matt Lawson" wrote: For example, I know I can refer to another worksheet in a cell formula as such: =Data!C6 However, Is there a way to refer to the name of the sheet based on the name of the sheet being a variable (ie. the contents of another cell?) THanks Matt Lawson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
how to cell reference a Chart title | Charts and Charting in Excel | |||
Using a formula in a Hyperlink Cell reference | Excel Discussion (Misc queries) | |||
Displaying sheet and cell value in another cell | Excel Discussion (Misc queries) | |||
Cell Colors and Sheet Protection | Excel Discussion (Misc queries) |