CODEWITHSUNDEEP
excelrowformula
Vawn Harvey Galanza
Vawn Harvey Galanza

Reputation: 23

Excel row increment formula

Can someone help me with excel about the formula row increment. I have a sheet (I6)Column and im copying a data on another sheet (H138)Row, what i need to do is copy I6 column down (I7,I8,I9) that will follow and have the data on the other sheet which is (I138,J138,K138).

The current formula the excel giving me is (H139,H140,H141).

Upvotes: 1

Views: 102

Answers (1)

user4039065
user4039065

Reputation:

Try the OFFSET function using ROW to increment the column as you fill down.

=offset('Other Sheet'!G$138, 0, row(1:1))

Upvotes: 1

Related Questions