How to keep data chosen from the drop list in specific cell after choosing another one

Copper Contributor

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.

 

 

2 Replies

@import_usk 

 

You might need to use macros for this I guess

@import_usk 

 

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