Filling a template with multiple data's??

[joshi007]

Hello everyone,

I am a Student working for a Company during the summer. I have a question related to filling a template with multiple data (from multiple data files) and then saving them all separately. i have an empty (default) form with fields like actual voltage, measured voltage, actual current , measured current etc etc. I then have hundreds of test values given to me by my Company. so the way i do it, is use the Add-ins function to first open the Default form in Excel and then open the test value from other file and once the values are filled in the form , i save it. But as i said i have hundreds of test values that has to be filled in the same form and saved separately so it takes me a lot of time to do it. i was wondering if there might be an easier way using macros or other functionalities which might make my work easier.

A way maybe to give all the test values to Excel all at once and let it fill the Default form by itself and save them as a separate files with the Name i provide. if anyone can help or give any Suggestion , it would be of great help for me. A payment for the work would also be okay.

Kind regards
yoshi

 

[joshi007]

also forgot to mention that the test values are basically also different files with different Kinds of test perfomed . so hundreds of test values means hundreds of files. sorry english is not my first language so it is hard to explain what i mean precisely.

Kind regards