Good afternoon all,
I'm pretty new to using Excel for more than basic list and math functions, so this may be a basic question, maybe not. I don't know.
I use Excel to list and track workorders in my shop.
My page is pretty basic:
Column A: Customer
Column B: Customer email
Column C: Department
Column D: Date in
Column E: Date out
Column F: Description
What I'd like to do is set Excel up so that once the "Date out" hits 60 days past, the entire line containing that date will automatically move to a similar list on a second sheet within the same .xls file.
I've been doing this manually, but I'm hoping it can be automated.
Any ideas?
Bookmarks