Originally Posted by beefcake

I just tried doing this. The problem is, that when I delete the previous column, the cell turns into this "#REF!"

With the original column gone the data disappears,

what I am trying to do is this.

I have catalogs from my companies of products I sell.

I want to be able to add lines at the same time.

Here is a pic of what i'm trying to do, except 100's to 1000's of items with different lines of text.