I've gotten this far, in where I can get the code to copy from one column to another, but I need two other functions and I don't know how to get them working with the code I have now. I've been reading over the internet, trying to learn what I can but a lot of the sites out there are VBA for Excel 2003 and it seems that the 2007 sites, well do things not exactly complete, I am using Excel 2010 at work and Excel 2011 at home, so I am getting mixed messages about what to do since VBA in Excel 2003 and 2007 never mind 2010 is is different.
Here is my code, as I said before I've gotten it to where it copies and pastes, I thought I could delete and paste but it seems that VBA doesn't work that way, or if it does I haven't found out how.
The other thing I need to try to get into this code, is make it where I can choose which row to use as an identifier, so that it could be row 6, row 7, etc, and then finish the rest of the script as described above.
Any help would be greatly appreciated.
Option Explicit Sub MoveColumns() Dim cel As Range With Sheets("BackOrder") For Each cel In Intersect(.UsedRange, .[B6:N6]).SpecialCells(xlCellTypeBlanks).Cells Next End With End Sub
This post has been edited by MattRidge: 11 April 2012 - 06:02 AM