Originally Posted by shrek

Hi there

I have a workbook that has data in columns A- H and in column H some are marked "North"

What im trying to do is there the word "north" ends in column "H" I need all the following data in columns A-H moved to columns J-P.

Any help appriciated