Hi, I am after VBA code to compile list of distinct items of column F of the Material List Tab and copy to column A of the Material Summary Tab,
also:
1- the part number from column G of the Material List Tab to Colum B of the material summary,
2- The supplier from column H of the Material List to Column C of the material summary tab'
3- The unit (of measurement) in column I of the material list tab to column D of the material summary tab ,
4- The distinct product quantities from column J of the material list tab to column E of the material summary tab,
Thank you. Sample file attached.
Bookmarks