This should be fairly easy, but I am not familiar with progamming a macro. I have the following data:
NH5101
NH5104
NH5106
NH5107
There are many more lines after these, but I'm using this as the example. I want to start at NH5101, insert 4 more lines and copy down. So that the data ends up looking like this.
NH5101
NH5101
NH5101
NH5101
NH5101
NH5104
NH5104
NH5104
NH5104
NH5104....
I need 5 lines of each. All the data is in one column and it is the only data on the sheet at this point. I'm using Excel 2003. Thanks
Bookmarks