1
votes

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).

1

1 Answers

1
votes

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

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