The problem is - I am sending this excel file to my customers to fill in the bare minimum information required by my database. Now, before submitting the Excel, I need to generate another Excel with all the fields required by the database (which is more than the bare minimum fields I asked for from my customer). Now, I have default values ready for these extra fields. All I want is a script that takes the first excel as an input and automatically generate the other excel with all the default fields as well.
From my Customer, I get back the following columns -
One of the solution seems to be to link up the new Excel with the customer copy and a default template. But this is not automatic. Please recommend how it can be done through a script that can run on the desktop and convert all my customer excels individually into this format.