Need help/VBA/Insert Columns and data

[nathan.volker12]

Hello all,

Could use some help here, not sure where to even start.
cap 1.PNG
This is my starting process. What I need to do is copy the dates column and the ticker column and insert it prior to each name that is referenced in Row 1. Column B the ticker column needs to have the name that is referenced to it in row 1.
Here is the after picture of what I am looking for.
cap 2.PNG

The caviot here is that i need something that would dynamically do this, because sometimes there is 20 columns, other times there are 50+ columns

[JLGWhiz]

Your data would be easier to read and work with if you click the 'Go Advanced' button on the 'Quick Reply' box and then click 'Manage Attachments' to upload your file. We responders can then access the actual file and work with it to develop solutions.

[nathan.volker12]

I have tried to upload the workbook but it tells me upload failed everytime I tried, Thats why I posted the pictures so that there was still something to see

This is the file on my onedrive if your able to access it there

https://1drv.ms/x/s!Aop9YfDogrcQhjASSXiW6Q3gNHqB

[JLGWhiz]

Make a copy of your file and try this code on it. If your sheet names are not the same as in the posted examples, then you will need to correct them in the Set statements below.

Please Login or Register  to view this content.