HI all

i need to automate the creation of the following table "tab R_conveyor_table"

How is calculated?:

Each site in "tab Volumes" has a month and amount

we need to multiply in each month: each site volume, per programme %, per price, in "tab R_conveyor"

example site 1 Amount in January = 4702.6 * 59% *3.75 = 10,404 (cell E2 in Volumes* cell C2 in R_conveyor* Q2 in R_conveyor)

the number of rows in tab volumes and R_conveyor can increase substantially

Shareable link: https://drive.google.com/open?id=0B6...U9HblhIWlQwMWs


thanks in advance

Anthony