I have a spreadsheet with several columns and I make entries in rows across
the columns. I would like to be able to have some of those entries copied
into another sheet to save making the entries twice.

I can see how to get a cell in the second sheet to pick up the entries in
the first but I may add rows in the first sheet from time to time and I want
these to be automatically picked up in the second.

Also, in the first sheet there are some rows which I don't want copied over,
and I may make entries in rows subsequent to these. How can I accommodate
all this?

Rob Graham