moving data

[Brad]

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?

 

[Roger Govier]

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.