G

#### Guest

=INDEX('[customer price level4.xls]Sheet1'!$A$2:$C$2,3)

I have the formula in C2 and trying to copy the formula in the column

C3..c1000, but when I copy it or use fill down, then it doesn't change.

Example:

C2 =INDEX('[customer price level4.xls]Sheet1'!$A$2:$C$2,3)

C3 =INDEX('[customer price level4.xls]Sheet1'!$A$3:$C$3,3)

C4 =INDEX('[customer price level4.xls]Sheet1'!$A$4:$C$4,3)

C5 =INDEX('[customer price level4.xls]Sheet1'!$A$5:$C$5,3) and so on....

I will be doing this often and the range will change every week. which is

no problem but I need to be able to copy the formula and have it adjust to

the cells w/o me having to go to each row. I thought when you copy it

normally did that? Is it my formula? I am new to using Index. Also, the

source sheet has 16 worksheet. Tabs sheet1, sheet2, and so on until sheet16,

and from a1..c65536. So I need to adjust my range also, but I was doing a

test range. But I am not sure how to reference several worksheet in one

workbook?

Thanks for any help and hopefully today!! Need to have the 1st spreadsheet

done today.