ANTONIO1981
Board Regular
- Joined
- Apr 21, 2014
- Messages
- 162
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:
QUESTION TO MR EXCEL_CREATE CONVEYOR TABLE.xlsb - Google Drive
thanks in advance
Anthony
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:
QUESTION TO MR EXCEL_CREATE CONVEYOR TABLE.xlsb - Google Drive
thanks in advance
Anthony
Last edited: