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?