I made this little macro this morning which may help someone who visits this forum

I don't know if this is an efficient way of doing this but then again I'm only a beginner so I have an excuse 

Please Login or Register  to view this content.
This swops the data between the end columns of a selected range.