Hi,
I am trying to make a Macro for excel 2003 that pulls data from different files in a folder, and it runs/updates whenever the file is opened so that if the files that it is referencing are updated, the values it has pulled are also updated. The macro would auto populate a column by taking values from another column in the current file, in my case mold numbers, and search the folder for partial matches in the file names (the file name would contain more than just the mold number). Once it found a match it would then pull the value of a specific cell and input it into the current file. I am an intern and don't have much experience in macros but was told to do it this way by my boss. Any help with the code or points in the right direction for certain parts of it would be greatly appreciated.
Thanks
I am trying to make a Macro for excel 2003 that pulls data from different files in a folder, and it runs/updates whenever the file is opened so that if the files that it is referencing are updated, the values it has pulled are also updated. The macro would auto populate a column by taking values from another column in the current file, in my case mold numbers, and search the folder for partial matches in the file names (the file name would contain more than just the mold number). Once it found a match it would then pull the value of a specific cell and input it into the current file. I am an intern and don't have much experience in macros but was told to do it this way by my boss. Any help with the code or points in the right direction for certain parts of it would be greatly appreciated.
Thanks