1. Is there a formula i can use which will make a cell show exactly the
same as what another cell shows on a different page?
If the cell format is set up the same as the cell on the different
page, the displayed value should be the same as displayed on the other
sheet.
Suppose the format is for a percentage with two decimals in cell C2 on
Sheet2. The formula on page one would be =Sheet2!C2, just set the
format to a pecentage with two decimal places.

2. Is it possible to put a timer on certain cells so they close within
--mins and --hours?
I am not sure what you are really trying to do? What do you mean by
"close within --mins and ---hours"?

3. Can i enter a formula into a cell which stops people from going over
a certain number?
Try Data Validation - Select Custom and enter a formula such as =<1000
to limit entries to less than 1,000.


--
DCSwearingen


------------------------------------------------------------------------
DCSwearingen's Profile: http://www.excelforum.com/member.php...o&userid=21506
View this thread: http://www.excelforum.com/showthread...hreadid=533869