Copy, Paste Cells in a range

[rawdog2222]

I have been banging my head through a wall trying to figure this thing out, so I am not reaching out for help. Here is what I need to do:

I have to copy company names in a range of cells to another worksheet and once pasted, then copy another row and paste it below. The hard part for me here is cycling through the company names until I reach the end. Another difficult part is need to offset by a row for each company for the final paste.

Below is what I have so far

Please Login or Register  to view this content.

[mike7952]

It would be best if you upload a workbook with what your trying to do. Show before and after.