Urgent - Need help with Excel, please help!

[CarGirl]

This is for pre-school

I have an invoice spreadsheet and on it are drop down arrows that take you to a list where you select the correct payment rate, or in another they correct age etc.

How do I amend what is in the drop down list - I can't find another sheet where it is or anything like that???? Don't even know what it is called to look it up in excel help.

I think I may have some more questions later too changing an "If" formula.

Thank you

[SAD] think dh has thrown them in the bin

Drop down list options are usually in Data menu under validation

I have a password cracker that will do sheet-level passwords if you need it?

When on the cell go to Data / Validation it should then should have a pop up box showing which validation options are in force. Allow list should be selected, there will then either be a list of words, a range of cells, or a single word range name.

If a list of words then edit in the pop up box, is a cell range then go to the cells referenced edit the list, if you extrend the list then you will have to go back to the pop up box and edit the range.

If a single word range name then come back and we can go through that.

Have been at the wine, will be back on this thread on Wednesday to try it all again......if anyone else wants a copy of the spreadsheet to have a go let me have your email addy!!!

At least I managed to crack the cash book problems on my own!

Did you email it to me? Haven't had it

cargirl, i'll have a go at your spreadsheet if you're happy for me to look too, i don't like putting email on here, but you can cat me and i'll cat you back.

Plan has been foiled, copied spreadsheets onto disc from pre-school's laptop and my laptop can't find them I only have excel 2003 so perhaps it can't recognise them?

Perhaps I will have to go back to the beginning and just write my own spreadsheet with drop down boxes

Thanks for all your help, I don't even have the pre-school laptop anymore to try the ideas given yesterday pm.

okay have just discovered the blank disc I tried to copy it onto wasn't blank it is dh's ipod stuff - grrrrrrrrrrrrr so not wonder it didn't work!

can you try copying it again?

I don't have the pre-school laptop on at the moment the administrator has it, will hopefully get it back in a few days.