CopyPaste data from multiple excel files

maheshrk81

Board Regular
Joined
Jan 5, 2010
Messages
145
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.xlsbSheet1A1:Z500Main.xlsxSheet1A1:Z500
5.pqr.xlsbSheet1A3:Z2100Main.xlsxSheet1A501:Z2100
10.mno.xlsbSheet1A1:Z14725Main.xlsxSheet1AR1:BA14725
6.xyz.xlsmSheet1A3:Z33571Main.xlsxSheet1AR14726: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]
 

maheshrk81

Board Regular
Joined
Jan 5, 2010
Messages
145
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
 

Forum statistics

Threads
1,077,635
Messages
5,335,379
Members
399,014
Latest member
hamzalaarif

Some videos you may like

This Week's Hot Topics

Top