Formula ? on scrolling down

[zone709]

Hi I am trying to scroll down all 3 at once and only change the number going from 8 9 10 11 leaving the letters the same. I cant figure out a way to do this and been copying and pasting and taking forever.


=IF(Data!I8=0,TEXT(Data!I8,""),Data!I8)
=IF(Data!J8=0,TEXT(Data!J8,""),Data!J8)
=IF(Data!K8=0,TEXT(Data!K8,""),Data!K8)

So next 3 rows I would need it to look like this and go to 9

=IF(Data!I8=0,TEXT(Data!I9,""),Data!I9)
=IF(Data!J8=0,TEXT(Data!J9,""),Data!J9)
=IF(Data!K8=0,TEXT(Data!K9,""),Data!K9)

and after this 10 then 11 and so on

Any help would be great thanks​

 

[zone709]

can this be done by scrolling down. Right now I am copying 3 rows in column L and pasting it down they replacing the number. I have 3000 rows to do so its annoying.