moving data
 

I have a list of orders with product info, sales clerk and sales info in a
spreadsheet. I am aging these orders so that I know if they are over 30
days, 60 days, 90 days etc... What I would like to do is copy all info in a
row to a seperate sheet if the number in the aging column is less than 30,
greater than 30, greater than 60 or greater than 90. How do I do this?

Hi Brad

One way would be to use Data=Filter =Autofilter
From the dropdown on your ageing column select Custom =30 and <60
Copy the resulting filtered rows to your new location.
Data=Filter=Show all
then repeat using criteria to suit your other ranges.

--
Regards
Roger Govier
"Brad" wrote in message
...
I have a list of orders with product info, sales clerk and sales info in a
spreadsheet. I am aging these orders so that I know if they are over 30
days, 60 days, 90 days etc... What I would like to do is copy all info in
a
row to a seperate sheet if the number in the aging column is less than 30,
greater than 30, greater than 60 or greater than 90. How do I do this?