I know how to use IF statements to have do calculations or insert text or
numbers based on whether the IF statement is true or not. Is it possible to
construct an IF statement that would physically change the spreadsheet? For
example, IF <something is true insert a row? Or do you have to get into VBA
to do things like that?