Hi macro_noob3030

Probably the easiest way is not to use macros!

I am assuming that if there is data in column A, then there will be data in B through to (whatever) and likewise if there is nothing in column A then that row is completely blank.

Copy from sheet 1 A1 : last row last column to Sheet 2 B1

In column A number from 1 to last row used

Sort whole sheet on column B.

This will put all blank rows at the bottom of the data. Delete these rows

Sort whole sheet on column A (to put back in original order)

Delete column A

Delete Sheet 1

Save As (New name)

If you would like this automated by means of a macro, let me have a sample of your data and I will write such a macro

Regards
Alastair