[EPounds]

Is there a way to set up a macro to search multiple excel files in a given directory and compile specific information from each spreadsheet into a master file?

[Advertisements]

why would u want to do that?

can u give me a little more info on why and ill help u out

like what kind of info are u searching for etc

Thanks

Stu Design

[stu_design]

why would u want to do that?

can u give me a little more info on why and ill help u out

like what kind of info are u searching for etc

Thanks

Stu Design

[EPounds]

I am trying to track progress for a project. I would like a macro to search a specified column in various excel files that are based on a template and pull progress statistics like "in progress, completed or not started".

Basically put, have a macro or something that says go to this directory, open these files, and report this to a new excel file.

[stu_design]

yes here goes, wait this take awhile...

im going to get on it i have to find out some stuff first

Stu Design

[stu_design]

looked for it and i found this hope this helps

http://www.exceltip....excel_2000.html

if it doesnt message back

Stu Design

[stu_design]

oh and i hope u know VBA, to do this otherwise, just try the link and muddle ur way thru or ask in the programming forum on geekstogo.com

Stu Design