How can i search information in excel in search the same information in a other excel file plz ?
@Soudios Can you Please Explain the Proces what you are trying to do :
You can Explain your process by providing these 3 Step Information :
- What is the Input Data?
- What Operations you want to perform ?
- The Output Data you Expect.
Screenshots would be Appreciated.
Do you mean data of one column of one excel with another column of another excel?
yes exactly, for example : Name in excel 1 / Same Name in excel 2
thank you, but the example is not really clear, i want to compare 2 excel file and not to create a new one, i want to highlight the name when it find it in the first excel file plz
You can do a For Each Row in Excel2 and inside you will have a LookUp Data Table that looks for each name from excel2 in excel one, when it finds, it can return the index row and use set range color to highlight the found name.