No the file name changes each week. The workbook structure remains the same, but the data and number of files changes. We need to paste that data to another workbook to upload the data to the system. I have attached a word doc with some screenshots. RFL Information.docx
Posts by Jonnyboisme
-
-
I have a folder called RFL Worksheets. I created a VBA to create the worksheets and rename then populate the data into the cells. Once my employees populate additional Data I need to extract the value in Cells "B4" and "C49". Then paste values in a different workbook, loop all the files in the folder with the value of the second workbook below the values from the previous one.
-
I am new at VBA and I can't seem to find anything that would work for what I am trying to accomplish. I have a folder that contains a bunch of workbooks, I am trying to use VBA to write a macro to copy the same cell on every workbook and copy that value in Colum B and once the second file is run copy it below that cell. Any help would be appreciated.