VBA to create a unique list from two columns

Hi,

I have a table of transactions from which I'd like to create a unique schedule of which suppliers have submitted returns and which month they relate to.

The attached example should explain what it is I'm looking to achieve but if you have any queries just give me a shout.

Snook

Dear The_snook:

Your logic is correct. The following code does just that. Yet, a better way to summarize your data would be to do ut in another sheet.

Please Login or Register  to view this content.

This is just another way to do it:

Please Login or Register  to view this content.

Try

Please Login or Register  to view this content.