easily linking cells from various worksheets

C

Carlos Munoz

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.
 
F

Frank Kabel

Hi
if you start in row one try the following
=INDIRECT("'B0" & ROW()+56 & "'!A1)
and copy down
 

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

How to update data entry to a linked worksheet and then return thenew value back to a master workshe 0
linking data from one worksheet to another 1
Index formula-change cell range 2
Link cells with text not numbers 4
How to update a value from a linked worksheet back to the master worksheet? 0
How to update data from linked worksheet back to a master worksheet? 0
Excel linking from one master worksheet to many worksheets and ableto return a value back. 0
linking two worksheets in the same workbook 3

Top