Reply to thread

Message: [QUOTE="HS Hartkamp, post: 7467206"] Build a list of cell-references (based on parameters elsewhere) and use the INDIRECT function referring at list items. If the output of your students is always in the same cells, you can use some formula to make it easier Example: A1 contains the path to all student-sheets (e.g. "C:\Data\Excel results\Test1\ B2 contains "A47" C2 contains "D53" A3 contains "John Doe" B3 contains =INDIRECT("['"&$A$1&"Sheet1!"&$A3&"'B$2"&"]") Copy cell B2 down and right to get the desired values copied from all worksheets. Check the exact syntax for the pathname by referring to a single cell in an external worksheet, and then closing that sheet. Build the string to that example, and when it's OK, include the indirect function. Excel is very picky with the order of [, ], ', and ! Bas Hartkamp. [/QUOTE]