| Author |
Message |
|
Posted: Fri, 30 Dec 2005, 9:57pm Post subject: Excel Spreadsheet for DVD collection
|
 |
|
Season II
Joined: 11 May 2004
Posts: 1697
WPP: 68
Location: MI
|
|
| I want to keep track of all the movies I have in a database on my computer. What I am looking for is a spreadsheet where I can just type in the name of my DVD and it will add it to an alphabetized list. I don't know how to do this but I'm sure that it is pretty easy for someone who knows excel well. If someone would want to make a spreadsheet like this for me I would really appreciate it. |
|
|
|
|
|
|
|
Posted: Fri, 30 Dec 2005, 10:01pm Post subject:
|
|
|
Strike 3
Joined: 07 Jul 2004
Posts: 3289
WPP: 119
|
|
| Sounds like you want an Access Database rather than an Excel Spreadsheet? |
|
|
|
|
|
|
|
Posted: Fri, 30 Dec 2005, 11:00pm Post subject:
|
|
|
Season II
Joined: 11 May 2004
Posts: 1697
WPP: 68
Location: MI
|
|
| Well I don't have Access on my computer, I have Excel though. Is his doable with Excel? |
|
|
|
|
|
|
|
Posted: Sat, 31 Dec 2005, 12:00am Post subject:
|
|
|
Administrator
Joined: 04 Dec 2003
Posts: 1748
WPP: 155
Location: on my laptop
|
|
| Les_Worm wrote: | | Well I don't have Access on my computer, I have Excel though. Is his doable with Excel? |
It is doable with Excel but Access is a better tool for this sort of thing. What version of Excel do you have? In the past most versions of Office used to have both Excel and Access bundled in. |
|
|
|
|
|
|
|
Posted: Sat, 31 Dec 2005, 4:22am Post subject:
|
|
|
Season II
Joined: 11 May 2004
Posts: 1697
WPP: 68
Location: MI
|
|
| Well now that I double checked I do have Access. Unfortunately I am even less familiar with Access as I am with Excel. |
|
|
|
|
|
|
|
Posted: Sat, 31 Dec 2005, 9:15am Post subject:
|
|
|
One Pair
Joined: 24 May 2005
Posts: 18
WPP: 61
|
|
| There is a software called MediaMonley, it's very good for music collections and I think (I'm not sure) it works for movie collections too. |
|
|
|
|
|
|
|
Posted: Sat, 31 Dec 2005, 12:54pm Post subject:
|
|
|
Full House
Joined: 23 Aug 2004
Posts: 813
WPP: 145
Location: Mount Holly, NC
|
|
I use DVD Profiler.....several years ago it was free and $25 if you wanted the Hi-Rez images and lifetime updates. Very customizable reports, and if you can get your hands on a "cue cat" bar code reader entering a large collection is a snap
http://www.intervocative.com/Products.aspx |
|
|
|
|
|
|
|
Posted: Sat, 31 Dec 2005, 2:44pm Post subject:
|
|
|
4-of-a-Kind
Joined: 25 Jan 2005
Posts: 1524
WPP: 109
|
|
| Excel has a sort function. |
|
|
|
|
|
|
|
Posted: Sat, 31 Dec 2005, 4:04pm Post subject:
|
|
|
Season II
Joined: 11 May 2004
Posts: 1697
WPP: 68
Location: MI
|
|
| r8ed wrote: | | Excel has a sort function. |
Wow, that was wicked easy. Thanks. |
|
|
|
|
|
|
FTR $200 Freeroll at ChiliPoker, November 22nd 14:00 ET
