Locate a set value and copy the value in the cell that's below it

[p45cal]

Now what should I change if there's 5000 lines of shareholders, rather than just 500...like in the example you put together for me?

Absolutely nothing.