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

[OneLieIn]

They are probably a look up table. When you click on the cell with the drop down list, it might show you where you should be looking in the Formula bar. Alternatively see if there are any hidden sheets which contain the list.

[CarGirl]

No idea what version of excel but it goes back to 2005, nothing shows up in cell if I right click. How do I look for hidden sheets?

Sorry I used to be good with excel but I haven't worked for 5 years!!!

[CarGirl]

Forms toolbar where is it?

[CarGirl]

come back pleeeeeeeeeeeaaaaaaaaaaaase

[CarGirl]

Please the accountant who wrote the spreadsheets for us did a runner and I am the most excel literate of the committee please do not abandon me to doing all the invoices by hand

[CarGirl]

how do I unhide worksheets?

[CarGirl]

I just need to find "the list" and add to it I think?

[VinegARGHHHTits]

Cargirl if you right click on the sheet tab and 'view code' you might be able to amend what is in the list from there if it is hard coded in, you will also be able to see all the hidden sheets within the workbook and the code behind them. hth

[CarGirl]

There aren't any sheets to unhide.

When viewing the code it doesn't tell me anything helpful apart from it is password protected

Guess I will have to rewrite the whole thing at some point or find an excell whizz to help in person!

[VinegARGHHHTits]

Unless you know the password then i am afriad you are not going to be able to change it, sorry couldnt be more help.

[CarGirl]

no hidden columns

grrrr at accountant, guess that will this weeks job rewriting it!

[Flier]

oh, wish i could help, thsi sort of thing used to be right up my street, but I managed to delete my excel program last week and I have no discs to reinstall

hope you manage to get it ok, they've got to be somewhere!

[CarGirl]

I will send it to you tonight. It doesn't even have the internet so I will have to copy it onto disc to send it from my PC. Thanks for offer!

[Flier]

when trying to view the code, have you tried entering any passwords? if you try password, that is soemtimes the default.

[CarGirl]

will do Flier

Anyone fancy designer better invoices anyway. You can so tell it was a bloke who did them!

[Flier]

just thought - i have some excel tutorials upstairs, will take a look and see if there is anything relevant for you.