Unanswered: Macro to identify & consolidate same value cells
Hi, I have two columns. Column A has a Stock Material Number. Column B has the quantity of stock required for the corresponding Stock Material Number. I am trying to create a macro that searches column A, identifies any repeat stock material numbers and then consolidates all the repeat numbers, along with the sum of all the quantities into one line.
eg: Stock Material Number 123456 shows up in rows 1, 3 & 16. Each occurrence requiring a quantity of 2.
The macro would run leaving only 1 row showing only 1 occurrence of Stock Material Number 123456 and a quantity of 6.