Help Needed Urgent

B

BiggieD

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

DCSwearingen

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

Therese

Hi
This one is a whole lot better and funnier though. Click A1, Data, datavalid
and then click userdefined. Write >9 and the go to the last option and write
for instance: "Ooops, you are not allowed to enter a digit above 9." 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.
 
B

BiggieD

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

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

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

3.Wicked. Thanks, ill try that out
 
B

BiggieD

Thanks Therese. That is one cool tip! Thats going to look real nice and
professional now. Thanks alot man.:)
 
T

Therese

Oops, I must have misplaced my first answer which hopefully explans my
"goofy" answer. So sorry.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top