Cheeky question of possible help needed

[satzzz]

A lady friend of mine at work has a excel spreadsheet that she uses for course bookings(I have a copy here).It lists such things as type of course,name location dates of course,certificate numbers(important as they are CAA authorised).
What I am asking is someone with ideas that could help make it easier to fill in (drop down menu's etc) and just look better overall.
If anyone would like to view it i'll pm or email it to them.
Cheers

Satzzz

[Sanj[UK]]

Have you tried using auto filter in excel? It will create the drop down menu's you require..
(So highlight A1 for e.g go to data--> auto filter = drop down menu )

[satzzz]

Yes it already has the auto filter on,but it just looks a mess.I can do VERY easy formulas but I just though someone could take a look and throw a few new ideas into the ring

[addictive1]

Yes it already has the auto filter on,but it just looks a mess.I can do VERY easy formulas but I just though someone could take a look and throw a few new ideas into the ring

To get really good looking stuff with total control you'd need to do some VBA that sits behind the spreadsheet.

[satzzz]

To get really good looking stuff with total control you'd need to do some VBA that sits behind the spreadsheet.

Hmmm,thats what I thought.Oh well it'll have to stay how it is as I don't have the skills to help her (could've got me a jump as well,and she's real tasty)

[baronvon]

if you want I can have a look at it tomorrow in work, bank holiday so will be quiet

pm me if you want to

THE BARON

[Over Carl]

Would it be possible to make a simple access database to do the job?

[satzzz]

if you want I can have a look at it tomorrow in work, bank holiday so will be quiet

pm me if you want to

THE BARON

Thanks Baron PM sent

[satzzz]

I've attached it here if anyone decides to look in the future.

[wizle]

I can do you some drop downs without using vba..........what version of excel is she using?

[ka$h]

Using named ranges, data validation and a lookup formula you should simply be able to add the functionality you require.

[satzzz]

I can do you some drop downs without using vba..........what version of excel is she using?

its 2000 mate.Oh and thanks buddy i'll owe you one

[wizle]

Ok mate, I'm on the case.............