I have numerous spreadsheets that only initially has data in 2 columns
(Column A and B) and each spreadsheet has numerous rows.

I currently have to do the following:-

1. Select from rows 51 to row 100 and cut and paste into columns C and D.

2. Select rows 101 to 150 and cut and paste into columns E and F.

3. Select rows 151 to 200 and cut and paste into columns G and H.

4. etc. etc. etc.

As one can see this is a fairly routine and repetitive and therefore fits
ideally for a macro.

I have tried to record a macro but as the number of initial rows in Columns
A and B differs every time, the macro is not is not running correctly.

Additionally, I also have spreadsheet that I need to do exactly the opposite
to the above (i.e. I have multiple columns and I need to cut and paste the
values from columns C and D, E and F etc. etc. etc into the end position of
column A and B.

If anyone can help to create the perfect macros, then I would appreciate
their assistance.