Macro to Copy tanspose data to another sheet

[danallamas]

I need to copy transpose data vertically to another sheet and duplicate the same company name. Is there a macro that can easily do this?

[walruseggman]

This assumes the company names are in the same order on both sheets, and that all the companies on Sheet1 are also on Sheet4, and vice versa. If that's not the case, I can modify the code.

Don't forget to change the worksheet names of ws1 and ws4 in the code to match your actual worksheet names if they are different than the example you posted.

Please Login or Register  to view this content.