linking multiple columns onto multiple worksheets

T

talderman

I would like Column's A, B, and C on the source sheet (sheet 1) to correspond
to Column's A, B, and C on the destination sheet (sheet 2). Is it possible
for me to insert a row into my source sheet, add information into a cell
located in column A and that cell be updated and reflected on my destination
sheet as well. Is excel capable of creating that row in the destination
sheet?
 
R

RagDyer

As long as you realize that the row you added to Column A is added to *all*
columns.

Try this on the destination sheet (Sheet2), in A1, and copy across to C1,
then down as needed.

=INDEX(Sheet1!$A:$C,ROWS($1:1),COLUMNS($A:A))

You can actually enter this formula *anywhere* on the destination sheet,
copy across 3 columns, and then down as needed.
 
Top