Copy certain data from multiple excel files to another file via VBScript.

By Kirasama82 ·
Hello everyone,

I'm not a coder or developer, so I'm really novice in the topic. What I would need is a .vbs file, that can manage following stuff and I really need urgent assistance with this:

I'm having eight Excel 2016 .xlsx files in directory A with different names like file01.xlsx, fileK4.xlsx, etc., each with one worksheet. The data is spread in them in different cells (B6 for example or G43).

I have in directory B a single Excel 2016 .xlsx file which is used basically as template in the maning that it has eight different worksheets where the data form the certain cells mentioned above should be copied over to certain worksheet's certain cells basically and saved in directory C as outputfilename.xlsx.

So lets say from directory A's file01.xlsx cell C5 should be copied over to directory B's template excel file's worksheet1's cell K16, directory A's fileK4.xlsx cell C3 should be copied to diretory B's template excel file's worksheet2's cell F2 and so on... from all 8 files in directory A.... and at the end it should save the file to directory C as outputfilename.xlsx.

Could someone create such a .vbs script? I guess for any of you coder guys it should not be a big deal... unfortunately due to a due date to reach I cannot afford to loose any time trying to go after this by myself. Any assistance is more than appreciated guys!

Thanks in advance for your help!

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Software Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums