First of all I'd like to apologize. I've seen a few threads addressing my issue but I'm unfamiliar with code and cannot figure out how to modify it to fit my specific data. I have 5 columns of data. (A-E) I'd like to look at the value in column D and insert 1 less number of rows directly below the data and then copy the data for the entire row down. Example: If value in column D=4, I'd like to insert 3 blank rows and then copy down. If value in column D=1, no additional rows needed. Any help would be greatly appreciated.