I need a relatively simple VB script/macro to be coded for me please.
I have 9 product lines (including the grand total column) in the attached spreadsheet which contain revenue generated data. I need each of these product columns ranked in order of highest to lowest and then a new column to be inserted next to that product line column.
In that new column should be the cumulative values of all of the figures, dragged down to the last row in that column.
Example from attached spreadsheet
A new column should be inserted after the column titled Oranges (lets call the new column Apples ranked cumulative. The first cell (the new D2) would be 1,015,334 whilst the second one would be 993,932 + 1,015,334 etc all the way down. The data in this new column should also be saved as a value and not relative, because the same should be replicated for the other columns with their titles shown using the above procedure, this way when the columns are reordered the values in the new column will not change.
Oh and please name the macro "PR"