On Mon, 17 Aug 2009 16:54:01 -0700, joemomma
wrote:

I have a question about the formula. I just set up sheet 2 to match th
ings entered in sheet 1 but my formula is =Sheet1!A2 not =Sheet2!A2

He was showing you which cell to put the formula in. The formula
itself STARTS at HIS equal sign.

LOOK again.

I'll strip his 'pointers' away.

=INDEX(Sheet1!$A:$A,ROW())

=INDEX(Sheet1!$B:$B,ROW())

And if column deletion could also be an issue,

=INDEX(Sheet1!$1:$65536,ROW(),COLUMN())


Now, the reference you claimed was wrong is merely the location where
he wants you to place the above strings.