I am looking to copy a range of cells from one document to another based on an IF Statement.

eg. in document YTM-IEP FINAL -

copy range A12:O15
IF O13 = '00/00/00'

into document YTM IEP Parent Version A13:O16

The idea of the document YTM IEP Parent Version however is to auto fill in the ranges A13:O16, A24:27, A35:O38, A46: 049 - based on the IF Statement in YTM IEP Final.

Does it matter that cells do not copy into the same cells in each document. The idea is in document YTM IEP FINAL there could be cells 'Final Assessment' that do not meet 00/00/00 in order. So the mixture in document YTM IEP FINAL must fill in the gaps in A13:O16, A24:27, A35:O38, A46: 049 in document YTM IEP Parent Version

Thank you so much in advance.

Please help !YTM IEP - FINAL.xlsxYTM IEP - Parent Version v1.xlsx