If you have the V6, you can use the CL Type-S 6 speed or the Accord Coupe V6 6 speed. The Legend swap is not a bolt on and requires some work if it can, in fact, be done.

Obviously the number of gears wouldn't matter, as you're replacing the entire transmission with a new one.