Hi, I am trying to find the best way to compare two excel spreadsheets and getting value from one. Excel 1 have a value I need to look for in Excel 2 in column C, if there is a match I need to get the value from Excel 2 in the same row as the match 3 cells to the right and populated that to Excel 1. Any help is appreciated, thanks.
Basically, you would define two connectors and loop over one worksheet with an embedded loop over the second worksheet column. Then if a match is found, you could copy the value from 3 cells to the right in the 2nd sheet. To know the bounds of the sheets, you could refer to the UsedRange property which gives you the column and row count.