Forum Discussion
Tsuriel Avraham
Mar 14, 2018Copper Contributor
combine multiple excel files
hello every one,
i have a lot of files with the same format.
every file have 2 sheets. sheet for every test i made.
i want to copy part of the data (under Vcollector and under Icollector) in the first sheet to new excel file (master file) and part of the data (under Vgate and under Icollector) in the second sheet also to the master file but to different sheet.
any idea please?
thanks :)
- Hi Tsuriel,
Does each sheet always have the same name in each workbook?
What version of Excel are you using and have you ever used Power Query ? It's great at this sort of thing.- Tsuriel AvrahamCopper Contributor
hello wyn,
thank for your respond :)
the names are always like List(xxx) but its arbitrary.
i am using 2016.
yes i try to play with the power query but i didnt succeed :(
thank again :)