Ken,
Try taking the dollar signs out before you copy the formula.
The dollar signs make the formula absolute, which means that no matter where
you copy it to, you'll always be referencing the same cell.
This is fine where yu want to, for example, always reference one cell in a
formula that might, for example, contain a currency conversion factor that
you want to apply to a range of cells, but not, I suspect, in what you're
trying to do.
Hope this helps
Pete


"Ken" wrote:

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.