I have a file on my desktop called "magmusic". it contains over 700 songs.
how do i list them alphabetically in an Excel spreadsheet.
EX. TITLE ARTIST
ANY HELP WOULD SURELY BE APPRECIATED. THANKS.
I have a file on my desktop called "magmusic". it contains over 700 songs.
how do i list them alphabetically in an Excel spreadsheet.
EX. TITLE ARTIST
ANY HELP WOULD SURELY BE APPRECIATED. THANKS.
Try the attached link
http://www.j-walk.com/ss/excel/tips/tip103.htm
VBA Noob
What file format is the file on your desk top?
you could try and 'Data'.....'Data import'....follow the steps to import the
data into excel once you have it in it should just be a matter of doing a
'data'...'sort' using the song title as the key sort field.
"[email protected]" wrote:
> I have a file on my desktop called "magmusic". it contains over 700 songs.
> how do i list them alphabetically in an Excel spreadsheet.
> EX. TITLE ARTIST
> ANY HELP WOULD SURELY BE APPRECIATED. THANKS.
I'm betting it is not a "file" but rather a "folder".
Noob has given you a good link to John's site.
Gord Dibben MS Excel MVP
On Mon, 17 Jul 2006 12:04:01 -0700, [email protected]
<[email protected]@discussions.microsoft.com> wrote:
>I have a file on my desktop called "magmusic". it contains over 700 songs.
>how do i list them alphabetically in an Excel spreadsheet.
>EX. TITLE ARTIST
>ANY HELP WOULD SURELY BE APPRECIATED. THANKS.
I'm betting it is not a "file" but rather a "folder".
Noob has given you a good link to John's site.
Gord Dibben MS Excel MVP
On Mon, 17 Jul 2006 12:04:01 -0700, [email protected]
<[email protected]@discussions.microsoft.com> wrote:
>I have a file on my desktop called "magmusic". it contains over 700 songs.
>how do i list them alphabetically in an Excel spreadsheet.
>EX. TITLE ARTIST
>ANY HELP WOULD SURELY BE APPRECIATED. THANKS.
I'm betting it is not a "file" but rather a "folder".
Noob has given you a good link to John's site.
Gord Dibben MS Excel MVP
On Mon, 17 Jul 2006 12:04:01 -0700, [email protected]
<[email protected]@discussions.microsoft.com> wrote:
>I have a file on my desktop called "magmusic". it contains over 700 songs.
>how do i list them alphabetically in an Excel spreadsheet.
>EX. TITLE ARTIST
>ANY HELP WOULD SURELY BE APPRECIATED. THANKS.
I'm betting it is not a "file" but rather a "folder".
Noob has given you a good link to John's site.
Gord Dibben MS Excel MVP
On Mon, 17 Jul 2006 12:04:01 -0700, [email protected]
<[email protected]@discussions.microsoft.com> wrote:
>I have a file on my desktop called "magmusic". it contains over 700 songs.
>how do i list them alphabetically in an Excel spreadsheet.
>EX. TITLE ARTIST
>ANY HELP WOULD SURELY BE APPRECIATED. THANKS.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks