How would I code a problem like this? I have a list of Data as shown in the picture. If I enter the number 2 for example in Range(B12), I need the top of the list be rearranged at position 2 or in this Row2 and then the Last Row to goto the top.
Column C in this case is just an example. I can redo the code to suit me if I knew where to start.

image_2022-10-10_182444805.png