hi there,
i have information on sheet 1 that has been pulled from our
database and what l would like to do is start a new sheet like (sheet2) and
put ceratin information in there like the following.
i have our product codes that have been taken from three months ago up until
today.
example
Sheet 1 column E column w
00048003 quantity is 48
00048003 qty is 5
00048003 qty is 15
01671006 qty is 32
and so on along with different product codes and varies qty next to
them.(each product code has a different quantity of rows. For instance
product code 00048003 there might be 100 rows with different quantity amounts
but then product code 01671006 might only have 5 rows with different
quantity's.)

In sheet 2 column A l would like to put one of each product code from sheet
1 column E into sheet 2, so it would look like this
00048003
01671006
01672006
and so on
Then in sheet 2 column B l would like to have the total quantity of each
product code from sheet 1 column W to match sheet 2 column A (product code)
example
00048003 total qty is 500 cartons
01671006 " " is 250 cartons
01672006 " " is 800 cartons

sorry to confuse anybody. just trying to work out what is my fastest moving
stock in the warehouse?
--
chris