adding rows and populating them with data from other columns

S

shirley

i need to add 10 empty rows after each non-empty row and copy data fro
other columns and paste it within the empty row. how should i go abou
doing it
 
P

papou

Hi Shirley
Are you copying data from the same sheet within the same workbook?
How many columns are involved?

Cordially
Pascal
 
Top