Buckwheat

Any problem with having macros in your workbook?

David McRitchie's Insert Rows and Fill Formulas code will do that.

http://www.mvps.org/dmcritchie/excel/insrtrow.htm

If the column formulas are just a Function like SUM at the bottom you could
use

=SUM(A2:INDEX(A:A,ROW()-1)) A2 so's you can have a column title.

Drag/copy across columns.


Gord Dibben Excel MVP

On Mon, 2 May 2005 15:32:01 -0700, Buckwheat
wrote:

I have created a spreadsheet for the sales people at our company and it seems
to calculate everything fine. My question is, since I only formatted rows 1
- 25 with formulas for each column in those rows, if more rows need to be
inserted once I turn this over to another dept, what can I do now, so that
when they add those extras rows, that the formula for each column will also
be there for those rows?

TIA,
Buckwheat