need to know how to pull inventory thats not been returned

i need to know how or if i can get a formula that will let me sort my beams that has been returned and the ones that hasn't. but when it sorts it i need the whole line to stay together. and i would like the ones that hasn't been returned to be put on a different page in a different work sheet. thanks for the help jennifer



7/24/2013
DATE # of day SET # BEAMS SHIPPED BEAMS RETURNED
1/17/2013 187 80219 A2826
1/17/2013 187 80219 A3731
1/17/2013 187 80219 A2019
1/17/2013 187 52335 A2162 3/25/2013
1/17/2013 187 52335 A2988 3/25/2013
1/17/2013 187 52335 A3723 3/25/2013
1/17/2013 187 52336 A3637 5/8/2013
1/17/2013 187 52336 A3632 5/8/2013
1/17/2013 187 52336 A3863 5/8/2013
1/17/2013 187 80223 A1306
1/17/2013 187 80223 A1768
1/17/2013 187 80223 A2790
1/17/2013 187 80227 A2028 3/25/2013
1/17/2013 187 80227 A1026 3/25/2013
1/17/2013 187 80227 A1842 3/25/2013

Will the Returned column have dates in it when they are returned?

yes i put dates in the day they come back

i hope i've attached this correctly

Do you want to sort by the returned page and unreturned page by date or by shipped?

the unreturned

I know, but in what order?

im sorry it doesn't matter which way it sorts i just need the ones that are unreturned to go to a different worksheet

Something like this?

unreturned daffodils.xlsx

yes thank you sooo much i greatly appreciate that!!