Hi Bill,
Thank you for reply. Because of the numerous worksheets involved a VBA
solution would be more suitable.
Cheers,
Sam
Bill Renaud wrote:
Sounds like you are entering data in a list. I would just use Data|Form to
enter a new row of data. All cells above the new row that have formulas
will automatically be copied down. To copy a cell from the row above that
has a constant in it, press Ctrl+; (Ctrl+ semicolon) while in that field.
--
Message posted via
http://www.officekb.com