Example sheet.xlsx
(Please see attachment for reference)
The attached image is an example of an excel sheet used to keep track of due dates.
In the attachment, column G shows the due date for the job specified in column A. I would like create a formula, use vba, or anything so that if the date specified in column G is one month or less from today's(the current) date, the entire row will then be copied and moved to a second tab. Even better, I'd love to add in something that will organize them so that the rows with the closest upcoming due date show at the top.
I've been using my knowledge, reading guides and watching YouTube videos trying to figure this out and have not made very much progress Any help would be GREATLY appreciated!!
Bookmarks