Rob:
My take on what you were wanting to do was to suggest that your
use the Copy of your Full Data from Sheet1 and do a Paste-Special - Paste
Link to Sheet2.
That way, whatever changes you make to the existing records on Sheet1
auto-update
the same records on sheet2 as each of your cells on sheet2 are linked to
it's couterpart
cell on sheet1.

Now, if you periodically add rows to sheet1, it would be "easiest" to simply
again do
a Copy of your full table on sheet1 and the paste-special Paste link onto
sheet2, but
before so doing erase all your data off sheet2 (top to bottom) as you are
about to
completely replace it with the newly updated sheet1.

Maybe I assumed perhaps too much here,,,







"Rob graham" wrote in message
...

"Jim May" wrote in message
news:A6pte.65529$Fv.18925@lakeread01...
Originally, I meant to say Sheet1Range A1:C5 << The reference to
Sheet1RangeA1..
was not intended to be entered into the sheet.
Does that help.

Thanks Jim.

Now if I enter some data in say Sheet1, row C6 I would like it to
automatically find its way to a row in Sheet 2.

Rob