I need a macro to produce an error message if a cell is blank

Closed
RebeccaJenkins - Mar 18, 2015 at 02:03 PM
I created a macro that will transfer the data from one sheet to another, but I need it to produce an error message if a certain cell is left blank, but there is an exception. If a different cell says Smart Trees, then this other cell can be blank. Also, at the end of the macro I need it to clear the data from the original sheet.