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

%3CLINGO-SUB%20id%3D%22lingo-sub-1552626%22%20slang%3D%22en-US%22%3EHow%20to%20keep%20data%20chosen%20from%20the%20drop%20list%20in%20specific%20cell%20after%20choosing%20another%20one%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1552626%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%3C%2FP%3E%3CP%3ELet's%20say%20I%20want%20to%20keep%20information%20about%20patients%20that%20visited%20my%20office%20including%20e.g.%20their%20name%2C%20last%20name%2C%20hometown%20and%20diagnosed%20disease.%20So%20I%20create%20a%20input%20row%3C%2FP%3E%3CP%3EA1%20%3D%20name%20(typed)%3C%2FP%3E%3CP%3EB1%20%3D%20last%20name%20(typed)%3C%2FP%3E%3CP%3EC1%20%3D%20city%20(chosen%20from%20the%20list)%3C%2FP%3E%3CP%3ED1%20%3D%20disease%20(chosen%20from%20list)%3C%2FP%3E%3CP%3EI%20make%20the%20input%20for%20the%20first%20patient%20and%20have%20the%20data%20stored%20in%20different%20part%20of%20the%20workbook%2C%20let's%20say%20in%20output%20row%3A%3C%2FP%3E%3CP%3EA10%2C%20B10%2C%20C10%2C%20D10%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20then%20the%20second%20patient%20visits%20and%20I%20make%20new%20input%20in%20the%20same%20input%20row%20(A1%3AD1)%20and%20want%20to%20keep%20the%20data%20stored%20in%20new%20row%20(A11%3AD11)%3C%2FP%3E%3CP%3EAnd%20so%20on.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20formula%20to%20keep%20the%20data%20from%20the%20input%20row%20after%20I%20type%20a%20new%20one%20in%20there%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1552626%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1552658%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20keep%20data%20chosen%20from%20the%20drop%20list%20in%20specific%20cell%20after%20choosing%20another%20one%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1552658%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F743388%22%20target%3D%22_blank%22%3E%40import_usk%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20might%20need%20to%20use%20macros%20for%20this%20I%20guess%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1552669%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20keep%20data%20chosen%20from%20the%20drop%20list%20in%20specific%20cell%20after%20choosing%20another%20one%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1552669%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F743388%22%20target%3D%22_blank%22%3E%40import_usk%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAn%20easier%20option%20is%20to%20use%20form%2C%20but%20the%20challenge%20with%20form%20is%20that%20you%20will%20not%20be%20able%20to%20choose%20from%20the%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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