Generate Random Number for an Unknown Number of Numbers under a Cell Heading in Two Column

Ok, so say I have a cell A1 with a heading "ID" with a number 25467 and another heading in C2 named "Number" and the cell under that has the same number 25467.

The situation? There are an unknown number of rwos under the heading "ID" with 25467 and an unknown number of rows of "Number" with 25467, but the numbers for both headings are the same. Now this is one record of an... Unkown number of records. But all of these are on the same worksheet they just continue on: Example
A B C
ID
25467 Number
25467 25467
25467 25467
25647
98657 Number
98657 98657
98657 98657
98657 98657


As you can see the first record has 4 rows under ID and 2 under number and for the second row 4 under ID and 3 under Number.

How could I create a Macro Button that would change with one click the number for each record in the ID and the Number category "which match" to the same random generated number? which would be unique for each record which isn't seperated by any blank lines in Excel?

Do the numbers need to be a consistent number of digits? Like 10000 through 99999, or does it matter/are they different?
Basically, you need to determine what the minimum number would be and what the maximum number would be, then use the formula

Formula:

Please Login or Register  to view this content.

. Now if the random generated number has to be unique (not appearing elsewhere in the sheet), this can only be done with vba code, which it seems you are wanting to use anyway. Assuming the button you want to click replaces all existing values in columns A and B that are the same as the selected value with a new random, non-duplicated number between that number range, the code would look like this:

Please Login or Register  to view this content.

So I modified it a bit. What I need to do now is drop to the next row not by a blank row which is consistent for all records now, but by searching for the next ID in column A that is different than the current record after it has been randomized and changed. I don't really want to look for ID and then offset by 1 but just look for the number. And the ID number for the next record would not have any blank row seperating it from the next record like it has now. ??? I posted a pic and the current code.

Please Login or Register  to view this content.

Capture.JPG

You notice 7857 under ID in column A:2

What I mean is if that column A had only one 7857 in it for each record for that column only and then it skipped the blank spaces underneath until it reached the next record below with a different number and then repeated this on down. You can look at the capture.jpg I attached in the previous post. Thanks.

Right now the code replaces all the numbers in each record with a random number and scrolls down to the bottom automatically. Each record is separated by a space followed by cell with "ID" written in it. Also Each ID has a number that 7857 in this case that is in each cell in column A all the way down until the last row has no other 7857 in it. This is were the space then seperates the record. Look at the Capture.jpg and you will see what I mean. What I want to do is only have 7857 once in Column A for that record and each preceding record has its own unique number. The catch is that there will be no "ID" written in a cell or blank row between records, it will simply be a new number like 6532 printed once in that cell and the other cells will have 6532 in them like the Capture.jpg shows each record having there own unique numbers. So, how can I generate random numbers for each record of unique numbers where there is no blank row and no "ID" written between cells, just a different set of numbers?