| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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) | |||
Hybrid Mode
