CopyPaste data from multiple excel files

maheshrk81

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

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

maheshrk81

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

Watch MrExcel Video

Forum statistics

Threads
1,090,481
Messages
5,414,796
Members
403,544
Latest member
rabdorawsh

This Week's Hot Topics

Top