easily linking cells from various worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a workbook to track test anomalies. One worksheet is the Log and the other worksheets are the individual test anomlies. The worksheets are named B057, B058, B059, etc. The first row of the log contains information from B057, the second row contains information from B058, etc. I know how to link information (='B057'!A1) but I would have to manually enter the sheetname for the next row because if I copy and paste it will link information from sheet B057 instead of B058. Is there an easy way to do this? Thanks in advance for any help.
 
Hi
if you start in row one try the following
=INDIRECT("'B0" & ROW()+56 & "'!A1)
and copy down
 
Back
Top