Hi All,
I have recently undertaken a VBA course and I am gradually starting to get a hold of how VBA works.
My current problem is that I would like to tables of data to combine. Whilst combining I'd like the tables to be scanned for the same items and if the same item code has the same quantity the one of the lines is kept and the duplicate is removed. If the items are the same but the quantities differ then they are highlighted and finally if the item is new or unmatched it would be kept.
Any help would be greatly appreciated.
I have recently undertaken a VBA course and I am gradually starting to get a hold of how VBA works.
My current problem is that I would like to tables of data to combine. Whilst combining I'd like the tables to be scanned for the same items and if the same item code has the same quantity the one of the lines is kept and the duplicate is removed. If the items are the same but the quantities differ then they are highlighted and finally if the item is new or unmatched it would be kept.
Any help would be greatly appreciated.