adding rows and populating them with data from other columns
 

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

--
Message posted from http://www.ExcelForum.com

adding rows and populating them with data from other columns
 

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

Cordially
Pascal

"shirley " a écrit dans le message
de ...
i need to add 10 empty rows after each non-empty row and copy data from
other columns and paste it within the empty row. how should i go about
doing it?


---
Message posted from http://www.ExcelForum.com/

adding rows and populating them with data from other columns
 

yes, the copy and paste is within the same sheet. i'm looking at abou
140 column

--
Message posted from http://www.ExcelForum.com