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.