I am trying to work out the value of sales for each individual sales person per month per nominal code.
In the attached spreadsheet are the following worksheets:
Sales = Sales of ink cartridges from 01/04/2010 'Nominal_Code' is what splits up certain types of ink cartridges and 'Analysis_1' shows me the individual salesperson who's account bought the said product.
Ink Nominal = This shows me our code for the product and the equivelant nominal code used in the accounts system for the product.
Value = By entering the initials of the sales person in cell B1 should indicate which sales person I want to display the results of.
In 'Value' worksheet under the corresponding dates I would like to display the sales person in cell B1's sales for each individual sales for each product line.
If you need more explaining please let me know.