Update entries from 2 different files

[hbejo]

Hi everyone,

Would somebody please help me on how to update entry in Excel when I have 2 different files?

For example, I have a database which contains
Name Number
A 1
B 2
C 3
Then, from another file (without opening that database file), I want to update Name "A" and Number "2", and change the Number to (let's say) "4" (but the Name will not be changed). Then at the end, I will have something like
Name Number
A 1
B 4
C 3

Thank you very much for any suggestion or hints. I really appreciate that

 

[msmith]

hbejo,
If you still need a solution to this problem, I will try to help, but I have some questions for you:

What is the source of your data? Are these databases or separate Excel files (workbooks)?

Can you explain what you are trying to do a little better? Your example mentions "updating Name A" but the result after shows only the second record changing (the Number field associated with Name B). Perhaps you could show examples of both files before the update and then the final result (in the updated file).

Then, from another file [highlight](without opening that database file)[/highlight]...

A file must be opened in some fashion to work with its contents.

Regards,
Mike