Answer the question
In order to leave comments, you need to log in
How to automatically create an Excel spreadsheet from a completed form?
Hello!
The task is to speed up the process of filling out the TOR.
Already made the script of filling.
1. Indication of the first parameters. Either yes/no, or number.
2. Indication of the second parameters. Title + space occupied (in numbers)
3. Fill in the main parameters, based on the first.
Scenario:
1. Horns yes/no (yes indicated)
2. Hooves count (three hooves)
3. Horns are selected
4. How many hooves to assign to horns is selected
Next, about what should be the output.
So far, there is only a manually created table.
But it just became uncomfortable, constantly redoing it. So I want to make the filling process automated.
Answer the question
In order to leave comments, you need to log in
1. Learn any (well, almost any) programming language and write a script for autocomplete and export to Excel.
2. Write your wish for freelancing, pay, they will write to you.
If you need a form for entering data and there is no desire to learn a language or pay, then you can use Access, where you can create an input form (well, you have to read a little). If the use of Excel is important, then you can then connect to this database from it in a couple of clicks.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question