Sheet1 is just an easier way to input the data. The cell font is set to Marlett so that it will register a check entry if "a" is entered. The user need not enter anything for a "NO" or "X" as a blank cell automatically registers a "NO" entry in sheet2. The data looks better visually with checks and blank. In sheet2, the data is converted to a "Y" and "N" which is the basis of the behavior summary. Yes it will be for a monthly monitoring...and I'll just update the workbook for the other months. Huge thanks for your attention and willingness to help.
Bookmarks