Talk

Advanced search

Urgent - Need help with Excel, please help!

(37 Posts)
CarGirl Mon 13-Oct-08 09:30:18

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 Mon 13-Oct-08 09:32:46

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.

littlelapin Mon 13-Oct-08 09:32:48

Message withdrawn at poster's request.

littlelapin Mon 13-Oct-08 09:34:58

Message withdrawn at poster's request.

CarGirl Mon 13-Oct-08 09:39:52

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 Mon 13-Oct-08 09:40:36

Forms toolbar where is it?

CarGirl Mon 13-Oct-08 09:48:21

come back pleeeeeeeeeeeaaaaaaaaaaaase

CarGirl Mon 13-Oct-08 09:50:37

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

littlelapin Mon 13-Oct-08 09:51:05

Message withdrawn at poster's request.

littlelapin Mon 13-Oct-08 09:52:01

Message withdrawn at poster's request.

littlelapin Mon 13-Oct-08 09:54:51

Message withdrawn at poster's request.

CarGirl Mon 13-Oct-08 09:58:45

how do I unhide worksheets?

CarGirl Mon 13-Oct-08 10:00:05

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

littlelapin Mon 13-Oct-08 10:11:16

Message withdrawn at poster's request.

VinegARGHHHTits Mon 13-Oct-08 10:17:57

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 Mon 13-Oct-08 10:25:58

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 Mon 13-Oct-08 10:29:39

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

littlelapin Mon 13-Oct-08 10:31:22

Message withdrawn at poster's request.

CarGirl Mon 13-Oct-08 10:33:25

no hidden columns

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

littlelapin Mon 13-Oct-08 10:36:25

Message withdrawn at poster's request.

Flier Mon 13-Oct-08 10:38:38

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 sad

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

CarGirl Mon 13-Oct-08 10:39:28

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!

littlelapin Mon 13-Oct-08 10:40:37

Message withdrawn at poster's request.

Flier Mon 13-Oct-08 10:55:18

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

CarGirl Mon 13-Oct-08 10:57:08

will do Flier

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

Join the discussion

Join the discussion

Registering is free, easy, and means you can join in the discussion, get discounts, win prizes and lots more.

Register now