Dynamically Copy and paste column

[Patriot17]

Your best bet for doing this sort of operation is to use pandas.
I don't use it myself enough to be of great assistance, but the basics can be learned in a very short amount of time, and you can do a lot of clever work.
I'd recommend, to start: https://www.youtube.com/results?search_q...+tutorials

Thank you, I have been using Pandas however the reason I am not with this workbook is because it has a pivot table embedded in the middle of the data and when I pull it into a df it messes the whole thing up.