Forum Discussion
import_usk
Jul 29, 2020Copper Contributor
How to keep data chosen from the drop list in specific cell after choosing another one
Hello.
Let's say I want to keep information about patients that visited my office including e.g. their name, last name, hometown and diagnosed disease. So I create a input row
A1 = name (typed)
B1 = last name (typed)
C1 = city (chosen from the list)
D1 = disease (chosen from list)
I make the input for the first patient and have the data stored in different part of the workbook, let's say in output row:
A10, B10, C10, D10
But then the second patient visits and I make new input in the same input row (A1:D1) and want to keep the data stored in new row (A11:D11)
And so on.
Is there a formula to keep the data from the input row after I type a new one in there?
Thank you,
I.