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

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.

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

Hi Kent
Have a look at this site for a sample template.
HTH
Cimjet
http://office.microsoft.com/en-us/templates
"Kent" wrote in message
...
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.

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

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.