I have spent much time this morning trying to find the answer to my question. So far no luck. Maybe you can help.

I have 2 sheets in a workbook.
Sheet 1 is called PChart.
Sheet 2 is called Defect Sheet.

Defect Sheet, Cell E8 has a value of 5. Cell E9 has a value of 10.
In the Sheet called PChart, I want to write a formula that references the values in row 8.

If I type the following formula ='Defect Sheet'!E$8, I will get the result of 5. This is correct.

The problem is that if I try to copy this formula down the column on the PChart Sheet, I get the same results of ='Defect Sheet'!E$8, I will get the result of 5.

This isn't what I am after. I want the formula to be ='Defect Sheet'!E$8 for the first row and on the next row for it to be ='Defect Sheet'!F$8.

Thanks
Barry Givens
bgivensatasmo-na.com

--
Message posted via http://www.officekb.com