I want a Macro to run only if a cell listed in column B says "Red" to create
a seperate spreadsheet.
I currently have 86 line items in this sheet which could potentially go
"Red", so the Macro needs to run each time this happens.