Formatting columns along several spreadsheets

[payrollgal]

Hi,

This might seem like a very simple question, but I've completely forgotten how to do this the easy way...

I have a VERY LONG excel sheet with only two columns of data that cover about 100 pages.

I want to be able to roll those two columns over to additional columns within the same page or pages, in order to shorten the amount of pages.

I can only think of cutting and pasting, but that seems rather tedious and I'm also afraid of either losing the data or messing it up by doing it this way.

I want the data to stay in a specific order, but just to be rolled over to additional columns until one page is completed filled. Then it will start again on the next page until that page is completely filled, etc.

Also, I want to be able to include the titles of the columns on each column...

Can you help?

[VBA Noob]

payrollgal,

Please read forum rules below and then amend you're title

VBA Noob