Below is an outline of what how my books are set up and what the macros accomplish;
Workbook#1: Incident Workbook (IWB) - used to create incident reports. Both macros are in this workbook.
Workbook#2: Master Incident Data Tracker (MIDT) - functions as a summary sheet of all incidents and...