Hello,

Im trying to merge three large worksheets together in one. Each worksheet is an inventory list for a warehouse, containing each item's division number, item #, its ship factor quantity, pick ticket qty (for a pick to light line) and what quantities are recieved in. I'm trying to compare the inventory of these 3 WH and want to create a combined inventory list showing the variations between the pick ticket quantites for each item. But i cant figure out how to merge the inventory lists together because the item lists are varying between each WH. Any help would be much appreciated.

Thanks