Thanks know how to do that. The problem is there are lines separating the columns and so it will only do a few. Every page I copied from my account came up as a different page. I have almost 900 items so there are a lot of page lines. It's almost like a set of tables. Don't know if I'm making myself clear here. I need them all in one table, not separated. Even tried copying the entire worksheet and re-pasting but it still keeps those breaks.
Marque