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