Hi All, I need help on this. I am currently looking for a formula or VBA code to copy and paste all information from column A to M and O to S columns based on the N column open date from workbook1 to workbook2.

There will be two scenario:
1. If the column N in workbook 1 have a specific date (Example 10/2/2018) the formula or VBA code should bring all data from column A to M and O to S in the workbook 2.

2. If the column N in workbook 1 have a word (Done or done). the formula or VBA code should ignore that row. also, If the date in workbook 1 have been changed to Done or done. The workbook2 should remove that data out. Please help.