Excel Vba – Copy And Paste Data Into A New Sheet

The data is retrieved from a separate macro; however, the issue is that the formatting is skewed. Meaning, instead of having multiple rows, I would like to have it as one going across. I’m not sure how to explain it in words, but I think it’s best to demonstrate it using an actual example. Please see attached.

In essence, this is a simple copy and paste project. The format is exactly as shown on the attachment.

The columns are always the same; however, The main challenge is that the rows varies depending on how many rows per header the macro creates.

If you have any questions to further explain the issue, you can send me a message and explain further.

Leave a Reply

Your email address will not be published. Required fields are marked *