insert offset blank cell

I have a list of names in rows. Some rows use three columns, like for James Earl Jones. Others use two columns, like for Tom Jones. And some use four columns, like for Oliver Wendell David Holmes.

I want to be able to sort by last name, so I believe I need all the rows positioned with the last names in the right-most column, which I would then sort on.

To get the names lined up on the right-hand column, I think I need a macro that looks at the right-most cell. If the cell is blank, then the macro would insert a blank cell X columns to the left, moving the cells with names to the right. The macro could be run repetitively until there were no blank cells on the right side.

Help?

Hi

Here goes.

Please Login or Register  to view this content.

rylo

Thanks. It ran, but no cells moved. Oh, well.