Blkout19

Okay my poor 02 cls is sitting in the garage with a 3rd shot tranny , rebuilding it is starting to get a bit irritating & pointless , i've been reviewing some of the threads & that 07/08 TL & 03/04 odyssey tranny will work ?
Now are they a complete drop in ? what other kind of stuff am i going to have to buy if not ?
& will sport shift still work ??
the guy gave me a estimate for about 1800 to rebuild it, but i know i can find those trannys for around 1000 , i don't know what to do , i absolutely love my cl , but these transmissions are such a pain in the ( l )