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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index formula-change cell range 2
linking data from one worksheet to another 1
Linking Multiple Worksheets and Cells 1
Link cells with text not numbers 4
Worksheet formula - auto populate 4
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
linking two worksheets in the same workbook 6
keeping rows together during column sorts of linked worksheets 1

Back
Top