druddle

Hi all

I have an Excel workbook that consists of about 12 sheets (artist, title, cd, etcof my music collection). Anyone know how i can do a workbook search for the word "black"and get it to produce a new sheet with all matching rows copied to the new sheet ?

Thanks

Dave

bioforger

iTrader: (1)

Would be easily achievable in vba/macro. No I can't do it, have enough of these type of requests at work

druddle

Lol, is there any Excel/VBA websites or forums I could go to that might help me understand how to do it ?

DAve

bioforger

iTrader: (1)

You can only learn VBA with experience really. Ok send me the workbook if u want I'll knock something up for you.

bob269

The easier option would of been to use one of the 100's of free music catalog progs available.

bioforger

iTrader: (1)

Not really, as he would need to reenter his whole music catalogue into said app And which decent ones are free? The only one of any use I use is MP3 collector, which isn't free.

druddle

You are right, but the way I catalogued them was ripping them all to 320k MP3 and then using MP3Tag to create a .csv file from the tags. I have many many thousands of tracks so it would have taken me ages manually !!

Bio - thanks alot for this, will mail you something.

Dave