Hi All,
I was hoping someone might have some direction for a macro. I would like this macro to copy and paste the range A1:G22 on Sheet1 into a master file. There are a number of files I want to copy from and have it pasted in the next empty row in Column A of the master sheet. All of these files are in a folder called Current Quarter. This folder also contains three sub folders for each month in that quarter but I don't know if that matters or not. Any help on this would be extremely appreciated. Thanks so much excel experts!
I was hoping someone might have some direction for a macro. I would like this macro to copy and paste the range A1:G22 on Sheet1 into a master file. There are a number of files I want to copy from and have it pasted in the next empty row in Column A of the master sheet. All of these files are in a folder called Current Quarter. This folder also contains three sub folders for each month in that quarter but I don't know if that matters or not. Any help on this would be extremely appreciated. Thanks so much excel experts!
