Macro range of cells change

Hi

I have a macro that is not searching a cell range properly. If someone could kindly assist. Please see my Excel image.

Example with expected result.

The first part of the macro works fine it’s the last part that is not working correctly. 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 in advance for your assistance.

Please Login or Register  to view this content.

EXCEL IMAGE.JPEG

Hi, CHRISTINEKENDALL93
Can you upload your sample workbook, showing the 'before data' & the result you expected?
That way we don't need to retype your data sample.

To attach an Excel file:
in the reply box, scroll down and press Go Advanced button and then scroll down and press Manage Attachments link. Follow the instructions to upload file.

For the moment, I don't quite understand this part:

Please Login or Register  to view this content.

but you have no data in row 13 & 14, so actually what do you expect?

Hi

Thanks for your response. I will try the code and let you know..

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.

Hi

I have attached my Excel sheet with your changes but the macro is not working anymore.
I have also included cells that were not in the original Excel image.
Thanks so much for your help.

Hi protonLeah

It works but a couple of issues: using my Excel sample sheet above when it finds the 7-15 (cell B30) it doesn’t use the cell below, cell B31 (1 in it) to search the cell range E1:E12 to find the number 1. The other issue is cell J30 also has a 1-15 in it. Right now both finds Cell B30 and J30 are placed in the same cell outside the range of E1:E12.

Also, the contents of cell B30 and J30 are deleted after the move could we also delete the contents of cells C30 and D30. Also the contents of K30 and L30.

Thanks again for your help.

Hi protonLeah

It works, it works. Thank-you so much for your effort.
Christine