Richard, here's something fun... Someone over on the MrExcel forum helped me with a VBA macro that allows you to toggle the value in a cell within your 10x16 matrix between "null" and "1" by simply clicking on it. The attached file is your spreadsheet with macros enabled (xlsm rather than xlsx file extension). I'm not sure if you have to enable "developer" mode in Excel or not, but give it a try...
Cheerful regards, Mike
Code:Private Sub Worksheet_SelectionChange(ByVal Target As Range) 'Modified 5/30/18 9:50 PM EDT If Not Intersect(Target, Range("B30:K45")) Is Nothing Then If Target.Cells.CountLarge > 1 Then Exit Sub If Target.Value = "1" Then Target.Value = "" Else Target.Value = "1" End If Range("b28").Select End If End Sub




Bookmarks