Hi,
Been awhile since I've need the help of this fabulous forum, but here I am to be a bother again! :-)
I have worklog that we track ALL our actions in. Most of the actions do not require tracking, but there is one event that does, however. When the information arrives to us we place a future date in column F of the worksheet. For most entries this column is empty.
Is it possible to insert a macro, with a control button, that would search column F, and if the date is earlier than the current date, then create a new worksheet title "Overdue", and copy that line entry onto the Overdue worksheet?
I've included a sample of the worklog for you convenience.
THANKS for any help you give!!!
Bookmarks