help search then copy cell data from on excel file to another

[amojuan50]

hi, would like some help on a script on the following situation:

name.xls has a column for first-name then "empty column" then id-number

fullname.xls has a column for first-name then last-name then id-number

I would like to search the id-number of name.xls in the id-number of fullname.xls

if not found, goes back to the next id-number of name.xls then search again

if found, copies the last-name of fullname.xls(same row of the found id-number)then paste it on the empty column next to the first-name of name.xls(same row of the searched and found id-number) then search again the next id-number of name.xls

[electrico]

I could do some examples for you, but actually it is better if you do it yourself. See all the <Excel.au3> functions.

For jumping to the next ID cell, you can use Loop inside If, like if x (your ID cell data) not found, then -> for $i .. do..(jump to the next ID row and search again) ..... Else (if ID found) - YourFunc() and so on..

Also try to use search in AutoIt forums, there you can find plenty of functions made by other users, that are ready to use just after small changes.

Hope it will help you.

Edited July 26, 2010 by electrico