Put in A1 and copy across:

=INDIRECT("Sheet2!A" & COLUMN())

HTH


"Dan Oakes" wrote:

This has got to be very simple but I can't seem to figure it out...

On Sheet1 "A1" I have "=Sheet2!A1"
On Sheet1 "B1" I have "=Sheet2!A2"
On Sheet1 "C1" I have "=Sheet2!A3"

What function or symbol can I use to drag this formula so it keep this
pattern?
Is it transpose?

Thanks,
-- Dan