Hi
a solution for inserting rows with formulas:
http://www.mvps.org/dmcritchie/excel/insrtrow.htm

-----Original Message-----
What I need to be able to do is have a dropdown in the
cells in a row
where you can either select the cell value to be set
as "N/A" OR set
the cell to be a given formula. Is this possible?

basically I have 5 columns which may need to have a
formula in but they
will not all want the formula for every row, some rows
will need to be
set to N/A. The problem then is that when someone
inserts a new row
underneath, I am guessing excel will not put the formulas
into all
those 5 columns because the cell above it might have been
set to N/A,
meaning the users are going to have to keep trying to
copy and paste
formulas into the new row.

So I either need a way for the user to simply select N/A
OR select the
formula for each of those cells from a dropdown, or i
need to
automatically put the formula into those 5 columns every
time a new row
is inserted, and then the users can overwrite it with N/A
if needed, so
they wont have to copy and paste anything.

Anyone know if any of this is possible? if not whats the
easiest way to
do it? I need to make it quick and easy for people to
enter new rows
without having to muck about copying formulas.


---
Message posted from http://www.ExcelForum.com/

.