Duplicating data from one sheet to another

Hello.

I am attempting to duplicate data from the first cell in each row in Sheet1 to the first cell in 6 rows in Sheet2.

I want to do this for each row in Sheet1. For example, I want to take cell A1 from Sheet1 and copy what was in that into Sheet2 into cells A1-A6. Then I want to take A2 from Sheet1 and copy what was in that into Sheet2 into cells A7-A12.

Is there an easier way to go about doing this? I have too many rows in Sheet1 to do this by hand.

Edit: I know the formula for getting a value from Sheet1 and put into Sheet2 cells A1-A6: =(Sheet1!A1)

Do you mean that you want Sheet1!A1 to be repeated 6 times in A1:A6 of Sheet2, then A2 of Sheet1 to repeat 6 times in A7:A12 of Sheet2, and so on?

Pete

EDIT: I see that Ace has made that assumption, though you just need to change his Sheet2 to Sheet1.

Pete, that's correct. How can I modify the formula because I just added a title row. So the entries start at A2 for both sheets.

Change the formula to this in A2 of Sheet2:

=INDEX(Sheet1!A:A,INT((ROW(A1)-1)/6)+2)

then copy down.

Hope this helps.

Pete

Thank you so much!