Greetings! New member here. Thank you in advance for spending the time to help a perfect stranger who can't offer anything in return! I just received some awesome help from SKTNEER and SkyWriter; I'm feeling bold enough to ask for a little more, if you wouldn't mind.
I have a macro which generates a very long list of names, with corresponding data in two other columns. Printing this list wastes a lot of paper. Is there a way to organize it in two columns, so I effectively halve the amount of paper when printing? Please see attached example file. I know my "desired end state" example isn't correct; but it would be alright if I just printed with the "fit all columns on one page" option, like I normally do.
Please note: the "names" and "speeds" are all different on the actual report. I just used copied the one person a lot to make the example.
Some code which reorganizes the list after it's been generated would be easiest, because the macro used to get to this point is a beast; I'd rather not make anybody wade through all of it.
Bookmarks