You can't have it both ways. If you want it to be formula then they're not
suuposed to fill in information into those cells. They are supposed to be
calculated with every change in the varinats in the formula

"lauraroebuck" wrote:


I can't as it is the same cells that they need to enter data into


--
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