Hi

The macro works but not the last part. As per my Excel image cell B30 has the number 7-15 in it. I need the macro to go to the cell below B31 and use that number (1 in this example) and search the following cell range: E1:E12 to find a 1 (cell E1). Once found place the 7-15 and increase the last digit by 1 (so it becomes 7-16) in the adjacent cell to the right (F1). Do the same with all cells: B30, F30 and J30 but only if they contain a 15 (1-15 or 7-15 etc.) as the last number. After this delete all contents in cell B30, C30, D30. There are are two examples in my Excel sheet.

Thank-you again for your assistance.