Product list to week columns

Hi,

I have a sheet with a list of products each with a quantity and a week number.
I need to put them into another sheet I have with weeks in seperate columns.

Please see the attached document.

Also it would be great if I could remove duplicate rows on the new sheet, as long as it adds the quantities of each duplicate.

Can anyone help?

Hi

For each week, do you want a list of the unique products for that week, or do you want a unique list of ALL the products, and the total quantity for each week.

rylo

Originally Posted by rylo

Hi

For each week, do you want a list of the unique products for that week, or do you want a unique list of ALL the products, and the total quantity for each week.

rylo

A list of unique products for each week, with a total for each product in the next column.

Originally Posted by rylo

Hi

For each week, do you want a list of the unique products for that week, or do you want a unique list of ALL the products, and the total quantity for each week.

rylo

Actually I can combine the duplicates in the QTY sheet beforehand.

So all I need to know is how to put them into the PRODUCTS sheet in the respective week columns.

Hi

Put the code below into a general module and see how it goes. Will process all the source data.

Please Login or Register  to view this content.

rylo

Works like a charm, thanks.