split a file based on column value awk / sed?

view story

http://www.linuxquestions.org – I have a file with some data and one of it is a long integer value say column $4, I want to sort that column and based on a range split the file. EX:- 100 - 5000 (where x = 100 and y = 5000) Next file is like X= 5001 and y=10000 Can someone please help? Thanks in advance (HowTos)