Need help matching up lists using Dave Hawley s Macro
Posted by John Piccolo on August 04, 2001 7:54 AM
I am trying to use the Macro (Sub CopyDupes) you wrote for Claudette on May 9th, 01. to match up 2 sets of lists. My problem is that my 2 lists have 4 columns each instead of 2.
List 1 has: Item Number, Item Discription, Units TY, Dollars TY.
List 2 has: Item Number, Item Discription, Units LY, Dollars LY.
There is no way to sort them because not all of the items are in both lists. I need to do this monthly and its driving me crazy with approx 1500 items to match up.
Any help would be greatly appreciated