Hi,

This formula has suddenly stopped working!

One of the cell references has changed but that is i.e. Used to be BE16 now it is BE2.

The cells I need info from are:- BE2, BH2, BK2, BN2 etc (these are on a tab called Modules)

And I need this info to appear in cells:- A5, A6, A7, A8 etc (these are on a tab called Summary)

The formula I have looks like this:-

=OFFSET(Modules!$BE$2,,(ROWS($5:5)-1)*3,,)

and the only thing that changes as you move down the rows is ($5:5) which goes as follows:- ($5:6), ($5:7), ($5:8), ($5:8) etc.

The formula used to pull the correct info but it is now just repeating what is in BE2 and not pulling what is in BE2, BH2, BK2, BN2 etc

Help! :-)