Hi there

I have the following macro which will move rows from one sheet to another depending on one of the cell value in the row being set to Closed.

I want to do 2 things with this macro

1. One of the cell value in the row inserts current date and time i.e. now().
I want to move any rows if the following condition is met i.e.
if cell b23 and downwards having older than now() having yesterday date and time etc and cell p23 and downwards having value = closed to move to sheet 2 on the same workbook

please advice

Please Login or Register  to view this content.