Jackel
09-30-2016, 12:24 PM
Hello everyone,
I am working on a project that requires me to copy and paste data from 50 different excel files, into one master. This master files name changes every month and am currently having to manually go in and change it for every line that it is used(about 10 lines within the code) every month. Is anyone familiar with some from of code that could let me just designate it to look at a "Master" and only have to change it once? It would really help! Thanks!
Would this be declaring a file name? Would that give the rest of the macro the ability to know to look at that one file?
I am working on a project that requires me to copy and paste data from 50 different excel files, into one master. This master files name changes every month and am currently having to manually go in and change it for every line that it is used(about 10 lines within the code) every month. Is anyone familiar with some from of code that could let me just designate it to look at a "Master" and only have to change it once? It would really help! Thanks!
Would this be declaring a file name? Would that give the rest of the macro the ability to know to look at that one file?