One way

Assuming in Sheet1,
H9:K9 contains the values: 1,2,3,4

In Sheet2
-------------

Put in any starting cell, say A2:

=OFFSET(Sheet1!$H$9,,ROWS($A$1:A1)-1)

A2 will return the same as: =Sheet1!H9
i.e. the value of 1

Copy A2 down to A5

As you copy down,

A3 will return the same as: =Sheet1!I9
A4 will return the same as: =Sheet1!J9
A5 will return the same as: =Sheet1!K9

i.e. A2:A5 will return the values: 1,2,3,4
from Sheet1's H9:K9

Adapt to suit
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Ken" wrote in message
...
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.