"Jim May" <jmay@cox.net> 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