Transfer values to master sheet

[cdrwolfe]

Hi all,

I've agreed to do a nice task which seems nigh impossible, or more likely just annoying as my VB coding isn't that great at the moment.

What i have to do is:

- Pass information from mutliple files to a master file
- Each multiple file will have to run a macro when accessed which then gives the values to be transferred

Now the problem i have is figuring out how to get information from one file to the next. In the master file is a list of project codes, i.e BC112, and consequently this is the name of a 'multiple file'.

So i believe it best to write a macro which looks up the project code name, then uses this to open the subsequent named 'multiple file'. Then the macro runs and i can begin to pull values from the various cells and populate the master file.

To begin with does it sound like a good feasible direction to head?

Regards Wolfe

[Richard Buttrey]

Hi all,

I've agreed to do a nice task which seems nigh impossible, or more likely just annoying as my VB coding isn't that great at the moment.

What i have to do is:

- Pass information from mutliple files to a master file
- Each multiple file will have to run a macro when accessed which then gives the values to be transferred

Now the problem i have is figuring out how to get information from one file to the next. In the master file is a list of project codes, i.e BC112, and consequently this is the name of a 'multiple file'.

So i believe it best to write a macro which looks up the project code name, then uses this to open the subsequent named 'multiple file'. Then the macro runs and i can begin to pull values from the various cells and populate the master file.

To begin with does it sound like a good feasible direction to head?

Regards Wolfe

Yes, that's exactly the right approach. Building up a filename from code values / dates and other variables held in cells somewhere is a fairly standard approach.

Rgds