Hi Focus,

I am trying to compare 2 values in different cell in separeted
workbooks, but the value of cell are different. So I need to use some
"substring" funcition to compare a part of value inside the cell with
another cell. For example:
Cell1 = ZONE 101
CellX (in other workbook) = STOP XXXX ZONE 101 YYYYY

The part of text is the same, so I need to find cell1 and compare to
cellX and when I find this part of text I need do copy 2 other cell in
2 other places.

Can someone help me to do this in macros VBA?

Rgrds,