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

basically I have 5 columns which may need to have a formula in but the
will not all want the formula for every row, some rows will need to b
set to N/A. The problem then is that when someone inserts a new ro
underneath, I am guessing excel will not put the formulas into al
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 past
formulas into the new row.

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

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

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