I need to create a macro which will sort data, first by Stock Name. Then, for each Stock Name, rows which are opposite transactions to be listed first. Opposite transactions are those which have the same stock name, same quantity but one is delivery and the other is receipt.
So, in the attached spreadsheet, the data on the left should be sorted to show the data on the right.
Can any please help me?
Bookmarks