Is there an expert out there that could provide VBA code that will match items from one sheet with items on another sheet
I have attached a spreadsheet which will show in more detail.
The criteria is that the Amounts must be within the same Reference Group i.e.
On Sheet 1
On Sheet 2
So in the above example the total of the 4 items in sheet 1 total the items in sheet 2 so there is a group match.
Basically I need to try and match in the following order.
Many to Many
Many to one
One to one
Would very much appreciate an experts help with this.