New to VBA coding and have tried coding this but I cannot figure out how to get the ranges to line up under the headers. I have a results tab that has data that varies in rows the data is every 17 cells that I want to cut and paste below each new row under the headers. I was using the last column which is always 17 cells in the because it was always will have a "Yes" to show it should be moved if it has a "No" the columns will end.
I attached the workbook with the macro that I wrote so you can see what it is doing now. On the "Data" tab is the way the current macro spits out the data. I made a tab "What should look like" to give an example of how the end result should look like. Since I think it is easier to visualize it then trying to explain it. This is just a example the columns could go to 500 and the rows will vary when the results come out.
Please PM me with any questions or concerns.