Hi there

How can I auto fill a series of values that equals a series of cells from
another sheet?
The cells I want the information to come from a row in another sheet and are
going into a column.
the references of the host cell are
'!AH$9
when I fill down using the plus sign at the bottom corner it just copies
this reference to each cell instead of
filling the values '!AI$9 then '!AJ$9 etc.