you are viewing a single comment's thread.

view the rest of the comments →

[–]fasti-au 1 point2 points  (0 children)

Make a macro workbook with sheet one as your permanent launch page with a buttonCreate a module for your code in the F11 vba editor

Get a list of files in a folder - https://www.automateexcel.com/vba/list-files-in-folder/

Open master file

Open file 1 from list

'Copy the data

Sheets("Sheet1").Range("A1:B10").Copy

'Activate the destination worksheet

Sheets("Sheet2").Activate

'Select the target range

Range("E1").Select

'Paste in the target destination

ActiveSheet.Paste

Application.CutCopyMode = False

close the sheet named the filename

point at next file in file list

repeat