Hi, I would like to carry out an IF function so that if one cell has a text
of " Note", text of "N/A" is put in another cell ie =IF(C28="Note","N/A",
""), but I want to do this in VBA so that I can still type in the cell that
the answer would be put into, ie if the text isnt "Note" I want to be able to
manually write other text or values in the cell. I want this to be automatic
without running macros, so that "N/A automatically appears if "Note" is
written is the reference cell.
VBA is not my strong point but I'm guessing that an IF statement can be used
on the correct sheet in Excel objects.