I would like to add the following procedure to my personal.xlsb
When I add a formula in a specific range: In my example attached C1. I would like, instead of dragging manually the formula, to have a procedure that cover the following requirement:
1-Display inputbox that says "Select the cell in which is your formula
2-Fill formula till the last used range. Last used row number should take into account the last used range of the sheet.
I attached an example with my initial data: Input sheet and with the final result Final-Result sheet after I run the procedure.
If you have questions, please contact me.