HI,
I have one workbook with 8 spreadsheets on it.
7 sheets refers to the days of the week and the 8th one is for the calculations.
On each sheet I have:
Column A with names of 5 buyers represented by numbers from 1 to 5;
Column B with 10 products represented by numbers from 1 to 10 ;
Column C with quantities of the products purchased.
On spreadsheet 8 I need a report for the products purchased.
I need to know for instance:
how many for product 1 was purchased on Monday by: Buyer 1 = 3, Buyer 2 = 4, Buyer 3 = 5
So it should be something like:
Column A: PRODUCTS from 1 to 10
Column B: TOTALS, for instance: 12 for product 1 (3 + 4 + 5)
ATT: I need to know only the purchases from Monday spreadsheet.
I have one workbook with 8 spreadsheets on it.
7 sheets refers to the days of the week and the 8th one is for the calculations.
On each sheet I have:
Column A with names of 5 buyers represented by numbers from 1 to 5;
Column B with 10 products represented by numbers from 1 to 10 ;
Column C with quantities of the products purchased.
On spreadsheet 8 I need a report for the products purchased.
I need to know for instance:
how many for product 1 was purchased on Monday by: Buyer 1 = 3, Buyer 2 = 4, Buyer 3 = 5
So it should be something like:
Column A: PRODUCTS from 1 to 10
Column B: TOTALS, for instance: 12 for product 1 (3 + 4 + 5)
ATT: I need to know only the purchases from Monday spreadsheet.
Last edited: