Hey everyone,

I am working on what seems to be a difficult macro and I do not have any clue where to start.

I have one document that has a table of information, about 50-100 lines on a given month

I want to loop through each row and place each cell on each row into another sheet(sheet1) (where it corresponds) then when the loop goes through the row and finishes, I want to create a new worksheet(sheet2) with the same outline as the current sheet(sheet1) (so each sheet will look exactly the same but with different information)

each time the row ends or has a blank, then I want to move to the next row and place information from row 2 into another worksheet(worksheet 2).. row 3 to worksheet 3 and so on.

I am looking for help and with it being copied and placed into another worksheet we can begin with B1 and go down.. just need to get an idea of how to write this macro.

Let me know if that makes sense.

Please see attached documents

any help would be appreciated