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.

[TABLE="width: 854"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD="align: left"]Copy From File Names:[/TD]
[TD="align: left"]Copy From Tab Names:[/TD]
[TD="align: left"]Copy From Data Ranges:[/TD]
[TD="align: left"]Copy To File Names:[/TD]
[TD="align: left"]Copy To Tab Names:[/TD]
[TD="align: left"]Copy To Data Ranges:[/TD]
[/TR]
[TR]
[TD="align: left"]1.ABX.xlsb[/TD]
[TD="align: left"]Sheet1[/TD]
[TD]A1:Z500[/TD]
[TD="align: left"]Main.xlsx[/TD]
[TD="align: left"]Sheet1[/TD]
[TD="align: left"]A1:Z500[/TD]
[/TR]
[TR]
[TD="align: left"]5.pqr.xlsb[/TD]
[TD="align: left"]Sheet1[/TD]
[TD]A3:Z2100[/TD]
[TD="align: left"]Main.xlsx[/TD]
[TD="align: left"]Sheet1[/TD]
[TD="align: left"]A501:Z2100[/TD]
[/TR]
[TR]
[TD="align: left"]10.mno.xlsb[/TD]
[TD="align: left"]Sheet1[/TD]
[TD="align: left"]A1:Z14725[/TD]
[TD="align: left"]Main.xlsx[/TD]
[TD="align: left"]Sheet1[/TD]
[TD="align: left"]AR1:BA14725[/TD]
[/TR]
[TR]
[TD="align: left"]6.xyz.xlsm[/TD]
[TD="align: left"]Sheet1[/TD]
[TD]A3:Z33571[/TD]
[TD="align: left"]Main.xlsx[/TD]
[TD="align: left"]Sheet1[/TD]
[TD="align: left"]AR14726:BA48294[/TD]
[/TR]
</tbody>[/TABLE]
[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