dynamic named range

Hi,

I am having a few problems with dynamic named range in excel 2000.

When adding new data to the range, excel extends the range correctly, but only copies some of the formula correctly. It does not copy the formula that references a cell from another line.

I am trying to create a excel spreadsheet and have a formula =e10-e9, which does not copy down.

Any help provided would be gratefully received.


Thanks

Hi

By the sounds of it, you are not actually having any problems with your dynamically named range? I am afraid I am finding it difficult to understand exactly what problem you are experiencing. Perhaps you could show, by way of examples, what cells you are having trouble with (and what they contain) and what you think they should contain after you add new data to your row?

Originally Posted by RichardSchollar

Hi

By the sounds of it, you are not actually having any problems with your dynamically named range? I am afraid I am finding it difficult to understand exactly what problem you are experiencing. Perhaps you could show, by way of examples, what cells you are having trouble with (and what they contain) and what you think they should contain after you add new data to your row?

Hi, thanks for the response. I will try and provide more detail.

I have a formula which works out the trip distance by subtracting the latest odo reading from the last.

Column E has the odo readings listed. In cell G10 I have the fomula =E10-E9

The dynamic named range works for other formulas, but only from cells in that row, is this a limitation on dynamic ranges?

But where does the DNR come into play in this? Is it referencing column G?

Originally Posted by RichardSchollar

But where does the DNR come into play in this? Is it referencing column G?

Hello again,

I have added a sample spreadsheet.

If you add figures to the A12 to D12, DNR fills in H12 to J15 ok, but it does not fill in cells E12 to G12.

Thanks

Hi Compaq

Would you mind posting a message with what formulas you have in the cells (eg E3:J3) as when i open your file I get an error message saying some data has been lost (the formulas are replaced with #N/A, although the DNR exists and the data values in A:D are visible). Thanks!

Richard