Thank you my bad! been practicing on 2 little sheets sheet 1 (master1),
sheet 2 (fill1). inserting the formula per the instuctions works fine. sheet
1 is the main sheet where data is added or changed. When I insert a row in
sheet 1 the formulas on sheet 2 are intact, but it doesn't insert a row in
sheet 2. Joe

"OutsideObserver" wrote:

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.