| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 59353 | 2005-06-29 15:40:00 | MS Excel: Using INDIRECT in formula to link worksheets to summary page | scottsox2000 (8446) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 368074 | 2005-06-29 15:40:00 | Anyone know how to construct a formula in MS Excel that will recognize the results in one cell and use that in a formula to link to another worksheet? I have a summary worksheet that I use that I want to link multiple workbooks to. Summary Worksheet cell $a$1 = "May 2005" Results wanted in cell $a$2: Link to c:\May 2005\$c$14 If cell $a$1 is changed to "April 2005" then automatically link to c:\April 2005\$c$14 |
scottsox2000 (8446) | ||
| 368075 | 2005-06-30 07:24:00 | Hi, see this link (support.microsoft.com). Note that you will get a ref error unless the target workbook is open. | Parry (5696) | ||
| 1 | |||||