CODEWITHSUNDEEP
excelcopyformula
Car Hibou
Car Hibou

Reputation: 1

Copy and paste formula in excel

Good morning everyone, I have sheet1 where I past information from SAP. In a second tab and for each line in sheet1 I have to copy paste 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

Upvotes: 0

Views: 63

Answers (1)

shrivallabha.redij
shrivallabha.redij

Reputation: 5902

Write following formula in Sheet2 cell A1:

=INDEX(Sheet1!A:A,CEILING(ROWS($A$1:A1)/6,1))

Copy down as much as you need.

Edit: Tweaked formula per OP's latest info which should go into cell F5 or whatever cell:

=INDEX(Sheet1!B:B,CEILING(ROWS($A$1:A1)/6,1)+2)

Notice

+2

which is added so as to start directly from Row 3 instead of Row 1!

Upvotes: 1

Related Questions