copy the entire row n paste 3 times in the new sheet

chitra mr · May 13th 2016

Hi I have a requirement , if cell value d3=3, then copy the entire row n paste 3 times in the new sheet, if d4=1, then copy the respective row 1time in the new sheet, like wise it has to check the value in cell d of each row and copy the rows n insert the row as many times as the value in new sheet.
Help appreciated

**pike** · May 13th 2016

Re: copy the entire row n paste 3 times in the new sheet

Hi chitra mr,
Welcome to the forum .. I'll close this thread as it a duplicate to your first post
Ill also move your first thread from the newsletter forum to the excel macro forum and change the title

copy the entire row n paste 3 times in the new sheet

Participate now!

Share