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...