copy paste from one sheet to another via formula

[guismo30]

Good morning eveyone,

I have sheet1 where I past information from SAP. In a second tab and for each line in sheet1 I have to copy past the info on 6 lines What I did is cell A1 of sheet 2 is "=sheet1!A1" cell A2 to A6 "=A1", ="A2" etc..
Problem is, I have about 500 lines in sheet one, and when I try to copy past the formula, in the cell A7, the "=sheet!A1" becomes "=sheet!A6" where I need it to be "=sheet!A2"
Could someone help me please ?
Thanks a lot for the support Pierre

 

[Ryeera]

If I understood your question correctly, try the following: Into the first six rows, enter "=sheet1!A$1", "=sheet1!A$2", and so on until you reach 6. Then select these six cells, grab the little dot on the bottom right of your selection and drag it down. Then it should repeat these cells over and over again.

 

[guismo30]

If I understood your question correctly, try the following: Into the first six rows, enter "=sheet1!A$1", "=sheet1!A$2", and so on until you reach 6. Then select these six cells, grab the little dot on the bottom right of your selection and drag it down. Then it should repeat these cells over and over again.

Thanks a lot, it help a lot