Sign in to follow this  
Followers 0
amojuan50

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

2 posts in this topic

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

Share this post


Link to post
Share on other sites



#2 ·  Posted (edited)

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 by electrico

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0