I am looking for a macro that would automatically calculate the relative percentage for all values in a selection. I need two inputboxes, the first one to select the range of cells to be analyzed, and the second one to select the top cell to paste the percentages. Below is an example of what I am looking for...


Before macro After macro
25 25%
35 35%
40 40%

Thanks.