Hi Stephen, thank you for your help. The code for switching from 2 columns to lets say 3 or 4 is not working for some reason. I have attached a spreadsheet to show you what i am talking about. if you time i would appreciate it