linking to several workbooks in Excel

  • Thread starter Thread starter kv10
  • Start date Start date
K

kv10

I am working in Excel 2003. I have 1 workbook with 25 tabs. I then have a
summary page that needs to link to each workbook. I have created the first
line, and linked the cells to the first tab, but now want to "follow that
trend" so that it will link to the same cells in each workbook. I started to
do this manually and it is taking forever. There must be a better way.
Right?
 
If the sheet names are named as Sheet1, Sheet2, Sheet3 etc; then try the
below which will link to the cell A1 of each sheet. Apply the below formula
and copy down as required..

=INDIRECT("'Sheet" & ROW(A1) & "'!A1")
 
Back
Top