VBA Copy and Paste Formatting Help with Transpose

[ExcelNoob243]

Example.xlsx

Hey, I was looking for a macro that is able to copy and paste individual surveys (export from SurveyGizmo) with variable copy and paste ranges to another sheet. All starting from the same cell, but ending in a different column. There are two sets of data one is the title and then the description. I attached an example containing the data export and the desired format after the macro is ran.

I was thinking the macro would run something in a loop through the survey lines with copying from B2, Ctrl+Shift+Right to grab the titles and then paste onto the new sheet with transpose. It would then go back and grab the descriptions starting in L2, Ctrl+Shift+Right to grab the descriptions of the titles and paste them onto the new sheet next to the titles. The macro would then run for each of the surveys taken.

Is this possible to automate?

Thanks!

[jindon]

Try

Please Login or Register  to view this content.

[jindon]

Duplicate post......

[jindon]

Please Login or Register  to view this content.

[ExcelNoob243]

YES that does it! Thank you so much for your help!

[jindon]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.