First question:
How can I notify the user of an increase above 20%. Cell AD7 will contain a figure based on the input of E7/D7, in cell AE7, it will contain a figure based on the input of G7/F7, cell AF7 will contain a figure based on the input of I7/H7. What I need is to notify the user if AE7's content is 20% more than AD7, I don't want to use Conditional Formatting because I want to allow the user the oportunity to check the entries and change them if entered incorrectly. So, if cell AE7 is 20% more than AD7 then msgbox or warning appear to notify them and ask if to accept the new figure or re-enter. Cell AF7 will also need to have this figure if its content is 20% more than AE7s and then two others AG7>AF7 and AH7>AG7.
Second question:
I have the code the insert a new row that will be attached to a userform. My problem is that after the new row is added, my formulas have to be changed manually. I have one cell that multiplies say b7*c7=b8*c8 all the way down to b23*c23. I can't use the sum function because the cells in column c each contain a different figure. And when the new row is added I have to manually update the cell with the added rows b*c.
Any easier way?
Thanks,
How can I notify the user of an increase above 20%. Cell AD7 will contain a figure based on the input of E7/D7, in cell AE7, it will contain a figure based on the input of G7/F7, cell AF7 will contain a figure based on the input of I7/H7. What I need is to notify the user if AE7's content is 20% more than AD7, I don't want to use Conditional Formatting because I want to allow the user the oportunity to check the entries and change them if entered incorrectly. So, if cell AE7 is 20% more than AD7 then msgbox or warning appear to notify them and ask if to accept the new figure or re-enter. Cell AF7 will also need to have this figure if its content is 20% more than AE7s and then two others AG7>AF7 and AH7>AG7.
Second question:
I have the code the insert a new row that will be attached to a userform. My problem is that after the new row is added, my formulas have to be changed manually. I have one cell that multiplies say b7*c7=b8*c8 all the way down to b23*c23. I can't use the sum function because the cells in column c each contain a different figure. And when the new row is added I have to manually update the cell with the added rows b*c.
Any easier way?
Thanks,
