Copy data in one excel file to multiple excel files

Registration date
Saturday May 20, 2017
Last seen
May 20, 2017
- Updated on May 20, 2017 at 08:33 PM
Hello friends,

I have an excel field with 3 fields as below:

VendorID -
Name -
Email ID -

with nearly 5000 records.

I want to get some more information from vendors like location/phone no/Bank account etc. To get this done I plan to create 1 excel file for each vendor with the available 3 columns and send it to vendors so that they can fill in the other required information. It will be very difficult to create 5000 files for all vendors manually. So I wish to automate this process wherein for each vendor a new excel is created with the available information from the available file and sent to vendor. Please guide how I can do that.

Thanks in advance.