Would it be possible to add a feature that, if you select DivTa in the TransType, and then enter the SymbolName, the Qty field would auto-populate from the QtyHeld column?
This is good helpful idea, but not easy to implement. The problem is with Excel - column can be either calculated or you enter the data. Based on your suggestions that Qty column would be sometimes calculated and sometimes free to enter - and that would cause too many confusions. So I do not believe I can "elegantly" do that.
Comments
The problem is with Excel - column can be either calculated or you enter the data. Based on your suggestions that Qty column would be sometimes calculated and sometimes free to enter - and that would cause too many confusions. So I do not believe I can "elegantly" do that.