Macro to Count and Mark Items for Printing on Roll

[elgato74]

Dear All,

please have a look at the attached file.

This list is for printing posters on a plotter with paper rolls of 17.3 meters length. The images have a specific length which is marked in the columns E-H. I would like a Macro to count the images' length and then mark (e.g. Underline ) the last poster image that can fit on the first roll.

Then start to count the remaining ones for the second roll, then third roll etc...

Naturally, it will not always come out even to 17.3 meters, but that does not matter as long as they fit on the roll. So if the result of adding the first 12 items up is e.g. 17.4 meters, it should underline item # 11 and the start to count again with #12.

I hope i explained it well

Thanks so much for your help !

Felix