2009 Saturn Vue - transmission is bad

I think the transmission is bad can shift into reverse but not into drive

Yeah, that sounds like the trans is bad. Have it towed to a local independent shop for a diagnosis. Maybe it is something cheaper than a transmission rebuild.