rodtt
07-17-2013, 10:27 AM
This might prove too complicated for me, as I'm very inexperienced. If it prooves so, I might just make other sheets with data from the second and third workbooks.
I need my excel file to check two others for some information, and add them to the first one if the same ID is found on the first and second or third file. I also need the second or third file to register it was added on the first.
I think this is irrelevant here, but, anyway, this ID won't repeat on second and third file.
I know how to make a code to do the search in another sheet, but I don't know how to work with two or more different files.
I see both files are shown on VBA project window when both opened, but I need both to be linked so I don't need to open both files all the time.
Thanks in advance!
I need my excel file to check two others for some information, and add them to the first one if the same ID is found on the first and second or third file. I also need the second or third file to register it was added on the first.
I think this is irrelevant here, but, anyway, this ID won't repeat on second and third file.
I know how to make a code to do the search in another sheet, but I don't know how to work with two or more different files.
I see both files are shown on VBA project window when both opened, but I need both to be linked so I don't need to open both files all the time.
Thanks in advance!