jonaslin
10-23-2019, 07:22 AM
Hi,
Im seeking advice on where to start to try to automaticly compare two columns in two workbooks and have an output in a third column.
For an example
compare workbook1 column S compare with workbook2 column I (not sorted and the rows not match) it need to take the first row in workbook1 S column and search the entire workbook2 column I to find a match when match found check the column H in workbook1 is there a value, skip and go to next row, is the cell empty then fill it out from workbook2 column I
All advice appriciated
Thanks
Jonas
Im seeking advice on where to start to try to automaticly compare two columns in two workbooks and have an output in a third column.
For an example
compare workbook1 column S compare with workbook2 column I (not sorted and the rows not match) it need to take the first row in workbook1 S column and search the entire workbook2 column I to find a match when match found check the column H in workbook1 is there a value, skip and go to next row, is the cell empty then fill it out from workbook2 column I
All advice appriciated
Thanks
Jonas