Well, your macro is doing what it's supposed to do. The only exception is that you have an extra "End If" (maybe only a typo).
Every time you click on a cell, if it's in column O and it isn't empty, then copy into the cell O9 the value of the cell of the row under the clicked cell.
|