Hi,
I have two blocks of data (both product details: i.e. barcode, description, etc) beside each other in a doc. One has 8 columns and 500 rows of data/products, the other has 9 columns and 27000 rows. All I want to do is generate a list of items that appear in both lists, separately. I have already used an excel formula to produce an extra column that displays 'True' if there is a match (based on barcodes matching), or false if there is nothing.
My hope is to output a small list of items that appear on both, so that if I was to insert future data (copy/paste) I can easily just stick it in.
I'm sure there is a relatively easy macro/formula to do this, but I can't get it to work right now and could really use some help.
Much appreciated.
Bookmarks