Hi all,
I'm in the process of creating a macro to produce a report but i have come upon a stumbling block and have absolutely no idea how to get round it (although i'm sure its much simpler than it is in my head).
I have a single column of data, example is shown below, where i need to create a set of percentages from the data immediately above each total. The number of cells in each subset vary, the gaps between the data subsets vary by either one or two empty cells and the total is always in bold. I'm looking for a macro that gives the percentage of each cell from the cell at the base of the subset.
An example of the data and the manually completes percentages are below.
6 23.1%
9 34.6%
11 42.3%
0 0.0%
0 0.0%
26
7 43.8%
5 31.3%
4 25.0%
16
11 17.5%
4 6.3%
10 15.9%
3 4.8%
12 19.0%
7 11.1%
9 14.3%
7 11.1%
63
6 22.2%
6 22.2%
8 29.6%
7 25.9%
27
Any help would be much appreciated.
Thanks Guys.
Bookmarks