I need to have an input box or userform come up that prompts the user for a number that will be used as a multiplier. I then need that inputted number to be multiplied by whatever value is already populated in every cell in column I. The results are to be overwritten in those cells in that column. I'm certain I have made this sound more complicated than need be, but I've attached a worksheet that is representative of the data I will be working with.
In the attached, the Return Interest column (I) is what will need to be adjusted on occasion. There will always be a header and the number of rows will vary from day to day. So to reiterate, I need some sort of pop up box to ask for a multiplier, if the user puts 3, then each amount in column I will be multiplied by three and the result will overwrite what is currently populated.
Thanks a bunch for taking a look.
Paid 10% to Ozgrid Transaction ID 64T99994T5175930P