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