Objective:
1. Create a new workbook (call it CWP_List) if data from "MasterCopy" (Column "A" to "O" and Row "1 to 150") are change/updated.
2. It will only copy the data (including formating) from worksheet "Quantity Comparison" (first sheet).
MasterCopy.xlsmMasterCopy.xlsm

I've attached the MasterCopy file.