Link values to an item from another excel documents specific cells

Hi,

I'm trying to link my excel sheet that has Stomone in column B and an item name in column G which I need to provide its value in column J based on a specific cell in a different excel document named ValueFile.xls

I'm using excel 2003 and require VBA as it is part of a larger project which has column B with names other than Stomone.

Please Login or Register  to view this content.

Any help is appreciated.

Thanks,

David

Maybe:

Please Login or Register  to view this content.

Thank you very much John

I tried to add reputation but it states that I need to spread some reputation around before giving it to John, I guess you help me each time I post so thank you very much again I really appreciate it.

You're welcome. Glad to help out and thanks for the feedback.