Using advanced filters, I know I can move data based on certain criteria, but is there a way to have the data move automatically from Sheet1 to Sheet2, if it is 14 days past due?
Any suggestions?
Using advanced filters, I know I can move data based on certain criteria, but is there a way to have the data move automatically from Sheet1 to Sheet2, if it is 14 days past due?
Any suggestions?
Last edited by Zan03; 03-22-2010 at 03:30 PM.
It would require the use of VBA to automate the Advanced Filter and include a method to check the date. If you can use a VBA solution, then post a sample workbook that meets the folowing criteria.
1. It EXACTLY duplicates the structure of your real workbook
2. It contains representative non-sensitive dummy data
3. It illustrates manually the desired results
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
Hello,
Thank you for your response.
I've reattached the file.
Just to recap, these are my end goals:
- When a request for quote come in, they need to be added to the "RFQ + Quotation Sheet" and assigned a quotation number.
- All unawarded jobs are to be moved to another worksheet "UNAWARDED OR REJECTED JOBS" once the deadline is past.
- All awarded jobs are to be moved to the WIP.
Please let me know if you have any further questions.
Thanks,
zanna
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks