if you have a code for the speed sensor...why not start there and replace that.

makes since that you have gears in manual but not drive when the speed sensor is bad. its most likely one of the inputs the transmission computer uses to know when to shift up/down.