Hi!
I am new to VBA and I have a folder with approximately 130 xls files, all with unique workbook names and worksheet names.
I would like to create VBA code that allows the user to select the directory folder of the files to copy data from the range C2:J2 from the first worksheet in each of the files and paste the values to the first sheet of a master workbook ("Compiled.xlsm", saved in the same directory as the source files) range A2:H2 and down until data from each file in the directory has been populated into the master "Compiled" workbook.
I have tried a number of different codes without success. I would really appreciate any help. Thank you!!
I am new to VBA and I have a folder with approximately 130 xls files, all with unique workbook names and worksheet names.
I would like to create VBA code that allows the user to select the directory folder of the files to copy data from the range C2:J2 from the first worksheet in each of the files and paste the values to the first sheet of a master workbook ("Compiled.xlsm", saved in the same directory as the source files) range A2:H2 and down until data from each file in the directory has been populated into the master "Compiled" workbook.
I have tried a number of different codes without success. I would really appreciate any help. Thank you!!