Hello,
I've attached an example of my problem. Not sure where to start - your help much appreciated in advance!
Table 1 provides a unique ranking (driven from) elsewhere in my model but the cells will be formula based.
Table 2 is what the macro aims to calculate with each loop (see formula in cells). The loop is to start at 1 and go until the value in cell F6.
Table 3 is continually overwritten after each loop, (example output shown depending on cells B6 and G6).
I couldn't find a clear example elsewhere so i really do appreciate your help!
cheers,
m
Bookmarks