I am trying to copy and paste down the spreadsheet. The customer name is only on every third row or so. I need the VBA code that will copy data from the first occupied cell in Column A and paste down to the next occupied cell. I need this copy command repeated for every new customer that occupies Column A. Help! Thank you!