ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   i want to list all my cd's alphabetically (https://www.excelbanter.com/new-users-excel/28222-i-want-list-all-my-cds-alphabetically.html)

tangerine62

i want to list all my cd's alphabetically
 
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

You can certainly use Excel to do this. Just enter all your CD
information and the sort the data.


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


"tangerine62" wrote in
message
...
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.




paul

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.
--
paul
remove nospam for email addy!



"Chip Pearson" wrote:

You can certainly use Excel to do this. Just enter all your CD
information and the sort the data.


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


"tangerine62" wrote in
message
...
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.





CLR

You can also use Data Filter AutoFilter to examine only the ones by a
certain Artist, etc.

Vaya con Dios,
Chuck, CABGx3


"Chip Pearson" wrote in message
...
You can certainly use Excel to do this. Just enter all your CD
information and the sort the data.


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


"tangerine62" wrote in
message
...
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.






Rodney

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



"tangerine62" wrote in message
...
| 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.




All times are GMT +1. The time now is 05:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com