You were correct that I needed one more column to catch all the data
which I added and now have it working. Ther is one more thing that I
wonder if it is possible to add. When the macro is run could all the
columns with the 170"s be deleted along with the header?