Layout examples with before/after look

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Fred" wrote in message
...
Hi

I need a possible solution.

I am a mobile dj and have a database created in excel of my entire cd
collection it goes like this...

Artist - Song - Cd Title - Duration - Cat No.


In this database i have so far 10,000 cds hundreds of thousands of tracks
split over 5 sheets.

Now i have just finishing typing in the Uk Charts in a seperate excel
database which consists like this

Artist - Song - Year - Chart Position


Now i would love to be able to remove all of the tracks i have in my cd
collection from the uk chart database, so leaving only the uk chart tracks
i don`t have.


Is this possible if so how? `im newish to excel 07(came with pc).

thanks