Adding next row of formulas

[Lee]

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

 

[AAM]

when enter is pressed

Pick a different hotkey and write a macro to copy the formulas. You could
even have the macro check for where the active cell is to make sure it
wasn't fired at the wrong time

If you want to stick with Enter as a hotkey, there's probably a way to do
this with an event handler.

 

[Shane Devenshire]

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.

 

[Lee]

Thanks, your suggestion is working great.
Lee

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