linking multiple columns onto multiple worksheets

[Guest]

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?

 

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

 

[Guest]

Thanks for the post it was extremely helpful

 

[RagDyer]

You're welcome, and thank you for the feed-back.