can this be done simply ?

Giganews Newsgroups
Subject: can this be done simply ?
Posted by:  analyst…@hotmail.com (analyst…@hotmail.com)
Date: 10 Jun 2006

I have say 200 rows in sheet 1.

I want to copy row 1 sheet 1 to row 1 of sheet 2
                      row 2 of sheet 1 to row 10 of sheet 2
                      row 3 to row 19
                      row 4 to row 28

ROW i gets copied to ROW  9*(i-1) + 1

Thanks for any help.

Replies