=OFFSET(INDIRECT("'"&$A37&"'!ar76"),,COLUMN($A:C)-1)
"AR76" does not change to "AS76"

In the start cell, ie the first formula cell that you propagate the formula
from, the incrementer part: COLUMNS($A:A) in the expression must remain
unchanged. So it should be this:
=OFFSET(INDIRECT("'"&$A37&"'!ar76"),,COLUMN($A:A)-1)

But I'm not sure if your set-up/requirements have changed since,
based on your line:
"AR76" does not change to "AS76"

AR76 is fixed, yes, but it's just an anchor cell ref in each tab name that
you have running in A2 down. The "col" incrementation in the earlier
expression is done by the part: COLUMN($A:A)-1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"aMack" wrote:
Max: Thanks.

Getting close - The 1st column works - "B"

The second column "C" gives me the same resuilts as column "B".

=OFFSET(INDIRECT("'"&$A37&"'!ar76"),,COLUMN($A:C)-1)


"AR76" does not change to "AS76"