1. Sorry but i dont really understand. Ill tell you what it is im trying
to do.
I am making a spreadsheet for some coursework and the project is for
tickets sales. I have different sheets for different events like
"Dizzee Rascal" as one event and "ColdCut" as another event with a page
which is sort of like a home page just showing an overview of the events
so far so it shows how many tickets the event "Dizzee Rascal" has sold
so far etc.

So im wanting for example from the page named "Dizzee Rascal" id like
cell E12 to also show as exactly the same even when changed on the home
page.
Sorry if im not explaining this very well.

2. By this i mean for example the page to lock after "12hours and
10mins" and maybe make the formula say "EVENT CLOSED" near the bottom
of the page if possible.

3.Wicked. Thanks, ill try that out.


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