I was looking for help to develop some VBA code to write from potentially 4 cells to a possible 4 cells. I have uploaded my sample Excel sheet image with the expected result. If someone could kindly assist.

The macro would need to start with searching cells B3, B4, E3, E4 to determine if any numbers are present. When found use that number (example cell B3 has a 7 in it) to search for the same number in cells A14, E14, I14, L14 (cell E14 has the 7). When found write the contents from cell C3 (the adjacent cell to the right of the 7 in this example) to cell F14 and change the last number to a 1 (so cell F14 would be written as 8-1). Repeat for each cell B3, B4, E3, E4 and afterwards delete all the contents in B3,C3, B4,C4, E3,F3, E4,F4.

Thanks in advance for your help.

EXCEL 5.JPEG