Hello,

I have a giant file that I am trying to use VBA to quickly work through.

In column D, there are ~4500 unique identifiers. Somehow, i need to copy and paste those 4500 identifiers in the cell B1, individually.

(Essentially I am trying to find a way to copy cell "D5" paste it in cell "B1" then to "D6" and paste back into "B1" and so on...)

Any idea how to code this on VBA?