Thanks, your suggestion is working great.
Lee
"Shane Devenshire" wrote in message
...
Hi,

It would be much nicer is you showed us your data layout. But...
Highlight
your range with one row of titles and press Ctrl+L, click OK. Your range
is
now defined as a List. If you move down to the first blank row in the
list
and enter data the formulas will fill down automatically.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Lee" wrote:

I have Excel 2003 at work and want it to add the next row of formulas
when
enter is pressed on the last column that contains a formula. Is there an
easy way to do this? At present I have a bunch of rows and columns with
formulas and no data. I used sumproduct to calculate totals based on
criteria and I think I can reduce the calculate time by adding dynamic
ranges. This workbook is used by 2 of us and the other person has even
less
experience than me.
Thanks,
Lee