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?
--
Tim

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"talderman" wrote in message
...
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?
--
Tim

Thanks for the post it was extremely helpful
--
Tim


"RagDyer" wrote:

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"talderman" wrote in message
...
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?
--
Tim

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"talderman" wrote in message
...
Thanks for the post it was extremely helpful
--
Tim


"RagDyer" wrote:

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"talderman" wrote in message
...
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?
--
Tim