Macros

Closed
saratexas2001 Posts 1 Registration date Monday July 17, 2017 Status Member Last seen July 17, 2017 - Jul 17, 2017 at 10:41 AM
I have a spreadsheet of 15000 lines, I need to copy the Cell ranges B:E onto the next line B:E, then go down to the next populated cell and do the same eg

Invoice T-425 T-425 Latest 06/02/2015




Invoice LSE-4349 LSE-4349 Latest 11/02/2015


I need to be

Invoice T-425 T-425 Latest 06/02/2015
Invoice T-425 T-425 Latest 06/02/2015



Invoice LSE-4349 LSE-4349 Latest 11/02/2015
Invoice LSE-4349 LSE-4349 Latest 11/02/2015