how to combine workbooks or spreadsheets in to one????
 

i am new to excel - i have 20 spreadsheet files created by a music program,
they are all song-lists used by the program. i want to make a new excel file
combining all those lists into one so i can print or send the file. how?
also, can i then search that file for artist or title name?
is there a way to elimainate all the unused fields besides just cutting them
one by one? THANKS

how to combine workbooks or spreadsheets in to one????
 

i forgot to say, these are xml files, all the same format, all the artists
under A, then B, etc. - and i want to make a single large file i can search,
print, or send to users.

"musiclover" wrote:

i am new to excel - i have 20 spreadsheet files created by a music program,
they are all song-lists used by the program. i want to make a new excel file
combining all those lists into one so i can print or send the file. how?
also, can i then search that file for artist or title name?
is there a way to elimainate all the unused fields besides just cutting them
one by one? THANKS