Hi all. After about a week of learning how to use excel 2007 for cataloging my movie collection I came up with this template. I wanted to give it out to the community as I know many people might like it.
To use it enter your movies on the Movie List Tab. There are alot of options, all which are requirments for me, so you might have to play around with it.
You can see the code for this spreadsheet by right clicking on Select Movies and view code.
I took this example
and made it work for me.
If there are any excel Gods out there that can make this better please let me know. One option I want to add in is a "binder location" column. I want to store all my dvds in a binder and then label them with a number and than in this spreadsheet I can enter what number its at. This makes trying to find the disc easy.
Anyways hope people can find use of this!