I would not have to loose the items that are not on the new report, but at least shade them in, or show them closed. How would I put this macro together? Come up with a number that is unique to every item and have it compare the line data in each report updating the one with my added columns?