copying Cell References in Reverse

[HowardC]

I have a formula in a sheet named summary containing the following formula in Cell C3 =Sheet1!AG152 if I copy this formula to D3, it must appear as =Sheet1!AF152 etc

Your assistance in developing a formula that will allow me to do this when copying will be appreciated

[mbarron]

You try something like this:

=OFFSET(Sheet1!$AG$152,-ROW()+3,0)

[AndrewKKWalker]

I suspect you mean

=OFFSET(Sheet1!$AG$152,0,-COLUMN()+3)


Placed in D3 and then Copy RIGHT.

[mbarron]

Yes i did