I have 40 workbooks all of which have the same sheet that I would like to copy certain ranges of data from and paste them into new sheets in a new workbook (without opening the workbooks and keeping the formatting and the values:
the workbooks are all stored in one folder so at the same path
They all have the same sheet High (excess)
the ranges on the sheet to copy over are:
Columns D-F,U-V, AG-AI
Each sheet can be named using the cell V1 in each of the sheets.
please can anyone help?
the workbooks are all stored in one folder so at the same path
They all have the same sheet High (excess)
the ranges on the sheet to copy over are:
Columns D-F,U-V, AG-AI
Each sheet can be named using the cell V1 in each of the sheets.
please can anyone help?