linking column data in sheets to a summary sheet

  • Thread starter Thread starter mhsacks
  • Start date Start date
M

mhsacks

I have four sheets, each with a column of data.

I want to link the informtion in each of these sheet
columns to a corresponding column in the summary sheet.

Using copy and special paste with link I can link each
cell in the column individually to the corresponding
summary sheet cell.

I can not figure out a way to do it with the entire column.

Any suggestions. I have Excell 97.
 
mhsacks said:
I have four sheets, each with a column of data.

I want to link the informtion in each of these sheet
columns to a corresponding column in the summary sheet.

Using copy and special paste with link I can link each
cell in the column individually to the corresponding
summary sheet cell.

I can not figure out a way to do it with the entire column.

Any suggestions. I have Excell 97.
Click to expand...

Put the formulas in the first row, such as:
=Sheet2!A1
=Sheet3!A1
=Sheet4!A1
Then select these three cells and copy down as far as required. To copy
down, you can just drag the fill handle, which is the little black square at
the bottom right of the selection border.
 
Back
Top