Moving data between sheets

Good Afternoon Everyone!

This is my first attempt at creating a macro to automate some manual tasks. Here is what I am trying to do...

On the attached workbook there are 3 sheets. "Original" is the source of the data, "Example Report" is a mockup of the result I would like to see, and "Attempt" is what I am working on so far.

My current strategy is to take the "original" items and remove all the things I don’t need, resulting in the list found on the "attempt" tab.

Then my thoughts was that I would create a new sheet, and iterate through the list and every time I encounter "Name" make a new column on the sheet and continue working my way through. (See "Example Report")

The trick is that I have no idea how to iterate through the list and move the data to a new sheet!

Any assistance is greatly appreciated.

-Kevin

Posted code to wrong reply

Something like this?

Please Login or Register  to view this content.

Note I have the code putting the output into a new sheet named "Report". you will need to make this sheet before running this code.

Are you going to run the code on the data as it appears in the "MacroFun" worksheet in the latest file you posted?

The code was written and tested using the "Original" worksheet in the first file you posted.

If you go back to your original attachment and run the code on the data in the "Original" worksheet it should work.

You Sir are amazing! Thanks for all of your great help!!!