big list. Need advice for a new user of how to streamline it

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kent - 01 Apr 2008 13:51 GMT

Hey guys would really love some help.
I am putting a list of the best movies of all time together in my spare
time. I have movie name - year of release - director all in one coulmn.
Firstle I would like to know if there is a function that I could get similar
to a find/search so if I need to check the list for a title I could
iinstantly see if was there rather that trapse through 1000 entries.
Also I'm sure there are plenty of people out there that have done something
similar and I would appreciate any ideas on how to develope the sheet.

Any comments would be appreciated

Kent.

Reply to this Message

Cimjet - 01 Apr 2008 14:18 GMT

Hi Kent
Have a look at this site for a sample template.
HTH
Cimjet
http://office.microsoft.com/en-us/templates

> Hey guys would really love some help.
> I am putting a list of the best movies of all time together in my spare
[quoted text clipped - 10 lines]
>
> Kent.

Reply to this Message

Dave - 01 Apr 2008 21:23 GMT

Hi Kent,
If you want to stay with your current workbook, it would be more
manageable if the Name, Year of Release, Director etc each had their
own column. Later, you can add more columns as you think of them - eg
Genre, Studio, etc. You can then easily sort by Name, Director, or by
any column heading. Search macros would also be simpler to write.
You can probably use DATA > TEXT TO COLUMNS to separate your data,
depending on how your info has been inputted.
Regards - Dave.

Reply to this Message

Rate this thread: