R
RichLorn
When I add a new row within my list, I need to have formulas inserted
automatically in columns of that new row to coincide with similar existing
formulas. In other words, if I add a new row and go to the columns that
should contain the formulas, I need to be able to perform the equivilent of a
manual "EDIT > FILL > DOWN" operation, automatically.
I tried setting up a macro to do it, but the macro will only store the
specific row number the macro was created with. I need it to perform on ANY
row number I chose to add. (Possibly using the ROW() function in some way?)
Excel 2000, Windows 98se
automatically in columns of that new row to coincide with similar existing
formulas. In other words, if I add a new row and go to the columns that
should contain the formulas, I need to be able to perform the equivilent of a
manual "EDIT > FILL > DOWN" operation, automatically.
I tried setting up a macro to do it, but the macro will only store the
specific row number the macro was created with. I need it to perform on ANY
row number I chose to add. (Possibly using the ROW() function in some way?)
Excel 2000, Windows 98se