I have an array into which I paste values (golf handicaps) from another part of the sheet. The columns respresent the competition and each row a member of the group. As everyone in our group does not play each competition, there are blank cells. I want copy the array to another table and go through the membership,the array, row by row and move the handicap values to the left of the array so there are no blank cells in each row. Any suggestions would be appreciated. Thank you. Although I am eighty two years old, I have been given the task of writing a program and I have EXCEL to do it. My previous programming was done using fortran and VBA is somewhat foreign to me.
Bookmarks