Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / May 2005

Tip: Looking for answers? Try searching our database.

i want to list all my cd's alphabetically

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
tangerine62 - 27 May 2005 23:53 GMT
i want to list all my cd's/albums alphabetically and by year. As my
collection grows is it possible to add to this list alphabetically and by
year. Or am i barking up the wrong tree, and should i use something else to
list my cd's with.
Chip Pearson - 27 May 2005 23:57 GMT
You can certainly use Excel to do this. Just enter all your CD
information and the sort the data.

Signature

Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

>i want to list all my cd's/albums alphabetically and by year. As
>my
[quoted text clipped - 3 lines]
> something else to
> list my cd's with.
paul - 28 May 2005 07:21 GMT
its perfect,you can make your list with seperate columns for artist, release
date, record company,etc etc and sort by any number of columns.You could get
it to sort automatically every time you entered a new line,that would require
a macro.
Signature

paul
remove nospam for email addy!

> You can certainly use Excel to do this. Just enter all your CD
> information and the sort the data.
[quoted text clipped - 6 lines]
> > something else to
> > list my cd's with.
CLR - 28 May 2005 14:43 GMT
You can also use Data > Filter > AutoFilter to examine only the ones by a
certain Artist, etc.

Vaya con Dios,
Chuck, CABGx3

> You can certainly use Excel to do this. Just enter all your CD
> information and the sort the data.
[quoted text clipped - 13 lines]
> > something else to
> > list my cd's with.
Rodney - 29 May 2005 00:18 GMT
G'day tangerine62,
personally I would not.
I would opt for an Image database instead, and
in fact is what I use.
A simple scan of the case slipper, will include <ALL> the
info you need, tracks, dates, artists, etc etc. much, much more
than you could possibly type.

If the image is saved as an *.jpg you can use an image database
organiser or just Windows explorer with the file name including the
format (country, blues etc) performer, date etc.
You can add MSWord docs alongside the scans, News Group posts
or whatever, it is endlessly adjustable.

I also use this for my philatelic Stamp e-albums, and have well
in excess of 70,000 images in sortable form.

Just an idea for you to consider.
Rodney

| i want to list all my cd's/albums alphabetically and by year. As my
| collection grows is it possible to add to this list alphabetically and by
| year. Or am i barking up the wrong tree, and should i use something else to
| list my cd's with.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.