Copying colums of formula and adding blank rows

Hi,
I have been told by some people that this cannot be achieved in excel so I thought this wold be the best place to disprove them.

I have data in column A from 1-1000

I want to reference this data to another worksheet within the same workbook, still in a column but with spaces in between each entry so we have
1
[space]
[space]
2
[space]
[space]
3
etc

If i was doing this for half a dozen cells then it would not be an issue as I would link them manually but with so many entries I wanted to "fill down" usin an automatic method but I cannot get it to work.

If anyone has any ideas, I would be very grateful. I can also go back to the people who said it couldn't be done and show them

Many thanks
TGB

Assuming you want the data to start in C1 in another sheet then put this formula in C1

=INDEX(Sheet1!A:A,ROWS(C$1:C1)/3+1)

leave C2 and C3 blank

Now select C1:C3 and fill down as far as required

this is a breach of the forum rules dll you should know better lol
1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change the title of the thread, click EDIT on the original post, then click the Go Advanced button, then change the title. If two

mmm....you're right Martin, going a little senile ....please change thread title as advised tallgingerbloke

See my previous post for one possible method.....