Hi,
I'm New to VBA, I have 3 kits which need to be compared with each for their components and their components
3 kits BOM are present in 3 separate work book. I've kept all the 3 work book open.
I'm working on macro , it should copy required number of column from 3 worksheet (column i have Part number, qty, item seq.., i need to select either 2 as required or all 3 or combination of those), and copy into new work book.
Then it should compare into each column with part number column of wb1 with wb2 and wb3 and similarly for other column)
Could be better if its paste in ascending or descending order
And result should be like teamcentre BOM comparison.
I.e if part number of wb1 is not present in wb2 or Wb3 it should make the adjacent cell of wb2 and wb 3 as blank and highlight cells in red,
if QTY OR ITEM SEQUENCE mismatch it should highlight corresponding row cells in yellow
if QTY OR ITEM SEQUENCE mismatch it should highlight corresponding row cells in Grey
Please refer the attached xl for result format to be thrown
Bookmarks