Jul 29 2020 03:07 AM
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.
Jul 29 2020 03:11 AM
Jul 29 2020 03:20 AM
An easier option is to use form, but the challenge with form is that you will not be able to choose from the list.
Cheers