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.
Copy data in one excel file to multiple excel files