Safe Count

[smods]

Okay i'm creating an electronic safe counting sheet.

The items I will be entering come in different denominations and I want validations and error messages when the user enters something stupid.

So if the user tries to enter £550 in £20 notes which isn't possible then it will reject this value and throw up an error.

I had thought about creating a list containing the allowed values "£20, £40, £60, £80" etc and use the validation. However I will have huge long lists and I thought you guys maybe able to come up with a better way of doing this?

ALSO - Taking it to another level would it be possible for the user to enter the number of notes and for excel to multiply it by that value automatically? For example the user enters 25 and it's automatically changes to £500 in the same cell?

 

[SteveO59L]

Why would you want to change the value in the same cell ?

 

[smods]

Because I have very limited space on this sheet...

So I doubt it's possible as you would have a number cell which you would enter a number into and it would mulitiply by the denomination and also covert to a currency cell.

 

[SteveO59L]

Overwriting isnt a particular problem, but does not give you an audit trail.



Try and give an example of your data, and what you want to do with it

 

[smods]

Overwriting isnt a particular problem, but does not give you an audit trail.

Try and give an example of your data, and what you want to do with it

Audit trails don't matter, the safes are under CCTV etc and these counts get printed off.

So to start the user would have to enter how many bags of change are in the safe for each coin type.

So the user enters that the number 5 for complete bags of £2 coins. A complete bag of £2 coins contains £500. So the user enters 5 and it automatically converts to £2,500

User enters there are 4 bags of 10p's and it automatically converts to £400.

I hope i'm being clear, sorry if not

 

[SteveO59L]

Send me a pm with you e-mail address, and I'll send you a sample