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
Bookmarks