So just lock the cells you need. and leave the other editable

"lauraroebuck" wrote:


But they need to enter data on the other sheets.

What happens is they can overwrite the data that has copied across if
it has changed. It has conditional formatting so that any changes are
hightlighted as red

So thanks for your reply but this does not help me


--
lauraroebuck
------------------------------------------------------------------------
lauraroebuck's Profile: http://www.thecodecage.com/forumz/member.php?userid=289
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=93655