Dear All,

Can you help me with this rather simple VBA code. I have a column on
my worksheet containing the text "Numbers". The position of this
column can vary in every worksheet sometimes it can be B20 sometimes
D23 and so on.

All I want to do is
1. Find the Column which contains text "Numbers" and "Total" to define
start and end range
2. Position to the exact row below this founded column
3. Since, it comprises of numbers, i want to know how many times a
number is appearing

Example -
H
21 Numbers
22 2323
23 2323
24 2324
25 2323
26 2324
27 2329
28 2320
29 2323
30 2324
31 Total = 9

Hence my answer should be writtten in new worksheet as

A B
1 Number Count
2 2323 4
3 2324 3
4 2329 1
5 2320 1

Can you please provide me with the code for this. The row and column
with the Text "Numbers" can vary in every spreadsheet but it is
certain that it will end with "Total", so i believe that start row
should be row +1 where text "Numbers" appear and endRow should be row
-1 where Text "Total" appears. Also, the list of numbers can be more
or less demonstarted in example.

Many Thanks in advance...