More info.

Having worked through the problem I now have all of the math required. But no idea how to automate the output.

https://www.filehosting.org/file/det...xampleIOB.xlsx

This can be used to download the small sample sheet i made.

You will notice that on the Input sheet there are many rows. The calculations for the first 2 rows ive done in the Output, ive left the formulas in their.

There are 8 output rows for each individual row in the input sheet.

Hoping someone with some smarts can help me automate it to let it run through a whole list and output accordingly.

Thanks again.

## Like this thread? Share it with others