using excel as a database for movies and cd collection help

[Guest]

hi, ive been using excel to maintain a list for my cd's and moves etc just
wanted to make it more functional but as im a noob im not sure what i can do,
as it stands i have a workbook with a sheet for each catagory cd's movies tv
shows etc, with a cell comment giving details of the item like the list of
episode titles in a tv series. im using ctrl + f to search and using a red
cell for stuff ive lent to friends, i would really like to enhance this
workbook maybe add a stats page, see if there is some way to list the number
of red cells etc, improve the searching, count the no. of films and generally
use this as an opertunity to learn more about excel

 

[Bernie Deitrick]

The best thing would be to not use multiple sheets, but use a single
database with another column that has the category. That way, you can
filter the list (to see just certain categories or sub-categories, along the
lines of Movies, 2003 - your data set will determine the possiblilities) or
to use it as the basis of a pivot table, where you can see summaries.

HTH,
Bernie
MS Excel MVP