Hi,

I would like to do a macro which:

1. looks at a name from a list (in file Names.xls) then
2. opens a file (called Fixings.xls) at the sheet which equals that name then
3. copies text in cell M6 (of file Fixings.xls) and pastes it next to such name (in original file Names.xls).

The file Fixings.xls is found in directory P:\Lonib\Derivative\Fixings.xls

The name in file Names.xls is Apples and it is in cell A10
The sheet to open in Fixings.xls is Apples and the Text in cell M6 is Red.

Let me know if you need any other information.

Thanks,
Nix

Hi

LEt's go step by step.

You can use VBA's Dir Function (http://vbadud.blogspot.in/2007/05/vb...rectories.html) to get the directories / files

Workbooks.Open will allow you to open the file and .Copy for copying ranges

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)