Inputting "N/A" into a cell when "Internal" is typed into another cell on the same row

[alexander.small]

Hi all,

How would I go about having my workbook so it automatically inserts "N/A" into column J when "Internal" is selected from the drop down list in column H?

I have attached a copy of my workbook to hopefully make things clearer.

Thanks,

Alex

[ARGK]

Hi
Put this formula into cell J11 and copy down:

=IF(H11="Internal","N/A","")

Tony

[alexander.small]

Hi
Put this formula into cell J11 and copy down:

=IF(H11="Internal","N/A","")

Tony

Hi Tony,

This didn't solve my problem but only because I didn't explain it clear enough. The formula works perfectly just not in my case.

The part I left out was that I have a button that inserts rows to the top of the table and I need this formula to work in the newly inserted rows as well. Can this be done with a formula or would I need VBA?

Still getting rep points from me as the formula was spot on, thanks!

[ARGK]

Hi Alex
Thanks for the feedback. I have modified your NewRow macro to include the formula in the new row that is inserted. It needs testing as I don't know how you are calling this macro so I couldn't test it.
Let me know if it works okay for you.
Tony

[alexander.small]

Did you modify it in the file I uploaded? Or did you mean I should put that formula into the macro and see if it works?

[ARGK]

Hi Alex
Sorry - I forgot to attach the amended file :-(.
Here it is.
Tony