In the attached file I have two columns labeled Product and Zip Code. I would like to be able to have a command button that deletes all blank rows when the value in a Zip Code cell is blank. The next think I need is to have an input box that allows me to select which zip code cells I want to move over one column. For example, in the input box I may want every 10th zip code moved for this file moved over 1 cell. For other files it may be every 5th. This will become a template and data will be copied and pasted into it.