Posted by Carrie on December 11, 2001 7:18 AM
I am rolling up numbers from several different sheets (Sheets2-20)in an Excel workbook into a single sheet (Sheet1). The rows in Sheet1 each represent a different sheet. The columns in Sheet1 represent rows within the other Sheets2-20. Therefore, I would like to manually link each cell for the first row (i.e. Sheet2) in Sheet 1, but then copy that down so that it changes the formula as I copy down. For example, Cell A1 in Sheet1 is: =Sheet2!F13. Cell B1 in Sheet1 is: =Sheet2!F14. I would like to copy it down so that Cell A2 in Sheet1 is: =Sheet3!F13. And Cell B2 in Sheet1 is: =Sheet3!F14. And so on through Sheet 20.
Is there a way to accomplish this???