Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

I figured out how to somewhat automatically do it with macros. In the Range selection box type Sheet1.A1:A123455 and copy that, then go to sheet 2 A1 and paste. And repeat for every column...

Can't figure out how to get it to create the new sheet automatically though.

I figured out how to somewhat automatically do it with macros. In the Range selection box type Sheet1.A1:A123455 and copy that, then go to sheet 2 A1 and paste. And repeat for every column...

column... Can't figure out how to get it to create the new sheet automatically though.

Pretty sad that such a useful function isn't present