I have a spreadsheet that has pulled data from the database into sheet 1. In
sheet 2 i want excel to tell me how much of each product code and the total
quantity of that product code was picked. Example 00048003 is the product
code and then l have x amont of rows with a quantity next to it. I want to
siphon it done like below
00048003 = 2500 cartons
00447006 = 500 cartons
00449006 = 50 cartons and so on
the data can be refereshed at a later time which then l would like excel to
update sheet 2 with this information?
thanks in advance.
--
chris