Adding next row of formulas
 

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

Adding next row of formulas
 

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.


"Lee" wrote in message
...
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

Adding next row of formulas
 

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

Adding next row of formulas
 

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