Hi,
I'm working on analysing and comparing different forecasts by plotting them together in a normal distribution chart for a data of over 2-3 weeks.
I'm in need of a macro that can loop through every alternate column and perform four tasks such as:
(1) Shift every alternate column to the right (there is a data over several columns), starting from column C
(2) Look for an empty cell below the column on the left (unshifted, e.g column B) and calculate the mean and standard deviation.
(3) Sort the column on the left (increasing order) and populate every empty column on the right (created in the first step by shifting every alternate column, e.g. column C) the normal distribution function calculated from the cell values of the column on the left, its mean and standard deviation.
(4) Plot the normal distribution chart of a few columns(8-9) in the same graph, and this for several worksheets.
This macro would need to run on several worksheets, which can't be carried out manually anymore. I've been able to solve some small VB tricks before, but this seems a bit hardcore and complicated for me, that's why I need your help greatly.
I'd really appreciate any kind of help or advice.
This Image shows the awaited result using the Macro: Awaited Result Macro.jpg
----
Sanjeev Pandey
Bookmarks