Is there any way to setup a cell to allow data to be entered while not
deleting a formula or conditional statement?

I have a series of cells that are added and if it reaches 300, I want
it to automatically populate the cell with the number 300...otherwise,
the user can enter the number themselves without destroying the
statement for use again the following week.

Also, can I use a conditional statement to move an entire row of data?
If a sum of numbers reaches 300 in the middle of my spreadsheet, can I
have it automatically copy the values to the bottom of my sheet or
better yet, another page and then clear the row for use again?

Thanks for any help you can provide.


--
stilton
------------------------------------------------------------------------
stilton's Profile: http://www.excelforum.com/member.php...o&userid=36081
View this thread: http://www.excelforum.com/showthread...hreadid=558656