To copy, move, and then delete old row of data left.

In simple English, what is the worksheet supposed to do? Explain as much as you can if you don't mind.

Thanks,

Originally Posted by Kelshaer

Use this:

Please Login or Register  to view this content.

Ummm, I hate to say it, but it didn't even come close to do what I wanted... It just moved everything over left, the format has to stay the same. B has to be the first row, that being said, it didn't delete any of the copied rows either.

Originally Posted by 111StepsAhead

In simple English, what is the worksheet supposed to do? Explain as much as you can if you don't mind.

Thanks,

I already have.... but I'll repeat if I have to.

The script I have written copies all columns not directly next to each other over to the first left empty column it finds... what I want it to do is that once it has copied the columns over to delete the original so it isn't left there after the script has run.

That is as simple as I can get. Also the script has to be simple and straight forward like mine, because this is going into a much larger script, and must be self explanatory 3 months or 6 years down the road by just looking at it.

Originally Posted by Kelshaer

Sorry Cyberpawz but nothing in your original post says that you want to move or delete rows as well.

Actually I said columns, not rows, I can delete columns without issues... I thought I was quite clear.

If you see it is meant to run specifically in columns B through N. It copies everything over to the left, but it doesn't delete the old column's data... that is the part I need to finish.

That being said, I am still stuck.