Max and Mike H,

The code you gave me worked perfectly....... on Friday.

On Monday, for some reason, when I clicked in the "Quantity" column on any
item on a sheet, it would copy Row #9 across to the new sheet. As I clicked
other items, it would the copy Row #10, 11,12, etc.Why is this happening? I
rechecked the code and nothing has changed. I deleted the code, re-wrote it
and the same thing happened. What have I done to muck this up?
Thankyou
Mike W