C
Cal
I use excel to store my audio cd information, i have a big collection of music cds
I have it like
Column A = Currently blank
Column B = Artist
Column C = Track
Column D = Cd Name
Then say a cd as 10 tracks then it will be 10 Rows containing artist, track name, cd name etc.
What i would like if it is possible so far i do it manually but would like it easier etc.
Where i drag down column A and it will automatically number each cd for me, it would be similar to this...
0001 / Prince / Alphabet Street / Greatest Hits
0001 / Prince / 1999 / Greatest Hits
0002 / Madonna /Vogue/Greatest Hits 2
0002 / Madonna /True Blue/Greatest Hits 2
So the number is the same for each track on that cd but changes when it`s a different cd.
Is this possible?
I have it like
Column A = Currently blank
Column B = Artist
Column C = Track
Column D = Cd Name
Then say a cd as 10 tracks then it will be 10 Rows containing artist, track name, cd name etc.
What i would like if it is possible so far i do it manually but would like it easier etc.
Where i drag down column A and it will automatically number each cd for me, it would be similar to this...
0001 / Prince / Alphabet Street / Greatest Hits
0001 / Prince / 1999 / Greatest Hits
0002 / Madonna /Vogue/Greatest Hits 2
0002 / Madonna /True Blue/Greatest Hits 2
So the number is the same for each track on that cd but changes when it`s a different cd.
Is this possible?