Copy & Paste
 

I am trying to create a central results sheet that will collate results from
numerous other workbooks. The data in the workbooks to be referenced is in
the same place in each workbook. Is there an easy way to reference the data
without having to link the cells individually. I thought you could copy and
paste the cells in the new workbook once you had referenced one cell, but
this sometimes works and sometimes doesn't. I hope I've explained this ok!

Copy & Paste
 

Before you copy the formula, make sure that the cell references are relative.
When you click to create a link, Excel will make the reference absolute. A
relative reference looks like this: C4, while an absolute reference looks
like this: $C$4. Remove the dollar signs and you will be able to copy okay.

"JDB" wrote:

I am trying to create a central results sheet that will collate results from
numerous other workbooks. The data in the workbooks to be referenced is in
the same place in each workbook. Is there an easy way to reference the data
without having to link the cells individually. I thought you could copy and
paste the cells in the new workbook once you had referenced one cell, but
this sometimes works and sometimes doesn't. I hope I've explained this ok!