I'm new to this macro business but I was able to create a sheet that functions 95% of how I want it to. My only problem now is that my sheet is 4 pages long, when it could very well be 2 if I can find a code to catch the page overflow and drop it into the C&D columns.
I have co-existing data in the A&B columns that I want to be caught and thrown to the C&D columns once it's hit the page break at the bottom of the document. For me it's data begins at Row 6 and ends around Row 56.
I'd like Row 56 - 112 to be automatically pulled from the A&B cols dropped into the C&D columns then 113 - 169 go onto Page 2 in the A&B columns and 170 - 223 in C&D columns and so forth.
Is this something I can easily do?
Currently I have everything listed in the A&B columns to run a macro code hiding all 0 or blank rows which works perfectly, but Ideally I need to move the overflow onto the same page into adjoining columns.