I need to copy cells from one Excel file into >600 similar Excel files. Location and formatting of the cells are the same. Example: copy cell B5 from File1 to cell B5 into File2, etc.). Any suggestions?
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Copy data to multiple Excel files
0
Answers
0
- It's easier by far to create 600 files than to amend them. This is even true if you already created them (because that was the easy part). Reconsider an approach where you take a template which already includes the data to be inserted and insert the other variable data which would not come from dispersed cells but from a list, such as a list of names. To create 600 files in this manner would take very little code and just a few minutes.
- If the above solution isn't suitable for your case the projectyou describe falls into two tasks. One is to copy cells from the original to one file. Take a look at this thread where cells are identified for deletion. The same system can be used to copy them and expanded to paste the copied contents to other cells in another workbook.
- The second task is to repeat the same action on 600 different workbooks. This is done by creating a list of workbook names such as Windowes Explorer provides when you place many files into one folder. You would need code to call up one file after another, open it, run the code described in point 2 above, close it and pick the next until all files in the folder are done.