software

Hi. I have 3 questions to ask.

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?

2. Is it possible to put a timer on certain cells so they close within
--mins and --hours?

3. Can i enter a formula into a cell which stops people from going over
a certain number?

If anybody can help it would be much appriciated.

Many thanks,
Nathan.--
BiggieD
------------------------------------------------------------------------
BiggieD's Profile: www.excelforum.com/member.php...oamp;userid=33607
View this thread: www.excelforum.com/showthread...hreadid=533869
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
quot;close within --mins and ---hoursquot;?

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 =lt;1000
to limit entries to less than 1,000.--
DCSwearingen------------------------------------------------------------------------
DCSwearingen's Profile: www.excelforum.com/member.php...oamp;userid=21506
View this thread: www.excelforum.com/showthread...hreadid=533869Hi
This one is a whole lot better and funnier though. Click A1, Data, datavalid
and then click userdefined. Write gt;9 and the go to the last option and write
for instance: quot;Ooops, you are not allowed to enter a digit above 9.quot; A little
grey window will pop up with that messaage whenever you write a number above
9 in A1. I love this myself.
Hope you can use it.
--
Theresequot;BiggieDquot; skrev:

gt;
gt; Hi. I have 3 questions to ask.
gt;
gt; 1. Is there a formula i can use which will make a cell show exactly the
gt; same as what another cell shows on a different page?
gt;
gt; 2. Is it possible to put a timer on certain cells so they close within
gt; --mins and --hours?
gt;
gt; 3. Can i enter a formula into a cell which stops people from going over
gt; a certain number?
gt;
gt; If anybody can help it would be much appriciated.
gt;
gt; Many thanks,
gt; Nathan.
gt;
gt;
gt; --
gt; BiggieD
gt; ------------------------------------------------------------------------
gt; BiggieD's Profile: www.excelforum.com/member.php...oamp;userid=33607
gt; View this thread: www.excelforum.com/showthread...hreadid=533869
gt;
gt;


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
quot;Dizzee Rascalquot; as one event and quot;ColdCutquot; 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 quot;Dizzee Rascalquot; has sold
so far etc.

So im wanting for example from the page named quot;Dizzee Rascalquot; 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 quot;12hours and
10minsquot; and maybe make the formula say quot;EVENT CLOSEDquot; near the bottom
of the page if possible.

3.Wicked. Thanks, ill try that out.--
BiggieD
------------------------------------------------------------------------
BiggieD's Profile: www.excelforum.com/member.php...oamp;userid=33607
View this thread: www.excelforum.com/showthread...hreadid=533869
Thanks Therese. That is one cool tip! Thats going to look real nice and
professional now. Thanks alot man.--
BiggieD
------------------------------------------------------------------------
BiggieD's Profile: www.excelforum.com/member.php...oamp;userid=33607
View this thread: www.excelforum.com/showthread...hreadid=533869Oops, I must have misplaced my first answer which hopefully explans my
quot;goofyquot; answer. So sorry.
--
Theresequot;BiggieDquot; skrev:

gt;
gt; 1. Sorry but i dont really understand. Ill tell you what it is im trying
gt; to do.
gt; I am making a spreadsheet for some coursework and the project is for
gt; tickets sales. I have different sheets for different events like
gt; quot;Dizzee Rascalquot; as one event and quot;ColdCutquot; as another event with a page
gt; which is sort of like a home page just showing an overview of the events
gt; so far so it shows how many tickets the event quot;Dizzee Rascalquot; has sold
gt; so far etc.
gt;
gt; So im wanting for example from the page named quot;Dizzee Rascalquot; id like
gt; cell E12 to also show as exactly the same even when changed on the home
gt; page.
gt; Sorry if im not explaining this very well.
gt;
gt; 2. By this i mean for example the page to lock after quot;12hours and
gt; 10minsquot; and maybe make the formula say quot;EVENT CLOSEDquot; near the bottom
gt; of the page if possible.
gt;
gt; 3.Wicked. Thanks, ill try that out.
gt;
gt;
gt; --
gt; BiggieD
gt; ------------------------------------------------------------------------
gt; BiggieD's Profile: www.excelforum.com/member.php...oamp;userid=33607
gt; View this thread: www.excelforum.com/showthread...hreadid=533869
gt;
gt;


Is anyone able to follow up on this for me please?--
BiggieD
------------------------------------------------------------------------
BiggieD's Profile: www.excelforum.com/member.php...oamp;userid=33607
View this thread: www.excelforum.com/showthread...hreadid=533869
Please will someone help.--
BiggieD
------------------------------------------------------------------------
BiggieD's Profile: www.excelforum.com/member.php...oamp;userid=33607
View this thread: www.excelforum.com/showthread...hreadid=533869