CopyPaste data from multiple excel files

[maheshrk81]

Hi Team,

I need a macro to [FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]Copy and Paste (values) data from multiple excel files to Common Excel file.
I have below files which need to get pasted in Main.xlsx file

I have a New file called CopyPaste where I will update the file names and range details of copy and paste as below.

Copy From File Names:	Copy From Tab Names:	Copy From Data Ranges:	Copy To File Names:	Copy To Tab Names:	Copy To Data Ranges:
1.ABX.xlsb	Sheet1	A1:Z500	Main.xlsx	Sheet1	A1:Z500
5.pqr.xlsb	Sheet1	A3:Z2100	Main.xlsx	Sheet1	A501:Z2100
10.mno.xlsb	Sheet1	A1:Z14725	Main.xlsx	Sheet1	AR1:BA14725
6.xyz.xlsm	Sheet1	A3:Z33571	Main.xlsx	Sheet1	AR14726:BA48294

<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif][FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif][FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif][FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif][FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]
Can someone please provide me a macro for updating the data automatically when we run the Macro using CopyPaste file.

Thanks,
mahi
[/FONT][/FONT][/FONT][/FONT][/FONT]_{^{<strike>
</strike>}}[/FONT]

 

[alansidman]

Suggest you look at Power Query which lets you load multiple files and append one to the other.

https://support.office.com/en-us/ar...er-query-94b8023c-2e66-4f6b-8c78-6a00041c90e4

 

[maheshrk81]

Hi Alan,

Thanks for the response. But i need a Macro to do this as the date needs to be pasted in different ranges. Also that is the requirement.

Thanks,
Mahi