I am doing a golf handicap spreadsheet. I need to split some cells diagnally
according to their handicap so I can put their gross score in the upper left
half and their net score in the lower right half. Example: If a guy has a 8
handicap the spreadsheet needs to go to the 8 highest handicap holes and
divide those cells diagnally so I can type in his gross & net score in the
same cell. I have the handicap number of the holes across the top of my
spreadsheet. I would really like a formula that would insert that diagnal
line automaticaly after I put in their handicap. Any thoughts?
Jeff