I need the to locate numbers 1 TO 10 in MANY cell ranges, example only D3:D12, H3:H12, L3:L12 (I will need to be able to add additional ranges to the code, this is only an example). I have a sample Excel sheet at the end to visually see the details below.

A positive result would be a "*#-#*" in the column to the right of 1 to 10 numbers and also numbers in the second column to the right of the 1 to 10 numbers. Once numbers are found and have a positive result the numbers in the second column are to be written (do not delete after the write) to the following cells (again please make these cells changeable):

(1 to 10 are the search numbers)

1 to cell B3
2 to cell B4
3 to cell B5
4 to cell B6
5 to cell B7
6 to cell B8
7 to cell B9
8 to cell B10
9 to cell B11
10 to cell B12

I need the code to add all numbers in the cells, example from my Excel sheet is number 5 is found in cell D3 would write 10.00 to cell B7 and also cell L12 has a 5 and a 2.00 in which would be written to cell B7 (10.00 plus 2.00 = 12.00).

Using my sample Excel sheet has sample data and the expected result highlighted in yellow.

That would do it. Thanks so much for all your help.

LOCATE NUMBERS.png