Hello-
I'm trying to create a macro to copy a row (columns A-F) from worksheet "Current Log" if the date in column F (Due Date) is before today, and paste that to another sheet "Overdue Log" in the same workbook in columns B-G. In column A of "Overdue Log" I need to add today's date.
I've attached a screenshot of sample data for the "current log" and "overdue log." So what I would want is to copy rows 2 - 9 on the "current log" sheet, columns A - F only, and paste them beginning at B8 on the "overdue log" and adding today's date into column A. The "current log" updates every day, so the pasting into the "overdue log" would need to start at first unused row each time.
I've found several examples of somewhat similar scenarios across the web, but I have not been able to piece them together into anything that comes even close, so hoping for some help from those of you that can knock this out in your sleep... thanks so much.
I'm trying to create a macro to copy a row (columns A-F) from worksheet "Current Log" if the date in column F (Due Date) is before today, and paste that to another sheet "Overdue Log" in the same workbook in columns B-G. In column A of "Overdue Log" I need to add today's date.
I've attached a screenshot of sample data for the "current log" and "overdue log." So what I would want is to copy rows 2 - 9 on the "current log" sheet, columns A - F only, and paste them beginning at B8 on the "overdue log" and adding today's date into column A. The "current log" updates every day, so the pasting into the "overdue log" would need to start at first unused row each time.
I've found several examples of somewhat similar scenarios across the web, but I have not been able to piece them together into anything that comes even close, so hoping for some help from those of you that can knock this out in your sleep... thanks so much.