Macro triggered by changing the values in N4
Code multiplies each value in Col E by N4, shows results in Col G, adjusts Outstanding Balances in Col I, and shows % invoiced in Col H (As there are no "Prior payments" in the example attached, Col H should match N4)
Problem:: % entered is not what comes out on first attempt. Have to enter it again.
E.g. Enter 3% in N4, Col H applies 100%, making Cols G and I incorrect. Enter again, Col H now shows correct values of 3%. and Cols G and I are correct).
Never had this before, and can't see where the "error" can be?
All solutions, suggestions and alternatives welcome as ever
Ochimus
Bookmarks