okay i did a search and i think i might have a good combo to try!!!
GOOD = CHEAP!!!! 
LOL!
here is the threaded rod, guessed at size and it says its $1.01!!! for 1 foot

hehe why not?? i have done stupider things with a buck!
http://www.lowes.com/pd_160882-37672...3127881&***=32
Steelworks 3/16"Dia. x 36"L Threaded Rod
Zinc plated
Coarse thread
Threads Per Inch 20.0
okay so if it is 20 threads per inch and i want to move 1 inch per second then i need a motor that can spin 1200 rpm
20(tpi) x 60 (seconds per minute)= 1200rpm
.....
introducing the perfect motor to try!???!?!?.....
found here:
http://www.sciplus.com/category.cfm/...8/category/172
38143 6 VDC MABUCHI MOTOR
PRICE - A WHOPPING $2.95 for 3!!!!
This diminutive 6VDC Mabuchi motor draws 100 mA, approx 500mA at stall, and spins at approx 1240 rpm. The striated shaft is 1/2" long x 3/32" dia, in a housing that measures 1-3/16" x 1" dia. You get three for one great price for your science fair project, moving display, or latest invention.
might have to give it a shot. what you guys think?