I have a multiple excel workbook working with three sheets, sheets one and two have random salespeople logged with sales, sheet 3 is the final total of all salespeople, I can get it to add the total of each salesperson if I manually go into each of the first two sheets and assign the rows they are in, but how can I get it to total by assiging the task to the salespersons number, i.e salesperson 110 sells 10 (sheet 1) new and 18 (sheet 2) used (remember they are listed randomly down each of the sheets as different dates etc.