excel help (i THINK this could be easy...)

[shackrock]

I'm trying to write an excel document for documenting all the movies I have.

Basically, I'll have the following fields that I will fill in (manually)...these will be like the columns that I'll have.

*Movie Name
*Genre
*Year Produced
*My Rating
*IMDB Link

I'd like to be able to sort (in both directions) the Movie (alphabetically), Genre (alphabetically), Year (number order), and Rating (number order).... so everything except the IMDB links.

The genre column, I'd like to have only certain options available. I'd also like to be able to combine options. For example, I'll have a list of things that I can put a "check" next to it if it applies to the movie:
*romance
*action
*comedy
*drama
*tv series

There will be some TV series, that are romantic comedies.... (for example). So I'd like to do something like that. Now where I KNOW that will get tricky is with sorting...so I dont know, suggestions here would be nice.

I need to be able to add an unlimited number of movies.


Anyway I don't really know anything about programming in excel, but if anyone could help me out here, I'd really really appreciate it... I have an EE degree, so I have a fairly good background in general programming, just have no idea where to start here in excel.

Thanks.

[WingedPanther]

Why do you want to program? Data : Sort gives you all the power you need.