Is it possible to do something in the worksheet change event so that when the user inputs a value it does the math calculations.
if range(D,Activecell.row) then
range(E,Activecell.row) = range(D,Activecell.row) * 200
I tried something like the above, but got memory errors ...
I'm getting super frustrated with locked/protected sheets, insert not copying formulas etc.. I'd rather just 'control' the happenings of the spreadsheet from one place.