Hi all
I have started another thread as the previous had been solved and now the criteria has become more elaborate.
With my attached sample file.
I need to go through Sheets("Customer sales").Column B and record the no of different suppliers in Sheets("Product breakdown") Column C.
There are various products, however they each belong to a specific supplier....I have made use of keywords as per Sheets("Product breakdown Description")
Sheets("Customer sales").Column's C & D are edited to depict the breakdown.
I am not certain what procedure to make use of as the current code counts 13 as per individual highlights in Sheets("Customer sales").Column B.
the correct answer should be 6 as the breakdown is 6 Suppliers.
Can anyone please put me out of my misery....
I thank you in advance.
Bookmarks